| | |
|---|
| | | //得到mainid |
|---|
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //若MAINDI重复则重新获取 |
|---|
| | | oCn.BeginTran(); |
|---|
| | | //主表 |
|---|
| | | |
|---|
| | | oCn.RunProc("Insert Into Sc_MESBeginWorkBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
|---|
| | | ",HYear,HPeriod,HRemark" + |
|---|
| | |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
|---|
| | | { |
|---|
| | | sReturn = "无验证数据！"; |
|---|
| | | oCn.RollBack(); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") |
|---|
| | | { |
|---|
| | | sReturn = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); |
|---|
| | | oCn.RollBack(); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | sReturn = omodel.HInterID.ToString(); |
|---|
| | | oCn.Commit(); |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | sReturn = e.Message; |
|---|
| | | oCn.RollBack(); |
|---|
| | | throw (e); |
|---|
| | | } |
|---|
| | | } |
|---|
