/// <summary> /// 得到新增sql /// </summary> public string GetAddRemoveBillSQL(RemoveBill RemoveBill) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [RemoveBill]("); strSql.Append("RemoveBillGuid,CreatePerson,CreateDate,CheckPerson,CheckDate,Remark,BillAutoID,BillDate,DepotOut,DepotIn,HandlePerson,BillID"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + RemoveBill.RemoveBillGuid + "',"); strSql.Append("'" + RemoveBill.CreatePerson + "',"); strSql.Append("'" + RemoveBill.CreateDate + "',"); strSql.Append("'" + RemoveBill.CheckPerson + "',"); if (RemoveBill.CheckDate == DateTime.Parse("1900-01-01")) { strSql.Append("null,"); } else { strSql.Append("'" + RemoveBill.CheckDate + "',"); } strSql.Append("'" + RemoveBill.Remark + "',"); strSql.Append("'" + RemoveBill.BillAutoID + "',"); strSql.Append("'" + RemoveBill.BillDate + "',"); strSql.Append("'" + RemoveBill.DepotOut + "',"); strSql.Append("'" + RemoveBill.DepotIn + "',"); strSql.Append("'" + RemoveBill.HandlePerson + "',"); strSql.Append("'" + RemoveBill.BillID + "'"); strSql.Append(")"); return(strSql.ToString()); }
///<summary> /// 保存数据 /// </summary> /// <param name="pObj">信息集实体类</param> /// <returns>返回保存成功(true)或失败(false)</returns> public void SaveRemoveBill(RemoveBill RemoveBill, List <RemoveBillDetail> RemoveBillDetail) { CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql); try { pComm.BeginTrans(); //保存单据主表数据 //先删除主表数据 string strDeleteSql = "Delete from RemoveBill where RemoveBillGuid='" + RemoveBill.RemoveBillGuid + "'"; pComm.Execute(strDeleteSql); //插入主表数据 string strInsertSql = GetAddRemoveBillSQL(RemoveBill); pComm.Execute(strInsertSql); //删除明细表 strDeleteSql = "Delete from RemoveBillDetail where RemoveBillGuid='" + RemoveBill.RemoveBillGuid + "'"; pComm.Execute(strDeleteSql); //插入明细表数据 for (int i = 0; i < RemoveBillDetail.Count; i++) { strInsertSql = GetAddRemoveBillDetailSQL(RemoveBillDetail[i]); pComm.Execute(strInsertSql); } pComm.CommitTrans(); } catch (Exception e) { pComm.RollbackTrans(); pComm.Close(); throw e; } }