コード例 #1
0
        ///<summary>
        /// 保存数据
        /// </summary>
        /// <param name="pObj">信息集实体类</param>
        /// <returns>返回保存成功(true)或失败(false)</returns>
        public void SaveBill(SellOrder SellOrder, List <SellOrderDetail> SellOrderDetail)
        {
            CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);

            try
            {
                pComm.BeginTrans();

                //保存单据主表数据
                //先删除主表数据
                string strDeleteSql = "Delete from SellOrder where  SellOrderGuid='" + SellOrder.SellOrderGuid + "'";
                pComm.Execute(strDeleteSql);

                //插入主表数据
                string strInsertSql = GetAddBillSQL(SellOrder);
                pComm.Execute(strInsertSql);


                //删除明细表
                strDeleteSql = "Delete from SellOrderDetail where  SellOrderGuid='" + SellOrder.SellOrderGuid + "'";
                pComm.Execute(strDeleteSql);

                //插入明细表数据
                for (int i = 0; i < SellOrderDetail.Count; i++)
                {
                    strInsertSql = GetAddBillDetailSQL(SellOrderDetail[i]);
                    pComm.Execute(strInsertSql);
                }


                pComm.CommitTrans();
            }
            catch (Exception e)
            {
                pComm.RollbackTrans();
                pComm.Close();
                throw e;
            }
        }