| | |
|---|
| | | |
|---|
| | | int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id |
|---|
| | | int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改 |
|---|
| | | string user = sArray[4].ToString();//用户名 |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //判断是否有编辑权限 |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "无权限编辑!"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | msg2 = "[" + msg2.ToString() + "]"; |
|---|
| | | List<Gy_RoutingBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBill>>(msg2); |
|---|
| | | string BillType = "3301"; |
|---|
| | |
|---|
| | | double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数 |
|---|
| | | double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量 |
|---|
| | | double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量 |
|---|
| | | int HPRDORGID = mainList[0].HPRDORGID; //组织 |
|---|
| | | int HPRDORGID = mainList[0].HPRDORGID; //生产组织 |
|---|
| | | int HOrgID = mainList[0].HOrgID; //组织 |
|---|
| | | |
|---|
| | | string HPicNumVer = mainList[0].HPicNumVer;//图号版本 |
|---|
| | | string HPicNumAssemble = mainList[0].HPicNumAssemble;//总装图号 |
|---|
| | |
|---|
| | | ",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" + |
|---|
| | | ",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" + |
|---|
| | | ",HMainPrice,HStdSourceQty,HAddSourceRate,HPRDORGID,HDelSourceRate" + |
|---|
| | | ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum) " + " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
|---|
| | | ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HOrgID) " + " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
|---|
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID + |
|---|
| | | "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) + |
|---|
| | | "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty + |
|---|
| | | "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate + |
|---|
| | | ",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "') "); |
|---|
| | | ",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "',"+ HOrgID + ") "); |
|---|
| | | } |
|---|
| | | else if (OperationType == 3) |
|---|
| | | { //修改 |
|---|
