/// <summary> /// 重写更新updatepaper /// </summary> /// <param name="json"></param> /// <param name="columns"></param> /// <param name="clientInf"></param> /// <returns></returns> public string Update(sara.dd.ldsw.model.tbl_ld_cben model, string columns, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { String[] columnsArray = columns.Split(','); List <string> columsList = new List <string>(columnsArray); List <OracleParameter> parameterList = new List <OracleParameter>(); OracleParameter parameter = null; #region sqlString StringBuilder strSql = new StringBuilder(); StringBuilder strSql_use = new StringBuilder(); strSql.Append("update tbl_ld_cben set "); strSql_use.Append("update tbl_ld_cben set "); if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter") { } else //如果是sql形式的话,则进行textReturn { model = Eva.Library.Format.FormatTextTool.ModelFormat(model); } if (model.sys_orderid != null && columsList.Contains("sys_orderid")) { strSql.Append("sys_orderid='" + (model.sys_orderid) + "',"); strSql_use.Append("sys_orderid=:sys_orderid,"); parameter = new OracleParameter(":sys_orderid", OracleType.VarChar); parameter.Value = model.sys_orderid; parameterList.Add(parameter); } if (model.sys_creatuserid != null && columsList.Contains("sys_creatuserid")) { strSql.Append("sys_creatuserid='" + (model.sys_creatuserid) + "',"); strSql_use.Append("sys_creatuserid=:sys_creatuserid,"); parameter = new OracleParameter(":sys_creatuserid", OracleType.VarChar); parameter.Value = model.sys_creatuserid; parameterList.Add(parameter); } if (model.sys_creatusername != null && columsList.Contains("sys_creatusername")) { strSql.Append("sys_creatusername='******',"); strSql_use.Append("sys_creatusername=:sys_creatusername,"); parameter = new OracleParameter(":sys_creatusername", OracleType.VarChar); parameter.Value = model.sys_creatusername; parameterList.Add(parameter); } if (model.sys_creatdate != null && columsList.Contains("sys_creatdate")) { strSql.Append("sys_creatdate=to_date('" + model.sys_creatdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql_use.Append("sys_creatdate=:sys_creatdate,"); parameter = new OracleParameter(":sys_creatdate", OracleType.DateTime); parameter.Value = model.sys_creatdate; parameterList.Add(parameter); } if (model.sys_lastedituserid != null && columsList.Contains("sys_lastedituserid")) { strSql.Append("sys_lastedituserid='" + (model.sys_lastedituserid) + "',"); strSql_use.Append("sys_lastedituserid=:sys_lastedituserid,"); parameter = new OracleParameter(":sys_lastedituserid", OracleType.VarChar); parameter.Value = model.sys_lastedituserid; parameterList.Add(parameter); } if (model.sys_lasteditusername != null && columsList.Contains("sys_lasteditusername")) { strSql.Append("sys_lasteditusername='******',"); strSql_use.Append("sys_lasteditusername=:sys_lasteditusername,"); parameter = new OracleParameter(":sys_lasteditusername", OracleType.VarChar); parameter.Value = model.sys_lasteditusername; parameterList.Add(parameter); } if (model.sys_lasteditdate != null && columsList.Contains("sys_lasteditdate")) { strSql.Append("sys_lasteditdate=to_date('" + model.sys_lasteditdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql_use.Append("sys_lasteditdate=:sys_lasteditdate,"); parameter = new OracleParameter(":sys_lasteditdate", OracleType.DateTime); parameter.Value = model.sys_lasteditdate; parameterList.Add(parameter); } if (model.sys_deluserid != null && columsList.Contains("sys_deluserid")) { strSql.Append("sys_deluserid='" + (model.sys_deluserid) + "',"); strSql_use.Append("sys_deluserid=:sys_deluserid,"); parameter = new OracleParameter(":sys_deluserid", OracleType.VarChar); parameter.Value = model.sys_deluserid; parameterList.Add(parameter); } if (model.sys_delusername != null && columsList.Contains("sys_delusername")) { strSql.Append("sys_delusername='******',"); strSql_use.Append("sys_delusername=:sys_delusername,"); parameter = new OracleParameter(":sys_delusername", OracleType.VarChar); parameter.Value = model.sys_delusername; parameterList.Add(parameter); } if (model.sys_deldate != null && columsList.Contains("sys_deldate")) { strSql.Append("sys_deldate=to_date('" + model.sys_deldate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql_use.Append("sys_deldate=:sys_deldate,"); parameter = new OracleParameter(":sys_deldate", OracleType.DateTime); parameter.Value = model.sys_deldate; parameterList.Add(parameter); } if (model.sys_delflag != null && columsList.Contains("sys_delflag")) { strSql.Append("sys_delflag='" + (model.sys_delflag) + "',"); strSql_use.Append("sys_delflag=:sys_delflag,"); parameter = new OracleParameter(":sys_delflag", OracleType.VarChar); parameter.Value = model.sys_delflag; parameterList.Add(parameter); } if (model.f_value1 != null && columsList.Contains("f_value1")) { strSql.Append("f_value1='" + (model.f_value1) + "',"); strSql_use.Append("f_value1=:f_value1,"); parameter = new OracleParameter(":f_value1", OracleType.VarChar); parameter.Value = model.f_value1; parameterList.Add(parameter); } if (model.f_value2 != null && columsList.Contains("f_value2")) { strSql.Append("f_value2='" + (model.f_value2) + "',"); strSql_use.Append("f_value2=:f_value2,"); parameter = new OracleParameter(":f_value2", OracleType.VarChar); parameter.Value = model.f_value2; parameterList.Add(parameter); } if (model.f_value3 != null && columsList.Contains("f_value3")) { strSql.Append("f_value3='" + (model.f_value3) + "',"); strSql_use.Append("f_value3=:f_value3,"); parameter = new OracleParameter(":f_value3", OracleType.VarChar); parameter.Value = model.f_value3; parameterList.Add(parameter); } if (model.f_value4 != null && columsList.Contains("f_value4")) { strSql.Append("f_value4='" + (model.f_value4) + "',"); strSql_use.Append("f_value4=:f_value4,"); parameter = new OracleParameter(":f_value4", OracleType.VarChar); parameter.Value = model.f_value4; parameterList.Add(parameter); } if (model.f_value5 != null && columsList.Contains("f_value5")) { strSql.Append("f_value5='" + (model.f_value5) + "',"); strSql_use.Append("f_value5=:f_value5,"); parameter = new OracleParameter(":f_value5", OracleType.VarChar); parameter.Value = model.f_value5; parameterList.Add(parameter); } if (model.f_value6 != null && columsList.Contains("f_value6")) { strSql.Append("f_value6='" + (model.f_value6) + "',"); strSql_use.Append("f_value6=:f_value6,"); parameter = new OracleParameter(":f_value6", OracleType.VarChar); parameter.Value = model.f_value6; parameterList.Add(parameter); } if (model.f_value7 != null && columsList.Contains("f_value7")) { strSql.Append("f_value7='" + (model.f_value7) + "',"); strSql_use.Append("f_value7=:f_value7,"); parameter = new OracleParameter(":f_value7", OracleType.VarChar); parameter.Value = model.f_value7; parameterList.Add(parameter); } if (model.f_value8 != null && columsList.Contains("f_value8")) { strSql.Append("f_value8='" + (model.f_value8) + "',"); strSql_use.Append("f_value8=:f_value8,"); parameter = new OracleParameter(":f_value8", OracleType.VarChar); parameter.Value = model.f_value8; parameterList.Add(parameter); } if (model.f_value9 != null && columsList.Contains("f_value9")) { strSql.Append("f_value9='" + (model.f_value9) + "',"); strSql_use.Append("f_value9=:f_value9,"); parameter = new OracleParameter(":f_value9", OracleType.VarChar); parameter.Value = model.f_value9; parameterList.Add(parameter); } if (model.f_value10 != null && columsList.Contains("f_value10")) { strSql.Append("f_value10='" + (model.f_value10) + "',"); strSql_use.Append("f_value10=:f_value10,"); parameter = new OracleParameter(":f_value10", OracleType.VarChar); parameter.Value = model.f_value10; parameterList.Add(parameter); } if (model.f_cbbh != null && columsList.Contains("f_cbbh")) { strSql.Append("f_cbbh='" + (model.f_cbbh) + "',"); strSql_use.Append("f_cbbh=:f_cbbh,"); parameter = new OracleParameter(":f_cbbh", OracleType.VarChar); parameter.Value = model.f_cbbh; parameterList.Add(parameter); } if (model.f_cbmc != null && columsList.Contains("f_cbmc")) { strSql.Append("f_cbmc='" + (model.f_cbmc) + "',"); strSql_use.Append("f_cbmc=:f_cbmc,"); parameter = new OracleParameter(":f_cbmc", OracleType.VarChar); parameter.Value = model.f_cbmc; parameterList.Add(parameter); } if (model.f_cbzq != null && columsList.Contains("f_cbzq")) { strSql.Append("f_cbzq='" + (model.f_cbzq) + "',"); strSql_use.Append("f_cbzq=:f_cbzq,"); parameter = new OracleParameter(":f_cbzq", OracleType.VarChar); parameter.Value = model.f_cbzq; parameterList.Add(parameter); } if (model.f_ksyf != null && columsList.Contains("f_ksyf")) { strSql.Append("f_ksyf='" + (model.f_ksyf) + "',"); strSql_use.Append("f_ksyf=:f_ksyf,"); parameter = new OracleParameter(":f_ksyf", OracleType.VarChar); parameter.Value = model.f_ksyf; parameterList.Add(parameter); } if (model.f_cbymc != null && columsList.Contains("f_cbymc")) { strSql.Append("f_cbymc='" + (model.f_cbymc) + "',"); strSql_use.Append("f_cbymc=:f_cbymc,"); parameter = new OracleParameter(":f_cbymc", OracleType.VarChar); parameter.Value = model.f_cbymc; parameterList.Add(parameter); } if (model.f_cbyid != null && columsList.Contains("f_cbyid")) { strSql.Append("f_cbyid='" + (model.f_cbyid) + "',"); strSql_use.Append("f_cbyid=:f_cbyid,"); parameter = new OracleParameter(":f_cbyid", OracleType.VarChar); parameter.Value = model.f_cbyid; parameterList.Add(parameter); } if (model.f_cbyphoto != null && columsList.Contains("f_cbyphoto")) { strSql.Append("f_cbyphoto='" + (model.f_cbyphoto) + "',"); strSql_use.Append("f_cbyphoto=:f_cbyphoto,"); parameter = new OracleParameter(":f_cbyphoto", OracleType.VarChar); parameter.Value = model.f_cbyphoto; parameterList.Add(parameter); } if (model.f_zt != null && columsList.Contains("f_zt")) { strSql.Append("f_zt='" + (model.f_zt) + "',"); strSql_use.Append("f_zt=:f_zt,"); parameter = new OracleParameter(":f_zt", OracleType.VarChar); parameter.Value = model.f_zt; parameterList.Add(parameter); } if (model.f_ztid != null && columsList.Contains("f_ztid")) { strSql.Append("f_ztid='" + (model.f_ztid) + "',"); strSql_use.Append("f_ztid=:f_ztid,"); parameter = new OracleParameter(":f_ztid", OracleType.VarChar); parameter.Value = model.f_ztid; parameterList.Add(parameter); } if (model.f_bz != null && columsList.Contains("f_bz")) { strSql.Append("f_bz='" + (model.f_bz) + "',"); strSql_use.Append("f_bz=:f_bz,"); parameter = new OracleParameter(":f_bz", OracleType.VarChar); parameter.Value = model.f_bz; parameterList.Add(parameter); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where sys_id='" + model.sys_id + "'"); n = strSql_use.ToString().LastIndexOf(","); strSql_use.Remove(n, 1); strSql_use.Append(" where sys_id='" + model.sys_id + "'"); #endregion int columscount = 0; if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter") { #region parameter if (parameterList.Count > 0) { if (t == null) { columscount = _iAccessData.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } else { columscount = t.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } } #endregion } else { #region sql if (t == null) { columscount = _iAccessData.ExecuteSql(strSql.ToString()); } else { columscount = t.ExecuteSql(strSql.ToString()); } #endregion } return(columscount.ToString()); }
/// <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); }
/// <summary> /// 重写添加addlayerconfig /// </summary> /// <param name="json"></param> /// <param name="clientInf"></param> /// <returns></returns> public string Add(sara.dd.ldsw.model.tbl_ld_cben model, Eva.Library.Data.AccessDataTrans.IAccessDataTrans t) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql_use = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); StringBuilder strSql3 = new StringBuilder(); if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter") { } else //如果是sql形式的话,则进行textFormat { model = Eva.Library.Format.FormatTextTool.ModelFormat(model); } List <OracleParameter> parameterList = new List <OracleParameter>(); OracleParameter parameter = null; string sid = ""; if (model.sys_id <= 0) { if (t == null) { sid = GetMaxId(null).ToString(); } else { sid = GetMaxId(t).ToString(); } model.sys_id = int.Parse(sid); } else { sid = model.sys_id.ToString(); } #region sqlString strSql1.Append("sys_id,"); strSql2.Append("'" + sid + "',"); strSql3.Append(":sys_id,"); parameter = new OracleParameter(":sys_id", OracleType.Number); parameter.Value = sid; parameterList.Add(parameter); if (model.sys_orderid != null) { strSql1.Append("sys_orderid,"); strSql2.Append("'" + (model.sys_orderid) + "',"); strSql3.Append(":sys_orderid,"); parameter = new OracleParameter(":sys_orderid", OracleType.VarChar); parameter.Value = model.sys_orderid; parameterList.Add(parameter); } if (model.sys_creatuserid != null) { strSql1.Append("sys_creatuserid,"); strSql2.Append("'" + (model.sys_creatuserid) + "',"); strSql3.Append(":sys_creatuserid,"); parameter = new OracleParameter(":sys_creatuserid", OracleType.VarChar); parameter.Value = model.sys_creatuserid; parameterList.Add(parameter); } if (model.sys_creatusername != null) { strSql1.Append("sys_creatusername,"); strSql2.Append("'" + (model.sys_creatusername) + "',"); strSql3.Append(":sys_creatusername,"); parameter = new OracleParameter(":sys_creatusername", OracleType.VarChar); parameter.Value = model.sys_creatusername; parameterList.Add(parameter); } if (model.sys_creatdate != null) { strSql1.Append("sys_creatdate,"); strSql2.Append("to_date('" + model.sys_creatdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql3.Append(":sys_creatdate,"); parameter = new OracleParameter(":sys_creatdate", OracleType.DateTime); parameter.Value = model.sys_creatdate; parameterList.Add(parameter); } if (model.sys_lastedituserid != null) { strSql1.Append("sys_lastedituserid,"); strSql2.Append("'" + (model.sys_lastedituserid) + "',"); strSql3.Append(":sys_lastedituserid,"); parameter = new OracleParameter(":sys_lastedituserid", OracleType.VarChar); parameter.Value = model.sys_lastedituserid; parameterList.Add(parameter); } if (model.sys_lasteditusername != null) { strSql1.Append("sys_lasteditusername,"); strSql2.Append("'" + (model.sys_lasteditusername) + "',"); strSql3.Append(":sys_lasteditusername,"); parameter = new OracleParameter(":sys_lasteditusername", OracleType.VarChar); parameter.Value = model.sys_lasteditusername; parameterList.Add(parameter); } if (model.sys_lasteditdate != null) { strSql1.Append("sys_lasteditdate,"); strSql2.Append("to_date('" + model.sys_lasteditdate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql3.Append(":sys_lasteditdate,"); parameter = new OracleParameter(":sys_lasteditdate", OracleType.DateTime); parameter.Value = model.sys_lasteditdate; parameterList.Add(parameter); } if (model.sys_deluserid != null) { strSql1.Append("sys_deluserid,"); strSql2.Append("'" + (model.sys_deluserid) + "',"); strSql3.Append(":sys_deluserid,"); parameter = new OracleParameter(":sys_deluserid", OracleType.VarChar); parameter.Value = model.sys_deluserid; parameterList.Add(parameter); } if (model.sys_delusername != null) { strSql1.Append("sys_delusername,"); strSql2.Append("'" + (model.sys_delusername) + "',"); strSql3.Append(":sys_delusername,"); parameter = new OracleParameter(":sys_delusername", OracleType.VarChar); parameter.Value = model.sys_delusername; parameterList.Add(parameter); } if (model.sys_deldate != null) { strSql1.Append("sys_deldate,"); strSql2.Append("to_date('" + model.sys_deldate.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss'),"); strSql3.Append(":sys_deldate,"); parameter = new OracleParameter(":sys_deldate", OracleType.DateTime); parameter.Value = model.sys_deldate; parameterList.Add(parameter); } if (model.sys_delflag != null) { strSql1.Append("sys_delflag,"); strSql2.Append("'" + (model.sys_delflag) + "',"); strSql3.Append(":sys_delflag,"); parameter = new OracleParameter(":sys_delflag", OracleType.VarChar); parameter.Value = model.sys_delflag; parameterList.Add(parameter); } if (model.f_value1 != null) { strSql1.Append("f_value1,"); strSql2.Append("'" + (model.f_value1) + "',"); strSql3.Append(":f_value1,"); parameter = new OracleParameter(":f_value1", OracleType.VarChar); parameter.Value = model.f_value1; parameterList.Add(parameter); } if (model.f_value2 != null) { strSql1.Append("f_value2,"); strSql2.Append("'" + (model.f_value2) + "',"); strSql3.Append(":f_value2,"); parameter = new OracleParameter(":f_value2", OracleType.VarChar); parameter.Value = model.f_value2; parameterList.Add(parameter); } if (model.f_value3 != null) { strSql1.Append("f_value3,"); strSql2.Append("'" + (model.f_value3) + "',"); strSql3.Append(":f_value3,"); parameter = new OracleParameter(":f_value3", OracleType.VarChar); parameter.Value = model.f_value3; parameterList.Add(parameter); } if (model.f_value4 != null) { strSql1.Append("f_value4,"); strSql2.Append("'" + (model.f_value4) + "',"); strSql3.Append(":f_value4,"); parameter = new OracleParameter(":f_value4", OracleType.VarChar); parameter.Value = model.f_value4; parameterList.Add(parameter); } if (model.f_value5 != null) { strSql1.Append("f_value5,"); strSql2.Append("'" + (model.f_value5) + "',"); strSql3.Append(":f_value5,"); parameter = new OracleParameter(":f_value5", OracleType.VarChar); parameter.Value = model.f_value5; parameterList.Add(parameter); } if (model.f_value6 != null) { strSql1.Append("f_value6,"); strSql2.Append("'" + (model.f_value6) + "',"); strSql3.Append(":f_value6,"); parameter = new OracleParameter(":f_value6", OracleType.VarChar); parameter.Value = model.f_value6; parameterList.Add(parameter); } if (model.f_value7 != null) { strSql1.Append("f_value7,"); strSql2.Append("'" + (model.f_value7) + "',"); strSql3.Append(":f_value7,"); parameter = new OracleParameter(":f_value7", OracleType.VarChar); parameter.Value = model.f_value7; parameterList.Add(parameter); } if (model.f_value8 != null) { strSql1.Append("f_value8,"); strSql2.Append("'" + (model.f_value8) + "',"); strSql3.Append(":f_value8,"); parameter = new OracleParameter(":f_value8", OracleType.VarChar); parameter.Value = model.f_value8; parameterList.Add(parameter); } if (model.f_value9 != null) { strSql1.Append("f_value9,"); strSql2.Append("'" + (model.f_value9) + "',"); strSql3.Append(":f_value9,"); parameter = new OracleParameter(":f_value9", OracleType.VarChar); parameter.Value = model.f_value9; parameterList.Add(parameter); } if (model.f_value10 != null) { strSql1.Append("f_value10,"); strSql2.Append("'" + (model.f_value10) + "',"); strSql3.Append(":f_value10,"); parameter = new OracleParameter(":f_value10", OracleType.VarChar); parameter.Value = model.f_value10; parameterList.Add(parameter); } if (model.f_cbbh != null) { strSql1.Append("f_cbbh,"); strSql2.Append("'" + (model.f_cbbh) + "',"); strSql3.Append(":f_cbbh,"); parameter = new OracleParameter(":f_cbbh", OracleType.VarChar); parameter.Value = model.f_cbbh; parameterList.Add(parameter); } if (model.f_cbmc != null) { strSql1.Append("f_cbmc,"); strSql2.Append("'" + (model.f_cbmc) + "',"); strSql3.Append(":f_cbmc,"); parameter = new OracleParameter(":f_cbmc", OracleType.VarChar); parameter.Value = model.f_cbmc; parameterList.Add(parameter); } if (model.f_cbzq != null) { strSql1.Append("f_cbzq,"); strSql2.Append("'" + (model.f_cbzq) + "',"); strSql3.Append(":f_cbzq,"); parameter = new OracleParameter(":f_cbzq", OracleType.VarChar); parameter.Value = model.f_cbzq; parameterList.Add(parameter); } if (model.f_ksyf != null) { strSql1.Append("f_ksyf,"); strSql2.Append("'" + (model.f_ksyf) + "',"); strSql3.Append(":f_ksyf,"); parameter = new OracleParameter(":f_ksyf", OracleType.VarChar); parameter.Value = model.f_ksyf; parameterList.Add(parameter); } if (model.f_cbymc != null) { strSql1.Append("f_cbymc,"); strSql2.Append("'" + (model.f_cbymc) + "',"); strSql3.Append(":f_cbymc,"); parameter = new OracleParameter(":f_cbymc", OracleType.VarChar); parameter.Value = model.f_cbymc; parameterList.Add(parameter); } if (model.f_cbyid != null) { strSql1.Append("f_cbyid,"); strSql2.Append("'" + (model.f_cbyid) + "',"); strSql3.Append(":f_cbyid,"); parameter = new OracleParameter(":f_cbyid", OracleType.VarChar); parameter.Value = model.f_cbyid; parameterList.Add(parameter); } if (model.f_cbyphoto != null) { strSql1.Append("f_cbyphoto,"); strSql2.Append("'" + (model.f_cbyphoto) + "',"); strSql3.Append(":f_cbyphoto,"); parameter = new OracleParameter(":f_cbyphoto", OracleType.VarChar); parameter.Value = model.f_cbyphoto; parameterList.Add(parameter); } if (model.f_zt != null) { strSql1.Append("f_zt,"); strSql2.Append("'" + (model.f_zt) + "',"); strSql3.Append(":f_zt,"); parameter = new OracleParameter(":f_zt", OracleType.VarChar); parameter.Value = model.f_zt; parameterList.Add(parameter); } if (model.f_ztid != null) { strSql1.Append("f_ztid,"); strSql2.Append("'" + (model.f_ztid) + "',"); strSql3.Append(":f_ztid,"); parameter = new OracleParameter(":f_ztid", OracleType.VarChar); parameter.Value = model.f_ztid; parameterList.Add(parameter); } if (model.f_bz != null) { strSql1.Append("f_bz,"); strSql2.Append("'" + (model.f_bz) + "',"); strSql3.Append(":f_bz,"); parameter = new OracleParameter(":f_bz", OracleType.VarChar); parameter.Value = model.f_bz; parameterList.Add(parameter); } strSql.Append("insert into tbl_ld_cben("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql_use.Append("insert into tbl_ld_cben("); strSql_use.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql_use.Append(")"); strSql_use.Append(" values ("); strSql_use.Append(strSql3.ToString().Remove(strSql3.Length - 1)); strSql_use.Append(")"); #endregion if (Eva.Library.Configuration.ConfigurationManager.AppSettings["SqlEditMode"].ToString() == "parameter") { #region parameter if (parameterList.Count > 0) { if (t == null) { _iAccessData.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } else { t.ExecuteSql(strSql_use.ToString(), parameterList.ToArray()); } } #endregion } else { #region sql if (t == null) { _iAccessData.ExecuteSql(strSql.ToString()); } else { t.ExecuteSql(strSql.ToString()); } List <string> paraStrList = new List <string>(); List <OracleParameter> pList = new List <OracleParameter>(); OracleParameter p = null; if (paraStrList.Count > 0) { string updateSqlString = " update tbl_ld_cben set " + string.Join(" , ", paraStrList.ToArray()) + " where sys_id = '" + sid + "' "; if (pList.Count > 0) { if (t == null) { _iAccessData.ExecuteSql(updateSqlString, pList.ToArray()); } else { t.ExecuteSql(updateSqlString, pList.ToArray()); } } } #endregion } return(sid); }
/// <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 = ""; string sql = ""; _t = commonclass.CreateIAccessDataTrans(); _t.getTrans().begin(); #region businesscode //businesscode //在此处添加针对projclassid = 3的业务代码 //更改水表表,用户表,客户表的状态,抄本信息(多个客户) //置空客户表f_value1,f_value2的状态 //更新本表的状态 model_tbl_ld_xhhbt = idal_tbl_ld_xhhbt.GetList(" fk_tbl_maintable_sys_id='" + sys_idss[i].ToString() + "'", "", "*", "", "", null)[0]; model_tbl_ld_cben = idal_tbl_ld_cben.GetList("f_cbmc ='QH023'", "", "*", "", "", null)[0]; IList <sara.dd.ldsw.model.tbl_ld_xhhbtzb> model_tbl_ld_xhhbtzb = idal_tbl_ld_xhhbtzb.GetList(" fk_tbl_ld_xhhbt_sys_id='" + model_tbl_ld_xhhbt.sys_id + "'", "", "*", "", "", null); foreach (sara.dd.ldsw.model.tbl_ld_xhhbtzb model in model_tbl_ld_xhhbtzb) { model_tbl_ld_khb = idal_tbl_ld_khb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string khfz = model_tbl_ld_khb.f_khfz; string khfzid = model_tbl_ld_khb.f_khfzid; string[] khfzarr = khfz.Split(','); string[] khfzidarr = khfzid.Split(','); string newkhfz = ""; string newkhfzid = ""; if (khfz == "") { newkhfz = "龙达水务清户表"; newkhfzid = "4059"; } else { for (int a = 0; a < khfzarr.Length; a++) { if (khfzarr[a] == "龙达水务新立户表" || khfzarr[a] == "客服中心总表" || khfzarr[a] == "客服中心大用户表" || khfzarr[a] == "经营中心考核表" || khfzarr[a] == "经营中心排子表" || khfzarr[a] == "经营中心远传表" || khfzarr[a] == "经营中心居民表") { } else { newkhfz += khfzarr[a] + ','; newkhfzid += khfzidarr[a] + ','; } } newkhfz = newkhfz.TrimEnd(',') + "," + "龙达水务清户表"; newkhfzid = newkhfzid.TrimEnd(',') + "," + "4059"; } sql = " update tbl_ld_khb set f_zt = '销户' , f_ztid ='1',f_value1='',f_value2='',"; sql += "f_cbbh='" + model_tbl_ld_cben.f_cbbh + "',f_cbbhid='" + model_tbl_ld_cben.sys_id + "',"; sql += "f_cbyxm='" + model_tbl_ld_cben.f_cbymc + "',f_cbyid='" + model_tbl_ld_cben.f_cbyid + "',"; sql += "f_khfz='" + newkhfz + "',f_khfzid='" + newkhfzid + "',"; sql += "f_cbzq='" + model_tbl_ld_cben.f_cbzq + "',f_cbmc='" + model_tbl_ld_cben.f_cbmc + "' where sys_id ='" + model.f_khbhid + "'"; _t.ExecuteSql(sql); //在客户表中加日志 List <IDictionary <string, string> > array = new List <IDictionary <string, string> >(); if (model_tbl_ld_khb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_khb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array.Add(temp); } if (model_tbl_ld_khb.f_khfz != newkhfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_khb.f_khfz); temp.Add("newvalue", newkhfz); temp.Add("name", "客户分组"); array.Add(temp); } if (model_tbl_ld_cben.f_cbbh != model_tbl_ld_khb.f_cbbh) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_cbbh"); temp.Add("oldvalue", model_tbl_ld_khb.f_cbbh); temp.Add("newvalue", model_tbl_ld_cben.f_cbbh); temp.Add("name", "抄本编号"); array.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_khb", model_tbl_ld_khb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array, clientInf, _t); model_tbl_ld_sbb = idal_tbl_ld_sbb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string sbfz = model_tbl_ld_sbb.f_sbfz; string sbfzid = model_tbl_ld_khb.f_sbfzid; string[] sbfzarr = sbfz.Split(','); string[] sbfzidarr = sbfzid.Split(','); string newsbfz = ""; string newsbfzid = ""; if (sbfz == "") { newsbfz = "龙达水务清户表"; newsbfzid = "4100"; } else { for (int a = 0; a < sbfzarr.Length; a++) { if (sbfzarr[a] == "龙达水务新立户表" || sbfzarr[a] == "客服中心总表" || sbfzarr[a] == "客服中心大用户表" || sbfzarr[a] == "经营中心考核表" || sbfzarr[a] == "经营中心排子表" || sbfzarr[a] == "经营中心远传表" || sbfzarr[a] == "经营中心居民表") { } else { newsbfz += sbfzarr[a] + ','; newsbfzid += sbfzidarr[a] + ','; } } newsbfz = newsbfz.TrimEnd(',') + "," + "龙达水务清户表"; newsbfzid = newsbfzid.TrimEnd(',') + "," + "4100"; } sql = " update tbl_ld_sbb set f_zt = '销户' , f_ztid ='1',f_sbfz='" + newsbfz + "',f_sbfzid='" + newsbfzid + "' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在水表表中加日志 List <IDictionary <string, string> > array1 = new List <IDictionary <string, string> >(); if (model_tbl_ld_sbb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_sbb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array1.Add(temp); } if (model_tbl_ld_sbb.f_sbfz != newsbfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_sbb.f_sbfz); temp.Add("newvalue", newsbfz); temp.Add("name", "水表分组"); array1.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_sbb", model_tbl_ld_sbb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array1, clientInf, _t); model_tbl_ld_yhb = idal_tbl_ld_yhb.GetList(" f_khbh='" + model.f_khbh + "'", "", "*", "", "", null)[0]; string yhfz = model_tbl_ld_yhb.f_yhfz; string yhfzid = model_tbl_ld_khb.f_yhfzid; string[] yhfzarr = yhfz.Split(','); string[] yhfzidarr = yhfzid.Split(','); string newyhfz = ""; string newyhfzid = ""; if (yhfz == "") { newyhfz = "龙达水务清户表"; newyhfzid = "4138"; } else { for (int a = 0; a < sbfzarr.Length; a++) { if (yhfzarr[a] == "龙达水务新立户表" || yhfzarr[a] == "客服中心总表" || yhfzarr[a] == "客服中心大用户表" || yhfzarr[a] == "经营中心考核表" || yhfzarr[a] == "经营中心排子表" || yhfzarr[a] == "经营中心远传表" || yhfzarr[a] == "经营中心居民表") { } else { newyhfz += yhfzarr[a] + ','; newyhfzid += yhfzidarr[a] + ','; } } newyhfz = newyhfz.TrimEnd(',') + "," + "龙达水务清户表"; newyhfzid = newyhfzid.TrimEnd(',') + "," + "4138"; } sql = " update tbl_ld_yhb set f_zt = '销户' , f_ztid ='3',f_yhfz='" + newyhfz + "',f_yhfzid='" + newyhfzid + "' where f_khbh ='" + model.f_khbh + "'"; _t.ExecuteSql(sql); //在用户表中加日志 List <IDictionary <string, string> > array2 = new List <IDictionary <string, string> >(); if (model_tbl_ld_yhb.f_zt != "销户") { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_zt"); temp.Add("oldvalue", model_tbl_ld_yhb.f_zt); temp.Add("newvalue", "销户"); temp.Add("name", "状态"); array2.Add(temp); } if (model_tbl_ld_yhb.f_yhfz != newsbfz) { IDictionary <string, string> temp = new Dictionary <string, string>(); temp.Add("key", "f_khfz"); temp.Add("oldvalue", model_tbl_ld_yhb.f_yhfz); temp.Add("newvalue", newyhfz); temp.Add("name", "用户分组"); array2.Add(temp); } sara.dd.ldsw.commonclass.commonclass.addUpdateLog("tbl_ld_yhb", model_tbl_ld_yhb.sys_id.ToString(), "tbl_ld_xhhbt_detail", "用户销户", array2, clientInf, _t); sql = " update tbl_ld_xhhbt set f_zt = '归档' , f_ztid ='2',f_czr='" + username + "',f_czrid='" + userid + "',f_czsj=to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd hh24:mi:ss') where sys_id ='" + model_tbl_ld_xhhbt.sys_id + "'"; _t.ExecuteSql(sql); } #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); }