/// <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);
}
