| | |
|---|
| | | |
|---|
| | | string sql = string.Format(@"select * from h_v_Sc_ProcessExchangeBillQuerySub"); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 出站关联数量=0 and cast(流水号 as int)>" + ds1 .Tables[0].Rows[0][0].ToString(), "h_v_Sc_ProcessExchangeBillQuerySub"); |
|---|
| | | ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 出站关联数量=0 and cast(流水号 as int)>" + ds1 .Tables[0].Rows[0][0].ToString()+ " order by cast(流水号 as int) ", "h_v_Sc_ProcessExchangeBillQuerySub"); |
|---|
| | | |
|---|
| | | if (float.Parse(ds.Tables[0].Rows[0]["进站关联数量"].ToString()) > 0) |
|---|
| | | { |
|---|
| | |
|---|
| | | objJsonResult.data = 1; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | int num = oItem.HBillNo.Split('-').Length; |
|---|
| | | oBill.omodel.HMaker = msg5; //制单人 |
|---|
| | | oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]); |
|---|
| | | oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[num - 1]); |
|---|
| | | oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
|---|
| | | oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
|---|
| | | oBill.omodel.HDate = oItem.HDate;// 日期 |
|---|
| | |
|---|
| | | oBill.omodel.HPlanEndDate = oItem.HPlanEndDate;// 计划完工日期 |
|---|
| | | oBill.omodel.HQty = oItem.HQty;// 数量 |
|---|
| | | oBill.omodel.HBillNo = oItem.HBillNo;// 单据号 |
|---|
| | | oBill.omodel.HProjectNum = oItem.HProjectNum;// 项目号 |
|---|
| | | } |
|---|
| | | |
|---|
| | | //表体数据 |
|---|
| | |
|---|
| | | j++; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | //保存 |
|---|
| | | //保存完毕后处理 |
|---|
