public string Checkrw(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_rwb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_rwb>(json);
if (model.f_rwid != null && model.f_rwid != "")
{
object[] args = { int.Parse(model.f_rwid) };
string result = Eva.Library.WebService.DynamicWebServices.InvokeWebService("http://162.16.166.1/sara.dd.waterdatacenter/service/service_tbl_waterdb_rw.asmx", "getLongdaRwZt", args).ToString();
IDictionary <string, string> resultdic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(result);
DataTable dt = Eva.Library.Format.FormatEntityTool.FormatJsonToDataTable(resultdic["message"]);
if (dt.Rows.Count > 0)
{
switch (dt.Rows[0]["f_zt"].ToString())
{
case "待执行":
model.f_zt = "待执行";
model.f_ztid = "1";
break;
case "执行中":
model.f_zt = "执行中";
model.f_ztid = "2";
break;
case "完成":
model.f_zt = "完成";
model.f_ztid = "3";
break;
}
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_rwb.Update(model, columns, null);
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "任务异常";
}
}
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_rwb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_rwb>(json);
//int count = int.Parse(_idal_tbl_ld_rwb.GetCount("f_khbh='" + model.f_khbh + "' and f_ztid!='3'",null));
//if(count > 0)
//{
// resultDic["result"] = "false";
// resultDic["message"] = "该用户有未执行完成的任务";
//}
//else
//{
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_rwb.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));
}
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_rwb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_rwb>(json);
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_rwb.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 Startrw(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_rwb model = Eva.Library.Format.FormatEntityTool.FormatJsonToModel <sara.dd.ldsw.model.tbl_ld_rwb>(json);
object[] args = { model.f_mlid, model.f_sbbh };
string result = Eva.Library.WebService.DynamicWebServices.InvokeWebService("http://162.16.166.1/sara.dd.waterdatacenter/service/service_tbl_waterdb_rw.asmx", "addLongdaRw", args).ToString();
IDictionary <string, string> resultdic = Eva.Library.Format.FormatEntityTool.FormatJsonToDic(result);
DataTable dt = Eva.Library.Format.FormatEntityTool.FormatJsonToDataTable(resultdic["message"]);
if (dt.Rows.Count > 0)
{
model.f_rwid = dt.Rows[0]["sys_id"].ToString();
model.f_rwmc = dt.Rows[0]["f_rwmc"].ToString();
model.f_yjzxsj = Convert.ToDateTime(dt.Rows[0]["f_yjzxsj"].ToString());
model.f_zt = "待执行";
model.f_ztid = "1";
columns = FormatColumns(columns).Replace("^", ",");
resultDic["result"] = "true";
resultDic["message"] = _idal_tbl_ld_rwb.Update(model, columns, null);
}
else
{
resultDic["result"] = "false";
resultDic["message"] = "任务异常";
}
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));
}
