/// <summary>
/// 增加数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_ADD(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里要根据具体业务逻辑处理
//开始真正的处理，根据业务逻辑操作数据库
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
//以可排序guid方式生成
string guid = CombGuid.GetMewIdFormSequence("ZZZ_gonggao");
param.Add("@GID", guid);
param.Add("@Gtitle", ht_forUI["Gtitle"].ToString());
string htmlstr = ht_forUI["Gneirong_html"].ToString();
htmlstr = StringOP.uncMe(htmlstr, "mima");
param.Add("@Gneirong", htmlstr);
param.Add("@Glaiyuan", ht_forUI["Glaiyuan"].ToString());
param.Add("@Gzt", ht_forUI["Gzt"].ToString());
param.Add("@Gaddren", ht_forUI["yhbsp_session_uer_UAid"].ToString());
alsql.Add("INSERT INTO ZZZ_gonggao(GID, Gtitle, Gneirong, Glaiyuan, Gaddren, Gzt) VALUES(@GID, @Gtitle, @Gneirong, @Glaiyuan, @Gaddren, @Gzt)");
if (ht_forUI["Gzt"].ToString() == "显示")
{
alsql.Add("INSERT INTO auth_znx(touser, msgtitle, msurl) select UAid as touser, '有新的公告发布' as msgtitle, '/adminht/corepage/bas/list_ss_gonggao.aspx' as msurl from ZZZ_userinfo where zhuangtai='在职' ");
}
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "保存成功！{" + guid + "}";
}
else
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，保存失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
/// <summary>
/// 从缓存读取数据(只用于FMDBHelperClass中执行语句时的那些接口实现)
/// </summary>
/// <param name="RedisKey">键</param>
/// <param name="RedisPZ">配置</param>
/// <returns></returns>
static public DataSet RedisTryOnlyForDBhelper(string RedisKey, string RedisPZ)
{
try
{
//没有设定键，直接返回空。
if (RedisKey == null || RedisKey.Trim() == "")
{
return(null);
}
//初始化
RedisClient RC = GetRedisClient(null);
//读取
byte[] re = null;
lock (RedisClass.LockObj)
{
re = RC.Get <byte[]>(RedisKey);
}
DataSet ds = StringOP.ByteToDataset(re);
return(ds);
}
catch (Exception ex)
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//表单识别号
string FID = "160805000002";
#region 必备的配置代码
//获取表单配置
dsFPZ = CallIPCPB.Get_FormInfoDB(FID);
htPP = FUPpublic.initPP(Request, dsFPZ);
//给控件传值
wuc_content._dsFPZ = dsFPZ;
wuc_content._htPP = htPP;
wuc_script._dsFPZ = dsFPZ;
wuc_script._htPP = htPP;
#endregion
if (this.Page.Request["cscscs"] != null)
{
cscscs = StringOP.uncMe(Request["cscscs"].ToString(), "mima");
}
else
{
cscscs = "a=1";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//sCorpID = ConfigurationManager.AppSettings["wx_CorpID"].ToString();
//wx_checkurl = ConfigurationManager.AppSettings["wx_checkurl"].ToString();
denglu_title.InnerHtml = ConfigurationManager.AppSettings["SYSname"];
if (Request["u"] != null && Request["u"].ToString() != "")
{
homeurl = StringOP.uncMe(Request["u"].ToString(), "mima");
}
//处理退出
if (Request["f"] != null && Request["f"].ToString() == "exit")
{
Session.RemoveAll();
}
//特殊的无权登录提示
if (Request["meiyouquanxian"] != null && Request["meiyouquanxian"].ToString() == "yes")
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "keys", "alert('此账号无权登录后台内部管理！');", true);
}
if (Request.Cookies["user_Uloginname_onlyforinput"] != null)
{
inputzhanghao = Server.UrlDecode(Request.Cookies["user_Uloginname_onlyforinput"].Value); //输入框记忆
}
}
/// <summary>
/// 增加数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_ADD(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里要根据具体业务逻辑处理
//开始真正的处理，根据业务逻辑操作数据库
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
//以可排序guid方式生成
//string guid = CombGuid.GetNewCombGuid("D");
//以两位年+两位月+两位日+6位序列顺序号方式生成
string guid = CombGuid.GetNewCombGuid("U");
param.Add("@UAid", guid);
param.Add("@Uloginname", ht_forUI["Uloginname"].ToString());
//对密码进行加密
string mima_enc = StringOP.encMe(ht_forUI["Uloginpassword"].ToString().Trim(), "mima");
param.Add("@Uloginpassword", mima_enc);
param.Add("@xingming", ht_forUI["xingming"].ToString());
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
param.Add("@nianling", ht_forUI["nianling"].ToString());
param.Add("@zhuangtai", ht_forUI["zhuangtai"].ToString());
param.Add("@beizhu", ht_forUI["beizhu"].ToString());
alsql.Add("INSERT INTO auth_users_auths(UAid ,Uloginname,Uloginpassword) VALUES(@UAid ,@Uloginname,@Uloginpassword )");
alsql.Add("INSERT INTO ZZZ_userinfo(UAid ,xingming,xingbie,nianling,zhuangtai,beizhu) VALUES(@UAid ,@xingming,@xingbie,@nianling,@zhuangtai,@beizhu)");
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "新增成功！";
}
else
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，保存失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
/// <summary>
/// 编辑数据前获取数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_EDIT_INFO(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里省略
//开始真正的处理，这里只是演示，所以直接在这里写业务逻辑代码了
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
Hashtable param = new Hashtable();
param.Add("@UAid", ht_forUI["idforedit"].ToString());
return_ht = I_DBL.RunParam_SQL("select top 1 *, sheng as yhb_city_Promary_shengshiqu, shi as yhb_city_City_shengshiqu, qu as yhb_city_Qu_shengshiqu from view_ZZZ_userinfo_ex where UAid=@UAid", "数据记录", param);
if ((bool)(return_ht["return_float"]))
{
DataTable redb = ((DataSet)return_ht["return_ds"]).Tables["数据记录"].Copy();
if (redb.Rows.Count < 1)
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "没有找到指定数据!";
return(dsreturn);
}
redb.Rows[0]["Uloginpassword"] = StringOP.uncMe(redb.Rows[0]["Uloginpassword"].ToString(), "mima");
dsreturn.Tables.Add(redb);
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "";
}
else
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "意外错误，获取失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
protected override void OnInit(EventArgs e)
{
//登录状态判定
if (UserSession.唯一键 == "")
{
Response.Redirect("/adminht/login.aspx?u=" + StringOP.encMe(Request.Url.PathAndQuery, "mima"));
return;
}
if (!AuthComm.chekcAuth_fromsession("1", UserSession.最终权值_全局独立权限, false))
{
Response.Redirect("/adminht/login.aspx?f=exit&meiyouquanxian=yes");
return;
}
base.OnInit(e);
}
public static DataTable ToDataTable(this string json)
{
json = StringOP.uncMe(json, "mima");
DataTable dataTable = new DataTable("接收的子表数据"); //实例化
DataTable result;
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值
ArrayList arrayList = javaScriptSerializer.Deserialize <ArrayList>(json);
if (arrayList.Count > 0)
{
foreach (Dictionary <string, object> dictionary in arrayList)
{
if (dictionary.Keys.Count <string>() == 0)
{
result = dataTable;
return(result);
}
if (dataTable.Columns.Count == 0)
{
foreach (string current in dictionary.Keys)
{
dataTable.Columns.Add(current, dictionary[current].GetType());
}
}
DataRow dataRow = dataTable.NewRow();
foreach (string current in dictionary.Keys)
{
dataRow[current] = dictionary[current];
}
dataTable.Rows.Add(dataRow); //循环添加行到DataTable中
}
}
result = dataTable;
return(result);
}
/// <summary>
/// 通过session检查权限(用户后台)
/// </summary>
/// <param name="enumNumber">要检查的权限权值枚举值(在配置中查阅)</param>
/// <param name="SUfinal_Number">当前用户某个类型的最终权值</param>
/// <param name="Do_Redirect">没有权限时，是否跳转到无权提示页面.true为跳转，false为不跳转。 一般情况用true，需要自己特殊处理代码的才用false,因为false不跳转等于没有控制权限只是检测了结果</param>
/// <returns>是否具备指定权限</returns>
public static bool chekcAuth_fromsession_userht(string enumNumber, string SUfinal_Number, bool Do_Redirect)
{
//检查唯一编号是否存在
if (UserSession.唯一键 == "")
{
HttpContext.Current.Response.Redirect("/userht/login.aspx?u=" + StringOP.encMe(HttpContext.Current.Request.Url.PathAndQuery, "mima"));
return(false);
}
//检查是否具备权限
if (!AuthComm.checkAuth(SUfinal_Number, enumNumber, UserSession.是否超管))
{
if (Do_Redirect)
{
HttpContext.Current.Response.Redirect("/userht/auth_noauth.aspx");
}
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 增加数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_ADD(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里要根据具体业务逻辑处理
//开始真正的处理，根据业务逻辑操作数据库
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
//以可排序guid方式生成
//string guid = CombGuid.GetNewCombGuid("D");
//以两位年+两位月+两位日+6位序列顺序号方式生成
string guid = CombGuid.GetMewIdFormSequence("FUP_FormsDemoDB");
param.Add("@id", guid);
param.Add("@fieldtest", ht_forUI["fieldtest"].ToString());
//取图片比较特殊需要判断
if (ht_forUI.Contains("allpath_file1"))
{
param.Add("@tupiantest", ht_forUI["allpath_file1"].ToString());
}
else
{
param.Add("@tupiantest", "");
}
//取下拉框和单选框和多选框也比较特殊，需要判断
if (ht_forUI.Contains("xingbie"))
{
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
}
else
{
param.Add("@xingbie", "");
}
//取编辑器比较特殊
if (ht_forUI.Contains("bianjiqi_html"))
{
string jjneirong = StringOP.uncMe(ht_forUI["bianjiqi_html"].ToString().Trim(), "mima");
string jjneirong_onlytext = StringOP.uncMe(ht_forUI["bianjiqi_text"].ToString().Trim(), "mima");
param.Add("@bianjiqi", jjneirong);
}
else
{
param.Add("@bianjiqi", "");
}
//日期段会根据id自动增加1和2
//取当前登录账号的uaid
param.Add("@beizhu", ht_forUI["yhbsp_session_uer_UAid"].ToString());
alsql.Add("INSERT INTO FUP_FormsDemoDB(id ,fieldtest,tupiantest) VALUES(@id ,@fieldtest,@tupiantest )");
//遍历子表， 插入
string zibiao_gts_id = "grid-table-subtable-sys_ddmo_0002";
DataTable subdt = jsontodatatable.ToDataTable(ht_forUI[zibiao_gts_id].ToString());
//必须验证js脚本获取的数量和c#反序列化获取的数量一致才能继续。防止出错
if (ht_forUI[zibiao_gts_id + "_fcjsq"].ToString() != subdt.Rows.Count.ToString())
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "子表数据量与获取量不相符，系统出现问题。";
return(dsreturn);
}
param.Add("@sub_" + "MainID", guid); //隶属主表id
for (int i = 0; i < subdt.Rows.Count; i++)
{
param.Add("@sub_" + "id" + "_" + i, CombGuid.GetMewIdFormSequence("demouser_sub_test"));
param.Add("@sub_" + "Sname" + "_" + i, subdt.Rows[i]["姓名"].ToString());
param.Add("@sub_" + "Scity" + "_" + i, subdt.Rows[i]["城市"].ToString());
param.Add("@sub_" + "Sint" + "_" + i, subdt.Rows[i]["整数"].ToString());
param.Add("@sub_" + "Sdecimal" + "_" + i, subdt.Rows[i]["小数"].ToString());
param.Add("@sub_" + "CreateTime" + "_" + i, subdt.Rows[i]["添加日期"].ToString());
string INSERTsql = "INSERT INTO demouser_sub_test ( id, SID, Sname, Scity, Sint, Sdecimal,CreateTime ) VALUES(@sub_" + "id" + "_" + i + ", @sub_MainID, @sub_" + "Sname" + "_" + i + ", @sub_" + "Scity" + "_" + i + ", @sub_" + "Sint" + "_" + i + ", @sub_" + "Sdecimal" + "_" + i + ", @sub_" + "CreateTime" + "_" + i + " )";
alsql.Add(INSERTsql);
}
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
//dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "新增成功！";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "新增成功！{" + guid + "}";
}
else
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，保存失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_EDIT(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里省略
if (ht_forUI["idforedit"].ToString().Trim() == "")
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "没有明确的修改目标！";
return(dsreturn);
}
//开始真正的处理，这里只是演示，所以直接在这里写业务逻辑代码了
// id, fieldtest, mima, xialakuang, xingbie, quanxian, xialakuangduoxuan, zhengshushuliang, erweixiao, yigeriqi, riqiqujian1, riqiqujian2, beizhu, bianjiqi, yhb_city_Promary_diquxian, yhb_city_City_diquxian, yhb_city_Qu_diquxian, sheng, shi, qu, zhanghao, tupiantest, dizhi, xingming
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
param.Add("@id", ht_forUI["idforedit"].ToString());
param.Add("@fieldtest", ht_forUI["fieldtest"].ToString());
//取图片比较特殊需要判断
if (ht_forUI.Contains("allpath_file1"))
{
param.Add("@tupiantest", ht_forUI["allpath_file1"].ToString());
}
else
{
param.Add("@tupiantest", "");
}
//取下拉框和单选框和多选框也比较特殊，需要判断
if (ht_forUI.Contains("xingbie"))
{
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
}
else
{
param.Add("@xingbie", "");
}
//取编辑器比较特殊
if (ht_forUI.Contains("bianjiqi_html"))
{
string jjneirong = StringOP.uncMe(ht_forUI["bianjiqi_html"].ToString().Trim(), "mima");
string jjneirong_onlytext = StringOP.uncMe(ht_forUI["bianjiqi_text"].ToString().Trim(), "mima");
param.Add("@bianjiqi", jjneirong);
}
else
{
param.Add("@bianjiqi", "");
}
//日期段会根据id自动增加1和2
//取当前登录账号的uaid
param.Add("@beizhu", ht_forUI["yhbsp_session_uer_UAid"].ToString());
alsql.Add("UPDATE FUP_FormsDemoDB SET fieldtest = @fieldtest,tupiantest=@tupiantest where id=@id ");
//遍历子表，先删除，再插入，已有主键的不重新生成。
string zibiao_gts_id = "grid-table-subtable-sys_ddmo_0002";
DataTable subdt = jsontodatatable.ToDataTable(ht_forUI[zibiao_gts_id].ToString());
//必须验证js脚本获取的数量和c#反序列化获取的数量一致才能继续。防止出错
if (ht_forUI[zibiao_gts_id + "_fcjsq"].ToString() != subdt.Rows.Count.ToString())
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "子表数据量与获取量不相符，系统出现问题。";
return(dsreturn);
}
param.Add("@sub_" + "MainID", ht_forUI["idforedit"].ToString()); //隶属主表id
alsql.Add("delete demouser_sub_test where SID = @sub_" + "MainID");
for (int i = 0; i < subdt.Rows.Count; i++)
{
if (subdt.Rows[i]["隐藏编号"].ToString().Trim() == "")
{
param.Add("@sub_" + "id" + "_" + i, CombGuid.GetMewIdFormSequence("demouser_sub_test"));
}
else
{
param.Add("@sub_" + "id" + "_" + i, subdt.Rows[i]["隐藏编号"].ToString());
}
param.Add("@sub_" + "Sname" + "_" + i, subdt.Rows[i]["姓名"].ToString());
param.Add("@sub_" + "Scity" + "_" + i, subdt.Rows[i]["城市"].ToString());
param.Add("@sub_" + "Sint" + "_" + i, subdt.Rows[i]["整数"].ToString());
param.Add("@sub_" + "Sdecimal" + "_" + i, subdt.Rows[i]["小数"].ToString());
param.Add("@sub_" + "CreateTime" + "_" + i, subdt.Rows[i]["添加日期"].ToString());
string INSERTsql = "INSERT INTO demouser_sub_test ( id, SID, Sname, Scity, Sint, Sdecimal,CreateTime ) VALUES(@sub_" + "id" + "_" + i + ", @sub_MainID, @sub_" + "Sname" + "_" + i + ", @sub_" + "Scity" + "_" + i + ", @sub_" + "Sint" + "_" + i + ", @sub_" + "Sdecimal" + "_" + i + ", @sub_" + "CreateTime" + "_" + i + " )";
alsql.Add(INSERTsql);
}
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
//dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "修改成功！";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "修改成功！{" + ht_forUI["idforedit"].ToString() + "}";
}
else
{
//其实要记录日志，而不是输出，这里只是演示
//dsreturn.Tables.Add(parameter_forUI.Copy());
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，修改失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
protected void Button3_Click(object sender, EventArgs e)
{
Label3.Text = StringOP.encMe("000000", "mima");
}
/// <summary>
/// 增加数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_ADD(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里要根据具体业务逻辑处理
//如果填写了邀请码，验证邀请码是否可用
string yqm = "xx";
//开始真正的处理，根据业务逻辑操作数据库
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
//以可排序guid方式生成
//string guid = CombGuid.GetNewCombGuid("D");
//用登录账号作为内码
//string guid = ht_forUI["Uloginname"].ToString();
//System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^\w+$");
//bool regre = reg1.IsMatch(ht_forUI["Uloginname"].ToString());
if (ht_forUI["Uloginname"].ToString().IndexOf('<') >= 0 || ht_forUI["Uloginname"].ToString().IndexOf('>') >= 0)
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "错误：登录账号含有禁用字符！";
return(dsreturn);
}
string guid = CombGuid.GetNewCombGuid("U");
param.Add("@UAid", guid);
param.Add("@Uloginname", ht_forUI["Uloginname"].ToString());
//对密码进行加密
string mima_enc = StringOP.encMe(ht_forUI["Uloginpassword"].ToString().Trim(), "mima");
param.Add("@Uloginpassword", mima_enc);
param.Add("@xingming", ht_forUI["xingming"].ToString());
param.Add("@zhuangtai", ht_forUI["zhuangtai"].ToString());
param.Add("@zhiwei", ht_forUI["zhiwei"].ToString());
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
param.Add("@beizhu", ht_forUI["beizhu"].ToString());
param.Add("@gongzuodi", ht_forUI["gongzuodi"].ToString());
param.Add("@suoshuquyu", ht_forUI["suoshuquyu"].ToString());
param.Add("@shoujihao", ht_forUI["shoujihao"].ToString());
param.Add("@gudingdianhua", ht_forUI["gudingdianhua"].ToString());
param.Add("@youxiang", ht_forUI["youxiang"].ToString());
param.Add("@lingdao", ht_forUI["lingdao"].ToString());
param.Add("@sfzh", ht_forUI["sfzh"].ToString());
param.Add("@csrq", ht_forUI["csrq"].ToString());
param.Add("@sheng", ht_forUI["yhb_city_Promary_shengshiqu"].ToString());
param.Add("@shi", ht_forUI["yhb_city_City_shengshiqu"].ToString());
param.Add("@qu", ht_forUI["yhb_city_Qu_shengshiqu"].ToString());
param.Add("@minzu", ht_forUI["minzu"].ToString());
param.Add("@yuanxiao", ht_forUI["yuanxiao"].ToString());
param.Add("@wxhm", ht_forUI["wxhm"].ToString());
param.Add("@qqhaoma", ht_forUI["qqhaoma"].ToString());
param.Add("@tongxundizhi", ht_forUI["tongxundizhi"].ToString());
param.Add("@ss_yqmsx", "10");
param.Add("@neibubeizhu", ht_forUI["neibubeizhu"].ToString());
//建档人和更新人 addtime,gxtime
param.Add("@addren", ht_forUI["yhbsp_session_uer_UAid"].ToString());
//param.Add("@gxren", ht_forUI["yhbsp_session_uer_UAid"].ToString());
param.Add("@ss_yaoqingma", yqm);
if (ht_forUI["zhuangtai"].ToString() == "离职")
{
param.Add("@Uattrcode", "1");
}
else
{
param.Add("@Uattrcode", "-1");
}
alsql.Add("INSERT INTO auth_users_auths(UAid ,Uloginname,Uloginpassword,Uattrcode) VALUES(@UAid ,@Uloginname,@Uloginpassword,@Uattrcode )");
alsql.Add("INSERT INTO ZZZ_userinfo(UAid ,xingming,zhuangtai,zhiwei,xingbie,beizhu,gongzuodi,suoshuquyu,shoujihao,gudingdianhua,youxiang,lingdao,ss_yaoqingma,sfzh,csrq,sheng,shi,qu,minzu,yuanxiao,wxhm,qqhaoma,tongxundizhi,ss_yqmsx,neibubeizhu,addren,addtime) VALUES(@UAid ,@xingming,@zhuangtai,@zhiwei,@xingbie,@beizhu,@gongzuodi,@suoshuquyu,@shoujihao,@gudingdianhua,@youxiang,@lingdao,@ss_yaoqingma,@sfzh,@csrq,@sheng,@shi,@qu,@minzu,@yuanxiao,@wxhm,@qqhaoma,@tongxundizhi,@ss_yqmsx,@neibubeizhu,@addren,getdate())");
if (yqm != "")
{
alsql.Add("update AAA_SJS set joinok=1,joinuser=@UAid,joinsj=getdate() where SN=@ss_yaoqingma and beok=1");
}
//设置初始权限组
if (ht_forUI.Contains("morenqanxianshezhi") && ht_forUI["morenqanxianshezhi"].ToString() != "")
{
param.Add("@morenqanxianshezhi", ht_forUI["morenqanxianshezhi"].ToString());
alsql.Add("update auth_users_auths set Uingroups=@morenqanxianshezhi where UAid=@UAid");
}
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "新增成功！{" + guid + "}";
}
else
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，保存失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_EDIT(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里省略
if (ht_forUI["idforedit"].ToString().Trim() == "")
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "没有明确的修改目标！";
return(dsreturn);
}
//System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^\w+$");
//bool regre = reg1.IsMatch(ht_forUI["Uloginname"].ToString());
if (ht_forUI["Uloginname"].ToString().IndexOf('<') >= 0 || ht_forUI["Uloginname"].ToString().IndexOf('>') >= 0)
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "错误：登录账号含有禁用字符！";
return(dsreturn);
}
//开始真正的处理，这里只是演示，所以直接在这里写业务逻辑代码了
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
param.Add("@UAid", ht_forUI["idforedit"].ToString());
param.Add("@Uloginname", ht_forUI["Uloginname"].ToString());
param.Add("@Uloginpassword", StringOP.encMe(ht_forUI["Uloginpassword"].ToString(), "mima"));
param.Add("@xingming", ht_forUI["xingming"].ToString());
param.Add("@zhuangtai", ht_forUI["zhuangtai"].ToString());
param.Add("@zhiwei", ht_forUI["zhiwei"].ToString());
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
param.Add("@beizhu", ht_forUI["beizhu"].ToString());
param.Add("@gongzuodi", ht_forUI["gongzuodi"].ToString());
param.Add("@suoshuquyu", ht_forUI["suoshuquyu"].ToString());
param.Add("@shoujihao", ht_forUI["shoujihao"].ToString());
param.Add("@gudingdianhua", ht_forUI["gudingdianhua"].ToString());
param.Add("@youxiang", ht_forUI["youxiang"].ToString());
param.Add("@lingdao", ht_forUI["lingdao"].ToString());
param.Add("@sfzh", ht_forUI["sfzh"].ToString());
param.Add("@csrq", ht_forUI["csrq"].ToString());
if (ht_forUI.Contains("yhb_city_Promary_shengshiqu"))
{
param.Add("@sheng", ht_forUI["yhb_city_Promary_shengshiqu"].ToString());
param.Add("@shi", ht_forUI["yhb_city_City_shengshiqu"].ToString());
param.Add("@qu", ht_forUI["yhb_city_Qu_shengshiqu"].ToString());
}
else
{
param.Add("@sheng", "0");
param.Add("@shi", "0");
param.Add("@qu", "0");
}
param.Add("@minzu", ht_forUI["minzu"].ToString());
param.Add("@yuanxiao", ht_forUI["yuanxiao"].ToString());
param.Add("@wxhm", ht_forUI["wxhm"].ToString());
param.Add("@qqhaoma", ht_forUI["qqhaoma"].ToString());
param.Add("@tongxundizhi", ht_forUI["tongxundizhi"].ToString());
param.Add("@ss_yqmsx", "10");
param.Add("@neibubeizhu", ht_forUI["neibubeizhu"].ToString());
//建档人和更新人 addtime,gxtime
//param.Add("@addren", ht_forUI["yhbsp_session_uer_UAid"].ToString());
param.Add("@gxren", ht_forUI["yhbsp_session_uer_UAid"].ToString());
if (ht_forUI["zhuangtai"].ToString() == "离职")
{
param.Add("@Uattrcode", "1");
}
else
{
param.Add("@Uattrcode", "-1");
}
alsql.Add("UPDATE ZZZ_userinfo SET xingming=@xingming,zhuangtai=@zhuangtai,zhiwei=@zhiwei,xingbie=@xingbie,beizhu=@beizhu,gongzuodi=@gongzuodi,suoshuquyu=@suoshuquyu,shoujihao=@shoujihao,gudingdianhua=@gudingdianhua,youxiang=@youxiang,lingdao=@lingdao, sfzh=@sfzh,csrq=@csrq,sheng=@sheng,shi=@shi,qu=@qu,minzu=@minzu,yuanxiao=@yuanxiao,wxhm=@wxhm,qqhaoma=@qqhaoma,tongxundizhi=@tongxundizhi,ss_yqmsx=@ss_yqmsx,neibubeizhu=@neibubeizhu,gxren=@gxren,gxtime=getdate() where UAid=@UAid ");
alsql.Add("UPDATE auth_users_auths SET Uloginname=@Uloginname,Uloginpassword=@Uloginpassword,Uattrcode=@Uattrcode where UAid=@UAid ");
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "修改成功！{" + ht_forUI["idforedit"].ToString() + "}";
}
else
{
//其实要记录日志，而不是输出，这里只是演示
//dsreturn.Tables.Add(parameter_forUI.Copy());
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，修改失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
protected void editjiedian_Click(object sender, EventArgs e)
{
errmsg.Text = "";
Button b = (Button)sender;
//如果是生成xml，不调用操作接口，直接调用接口获取数据并本地生成
if (b.ID == "shengchengxml")
{
//生成选定的菜单数据
DataTable dtT = new DataTable();
object[] re_dsiT = IPC.Call("获取菜单数据", new object[] { dbtbname.Text, 0, 1 });
if (re_dsiT[0].ToString() == "ok")
{
//这个就是得到远程方法真正的返回值，不同类型的，自行进行强制转换即可。
dtT = (DataTable)re_dsiT[1];
//dtT.WriteXml(Server.MapPath("/xml/" + dbtbname.Text + ".xml"), XmlWriteMode.WriteSchema);
}
else
{
errmsg.Text = re_dsiT[1].ToString();//向客户端输出错误字符串
}
//不管选定的哪个菜单，都把权限枚举表里的有效数据也生成到本地，用于菜单权限判定。
DataSet ds_mj = new DataSet();
object[] re_dsi_mj = IPC.Call("获取所有已启用的权限枚举", new object[] { "" });
if (re_dsi_mj[0].ToString() == "ok")
{
//这个就是得到远程方法真正的返回值，不同类型的，自行进行强制转换即可。
ds_mj = (DataSet)re_dsi_mj[1];
//ds_mj.WriteXml(Server.MapPath("/xml/auth_enum_number_ANused.xml"), XmlWriteMode.WriteSchema);
}
else
{
errmsg.Text = re_dsi_mj[1].ToString();//向客户端输出错误字符串
}
}
//调用执行方法获取数据
Hashtable HTforParameter = new Hashtable();
HTforParameter["buttonid"] = b.ID;
HTforParameter["dbtbname"] = dbtbname.Text;
HTforParameter["SortID"] = sh_SortID.Text;
HTforParameter["add_SortName"] = addnewjiedian_name.Text;
HTforParameter["move_SortParentID"] = movenewsid.Text;
HTforParameter["ee_SortName"] = ee_SortName.Text;
HTforParameter["ee_m_url"] = ee_m_url.Text;
HTforParameter["ee_m_tip"] = ee_m_tip.Text;
HTforParameter["ee_m_tag"] = ee_m_tag.Text;
HTforParameter["ee_m_ico"] = ee_m_ico.Text;
HTforParameter["ee_m_show1"] = ee_m_show1.Checked.ToString();
HTforParameter["ee_m_show0"] = ee_m_show0.Checked.ToString();
DataTable dt_request = StringOP.GetDataTableFormHashtable(HTforParameter);
object[] re_dsi = IPC.Call("菜单维护操作", new object[] { dt_request });
if (re_dsi[0].ToString() == "ok")
{
//这个就是得到远程方法真正的返回值，不同类型的，自行进行强制转换即可。
string dsreturn = re_dsi[1].ToString();
if (b.ID == "shanchu")
{
Response.Redirect("/adminht/menu_pub_edit.aspx?tb=" + dbtbname.Text);
}
else
{
Response.Redirect("/adminht/menu_pub_edit.aspx?sortid=" + sh_SortID.Text + "&tb=" + dbtbname.Text);
}
}
else
{
errmsg.Text = re_dsi[1].ToString();//向客户端输出错误字符串
}
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_EDIT(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里省略
if (ht_forUI["idforedit"].ToString().Trim() == "")
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "没有明确的修改目标！";
return(dsreturn);
}
//开始真正的处理，这里只是演示，所以直接在这里写业务逻辑代码了
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
param.Add("@UAid", ht_forUI["idforedit"].ToString());
param.Add("@Uloginname", ht_forUI["Uloginname"].ToString());
param.Add("@Uloginpassword", StringOP.encMe(ht_forUI["Uloginpassword"].ToString(), "mima"));
param.Add("@xingming", ht_forUI["xingming"].ToString());
param.Add("@xingbie", ht_forUI["xingbie"].ToString());
param.Add("@nianling", ht_forUI["nianling"].ToString());
param.Add("@zhuangtai", ht_forUI["zhuangtai"].ToString());
param.Add("@beizhu", ht_forUI["beizhu"].ToString());
alsql.Add("UPDATE ZZZ_userinfo SET xingming=@xingming,xingbie=@xingbie,nianling=@nianling,zhuangtai=@zhuangtai,beizhu=@beizhu where UAid=@UAid ");
alsql.Add("UPDATE auth_users_auths SET Uloginname=@Uloginname,Uloginpassword=@Uloginpassword where UAid=@UAid ");
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "修改成功！";
}
else
{
//其实要记录日志，而不是输出，这里只是演示
//dsreturn.Tables.Add(parameter_forUI.Copy());
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，修改失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}
protected void editjiedian_Click(object sender, EventArgs e)
{
errmsg.Text = "";
Button b = (Button)sender;
//调用执行方法获取数据
Hashtable HTforParameter = new Hashtable();
HTforParameter["buttonid"] = b.ID;
HTforParameter["dbtbname"] = dbtbname.Text;
HTforParameter["SortID"] = sh_SortID.Text;
HTforParameter["add_SortName"] = addnewjiedian_name.Text;
HTforParameter["move_SortParentID"] = movenewsid.Text;
HTforParameter["ee_SortName"] = ee_SortName.Text;
BigInteger Unumber1_qx = 0;
for (int i = 0; i < Unumber1.Items.Count; i++)
{
if (Unumber1.Items[i].Selected)
{
BigInteger numS = BigInteger.Parse(Unumber1.Items[i].Value);
Unumber1_qx = Unumber1_qx | numS;
}
}
HTforParameter["ee_Unumber1_qx"] = Unumber1_qx.ToString();
BigInteger Unumber2_qx = 0;
for (int i = 0; i < Unumber2.Items.Count; i++)
{
if (Unumber2.Items[i].Selected)
{
BigInteger numS = BigInteger.Parse(Unumber2.Items[i].Value);
Unumber2_qx = Unumber2_qx | numS;
}
}
HTforParameter["ee_Unumber2_qx"] = Unumber2_qx.ToString();
BigInteger Unumber3_qx = 0;
for (int i = 0; i < Unumber3.Items.Count; i++)
{
if (Unumber3.Items[i].Selected)
{
BigInteger numS = BigInteger.Parse(Unumber3.Items[i].Value);
Unumber3_qx = Unumber3_qx | numS;
}
}
HTforParameter["ee_Unumber3_qx"] = Unumber3_qx.ToString();
BigInteger Unumber4_qx = 0;
for (int i = 0; i < Unumber4.Items.Count; i++)
{
if (Unumber4.Items[i].Selected)
{
BigInteger numS = BigInteger.Parse(Unumber4.Items[i].Value);
Unumber4_qx = Unumber4_qx | numS;
}
}
HTforParameter["ee_Unumber4_qx"] = Unumber4_qx.ToString();
BigInteger Unumber5_qx = 0;
for (int i = 0; i < Unumber5.Items.Count; i++)
{
if (Unumber5.Items[i].Selected)
{
BigInteger numS = BigInteger.Parse(Unumber5.Items[i].Value);
Unumber5_qx = Unumber5_qx | numS;
}
}
HTforParameter["ee_Unumber5_qx"] = Unumber5_qx.ToString();
DataTable dt_request = StringOP.GetDataTableFormHashtable(HTforParameter);
object[] re_dsi = IPC.Call("菜单维护操作", new object[] { dt_request });
if (re_dsi[0].ToString() == "ok")
{
//这个就是得到远程方法真正的返回值，不同类型的，自行进行强制转换即可。
string dsreturn = re_dsi[1].ToString();
if (b.ID == "shanchu")
{
Response.Redirect("/adminht/auth_group_edit.aspx");
}
else
{
Response.Redirect("/adminht/auth_group_edit.aspx?sortid=" + sh_SortID.Text);
}
}
else
{
errmsg.Text = re_dsi[1].ToString();//向客户端输出错误字符串
}
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="parameter_forUI">前台表单传来的参数</param>
/// <returns></returns>
public DataSet NRS_EDIT(DataTable parameter_forUI)
{
//接收转换参数
Hashtable ht_forUI = new Hashtable();
for (int i = 0; i < parameter_forUI.Rows.Count; i++)
{
ht_forUI[parameter_forUI.Rows[i]["参数名"].ToString()] = parameter_forUI.Rows[i]["参数值"].ToString();
}
//初始化返回值
DataSet dsreturn = initReturnDataSet().Clone();
dsreturn.Tables["返回值单条"].Rows.Add(new string[] { "err", "初始化" });
//参数合法性各种验证，这里省略
if (ht_forUI["idforedit"].ToString().Trim() == "")
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "没有明确的修改目标！";
return(dsreturn);
}
//开始真正的处理，这里只是演示，所以直接在这里写业务逻辑代码了
I_Dblink I_DBL = (new DBFactory()).DbLinkSqlMain("");
Hashtable return_ht = new Hashtable();
ArrayList alsql = new ArrayList();
Hashtable param = new Hashtable();
param.Add("@GID", ht_forUI["idforedit"].ToString());
param.Add("@Gtitle", ht_forUI["Gtitle"].ToString());
string htmlstr = ht_forUI["Gneirong_html"].ToString();
htmlstr = StringOP.uncMe(htmlstr, "mima");
param.Add("@Gneirong", htmlstr);
param.Add("@Glaiyuan", ht_forUI["Glaiyuan"].ToString());
param.Add("@Gzt", ht_forUI["Gzt"].ToString());
alsql.Add("UPDATE ZZZ_gonggao SET Gtitle=@Gtitle, Gneirong=@Gneirong, Glaiyuan=@Glaiyuan, Gzt=@Gzt where GID =@GID ");
return_ht = I_DBL.RunParam_SQL(alsql, param);
if ((bool)(return_ht["return_float"]))
{
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "ok";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "修改成功！{" + ht_forUI["idforedit"].ToString() + "}";
}
else
{
//其实要记录日志，而不是输出，这里只是演示
//dsreturn.Tables.Add(parameter_forUI.Copy());
dsreturn.Tables["返回值单条"].Rows[0]["执行结果"] = "err";
dsreturn.Tables["返回值单条"].Rows[0]["提示文本"] = "系统故障，修改失败：" + return_ht["return_errmsg"].ToString();
}
return(dsreturn);
}