private string GetBefore(string action, string type, string id)
{
string str = string.Empty;
if (action.Equals("TB_USER"))
{
if (type.Equals("新增用户") || type.Equals("删除用户"))
{
str = string.Empty;
}
else if (type.Equals("IP管理"))
{
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from TB_USER_IP where user_id='" + id + "'");
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str += "计算机名:" + ds.Tables[0].Rows[i]["computer_name"].ToString() + ",外网地址:" + ds.Tables[0].Rows[i]["outside_net"] + ",内网地址:" + ds.Tables[0].Rows[i]["inside_net"].ToString() + ";";
}
}
}
else
{
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from TB_USER where userid='" + id + "'");
if (ds != null)
{
DataSet ds_role = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select (select rname from tb_role where roleid=t.roleid) as rname from TB_USER_ROLE t where t.userid=" + id + "");
string before_role = string.Empty;
if (ds_role != null)
{
for (int i = 0; i < ds_role.Tables[0].Rows.Count; i++)
{
before_role += ds_role.Tables[0].Rows[i]["rname"].ToString() + ",";
}
}
str = "登录账号:" + ds.Tables[0].Rows[0]["loginname"].ToString() + "|LOGINNAME;真实姓名:" + ds.Tables[0].Rows[0]["REALNAME"].ToString() + "|REALNAME;性别:" + ds.Tables[0].Rows[0]["SEX"].ToString() + "|SEX;手机:" + ds.Tables[0].Rows[0]["TEL"].ToString() + "|TEL;所属单位:" + ds.Tables[0].Rows[0]["UNIT"].ToString() + "|UNIT;邮箱:" + ds.Tables[0].Rows[0]["EMAIL"].ToString() + "|EMAIL;密码:" + DESEncrypt.Decrypt(ds.Tables[0].Rows[0]["PWD"].ToString()) + "|PWD;拥有角色:" + before_role + "|rids";
}
}
}
else
{
if (type.Equals("新增角色") || type.Equals("删除角色"))
{
str = string.Empty;
}
else
{
if (type.Equals("编辑角色"))
{
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from TB_ROLE where ROLEID='" + id + "'");
if (ds != null)
{
str = "角色名称:" + ds.Tables[0].Rows[0]["RNAME"].ToString() + "|RNAME;身份:" + ds.Tables[0].Rows[0]["IDENTITY"].ToString() + "|IDENTITY;角色说明:" + ds.Tables[0].Rows[0]["MEMO"].ToString() + "|MEMO";
}
}
}
}
return(str);
}
private string getUserByRoleId(string id)
{
try
{
string str = "";
string sql = "select t.loginname,t.realname from tb_user t,tb_user_role s where s.roleid=" + id + " and t.userid=s.userid";
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys(sql);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str += ds.Tables[0].Rows[i]["realname"].ToString() + "\n";
}
return(str);
}
catch
{
return("");
}
}
public string getmenu(string rid, string mflags)
{
MessageModel <DataTable> result = new MessageModel <DataTable>();
DataSet ds = null;
try
{
string str = string.Empty;
if (mflags.EndsWith(","))
{
mflags = mflags.Substring(0, mflags.Length - 1);
}
string[] temp = mflags.Split(',');
string where = string.Empty;
for (int i = 0; i < temp.Length; i++)
{
where += "'" + temp[i] + "',";
}
if (string.IsNullOrEmpty(where))
{
return(null);
}
else
{
where = where.Substring(0, where.Length - 1);
string sql = "select * from tb_menu t where t.mflag in(" + where + ") order by t.mparent";
ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys(sql);
// return ds;
}
}
catch
{
//return null;
}
result.data = ds.Tables[0];
result.code = System.Net.HttpStatusCode.OK;
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
public string getbmunu(string r_id)
{
MessageModel <DataTable> result = new MessageModel <DataTable>();
string str = string.Empty;
string sql = "select m.* from TB_ROLE_MENU t,tb_menu m where t.mflag=m.mflag and t.roleid=" + r_id + " order by m.mparent";
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys(sql);
if (ds.Tables[0].Rows.Count > 0)
{
result.data = ds.Tables[0];
result.code = System.Net.HttpStatusCode.OK;
}
else
{
result.data = null;
result.code = System.Net.HttpStatusCode.Accepted;
}
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
public string GetAdminApprovalTables(string id, string o_type, string r_id)
{
TableModel <ArrayList> result = new TableModel <ArrayList>();
int total = 1;
//List<string[]> list = new List<string[]>();
ArrayList list = new ArrayList();
try
{
string sql_temp = string.Empty;
if (o_type.Equals("TB_USER"))
{
sql_temp += ",(select loginname from tb_user where userid=t.oid) as name";
}
else
{
sql_temp += ",(select rname from tb_role where roleid=t.oid) as name";
}
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select t.*" + sql_temp + " from TB_ROLE_LOG t where t.id='" + id + "' and t.type='" + o_type + "' ");
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string type = string.Empty;
string content = string.Empty;
string status = string.Empty;
string temp_content = ds.Tables[0].Rows[i]["CONTENT"].ToString();
if (!string.IsNullOrEmpty(temp_content))
{
string[] strs1 = temp_content.Split('|');
type = strs1[0];
if (!string.IsNullOrEmpty(strs1[1]))
{
string[] strs2 = strs1[1].Split(';');
content = "<ul class=\"ultree\">";
for (int j = 0; j < strs2.Length; j++)
{
content += "<li>" + strs2[j] + "</li>";
}
content += "</ul>";
}
}
switch (ds.Tables[0].Rows[i]["status"].ToString())
{
case "-1": status = "<span style=\"color:red;\">审批不通过</span>"; break;
case "0": status = "<span style=\"color:blue;\">待审批</span>"; break;
case "1": status = "<span style=\"color:green;\">审批已通过</span>"; break;
}
string before_content = string.Empty;
before_content = GetBefore(o_type, type, ds.Tables[0].Rows[i]["oid"].ToString());
//string before_content = string.Empty;
string after_content = string.Empty;
if (!string.IsNullOrEmpty(before_content))
{
if (type.Equals("IP管理"))
{
string[] arr_remark = ds.Tables[0].Rows[i]["sqlremark"].ToString().Split(';');
string[] strs2 = before_content.Split(';');
before_content = "<ul class=\"ultree\">";
after_content = before_content;
for (int j = 0; j < strs2.Length; j++)
{
before_content += "<li>" + strs2[j] + "</li>";
}
for (int j = 0; j < arr_remark.Length; j++)
{
after_content += "<li>" + arr_remark[j] + "</li>";
}
before_content += "</ul>";
after_content += "</ul>";
}
else
{
string[] arr_remark = ds.Tables[0].Rows[i]["sqlremark"].ToString().Split(';');
string[] strs2 = before_content.Split(';');
before_content = "<ul class=\"ultree\">";
after_content = before_content;
for (int j = 0; j < strs2.Length; j++)
{
string after_value = strs2[j].Split('|')[0];
string str_tmp = strs2[j].Split('|')[1];
for (int k = 0; k < arr_remark.Length; k++)
{
if (str_tmp == arr_remark[k].Split(':')[0])
{
after_value = after_value.Split(':')[0] + ":" + arr_remark[k].Split(':')[1];
}
}
after_content += "<li><span id=\"span_" + str_tmp + "\">" + after_value + "<span></li>";
before_content += "<li>" + strs2[j].Split('|')[0] + "</li>";
}
before_content += "</ul>";
after_content += "</ul>";
}
}
if (type == "分配菜单")
{
string sqlremark = ds.Tables[0].Rows[i]["sqlremark"].ToString();
before_content = getbmunu(r_id);
after_content = getmenu(r_id, sqlremark);
//after_content = System.Text.Encoding.Default.GetString((byte[])ds.Tables[0].Rows[i]["sqlremark"]);
}
list.Add(new
{
czlx = type,
xgq = before_content,
xgh = after_content,
xglr = content,
zt = ds.Tables[0].Rows[i]["remark"].ToString()
});
//list.Add(new string[]
//{
// //czlx = type,
// //xgq = before_content,
// //xgh = after_content,
// //xglr = content,
// //zt = ds.Tables[0].Rows[i]["remark"].ToString()
// (i + 1).ToString(),
// type,
// content,
// status,
// ds.Tables[0].Rows[i]["remark"].ToString(),
// ds.Tables[0].Rows[i]["name"].ToString(),
// before_content,
// after_content,
// System.Text.Encoding.Default.GetString((byte[])ds.Tables[0].Rows[i]["sqlremark"])
//});
}
}
}
catch
{
}
result.Data = list;
result.Count = total;
result.Code = System.Net.HttpStatusCode.OK;
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
// return "";
}
public string noadopt(int id)
{
MessageModel <string> result = new MessageModel <string>();
string data = string.Empty;
List <string> DelList = new List <string>();//删除事务
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from tb_role_log where id='" + id + "'");
if (ds != null)
{
string content = ds.Tables[0].Rows[0]["CONTENT"].ToString();
if (content.StartsWith("新增"))
{
string logsql = string.Empty;
if (content.StartsWith("新增用户"))
{
logsql = "delete from TB_USER where USERID='" + ds.Tables[0].Rows[0]["oid"].ToString() + "';";
logsql += "delete from tb_role_log_process where lid in(select id from tb_role_log where type='TB_USER' and oid='" + ds.Tables[0].Rows[0]["oid"].ToString() + "');";
logsql += "delete from tb_role_log where type='TB_USER' and oid='" + ds.Tables[0].Rows[0]["oid"].ToString() + "';";
}
else if (content.StartsWith("新增角色"))
{
logsql = "delete from TB_ROLE where roleid='" + ds.Tables[0].Rows[0]["oid"].ToString() + "';";
logsql += "delete from tb_role_log_process where lid in(select id from tb_role_log where type='TB_ROLE' and oid='" + ds.Tables[0].Rows[0]["oid"].ToString() + "');";
logsql += "delete from tb_role_log where type='TB_ROLE' and oid='" + ds.Tables[0].Rows[0]["oid"].ToString() + "';";
}
logsql = !string.IsNullOrEmpty(logsql) ? logsql.Substring(0, logsql.Length - 1) : string.Empty;
string[] arr_del = logsql.Split(';');
for (int i = 0; i < arr_del.Length; i++)
{
//CommandInfo info = new CommandInfo();
//info.CommandText = arr_del[i];
DelList.Add(arr_del[i]);
}
}
}
// string update = "update TB_ROLE_LOG set status='-1' where id='" + id + "'";
int update = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Update("update TB_ROLE_LOG set status='-1' where id='" + id + "'");
if (update > 0)
{
TB_ROLE_LOG_PROCESS rlog_p = new TB_ROLE_LOG_PROCESS();
rlog_p.LID = id;
rlog_p.OMAN = usermodel.REALNAME;
rlog_p.OTIME = DateTime.Now;
rlog_p.REMARK = "审批不通过";
role_logbll.AddTB_ROLE_LOG_PROCESS(rlog_p);
int ss = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(DelList);
data = "审批成功";
}
else
{
data = "审批失败";
}
result.data = data;
result.code = System.Net.HttpStatusCode.OK;
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
public string adopt(int id)
{
MessageModel <string> result = new MessageModel <string>();
string data = string.Empty;
List <string> AddList = new List <string>(); //添加事务
List <string> DelList = new List <string>(); //删除事务
List <string> EditList = new List <string>(); //修改事务
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from TB_ROLE_LOG where id='" + id + "'");
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
string sqls = ds.Tables[0].Rows[0]["SAVESQL"].ToString();
string[] arr_sql = sqls.Split(';');
for (int i = 0; i < arr_sql.Length; i++)
{
//CommandInfo info = new CommandInfo();
//info.CommandText = arr_sql[i];
if (arr_sql[i].StartsWith("insert"))
{
AddList.Add(arr_sql[i]);
}
else if (arr_sql[i].StartsWith("delete"))
{
DelList.Add(arr_sql[i]);
}
else if (arr_sql[i].StartsWith("update"))
{
EditList.Add(arr_sql[i]);
}
}
}
}
//CommandInfo update = new CommandInfo();
//update.CommandText = "update TB_ROLE_LOG set status='1' where id='" + id + "'";
int update = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Update("update TB_ROLE_LOG set status='1' where id = " + id + "");
int e = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(EditList);
int d = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(DelList);
int a = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(AddList);
if (d > 0 || a > 0 || e > 0)
{
TB_ROLE_LOG_PROCESS rlog_p = new TB_ROLE_LOG_PROCESS();
rlog_p.LID = id;
rlog_p.OMAN = usermodel.REALNAME;
rlog_p.OTIME = DateTime.Now;
rlog_p.REMARK = "审批通过";
role_logbll.AddTB_ROLE_LOG_PROCESS(rlog_p);
data = "审批成功";
}
else
{
data = "审批失败";
}
result.data = data;
result.code = System.Net.HttpStatusCode.OK;
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
public string noadoptmore(string ids)
{
MessageModel <string> result = new MessageModel <string>();
string data = string.Empty;
try
{
//ids = ids.Substring(0, ids.Length - 1);
string[] arr = ids.Split(',');
string add = "";
for (int i = 0; i < arr.Length; i++)
{
add += "'" + arr[i] + "',";
}
add = add.Substring(0, add.Length - 1);
List <string> DelList = new List <string>();//删除事务
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from tb_role_log where id in(" + add + ")");
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string content = ds.Tables[0].Rows[i]["CONTENT"].ToString();
if (content.StartsWith("新增"))
{
string logsql = string.Empty;
if (content.StartsWith("新增用户"))
{
logsql = "delete from TB_USER where USERID='" + ds.Tables[0].Rows[i]["oid"].ToString() + "';";
logsql += "delete from tb_role_log_process where lid in(select id from tb_role_log where type='TB_USER' and oid='" + ds.Tables[0].Rows[i]["oid"].ToString() + "');";
logsql += "delete from tb_role_log where type='TB_USER' and oid='" + ds.Tables[0].Rows[i]["oid"].ToString() + "';";
}
else if (content.StartsWith("新增角色"))
{
logsql = "delete from TB_ROLE where roleid='" + ds.Tables[0].Rows[i]["oid"].ToString() + "';";
logsql += "delete from tb_role_log_process where lid in(select id from tb_role_log where type='TB_ROLE' and oid='" + ds.Tables[0].Rows[i]["oid"].ToString() + "');";
logsql += "delete from tb_role_log where type='TB_ROLE' and oid='" + ds.Tables[0].Rows[i]["oid"].ToString() + "';";
}
logsql = !string.IsNullOrEmpty(logsql) ? logsql.Substring(0, logsql.Length - 1) : string.Empty;
string[] arr_del = logsql.Split(';');
for (int m = 0; m < arr_del.Length; m++)
{
DelList.Add(arr_del[m].ToString());
}
}
}
}
int update = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Update("update TB_ROLE_LOG set status='-1' where id in(" + add + ")");
if (update > 0)
{
for (int i = 0; i < arr.Length; i++)
{
TB_ROLE_LOG_PROCESS rlog_p = new TB_ROLE_LOG_PROCESS();
rlog_p.LID = Convert.ToDecimal(arr[i]);
rlog_p.OMAN = usermodel.REALNAME;
rlog_p.OTIME = DateTime.Now;
rlog_p.REMARK = "审批不通过";
role_logbll.AddTB_ROLE_LOG_PROCESS(rlog_p);
//YunTuCore.Bussiness.TB_ROLE_LOGBLL().Update(add);
int ss = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(DelList);
}
data = "审批成功!";
}
else
{
data = "审批失败!";
}
}
catch (Exception ex)
{
data = "审批失败!";
}
result.data = data;
result.code = System.Net.HttpStatusCode.OK;
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
// return JsonConvert<TableResultFormat<string>>.ObjectToJson(result);
}
public string adoptmore(string ids)
{
MessageModel <string> result = new MessageModel <string>();
string data = string.Empty;
try
{
string[] arr = ids.Split(',');
string add = "";
for (int i = 0; i < arr.Length; i++)
{
add += "'" + arr[i] + "',";
}
add = add.Substring(0, add.Length - 1);
for (int i = 0; i < arr.Length; i++)
{
List <string> AddList = new List <string>(); //添加事务
List <string> DelList = new List <string>(); //删除事务
List <string> EditList = new List <string>(); //修改事务
DataSet ds = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Querys("select * from TB_ROLE_LOG where id = " + arr[i] + "");
if (ds.Tables[0].Rows.Count > 0)
{
string sqls = ds.Tables[0].Rows[0]["SAVESQL"].ToString();
string[] arr_sql = sqls.Split(';');
for (int m = 0; m < arr_sql.Length; m++)
{
//CommandInfo info = new CommandInfo();
//info.CommandText = arr_sql[m];
if (arr_sql[m].StartsWith("insert"))
{
AddList.Add(arr_sql[m]);
}
else if (arr_sql[m].StartsWith("delete"))
{
DelList.Add(arr_sql[m]);
}
else if (arr_sql[m].StartsWith("update"))
{
EditList.Add(arr_sql[m]);
}
}
//CommandInfo update = new CommandInfo();
int update = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().Update("update TB_ROLE_LOG set status='1' where id = " + arr[i] + "");
//update.CommandText = "update TB_ROLE_LOG set status='1' where id = " + arr[i] + "";
//EditList.Add(update);
int e = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(EditList);
int d = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(DelList);
int a = new YunTuCore.Bussiness.TB_ROLE_LOGBLL().UpdateTran(AddList);
if (d > 0 && a > 0 && e > 0)
{
TB_ROLE_LOG_PROCESS rlog_p = new TB_ROLE_LOG_PROCESS();
rlog_p.LID = Convert.ToDecimal(arr[i]);
rlog_p.OMAN = usermodel.REALNAME;
rlog_p.OTIME = DateTime.Now;
rlog_p.REMARK = "审批通过";
role_logbll.AddTB_ROLE_LOG_PROCESS(rlog_p);
}
}
}
data = "审批成功";
}
catch (Exception ex)
{
data = "审批失败";
}
result.data = data;
result.code = System.Net.HttpStatusCode.OK;
result.success = false;
result.msg = "获取成功";
return(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
