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