| | |
| | | { |
| | | public class Sc_WorkBillSortBillController : ApiController |
| | | { |
| | | private json objJsonResult = new json(); |
| | | private json objJsonResult = new json(); |
| | | public DataSet ds = new DataSet(); |
| | | public WebServer webserver = new WebServer(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + "order by åæ®å· desc ", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + " order by åæ®å· desc ", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | //æå
¥å表 |
| | | foreach (Models.Sc_WorkBillSortBillSub oSub in omodelsub) |
| | | { |
| | | oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID,HRemark,HMasterDate,HQty" + |
| | | oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ,HRemark,HMasterDate,HQty" + |
| | | ", HRptFinishQty, HTimes, HUseTimes, HBTimes, HETimes" + |
| | | ", HDateSub, HCloseMan, HEntryCloseDate, HCloseTypeSub, HColumn" + |
| | | ", HLockedSub, HComplete, HStatusTag, HIsHandModify)" + |