| | |
|---|
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //若MAINDI重复则重新获取 |
|---|
| | | oCn.BeginTran(); |
|---|
| | | DataSet _ds = oCn.RunProcReturn("select HInterID from Sb_EquipMaintainRuleBillMain where HBillNo = N'" + omodel.HBillNo + "'", "Sb_EquipMaintainRuleBillMain"); |
|---|
| | | if(_ds.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | sReturn = "单据号重复！"; |
|---|
| | | oCn.RollBack(); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | //主表 |
|---|
| | | oCn.RunProc("Insert Into Sb_EquipMaintainRuleBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
|---|
