///<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;
}
}
