| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 修改单据-保存按钮 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Xt_SystemParameter/AddBill1")] |
| | | #region 系统参数查询 编辑 |
| | | [Route("Xt_SystemParameter/Edit")] |
| | | [HttpPost] |
| | | public object AddBill1([FromBody] JObject oMain) |
| | | public object Xt_SystemParameterEdit([FromBody] JObject msg) |
| | | { |
| | | DataSet ds; |
| | | var _value = msg["msg"].ToString(); |
| | | string msg3 = _value.ToString(); |
| | | string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg1 = sArray[0].ToString(); |
| | | string msg2 = sArray[1].ToString(); |
| | | //string msg_HUSEORGID = sArray[2].ToString(); |
| | | Int64 HItemID = 0; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | |
| | | try |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | //反序列化 |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<SystemParameter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SystemParameter>>(msg2); |
| | | |
| | | long HItemID = int.Parse(msg3); |
| | | string HModClass = list[0].HModClass; |
| | | string Hkey = list[0].HKey; |
| | | string HCaption = list[0].HCaption; |
| | | string HValue = list[0].Hvalue; |
| | | string HReadonly = list[0].HReadonly; |
| | | string HExplanation = list[0].HExplanation; |
| | | string HFarmat = list[0].HFarmat; |
| | | |
| | | |
| | | |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Xt_BillType set " + |
| | | ",HValue= '" + HValue + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //修改子项目代码 |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //将上级 为非末级 |
| | | // |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "修改单据成功!"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | DAL.ClsXt_SystemParameter_Ctl oBill = new DAL.ClsXt_SystemParameter_Ctl(); |
| | | List<Model.ClsXt_SystemParameter_Model> lsmain = new List<Model.ClsXt_SystemParameter_Model>(); |
| | | msg1 = msg1.Replace("\\", ""); |
| | | msg1 = msg1.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Xt_SystemParameter(msg1); |
| | | IList list = lsmain; |
| | | //保存 |
| | | oBill.oModel = lsmain[0]; |
| | | //保存完毕后处理 |
| | | bool bResult; |
| | | if (oBill.oModel.HInterID == 0) |
| | | { |
| | | oBill.oModel.HInterID = DBUtility.ClsPub.CreateBillID("8003", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //检查主表内码是否重复,若重复则重新生成并继续检查,直到不再重复 |
| | | while (true) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Xt_SystemParameter where HInterID = " + oBill.oModel.HInterID, "Xt_SystemParameter"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | oBill.oModel.HInterID = DBUtility.ClsPub.CreateBillID("8003", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | break; |
| | | } |
| | | } |
| | | bResult = oBill.AddNew(); |
| | | } |
| | | else |
| | | { |
| | | bResult = oBill.ModifyByID(oBill.oModel.HInterID); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "保存成功!"; |
| | | //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.Message; |
| | | objJsonResult.data = null; |
| | | objJsonResult.Message = "保存失败!" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | // |
| | | |
| | | } |
| | | } |