WPF之多表新增

页面主要用DockPanel布局和Grid布局来做界面，界面有点单一。如下图：

数据库主要有两张表：一张采购信息订单表，一张采购明细表。
数据库存储过程如下：
--新增采购信息
IF(@type='XZ_Purchase_PurchasingManagement')
INSERT INTO Purchase
( StaffID ,WarehouseID ,SupplierInforID ,
PurchaseNo ,PurchaseDate ,ShouldMny ,RealityMny ,Audit )
VALUES (@StaffID,@WarehouseID,@SupplierInforID,@PurchaseNo,
@PurchaseDate,@ShouldMny, @RealityMny, @Audit)
SELECT SCOPE_IDENTITY()
--新增采购商品信息详细
IF(@type='XZ_PurchaseDtl_PurchasingManagement')
INSERT INTO PurchaseDtl
( PurchaseID ,CommodityInforID )
VALUES ( @PurchaseID,@CommodityInforID)
服务层因为是多表新增，所以在新增采购信息要返回采购信息表的ID，给我们采购明细表，进行新增。
采购信息表的写法和查询的写法差不了多少。
代码如下：
#region 新增
[OperationContract] //新增采购信息
public DataSet XZ_Purchase_PurchasingManagement(int StaffID, intWarehouseID,
int SupplierInforID,string PurchaseNo,DateTime PurchaseDate, decimal ShouldMny,
decimal RealityMny, bool Audit){
SqlParameter[] mySqlParameters = {
newSqlParameter("@type",SqlDbType.NChar),
newSqlParameter("@StaffID",SqlDbType.Int),
newSqlParameter("@WarehouseID",SqlDbType.Int),
newSqlParameter("@SupplierInforID",SqlDbType.Int),
newSqlParameter("@PurchaseNo",SqlDbType.NChar),
newSqlParameter("@PurchaseDate",SqlDbType.DateTime),
newSqlParameter("@ShouldMny",SqlDbType.Decimal),
newSqlParameter("@RealityMny",SqlDbType.Decimal),
newSqlParameter("@Audit",SqlDbType.Bit)
};
mySqlParameters[0].Value = "XZ_Purchase_PurchasingManagement";
mySqlParameters[1].Value = StaffID;
mySqlParameters[2].Value = WarehouseID;
mySqlParameters[3].Value = SupplierInforID;
mySqlParameters[4].Value = PurchaseNo;
mySqlParameters[5].Value = PurchaseDate;
mySqlParameters[6].Value = ShouldMny;
mySqlParameters[7].Value = RealityMny;
mySqlParameters[8].Value = Audit;
DataTable myDataTable =
myDALMethod.QueryDataTable("Frm_PurchasingManagement",mySqlParameters);
DataSet myDataSet = new DataSet();
myDataSet.Tables.Add(myDataTable);
return myDataSet;}
[OperationContract] //新增采购详细信息
public int XZ_PurchaseDtl_PurchasingManagement(int PurchaseID,
intCommodityInforID)
{SqlParameter[] mySqlParameters = {
newSqlParameter("@type",SqlDbType.Char),
newSqlParameter("@PurchaseID",SqlDbType.Int),
newSqlParameter("@CommodityInforID",SqlDbType.Int)};
mySqlParameters[0].Value ="XZ_PurchaseDtl_PurchasingManagement";
mySqlParameters[1].Value = PurchaseID;
mySqlParameters[2].Value = CommodityInforID;
int myDataTable =myDALMethod.UpdateData("Frm_PurchasingManagement", mySqlParameters);
return myDataTable;
}
#endregion