/// <summary> /// 创建单据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string CreateStorageDoc(StorageDoc model, string userid, string operateip, string clientid) { string docid = Guid.NewGuid().ToString(); SqlConnection conn = new SqlConnection(OrdersDAL.ConnectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { bool bl = OrdersDAL.AddStorageDoc(docid, model.DocType, model.TotalMoney, model.CityCode, model.Address, model.Remark, userid, operateip, clientid, tran); if (bl) { //单据明细 foreach (var detail in model.Details) { if (!OrdersDAL.AddStorageDocDetail(docid, detail.AutoID, detail.ProductDetailID, detail.Quantity, detail.Price, detail.TotalMoney, detail.BatchCode, clientid, tran)) { tran.Rollback(); conn.Dispose(); return(""); } } tran.Commit(); conn.Dispose(); return(docid); } else { tran.Rollback(); conn.Dispose(); return(""); } } catch (Exception ex) { tran.Rollback(); conn.Dispose(); return(""); } }