| | |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HModifyEmp = msg3; |
| | | string HMakeEmp = msg3; |
| | | bool HStopflag = list[0].HStopflag==null?false:true; |
| | | int HStopflag = list[0].HStopflag==0?0:1; |
| | | long HCREATEORGID = list[0].HCREATEORGID; |
| | | long HUSEORGID = HUSEORGID_1; |
| | | long HCompID = list[0].HCompID; |
| | |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime,HIDCard,HPhone,HDriverCardPic,HDriverCardType,HIDCardPic,HEmpType,HCompID) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HStopflag + ",'" + HRemark + "'" + |
| | | "," + HUSEORGID + "," + HCREATEORGID + ",'" + msg3 + "',getdate()," +"'"+ HIDCard +"',"+ |
| | | "'"+ HPhone+"','"+ HDriverCardPic+"','"+ HDriverCardType + "','"+ HIDCardPic +"','"+ HEmpType+"',"+ HCompID+ |
| | | ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | ",HParentID=" + HParentID + |
| | | ",HUSEORGID=" + HUSEORGID.ToString() + |
| | | ",HCREATEORGID=" + HCREATEORGID.ToString() + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HStopflag=" + HStopflag + |
| | | ",HModifyEmp='" + HModifyEmp + "'" + |
| | | ",HModifyTime='" + DateTime.Now + "'" + |
| | | ",HIDCard='" + HIDCard + "'" + |
| | |
| | | ",HIDCardPic='" + HIDCardPic + "'" + |
| | | ",HEmpType='" + HEmpType + "'" + |
| | | ",HCompID=" + HCompID + "" + |
| | | |
| | | |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | // ç´æ¥æ´æ°ææ° |
| | | string updateSql = $@" |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | // ç´æ¥æ´æ°ææ° |
| | | string updateSql = $@" |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |
| | | |
| | | string updateSql = $@" |
| | | UPDATE Sc_MouldStockBillMain |
| | | SET HPackQtys = {newPallet} |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | // ç´æ¥æ´æ°ææ° |
| | | string updateSql = $@" |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |
| | |
| | | if (hmainid <= 0) |
| | | return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; |
| | | |
| | | if (newPallet <= 0) |
| | | return new { code = "0", count = 0, Message = "ææ°å¿
须大äº0ï¼" }; |
| | | if (newPallet < 0) |
| | | return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; |
| | | |
| | | |
| | | |