public void getChart()
{
string groupID = Session["group_id"].ToString();
string sql = "select update_name,sum(case when state = 3 then 1 else 0 end) as total from dt_order where group_id like '%" + groupID + "' group by update_name ";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
if (db.DB2Obj.GetRs(sql, out Rs))
{
DataTable dt = ((DataSet)Rs).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count > 4)
{
containerHeight = (dt.Rows.Count * 50).ToString() + "px";
}
else
{
containerHeight = "200px";
}
string dataY = "[{name: '工单总数量',data: [";
foreach (DataRow dr in dt.Rows)
{
dataY += "['" + getUserName(dr["update_name"].ToString()) + "'," + dr["total"].ToString() + "]" + ",";
}
returnValue = dataY + "]";
}
}
}
public string checkNumber(string _user)
{
string str = "0";
try
{
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
string strSQL = "select UserId,UserName from Users where UserId='" + _user + "' or UserName='******'";
db.DBObj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
str = Rs[0, "UserName"].ToString();
}
else
{
ResultDataSet Rs2 = new ResultDataSet();
string strSQL2 = "select real_name from dt_manager where user_name='" + _user + "' or real_name='" + _user + "'";
db.DB2Obj.GetRs(strSQL2, out Rs2);
if (Rs2.RowCount > 0)
{
str = Rs2[0, "real_name"].ToString();
}
else
{
str = "0";
}
}
}
catch (Exception)
{
throw;
}
return(str);
}
private void RoleTypeBind()
{
int id = Convert.ToInt32(Request.QueryString["id"]);
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
string strSQL = "select * from dt_manager_role where id='" + id + "'";
db.DB2Obj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
ddlRoleType.Items.Clear();
ddlRoleType.Items.Add(new ListItem("请选择类型...", ""));
if (Convert.ToInt32(Rs[0, "role_type"]) < 2)
{
ddlRoleType.Items.Add(new ListItem("超级用户", "1"));
}
ddlRoleType.Items.Add(new ListItem("系统用户", "2"));
ddlRoleType.SelectedValue = Rs[0, "role_type"].ToString();
txtRoleName.Text = Rs[0, "role_name"].ToString();
}
else
{
ddlRoleType.Items.Clear();
ddlRoleType.Items.Add(new ListItem("请选择类型...", ""));
if (Convert.ToInt32(Rs[0, "role_type"]) < 2)
{
ddlRoleType.Items.Add(new ListItem("超级用户", "1"));
}
ddlRoleType.Items.Add(new ListItem("系统用户", "2"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select type,sum(case when state = 0 then 1 else 0 end) as total1,sum(case when state = 1 then 1 else 0 end) as total2,sum(case when state = 2 then 1 else 0 end) as total3,sum(case when state = 3 then 1 else 0 end) as total4,count(state) as total from dt_order where 1=1 group by type";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
if (db.DB2Obj.GetRs(sql, out Rs))
{
DataTable dt = ((DataSet)Rs).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count > 4)
{
containerHeight = (dt.Rows.Count * 50).ToString() + "px";
}
else
{
containerHeight = "200px";
}
string dataY = "[{name: '工单总数量',data: [";
foreach (DataRow dr in dt.Rows)
{
dataY += "['" + getGroupName(dr["type"].ToString()) + "'," + dr["total"].ToString() + "]" + ",";
}
returnValue = dataY + "]";
}
}
}
public DataTable GetListNoPage(int channel_id, string category_id, int pageSize, int pageIndex, string strWhere, string filedOrder)
{
string sql = "select * from dt_order where 1=1 ";
if (strWhere.Trim() != "")
{
sql += " and" + strWhere;
}
if (this.begin != "" && this.end != "")
{
sql += " and add_time >= '" + this.begin + " 00:00:00' and add_time <='" + this.end + " 23:59:59'";
}
if (category_id != "")
{
sql += " and group_id like '" + category_id + "%'";
}
if (state != "")
{
if (state == "10")
{
sql += " and state = '0'";
}
else
{
sql += " and state = '" + state + "'";
}
}
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataTable dt = ((DataSet)Rs).Tables[0];
return(dt);
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList(int channel_id, int category_id, int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount)
{
string sql = "";
int role_id = Convert.ToInt32(Session["role_id"]);
if (role_id > 1)
{
sql = ChkGroup("select * from dt_order A inner join dt_order_child B on A.id=B.child_id where B.child_user_name='" + Session["user_name"].ToString() + "'");
}
else
{
sql = ChkGroup("select * from dt_order A inner join dt_order_child B on A.id=B.child_id where 1=1");
}
if (strWhere.Trim() != "")
{
sql += " and" + strWhere;
}
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
recordCount = Rs.RowCount;
string _sql = PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, sql.ToString(), filedOrder);
ResultDataSet Rs2 = new ResultDataSet();
db.DB2Obj.GetRs(_sql, out Rs2);
DataSet dt = ((DataSet)Rs2);
return(dt);
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList(int channel_id, int category_id, int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount)
{
string sql = "select update_name,sum(case when state = 0 then 1 else 0 end) as total1,sum(case when state = 1 then 1 else 0 end) as total2,sum(case when state = 2 then 1 else 0 end) as total3,sum(case when state = 3 then 1 else 0 end) as total4,count(state) as total from dt_order where 1=1";
if (strWhere.Trim() != "")
{
sql += " and" + strWhere + " group by update_name order by total desc";
}
else
{
sql += " group by update_name order by total desc";
}
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
recordCount = Rs.RowCount;
string _sql = PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, sql.ToString(), filedOrder);
ResultDataSet Rs2 = new ResultDataSet();
db.DB2Obj.GetRs(sql, out Rs2);
DataSet dt = ((DataSet)Rs2);
return(dt);
}
protected void Button1_Click(object sender, EventArgs e)
{
string fileName = "文件名";
ResultDataSet Rs2 = new ResultDataSet();
database_inte db2 = new database_inte();
ClsData dbobj = db2.DB2Obj;
dbobj.BeginTrans("test");
string sql1 = "insert into FileInfo (fileName,fileSize) values ('" + fileName + "','50')";
string sql2 = "insert into FileType (typeName,parentID) values ('标题',0)";
if (!dbobj.GetRs(sql1, out Rs2))
{
dbobj.RollBack("test");
return;
}
if (!dbobj.GetRs(sql2, out Rs2))
{
dbobj.RollBack("test");
Label1.Text = "失败";
return;
}
if (dbobj.CommitTrans("test") == false)
{
dbobj.RollBack("test");
Label1.Text = "失败";
return;
}
Label1.Text = "成功";
}
public string getUserNameList()
{
string array = "";
string groupID = Session["group_id"].ToString();
string strSQL = "select * from dt_manager where group_id like '%" + groupID + "' ";
ResultDataSet Rs2 = new ResultDataSet();
database_inte db2 = new database_inte();
db2.DB2Obj.GetRs(strSQL, out Rs2);
DataTable dt = ((DataSet)Rs2).Tables[0];
if (Rs2.RowCount > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (array == "")
{
array = "'" + dr["user_name"].ToString() + "'";
}
else
{
array += "," + "'" + dr["user_name"].ToString() + "'";
}
}
}
return(array);
}
protected void Button1_Click(object sender, EventArgs e)
{
string strSQL, _title, _content, _start, _end, _empid, _receiveName;
_empid = Session["user_name"].ToString();
_title = task_title.Text;
_content = task_content.Text;
_start = task_start.Text;
_end = tast_end.Text;
string _add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
_receiveName = dp_pp.SelectedValue;
strSQL = "insert into T_task (Task_title,Task_content,Task_starttime,Task_endtime,Task_empid,Task_handlestate,Task_receivestate,Task_finishstate,Task_state,add_time,receive_name)values" + "('" + _title + "','" + _content + "','" + _start + "','" + _end + "','" + _empid + "',0,0,0,0,'" + _add_time + "','" + _receiveName + "');SELECT @@IDENTITY as ID";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
if (db.DB3Obj.GetRs(strSQL, out Rs) == true)
{
if (Rs.RowCount > 0)
{
Response.Write("<script>alert('提交成功!');window.location.href ='task_add.aspx'</script>");
}
}
else
{
Response.Write("<script>alert('提交失败!');window.location.href ='task_add.aspx'</script>");
return;
}
}
private bool DoEdit(int _id)
{
int role_id = int.Parse(ddlRoleId.SelectedValue);
string group_id = ddGroup.SelectedValue;
int role_type = RoleTypeBind(role_id);
int is_lock = 0, sms_lock = 0;
if (cbIsLock.Checked == true)
{
is_lock = 0;
}
else
{
is_lock = 1;
}
if (smsIsLock.Checked == true)
{
sms_lock = 0;
}
else
{
sms_lock = 1;
}
bool result = false;
string username = txtUserName.Text.ToString();
string password = txtPassword1.Text.ToString();
string real_name = txtRealName.Text.ToString();
string tel = txtTelephone.Text.ToString();
//判断密码是否更改
if (txtPassword.Text.Trim() != defaultpassword)
{
string jiamipassword = System.Encryption.MD5.MDString(password);
ResultDataSet Rs2 = new ResultDataSet();
database_inte db2 = new database_inte();
string sql2 = "update dt_manager set role_id='" + role_id + "',role_type='" + role_type + "',real_name='" + real_name + "',password='******',telephone='" + tel + "',sms='" + sms_lock + "',is_lock='" + is_lock + "',group_id='" + group_id + "' where id ='" + _id + "'";
if (db2.DB2Obj.Exec(sql2))
{
result = true;
return(result);
}
}
else
{
ResultDataSet Rs2 = new ResultDataSet();
database_inte db2 = new database_inte();
string sql2 = "update dt_manager set role_id='" + role_id + "',role_type='" + role_type + "',real_name='" + real_name + "',telephone='" + tel + "',sms='" + sms_lock + "',is_lock='" + is_lock + "',group_id='" + group_id + "' where id ='" + _id + "'";
if (db2.DB2Obj.Exec(sql2))
{
result = true;
return(result);
}
}
return(result);
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList()
{
string sql = "select * from dt_manager_role ";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataSet dt = ((DataSet)Rs);
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request["taskid"]);
string _add_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string strSQL = "update T_task set Task_finishstate=1,submit_time='" + _add_time + "' where Task_id=" + id;
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB3Obj.GetRs(strSQL, out Rs);
Response.Redirect("task_handle.aspx");
}
public string getweek(string bingqu)
{
string sql = "select * from PatientRecord where (SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)))< pr_todate and pr_todate <(SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))) and (pr_body ='' or pr_body is null) and pr_bingqu='" + bingqu + "' order by pr_todate asc";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataTable dt = ((DataSet)Rs).Tables[0];
string menu = ToJson(dt);
return(menu);
}
public string getMenu(string id, string _roleid)
{
string sql = "select id,text,state,iconCls,url from Menu where nid='" + id + "' and roleid='" + _roleid + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataTable dt = ((DataSet)Rs).Tables[0];
string menu = ToJson(dt);
return(menu);
}
public string getTest2(string id)
{
string sql = "select * from TestData where testID='" + id + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataTable dt = ((DataSet)Rs).Tables[0];
string menu = ToJson(dt);
return(menu);
}
public int getOrderCount(string sql)
{
int totalCount = 0;
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
if (Rs.RowCount > 0)
{
totalCount = Rs.RowCount;
}
return(totalCount);
}
public bool Delete(int id)
{
string sql = "delete from dt_order where id = '" + id + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
bool result = db.DB2Obj.Exec(sql);
if (result)
{
return(true);
}
return(false);
}
public bool Update(int id)
{
string sql = "update dt_order set state=1 where id='" + id + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
bool result = db.DB2Obj.Exec(sql);
if (result)
{
return(true);
}
return(false);
}
private bool DoAdd()
{
ResultDataSet Rs2 = new ResultDataSet();
database_inte db2 = new database_inte();
try
{
string title = txtTitle.Text.Trim();
int parent_id = int.Parse(ddlParentId.SelectedValue);
string class_list = "";
int class_layer = 1;
string sql2 = "insert into FileType (typeName,parentID) values ('" + title + "'," + parent_id + ") SELECT @@IDENTITY as ID";
if (db2.DB2Obj.GetRs(sql2, out Rs2))
{
int id = int.Parse(Rs2[0, "ID"].ToString());
if (parent_id > 0)
{
ResultDataSet Rs = new ResultDataSet();
string strSQL = "select * from FileType where id=" + parent_id + "";
db2.DB2Obj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
class_list = Rs[0, "class_list"].ToString() + id.ToString() + ",";
class_layer = int.Parse(Rs[0, "class_layer"].ToString()) + 1;
}
else
{
class_list = "," + id + ",";
class_layer = 1;
}
}
else
{
class_list = "," + id + ",";
class_layer = 1;
}
string sql3 = "update FileType set class_list='" + class_list + "',class_layer='" + class_layer + "' where id =" + id + "";
if (db2.DB2Obj.Exec(sql3))
{
return(true);
}
}
}
catch
{
return(false);
}
return(false);
}
public string getRealName(string user_name)
{
string real_name = "";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
string strSQL = "select real_name from dt_manager where user_name='" + user_name + "'";
db.DB2Obj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
real_name = Rs[0, "real_name"].ToString();
}
return(real_name);
}
public string getAddTime(int value)
{
string val = "";
string sql = "select add_time from dt_order where id='" + value + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
if (Rs.RowCount > 0)
{
val = Rs[0, "add_time"].ToString();
}
return(val);
}
private void ShowInfo(int _id)
{
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
string strSQL = "select * from FileType where id='" + _id + "'";
db.DB2Obj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
ddlParentId.SelectedValue = Rs[0, "id"].ToString();
txtTitle.Text = Rs[0, "typeName"].ToString();
}
}
public string getOrderModel(string value, string column)
{
string val = "";
string sql = "select * from dt_order where id='" + value + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
if (Rs.RowCount > 0)
{
val = Rs[0, column].ToString();
}
return(val);
}
public string getTitle(string value)
{
string val = "";
string sql = "select * from dt_order_child where child_id='" + value + "'";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
if (Rs.RowCount > 0)
{
val = "该工单已经指派给" + getUserName(Rs[0, "child_user_name"].ToString());
}
return(val);
}
public string GetTitle(int id)
{
string title = "";
ResultDataSet Rs1 = new ResultDataSet();
database_inte db1 = new database_inte();
string strSQL1 = "select top 1 role_name from dt_manager_role where id='" + id + "'";
db1.DB2Obj.GetRs(strSQL1, out Rs1);
if (Rs1.RowCount > 0)
{
return(Rs1[0, "role_name"].ToString());
}
return(title);
}
public string GetGroup(string id)
{
string title = "";
ResultDataSet Rs1 = new ResultDataSet();
database_inte db1 = new database_inte();
string strSQL1 = "select top 1 typeName from dt_type_list where typeID = '" + id + "'";
db1.DB2Obj.GetRs(strSQL1, out Rs1);
if (Rs1.RowCount > 0)
{
return(Rs1[0, "typeName"].ToString());
}
return(title);
}
public string getDetails(int id)
{
string value = "";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
string strSQL = "select * from dt_order A inner join dt_order_child B on A.id=B.child_id where id='" + id + "'";
db.DB2Obj.GetRs(strSQL, out Rs);
if (Rs.RowCount > 0)
{
value = Rs[0, "child_details"].ToString();
}
return(value);
}
public int getTestCount()
{
int totalCount = 0;
string sql = "select * from TestData";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
if (Rs.RowCount > 0)
{
totalCount = Rs.RowCount;
}
return(totalCount);
}
public string getTestSearch(string rows, string page, string title)
{
int _rows = Convert.ToInt32(rows);
int _page = Convert.ToInt32(page);
string sql = "select top " + rows + " * from TestData where testID not in(select top " + (_rows * (_page - 1)) + " testID from TestData order by testID) and testTitle like '%" + title + "%' order by testID";
ResultDataSet Rs = new ResultDataSet();
database_inte db = new database_inte();
db.DB2Obj.GetRs(sql, out Rs);
DataTable dt = ((DataSet)Rs).Tables[0];
string menu = CreateJsonParameters(dt, true, getTestCount());
return(menu);
}
