public string Update(string json, string columns, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_dyhlh model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_dyhlh>(json); columns = FormatColumns(columns).Replace("^", ","); resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_dyhlh.Update(model, columns, null); NewLog("数据更新成功,更新的数据为:json:" + json + ",columns:" + columns, "sql_update", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据更新失败,更新的数据为:json:" + json + ",columns:" + columns + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_update", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
public string Add(string json, string clientInf) { Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { sara.dd.ldsw.model.tbl_ld_dyhlh model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_dyhlh>(json); resultDic["result"] = "true"; resultDic["message"] = _idal_tbl_ld_dyhlh.Add(model, null); NewLog("数据创建成功,创建的数据为:" + json, "sql_insert", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据创建失败,创建的数据为:" + json + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_insert", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }
/// <summary> /// //projclass = 3时进行的归档操作,执行落数程序 /// </summary> /// <param name="sys_ids"></param> /// <param name="str_facterid"></param> /// <param name="ds_facter"></param> /// <param name="str_txt_bak_message"></param> /// <param name="clientInf"></param> /// <returns></returns> public string set_complete(string sys_ids, string str_facterid, DataSet ds_facter, string str_txt_bak_message, string clientInf) { /* * all_result返回参数的整理: * 1、"{\"result\":\"true\",\"message\":\"\"}"----》第二次点击落地按钮,(理论上不应该出现这个情况,有可能是第一次操作时整个操作流程没有完成,所以造成用户可以点击这个按钮,所以此处的操作仅实现状态修改,返回值为true) * 2、"{\"result\":\"submit\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,shpid|path * 3、"{\"result\":\"false\",\"message\":\"" + messageString + "\"}";----》此时message是一个字符串,异常信息。 * 4、"{\"result\":\"submitqueue\",\"message\":\"\"}"----》成功加入队列 * */ IDictionary <string, string> clientInfoDic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(clientInf); string userid = clientInfoDic["userid"]; string username = clientInfoDic["username"]; string all_result = ""; string[] sys_idss = sys_ids.Split(','); for (int i = 0; i < sys_idss.Length; i++) { try { _model_tbl_maintable = _idal_itbl_maintable.GetList(" sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; if (all_result == "") { string result = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode model_tbl_ld_dyhlh = idal_tbl_ld_dyhlh.GetList(" fk_tbl_maintable_sys_id = '" + sys_idss[i].ToString() + "' ", "", "*", "", "", null)[0]; sara.dd.ldsw.idal.Itbl_ld_cben idal_tbl_ld_cben = new sara.dd.ldsw.dal.tbl_ld_cben(); sara.dd.ldsw.model.tbl_ld_cben model_tbl_ld_cben = idal_tbl_ld_cben.GetList(" sys_id = '" + model_tbl_ld_dyhlh.f_cbbhid + "' ", "", "*", "", "", null)[0]; sara.dd.ldsw.model.tbl_ld_khb model_tbl_ld_khb = new sara.dd.ldsw.model.tbl_ld_khb(); string khbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("kh", model_tbl_ld_dyhlh.f_sblxid, null); string sbbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("sb", model_tbl_ld_dyhlh.f_sblxid, null); string yhbh = sara.dd.ldsw.commonclass.commonclass.getBusinessNum("yh", model_tbl_ld_dyhlh.f_sblxid, null); #region 向用户表更新数据 sara.dd.ldsw.model.tbl_ld_yhb model_tbl_ld_yhb = new sara.dd.ldsw.model.tbl_ld_yhb(); model_tbl_ld_yhb.sys_id = int.Parse(yhbh); model_tbl_ld_yhb.sys_orderid = ""; model_tbl_ld_yhb.sys_creatuserid = userid; model_tbl_ld_yhb.sys_creatusername = username; model_tbl_ld_yhb.sys_creatdate = DateTime.Now; model_tbl_ld_yhb.sys_lastedituserid = userid; model_tbl_ld_yhb.sys_lasteditusername = username; model_tbl_ld_yhb.sys_lasteditdate = DateTime.Now; model_tbl_ld_yhb.sys_deluserid = ""; model_tbl_ld_yhb.sys_delusername = ""; model_tbl_ld_yhb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_yhb.sys_delflag = "0"; model_tbl_ld_yhb.f_value1 = ""; model_tbl_ld_yhb.f_value2 = ""; model_tbl_ld_yhb.f_value3 = ""; model_tbl_ld_yhb.f_value4 = ""; model_tbl_ld_yhb.f_value5 = ""; model_tbl_ld_yhb.f_value6 = ""; model_tbl_ld_yhb.f_value7 = ""; model_tbl_ld_yhb.f_value8 = ""; model_tbl_ld_yhb.f_value9 = ""; model_tbl_ld_yhb.f_value10 = ""; model_tbl_ld_yhb.f_yhbh = yhbh; model_tbl_ld_yhb.f_yhm = model_tbl_ld_dyhlh.f_yhm; model_tbl_ld_yhb.f_jfm = model_tbl_ld_dyhlh.f_jfm; model_tbl_ld_yhb.f_dz = model_tbl_ld_dyhlh.f_dz; model_tbl_ld_yhb.f_yhfz = model_tbl_ld_dyhlh.f_yhfz; model_tbl_ld_yhb.f_yhfzid = model_tbl_ld_dyhlh.f_yhfzid; model_tbl_ld_yhb.f_dh = model_tbl_ld_dyhlh.f_dh; model_tbl_ld_yhb.f_dy = model_tbl_ld_dyhlh.f_dy; model_tbl_ld_yhb.f_dyid = model_tbl_ld_dyhlh.f_dyid; model_tbl_ld_yhb.f_sc = model_tbl_ld_dyhlh.f_sc; model_tbl_ld_yhb.f_scid = model_tbl_ld_dyhlh.f_scid; model_tbl_ld_yhb.f_qy = model_tbl_ld_dyhlh.f_qy; model_tbl_ld_yhb.f_qyid = model_tbl_ld_dyhlh.f_qyid; model_tbl_ld_yhb.f_pq = model_tbl_ld_dyhlh.f_pq; model_tbl_ld_yhb.f_pqid = model_tbl_ld_dyhlh.f_pqid; model_tbl_ld_yhb.f_khrq = model_tbl_ld_dyhlh.f_khrq; model_tbl_ld_yhb.f_sfts = model_tbl_ld_dyhlh.f_sfts; model_tbl_ld_yhb.f_tsyx = model_tbl_ld_dyhlh.f_tsyx; model_tbl_ld_yhb.f_tsyxid = model_tbl_ld_dyhlh.f_tsyxid; model_tbl_ld_yhb.f_tsyxzh = model_tbl_ld_dyhlh.f_tsyxzh; model_tbl_ld_yhb.f_htbh = model_tbl_ld_dyhlh.f_htbh; model_tbl_ld_yhb.f_htfj = model_tbl_ld_dyhlh.f_htfj; model_tbl_ld_yhb.f_sfzh = model_tbl_ld_dyhlh.f_sfzh; model_tbl_ld_yhb.f_sfzfj = model_tbl_ld_dyhlh.f_sfzfj; model_tbl_ld_yhb.f_sfzzs = model_tbl_ld_dyhlh.f_sfzzs; model_tbl_ld_yhb.f_zt = model_tbl_ld_dyhlh.f_yhzt; model_tbl_ld_yhb.f_ztid = model_tbl_ld_dyhlh.f_yhztid; model_tbl_ld_yhb.f_bz = model_tbl_ld_dyhlh.f_yhbz; model_tbl_ld_yhb.f_khbh = khbh; model_tbl_ld_yhb.f_qtfj = model_tbl_ld_dyhlh.f_qtfj; model_tbl_ld_yhb.f_htqdrq = model_tbl_ld_dyhlh.f_htqdrq; model_tbl_ld_yhb.f_ztyhh = ""; model_tbl_ld_yhb.f_wxwybz = ""; model_tbl_ld_yhb.f_zfbwybz = ""; model_tbl_ld_yhb.f_gdyxwybz = ""; string yhbhid = idal_tbl_ld_yhb.Add(model_tbl_ld_yhb, null); #endregion #region 向水表表更新数据 model_tbl_ld_sbb.sys_id = int.Parse(sbbh); model_tbl_ld_sbb.sys_orderid = ""; model_tbl_ld_sbb.sys_creatuserid = userid; model_tbl_ld_sbb.sys_creatusername = username; model_tbl_ld_sbb.sys_creatdate = DateTime.Now; model_tbl_ld_sbb.sys_lastedituserid = userid; model_tbl_ld_sbb.sys_lasteditusername = username; model_tbl_ld_sbb.sys_lasteditdate = DateTime.Now; model_tbl_ld_sbb.sys_deluserid = ""; model_tbl_ld_sbb.sys_delusername = ""; model_tbl_ld_sbb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_sbb.sys_delflag = "0"; model_tbl_ld_sbb.f_value1 = ""; model_tbl_ld_sbb.f_value2 = ""; model_tbl_ld_sbb.f_value3 = ""; model_tbl_ld_sbb.f_value4 = ""; model_tbl_ld_sbb.f_value5 = ""; model_tbl_ld_sbb.f_value6 = ""; model_tbl_ld_sbb.f_value7 = ""; model_tbl_ld_sbb.f_value8 = ""; model_tbl_ld_sbb.f_value9 = ""; model_tbl_ld_sbb.f_value10 = ""; model_tbl_ld_sbb.f_sbbh = sbbh; model_tbl_ld_sbb.f_ztsbh = ""; model_tbl_ld_sbb.f_lxth = sbbh.Substring(3, 7); model_tbl_ld_sbb.f_sbfz = model_tbl_ld_dyhlh.f_sbfz; model_tbl_ld_sbb.f_sbfzid = model_tbl_ld_dyhlh.f_sbfzid; model_tbl_ld_sbb.f_sbpp = model_tbl_ld_dyhlh.f_sbpp; model_tbl_ld_sbb.f_mph = model_tbl_ld_dyhlh.f_mph; model_tbl_ld_sbb.f_sbdz = model_tbl_ld_dyhlh.f_sbdz; model_tbl_ld_sbb.f_khbh = khbh; model_tbl_ld_sbb.f_rs = model_tbl_ld_dyhlh.f_rs; model_tbl_ld_sbb.f_sbkj = model_tbl_ld_dyhlh.f_sbkj; model_tbl_ld_sbb.f_sbkjid = model_tbl_ld_dyhlh.f_sbkjid; model_tbl_ld_sbb.f_sblx = model_tbl_ld_dyhlh.f_sblx; model_tbl_ld_sbb.f_sblxid = model_tbl_ld_dyhlh.f_sblxid; model_tbl_ld_sbb.f_jllx = model_tbl_ld_dyhlh.f_jllx; model_tbl_ld_sbb.f_jllxid = model_tbl_ld_dyhlh.f_jllxid; model_tbl_ld_sbb.f_cszm = model_tbl_ld_dyhlh.f_cszm; model_tbl_ld_sbb.f_bqzm = "0"; model_tbl_ld_sbb.f_sqzm = "0"; model_tbl_ld_sbb.f_sqsl = "0"; model_tbl_ld_sbb.f_ljgl = "0"; model_tbl_ld_sbb.f_qsqpjsl = "0"; model_tbl_ld_sbb.f_qlqpjsl = "0"; model_tbl_ld_sbb.f_zt = model_tbl_ld_dyhlh.f_sbzt; model_tbl_ld_sbb.f_ztid = model_tbl_ld_dyhlh.f_sbztid; model_tbl_ld_sbb.f_bz = model_tbl_ld_dyhlh.f_sbbz; model_tbl_ld_sbb.f_bqsl = "0"; model_tbl_ld_sbb.f_nljgl = "0"; model_tbl_ld_sbb.f_azrq = model_tbl_ld_dyhlh.f_azrq; model_tbl_ld_sbb.f_qfzt = model_tbl_ld_dyhlh.f_qfzt; model_tbl_ld_sbb.f_fj = model_tbl_ld_dyhlh.f_sbfj; model_tbl_ld_sbb.f_synx = model_tbl_ld_dyhlh.f_synx; string sbbhid = idal_tbl_ld_sbb.Add(model_tbl_ld_sbb, null); #endregion #region 向客户表更新数据 model_tbl_ld_khb.sys_id = int.Parse(khbh); model_tbl_ld_khb.sys_orderid = ""; model_tbl_ld_khb.sys_creatuserid = ""; model_tbl_ld_khb.sys_creatusername = ""; model_tbl_ld_khb.sys_creatdate = DateTime.Now; model_tbl_ld_khb.sys_lastedituserid = ""; model_tbl_ld_khb.sys_lasteditusername = ""; model_tbl_ld_khb.sys_lasteditdate = DateTime.Now; model_tbl_ld_khb.sys_deluserid = ""; model_tbl_ld_khb.sys_delusername = ""; model_tbl_ld_khb.sys_deldate = DateTime.Parse("1900-1-1"); model_tbl_ld_khb.sys_delflag = "0"; model_tbl_ld_khb.f_value1 = ""; model_tbl_ld_khb.f_value2 = ""; model_tbl_ld_khb.f_value3 = ""; model_tbl_ld_khb.f_value4 = ""; model_tbl_ld_khb.f_value5 = ""; model_tbl_ld_khb.f_value6 = ""; model_tbl_ld_khb.f_value7 = ""; model_tbl_ld_khb.f_value8 = ""; model_tbl_ld_khb.f_value9 = ""; model_tbl_ld_khb.f_value10 = ""; model_tbl_ld_khb.f_khbh = khbh; model_tbl_ld_khb.f_ztkhh = ""; model_tbl_ld_khb.f_khfz = model_tbl_ld_dyhlh.f_khfz; model_tbl_ld_khb.f_khfzid = model_tbl_ld_dyhlh.f_khfzid; model_tbl_ld_khb.f_ycje = model_tbl_ld_dyhlh.f_ycje; model_tbl_ld_khb.f_yslx = model_tbl_ld_dyhlh.f_yslx; model_tbl_ld_khb.f_yslxid = model_tbl_ld_dyhlh.f_yslxid; model_tbl_ld_khb.f_tbbh = model_tbl_ld_dyhlh.f_tbbh; model_tbl_ld_khb.f_sfjlbjf = model_tbl_ld_dyhlh.f_sfjlbjf; model_tbl_ld_khb.f_zt = model_tbl_ld_dyhlh.f_khzt; model_tbl_ld_khb.f_ztid = model_tbl_ld_dyhlh.f_khztid; model_tbl_ld_khb.f_bz = model_tbl_ld_dyhlh.f_khbz; model_tbl_ld_khb.f_cbbh = model_tbl_ld_dyhlh.f_cbbh; model_tbl_ld_khb.f_cbbhid = model_tbl_ld_dyhlh.f_cbbhid; model_tbl_ld_khb.f_cbxh = int.Parse(khbh).ToString(); model_tbl_ld_khb.f_cbyxm = model_tbl_ld_cben.f_cbymc; model_tbl_ld_khb.f_cbyid = model_tbl_ld_cben.f_cbyid; model_tbl_ld_khb.f_cbzq = model_tbl_ld_cben.f_cbzq; model_tbl_ld_khb.f_cbmc = model_tbl_ld_cben.f_cbmc; model_tbl_ld_khb.f_yhbh = model_tbl_ld_yhb.f_yhbh; model_tbl_ld_khb.f_yhbhid = model_tbl_ld_yhb.sys_id.ToString(); model_tbl_ld_khb.f_jfm = model_tbl_ld_dyhlh.f_jfm; model_tbl_ld_khb.f_yhfz = model_tbl_ld_dyhlh.f_yhfz; model_tbl_ld_khb.f_yhfzid = model_tbl_ld_dyhlh.f_yhfzid; model_tbl_ld_khb.f_dz = model_tbl_ld_dyhlh.f_dz; model_tbl_ld_khb.f_dh = model_tbl_ld_dyhlh.f_dh; model_tbl_ld_khb.f_dy = model_tbl_ld_dyhlh.f_dy; model_tbl_ld_khb.f_dyid = model_tbl_ld_dyhlh.f_dyid; model_tbl_ld_khb.f_sc = model_tbl_ld_dyhlh.f_sc; model_tbl_ld_khb.f_scid = model_tbl_ld_dyhlh.f_scid; model_tbl_ld_khb.f_qy = model_tbl_ld_dyhlh.f_qy; model_tbl_ld_khb.f_qyid = model_tbl_ld_dyhlh.f_qyid; model_tbl_ld_khb.f_pq = model_tbl_ld_dyhlh.f_pq; model_tbl_ld_khb.f_pqid = model_tbl_ld_dyhlh.f_pqid; model_tbl_ld_khb.f_tsyxzh = model_tbl_ld_dyhlh.f_tsyxzh; model_tbl_ld_khb.f_hth = model_tbl_ld_dyhlh.f_htbh; model_tbl_ld_khb.f_sfzh = model_tbl_ld_dyhlh.f_sfzh; model_tbl_ld_khb.f_khrq = model_tbl_ld_dyhlh.f_khrq; model_tbl_ld_khb.f_sbbh = model_tbl_ld_sbb.f_sbbh; model_tbl_ld_khb.f_sbbhid = model_tbl_ld_sbb.sys_id.ToString(); model_tbl_ld_khb.f_bqzm = model_tbl_ld_sbb.f_bqzm; model_tbl_ld_khb.f_sqzm = model_tbl_ld_sbb.f_sqzm; model_tbl_ld_khb.f_bqsl = model_tbl_ld_sbb.f_bqsl; model_tbl_ld_khb.f_sqsl = model_tbl_ld_sbb.f_sqsl; model_tbl_ld_khb.f_qsqpjsl = model_tbl_ld_sbb.f_qsqpjsl; model_tbl_ld_khb.f_qlqpjsl = model_tbl_ld_sbb.f_qlqpjsl; model_tbl_ld_khb.f_ljgl = model_tbl_ld_sbb.f_ljgl; model_tbl_ld_khb.f_lxth = model_tbl_ld_sbb.f_lxth; model_tbl_ld_khb.f_sblx = model_tbl_ld_dyhlh.f_sblx; model_tbl_ld_khb.f_sblxid = model_tbl_ld_dyhlh.f_sblxid; model_tbl_ld_khb.f_jllx = model_tbl_ld_dyhlh.f_jllx; model_tbl_ld_khb.f_jllxid = model_tbl_ld_dyhlh.f_jllxid; model_tbl_ld_khb.f_sbdz = model_tbl_ld_sbb.f_sbdz; model_tbl_ld_khb.f_tssbbh = ""; model_tbl_ld_khb.f_ztsbh = ""; model_tbl_ld_khb.f_rs = model_tbl_ld_dyhlh.f_rs; model_tbl_ld_khb.f_sbkj = model_tbl_ld_dyhlh.f_sbkj; model_tbl_ld_khb.f_sbkjid = model_tbl_ld_dyhlh.f_sbkjid; model_tbl_ld_khb.f_sbfz = model_tbl_ld_dyhlh.f_sbfz; model_tbl_ld_khb.f_sbfzid = model_tbl_ld_dyhlh.f_sbfzid; model_tbl_ld_khb.f_ztyhh = ""; model_tbl_ld_khb.f_wxwybz = ""; model_tbl_ld_khb.f_zfbwybz = ""; model_tbl_ld_khb.f_gdyhwybz = ""; model_tbl_ld_khb.f_yhm = model_tbl_ld_dyhlh.f_yhm; model_tbl_ld_khb.f_zhcbrq = model_tbl_ld_dyhlh.f_zhcbrq; model_tbl_ld_khb.f_ljqf = "0"; model_tbl_ld_khb.f_tjjzpwf = model_tbl_ld_dyhlh.f_tjjzpwf; model_tbl_ld_khb.f_tjjzsf = model_tbl_ld_dyhlh.f_tjjzsf; model_tbl_ld_khb.f_tssbbhid = ""; model_tbl_ld_khb.f_nljgl = model_tbl_ld_sbb.f_nljgl; model_tbl_ld_khb.f_sqysl = model_tbl_ld_dyhlh.f_sqysl; model_tbl_ld_khb.f_jhysl = model_tbl_ld_dyhlh.f_jhysl; model_tbl_ld_khb.f_ickljgl = "0"; string khbhid = idal_tbl_ld_khb.Add(model_tbl_ld_khb, null); #endregion //更新本表的状态,操作时间,操作人 model_tbl_ld_dyhlh.f_value2 = khbh; model_tbl_ld_dyhlh.f_zt = "归档"; model_tbl_ld_dyhlh.f_ztid = "2"; model_tbl_ld_dyhlh.f_czr = username; model_tbl_ld_dyhlh.f_czrid = userid; model_tbl_ld_dyhlh.f_czrsj = DateTime.Now; idal_tbl_ld_dyhlh.Update(model_tbl_ld_dyhlh, "f_value2,f_zt,f_ztid,f_czr,f_czrid,f_czrsj", null); #endregion //调整数据状态 NameValueCollection nvc_maintableparameters = new NameValueCollection(); nvc_maintableparameters.Add("sys_processnextuser", "^nextuser"); nvc_maintableparameters.Add("fk_tbl_maintable_sys_id", "^null"); nvc_maintableparameters.Add("fk_workflow_sys_id", "^null"); result = _hic.NextStateItemNew(sys_idss[i].ToString(), nvc_maintableparameters, str_facterid, ds_facter, str_txt_bak_message, "", "", clientInf, _t); if (result == "") { _t.getTrans().commit(); } else { _t.getTrans().rollback(); all_result = "{\"result\":\"false\",\"message\":\"" + result + "\"}"; } } } catch (Exception ex) { all_result = "{\"result\":\"false\",\"message\":\"" + ex.Message + "\"}"; } } if (all_result == "") { // all_result = "{\"result\":\"true\",\"message\":\"\"}"; } return(all_result); }