/// <summary> /// 获得权限列表 /// </summary> /// <param name="UserName">用户名</param> /// <param name="ClassID">权限对象</param> /// <param name="dr">返回DataReader</param> /// <returns>整形是否成功</returns> public int GetProcessList(string UserName, long ClassID, out SqlDataReader dr) { int iReturn = 1; UDS.Components.Database mySQL = new UDS.Components.Database(); SqlParameter[] parameters = { mySQL.MakeInParam("@UserName", SqlDbType.VarChar, 300, UserName), mySQL.MakeInParam("@ClassID", SqlDbType.Int, 4, ClassID) }; dr = null; try { mySQL.RunProc("sp_GetRightListToClass", parameters, out dr); } catch (Exception e) { Error.Log(e.ToString()); } finally { //mySQL.Close(); //mySQL = null; } return(iReturn); }
/// <summary> /// 添加权限 /// </summary> /// <param name="SrcID"></param> /// <param name="ObjID"></param> /// <param name="BaseOn"></param> /// <param name="ProcID"></param> /// <returns></returns> public int AddRight(long SrcID, long ObjID, int BaseOn, int ProcID) { int iReturn = 1; UDS.Components.Database mySQL = new UDS.Components.Database(); try { SqlParameter[] parameters = { mySQL.MakeInParam("@Act_ID", SqlDbType.Int, 4, ProcID), mySQL.MakeInParam("@Based_On", SqlDbType.Int, 4, BaseOn), mySQL.MakeInParam("@Src_ID", SqlDbType.Int, 4, SrcID), mySQL.MakeInParam("@Obj_ID", SqlDbType.Int, 4, ObjID) }; mySQL.RunProc("sp_AddAssignRule", parameters); } catch (Exception e) { Error.Log(e.ToString()); } finally { mySQL.Close(); mySQL = null; } return(iReturn); }
/// <summary> /// 添加权限 /// </summary> /// <param name="SrcID"></param> /// <param name="ObjID"></param> /// <param name="BaseOn"></param> /// <param name="ProcID"></param> /// <returns></returns> public int AddRight(long SrcID,long ObjID,int BaseOn,int ProcID) { int iReturn=1; UDS.Components.Database mySQL = new UDS.Components.Database(); try { SqlParameter[] parameters = { mySQL.MakeInParam("@Act_ID", SqlDbType.Int, 4,ProcID), mySQL.MakeInParam("@Based_On", SqlDbType.Int, 4,BaseOn), mySQL.MakeInParam("@Src_ID", SqlDbType.Int, 4,SrcID), mySQL.MakeInParam("@Obj_ID", SqlDbType.Int, 4,ObjID) }; mySQL.RunProc("sp_AddAssignRule",parameters); } catch(Exception e) { Error.Log(e.ToString()); } finally { mySQL.Close(); mySQL = null; } return iReturn; }
/// <summary> /// �ӽ�ɫ��ɾ����Ա /// </summary> /// <param name="roleid">��ɫid</param> /// <param name="staffid">��Աid</param> /// <returns>����ֵ</returns> public static int DelStaffFromRole(int roleid,string staffid) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@Role_ID",SqlDbType.Int,4,roleid), db.MakeInParam("@StaffIDS",SqlDbType.VarChar,3000,staffid) }; return(db.RunProc("sp_DeleteStaffFromRole",prams)); }
/// <summary> /// ��ӽ�ɫ /// </summary> /// <param name="rolename">��ɫ��</param> /// <param name="roledescription">��ɫ����</param> /// <returns>��ɫID</returns> public static int Add(string rolename,string roledescription) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@Role_Name",SqlDbType.VarChar,300,rolename.Trim()), db.MakeInParam("@Role_Description",SqlDbType.VarChar,300,roledescription.Trim()) }; return(db.RunProc("sp_AddMyRole",prams)); }
/// <summary> /// 从角色中添加成员 /// </summary> /// <param name="roleid">角色id</param> /// <param name="staffid">非成员id</param> /// <returns>返回值</returns> public static int AddStaffFromRole(int roleid, string staffid) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@Role_ID", SqlDbType.Int, 4, roleid), db.MakeInParam("@StaffIDS", SqlDbType.VarChar, 3000, staffid) }; return(db.RunProc("sp_AddStaffToRole", prams)); }
/// <summary> /// 添加角色 /// </summary> /// <param name="rolename">角色名</param> /// <param name="roledescription">角色描述</param> /// <returns>角色ID</returns> public static int Add(string rolename, string roledescription) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@Role_Name", SqlDbType.VarChar, 300, rolename.Trim()), db.MakeInParam("@Role_Description", SqlDbType.VarChar, 300, roledescription.Trim()) }; return(db.RunProc("sp_AddMyRole", prams)); }
/// <summary> /// 修改角色信息 /// </summary> /// <param name="roleid">角色ID</param> /// <param name="rolename">角色名称</param> /// <param name="roledescription">角色描述</param> /// <returns>返回值(0成功1不成功)</returns> public static int Modify(int roleid, string rolename, string roledescription) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@role_id", SqlDbType.Int, 4, roleid), db.MakeInParam("@role_name", SqlDbType.VarChar, 300, rolename.Trim()), db.MakeInParam("@role_description", SqlDbType.VarChar, 300, roledescription.Trim()) }; return(db.RunProc("sp_UpdateRoleInfo", prams)); }
/// <summary> /// 人员职位级别更新 /// </summary> /// <param name="PositionID">职位ID</param> /// <param name="NewCaste">新职级</param> /// <returns>返回是否成功</returns> public static int UpdateCaste(long PositionID, int NewCaste) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@PositionID", SqlDbType.Int, 4, PositionID), db.MakeInParam("@NewCaste", SqlDbType.Int, 4, NewCaste) }; return(db.RunProc("sp_UpdatePositionCaste", prams)); }
/// <summary> /// 检查此人是否已经在联系人列表中 /// </summary> /// <param name="type">联系人类型(0:所有联系人1:员工联系人2:客户联系人3:自定义联系人)</param> /// <param name="staffid">用户id</param> /// <param name="id">联系人id</param> /// <returns></returns> public bool HaveInList(int type, int staffid, int id) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@type", SqlDbType.Int, 4, type), data.MakeInParam("@staffid", SqlDbType.Int, 4, staffid), data.MakeInParam("@id", SqlDbType.Int, 4, id) }; return((data.RunProc("sp_Linkman_HaveInList", prams) == 1)?true:false); }
private void cmdSubmit_ServerClick(object sender, System.EventArgs e) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,selectedID), db.MakeInParam("@NewDeptID",SqlDbType.Int,4,Int32.Parse(Department.Items[Department.SelectedIndex].Value)) }; db.RunProc("sp_StaffMove",prams); if(ReturnPage ==0) Response.Redirect(backfilepath+"?DeptID="+DeptID+"&displayType="+displayType); else Response.Redirect("../Staff/ManageStaff.aspx?DisplayType=0"); }
/// <summary> /// 得到我的联系人 /// </summary> /// <param name="type">联系人类型(0:所有联系人1:员工联系人2:客户联系人3:自定义联系人)</param> /// <param name="staffid">用户id</param> /// <returns></returns> public SqlDataReader GetMyLinkman(int type, int staffid) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@type", SqlDbType.Int, 4, type), data.MakeInParam("@staffid", SqlDbType.Int, 4, staffid) }; SqlDataReader dr = null; data.RunProc("sp_Linkman_GetList", prams, out dr); return(dr); }
public string GetRoleInfo(long RoleID, string FiledName) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@RoleID", SqlDbType.Int, 4, RoleID), }; db.RunProc("sp_GetRoleInfo", prams, out dr); try { if (dr.Read()) { try { return(dr[FiledName].ToString()); } catch { return(""); } } else { return(""); } } finally { dr = null; db = null; } }
/// <summary> /// ����ĵ���������ĿID /// </summary> /// <param name="DocID">�ĵ�ID</param> public static int GetDocumentProjectID(long DocID) { int iReturn=0; UDS.Components.Database mySQL = new UDS.Components.Database(); SqlParameter[] parameters = { mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID) }; try { iReturn = mySQL.RunProc("sp_Flow_GetDocumentProjectID",parameters); } catch(Exception e) { Error.Log(e.ToString()); throw new Exception("��ù��ĵ���ĿID�����",e); } finally { mySQL.Close(); mySQL = null; } return iReturn; }
/// <summary> /// 设置用户是否需要硬件KEY验证 /// </summary> /// <param name="StaffID">人员ID</param> /// <param name="IsNeedKey">是否需要登陆</param> /// <returns>返回是否成功</returns> public bool SetIsNeedKey(string StaffIDs, bool IsNeedKey) { UDS.Components.Database db = new UDS.Components.Database(); if (StaffIDs.Length > 0) { SqlParameter[] prams = { db.MakeInParam("@StaffIDs", SqlDbType.VarChar, 1000, StaffIDs), db.MakeInParam("@IsNeedKey", SqlDbType.Bit, 1, IsNeedKey) }; return(db.RunProc("sp_Staff_SetIsNeedKey", prams) == 0?true:false); } else { return(false); } }
/// <summary> /// ������ɾ��ij��Ա /// </summary> /// <param name="staffids">��Աid����</param> /// <returns>�Ƿ�ɹ�</returns> public bool DeleteStaffFromTeam(string staffids,int TeamID) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,staffids), db.MakeInParam("@TeamID",SqlDbType.Int,8,TeamID) }; try { return((db.RunProc("sp_DeleteStaffFromTeam",prams)==0)?true:false); } catch(Exception ex) { Error.Log(ex.ToString()); throw new Exception("������ɾ��ij��Ա!",ex); } }
/// <summary> /// ɾ����ɫ /// </summary> /// <param name="roleid">��ɫID</param> /// <returns>0�ɹ�1���ɹ�</returns> public static int Delete(int roleid) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@role_id",SqlDbType.Int,4,roleid) }; return(db.RunProc("sp_DeleteRole",prams)); }
/// <summary> /// 删除角色 /// </summary> /// <param name="roleid">角色ID</param> /// <returns>0成功1不成功</returns> public static int Delete(int roleid) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@role_id", SqlDbType.Int, 4, roleid) }; return(db.RunProc("sp_DeleteRole", prams)); }
private void cmdSubmit_ServerClick(object sender, System.EventArgs e) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS", SqlDbType.VarChar, 300, selectedID), db.MakeInParam("@NewDeptID", SqlDbType.Int, 4, Int32.Parse(Department.Items[Department.SelectedIndex].Value)) }; db.RunProc("sp_StaffMove", prams); if (ReturnPage == 0) { Response.Redirect(backfilepath + "?DeptID=" + DeptID + "&displayType=" + displayType); } else { Response.Redirect("../Staff/ManageStaff.aspx?DisplayType=0"); } }
/// <summary> /// 加入成员至组 /// </summary> /// <param name="staffids">人员id集合</param> /// <returns>是否成功</returns> public bool AddMemberToTeam(string staffids, int TeamID) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS", SqlDbType.VarChar, 300, staffids), db.MakeInParam("@TeamID", SqlDbType.Int, 8, TeamID) }; try { return((db.RunProc("sp_AddStaffToTeam", prams) == 0)?true:false); } catch (Exception ex) { Error.Log(ex.ToString()); throw new Exception("加入成员至组出错!", ex); } }
/// <summary> /// 使人员复职 /// </summary> /// <param name="staffids">人员id集合</param> /// <returns>是否成功</returns> public bool ReturnPosition(string staffids) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS", SqlDbType.VarChar, 300, staffids) }; return((db.RunProc("sp_StaffRehab", prams) == 0)?true:false); }
/// <summary> /// 人员更新 /// </summary> /// <param name="StaffID">人员ID</param> /// <returns>返回是否成功</returns> public int UpdateInfo(long StaffID, string RealName, int Sex, string Birthday, string Password, string Email, string Phone, string Mobile, long PositionID, int Caste) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffID", SqlDbType.Int, 4, StaffID), db.MakeInParam("@RealName", SqlDbType.VarChar, 50, RealName), db.MakeInParam("@Sex", SqlDbType.Bit, 1, Sex), db.MakeInParam("@Birthday", SqlDbType.DateTime, 8, Birthday), db.MakeInParam("@Password", SqlDbType.VarChar, 255, Password), db.MakeInParam("@Email", SqlDbType.VarChar, 500, Email), db.MakeInParam("@Phone", SqlDbType.VarChar, 50, Phone), db.MakeInParam("@Mobile", SqlDbType.VarChar, 50, Mobile), db.MakeInParam("@PositionID", SqlDbType.Int, 4, PositionID), db.MakeInParam("@Caste", SqlDbType.Int, 4, Caste) }; return(db.RunProc("sp_UpdateStaffInfo", prams)); }
/// <summary> /// 更新自定义联系人分类 /// </summary> /// <param name="mlinkman"></param> public void UpdateCustomLinkmanType(CustomLinkman clinkman) { UDS.Components.Database data = new UDS.Components.Database(); if (clinkman.Type.IndexOf(',', 0) != -1) { string [] arrtype = clinkman.Type.Split(','); for (int i = 0; i < arrtype.Length; i++) { if (arrtype[i].Trim() != "") { SqlParameter[] prams1 = { data.MakeInParam("@typeid", SqlDbType.Int, 4, arrtype[i]), data.MakeInParam("@id", SqlDbType.Int, 4, clinkman.ID) }; data.RunProc("sp_Linkman_AddCustomLinkmanType", prams1); } } } }
public SqlDataReader GetStaffIDByRealName(string realname) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@realname", SqlDbType.VarChar, 100, realname) }; db.RunProc("sp_GetStaffIDByRealName", prams, out dr); return(dr); }
public SqlDataReader GetCustomLinkmanType(int id) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@id", SqlDbType.Int, 4, id) }; SqlDataReader dr = null; data.RunProc("sp_Linkman_GetCustomLinkmanTypeByCustomLinkmanID", prams, out dr); return(dr); }
public SqlDataReader Find(string key, BBSSearchOption option, DataTable boards) { string boardids = ""; string sql = "select * from UDS_Bbs_ForumItem"; SqlDataReader dr = null; if (option.searchtype == BBSSearchType.author) { sql += " where sender like '%" + key + "%'"; } else if (option.searchtype == BBSSearchType.title) { sql += " where title like '%" + key + "%'"; } if (option.BoardID != 0) { sql += " and board_id=" + option.BoardID; } else { foreach (DataRow row in boards.Rows) { boardids += row["board_id"].ToString() + ","; } if (boardids != "") { boardids = boardids.Substring(0, boardids.Length - 1); } sql += " and board_id in (" + boardids + ")"; } if (option.TimeBound != TimeSpan.MaxValue) { //计算时间段 sql += " and datediff(d,send_time,getdate())< " + option.TimeBound.Days.ToString(); } UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL", SqlDbType.NText, 5000, sql), }; db.RunProc("sp_RunSQL", prams, out dr); return(dr); }
public SqlDataReader GetRoleInfo(long RoleID) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@RoleID", SqlDbType.Int, 4, RoleID), }; db.RunProc("sp_GetRoleInfo", prams, out dr); return(dr); }
/// <summary> /// ����ĵ� /// </summary> /// <param name="UserName">�����</param> /// <param name="FlowID">��������ID</param> /// <param name="SQL">��ʽ�����ݵ�SQL���</param> public int AddDocument(string UserName,long FlowID,string SQL) { int iReturn=-1; UDS.Components.Database mySQL = new UDS.Components.Database(); SqlParameter[] parameters = { mySQL.MakeInParam("@DocBuilder",SqlDbType.VarChar,300,UserName), mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID), mySQL.MakeInParam("@SQL",SqlDbType.NText,4000,SQL) }; try { iReturn = mySQL.RunProc("sp_Flow_AddDocument",parameters); } catch(Exception e) { Error.Log(e.ToString()); } finally { mySQL.Close(); mySQL = null; } return iReturn; }
/// <summary> /// 人员复职 /// </summary> /// <param name="StaffID">人员ID</param> /// <returns>返回是否成功</returns> public bool Rehab(string StaffIDS) { UDS.Components.Database db = new UDS.Components.Database(); if (StaffIDS.Length > 0) { SqlParameter[] prams = { db.MakeInParam("@StaffIDS", SqlDbType.VarChar, 300, StaffIDS.ToString()) }; return(db.RunProc("sp_StaffRehab", prams) == 0?true:false); } else { return(false); } }
/// <summary> /// 根据rolename得到roleid /// </summary> /// <param name="rolename">角色名称</param> /// <returns>角色id</returns> public static int GetRoleIDByName(string rolename) { UDS.Components.Database db = new UDS.Components.Database(); int roleid = 0; SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@rolename", SqlDbType.VarChar, 100, rolename), }; db.RunProc("sp_GetRoleIDFromName", prams, out dr); while (dr.Read()) { roleid = Int32.Parse(dr["role_id"].ToString()); } return(roleid); }
/// <summary> /// ����ļ��������ݿ���� /// </summary> /// <param name="att">DocAttachFile��</param> /// <param name="DocID">�ļ�ID</param> public void AddAttach(UDS.Components.DocAttachFile att,long DocID) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@DocID", SqlDbType.Int, 20, DocID), data.MakeInParam("@FileName", SqlDbType.VarChar, 300, att.FileName), data.MakeInParam("@FileSize", SqlDbType.Int, 20, att.FileSize), data.MakeInParam("@FileAttribute", SqlDbType.SmallInt,20, att.FileAttribute), data.MakeInParam("@FileVisualPath", SqlDbType.NVarChar, 200, att.FileVisualPath), data.MakeInParam("@FileAuthor", SqlDbType.NVarChar, 50, att.FileAuthor), data.MakeInParam("@FileCatlog", SqlDbType.NVarChar, 20, att.FileCatlog), data.MakeInParam("@FileAddedDate", SqlDbType.DateTime, 30, DateTime.Parse(att.FileAddedDate)) }; try { data.RunProc("sp_Flow_AddFile", prams); } catch (Exception ex) { Error.Log(ex.ToString()); throw new Exception("�ļ��������ͳ���!",ex); } }
/// <summary> /// 得到员工上下班时间 /// </summary> public DutyTime GetDutyTime() { UDS.Components.Database db = new UDS.Components.Database(); DutyTime dt = new DutyTime(); System.Data.SqlClient.SqlParameter[] prams = { db.MakeInParam("@staffid", System.Data.SqlDbType.Int, 4, staffid), db.MakeOutParam("@ondutytime", System.Data.SqlDbType.SmallDateTime, 8), db.MakeOutParam("@offdutytime", System.Data.SqlDbType.SmallDateTime, 8) }; if (db.RunProc("sp_WA_GetDutyTime", prams) != 0) { throw(new Exception("读取人员上下班时间出错")); } else { dt.OnDutyTime = (System.DateTime)prams[1].Value; dt.OffDutyTime = (System.DateTime)prams[2].Value; return(dt); } }
private void Bind() { DataSet ds = new DataSet(); UDS.Components.Staff staff1 = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff1.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); try { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL", SqlDbType.NText, 5000, searchstring) }; SqlDataReader dr = null; db.RunProc("sp_RunSql", prams, out dr); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "Client"; ds.Tables.Add(dt); ltl_Client.Text = dt.Rows.Count.ToString(); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); dt.DefaultView.Sort = ViewState["SortField"].ToString() + " " + ViewState["SortDirect"].ToString(); dgrd_clientlist.DataSource = dt.DefaultView; dgrd_clientlist.DataBind(); } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../../Error.aspx"); } }
/// <summary> /// 删除权限 /// </summary> /// <param name="RuleIDs">权限记录号</param> public int DeleteRight(string RuleIDs) { int iReturn = 1; UDS.Components.Database mySQL = new UDS.Components.Database(); try { SqlParameter[] parameters = { mySQL.MakeInParam("@Rule_IDS", SqlDbType.VarChar, 300, RuleIDs) }; mySQL.RunProc("sp_DeleteAssignRule", parameters); } catch (Exception e) { Error.Log(e.ToString()); } finally { //mySQL.Close(); //mySQL = null; } return(iReturn); }
/// <summary> /// 删除权限 /// </summary> /// <param name="RuleIDs">权限记录号</param> public int DeleteRight(string RuleIDs) { int iReturn=1; UDS.Components.Database mySQL = new UDS.Components.Database(); try { SqlParameter[] parameters = { mySQL.MakeInParam("@Rule_IDS",SqlDbType.VarChar ,300,RuleIDs) }; mySQL.RunProc("sp_DeleteAssignRule",parameters); } catch(Exception e) { Error.Log(e.ToString()); } finally { //mySQL.Close(); //mySQL = null; } return iReturn; }
private void Bind() { DataSet ds = new DataSet(); UDS.Components.Staff staff1 = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff1.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); try { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL",SqlDbType.NText,5000,searchstring) }; SqlDataReader dr = null; db.RunProc("sp_RunSql",prams,out dr); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "Client"; ds.Tables.Add(dt); ltl_Client.Text = dt.Rows.Count.ToString(); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); dt.DefaultView.Sort = ViewState["SortField"].ToString() + " " + ViewState["SortDirect"].ToString(); dgrd_clientlist.DataSource = dt.DefaultView; dgrd_clientlist.DataBind(); } catch(Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../../Error.aspx"); } }
/// <summary> /// ɾ������ /// </summary> public void DelAttachment(string attachmentmd) { UDS.Components.Database data = new UDS.Components.Database (); SqlParameter[] prams = { data.MakeInParam("@replayid", SqlDbType.Int, 4,this.ReplayId), }; SqlDataReader dr = null; data.RunProc ("sp_BBS_GetReplayAttachment",prams,out dr); while(dr.Read()) { System.IO.File.Delete(attachmentmd+"\\"+dr["filename"].ToString()); } data.Close(); SqlParameter[] prams1 = { data.MakeInParam("@replayid", SqlDbType.Int, 4,this.ReplayId), }; data.RunProc("sp_BBS_DelAttachmentToReplay",prams1); }
public SqlDataReader Find(string key,BBSSearchOption option,DataTable boards) { string boardids = ""; string sql = "select * from UDS_Bbs_ForumItem"; SqlDataReader dr = null; if(option.searchtype==BBSSearchType.author) { sql += " where sender like '%"+key+"%'"; } else if(option.searchtype==BBSSearchType.title) { sql += " where title like '%"+key+"%'"; } if(option.BoardID!=0) { sql += " and board_id="+option.BoardID; } else { foreach(DataRow row in boards.Rows) { boardids += row["board_id"].ToString() + ","; } if(boardids!="") boardids = boardids.Substring(0,boardids.Length-1); sql += " and board_id in ("+boardids+")"; } if(option.TimeBound!=TimeSpan.MaxValue) { //����ʱ��� sql += " and datediff(d,send_time,getdate())< "+option.TimeBound.Days.ToString(); } UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL", SqlDbType.NText, 5000, sql), }; db.RunProc("sp_RunSQL",prams,out dr); return dr; }
/// <summary> /// ��Ա���� /// </summary> /// <param name="StaffID">��ԱID</param> /// <returns>�����Ƿ�ɹ�</returns> public int UpdateInfo(long StaffID, string RealName, int Sex, string Birthday, string Password, string Email, string Phone, string Mobile, long PositionID, int Caste, string ContractDate , string InsuranceStatus , string AccumulationStatus , string IDNumber , string Marriage , string Address , string BirthPlace , string Education , string Features , string Remark , string InsuranceBase , string EndowmentCompany , string EndowmentPersonal , string UnemploymentCompany , string UnemploymentPersonal , string Injury , string Maternity , string MedicalCompany , string MedicalPersonal , string InsuranceCompanyTotal , string InsurancePersonalTotal , string AccumulationBase , string AccumulationCompany , string AccumulationPersonal , string staff_dept) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffID",SqlDbType.Int,4,StaffID), db.MakeInParam("@RealName",SqlDbType.VarChar,50,RealName), db.MakeInParam("@Sex",SqlDbType.Bit ,1,Sex), db.MakeInParam("@Birthday",SqlDbType.DateTime ,8,Birthday), db.MakeInParam("@Password",SqlDbType.VarChar,255,Password), db.MakeInParam("@Email",SqlDbType.VarChar,500,Email), db.MakeInParam("@Phone",SqlDbType.VarChar,50,Phone), db.MakeInParam("@Mobile",SqlDbType.VarChar,50,Mobile), db.MakeInParam("@PositionID",SqlDbType.Int,4,PositionID), db.MakeInParam("@Caste",SqlDbType.Int,4,Caste), db.MakeInParam("@ContractDate",SqlDbType.DateTime,8,ContractDate), db.MakeInParam("@InsuranceStatus",SqlDbType.VarChar,300,InsuranceStatus), db.MakeInParam("@AccumulationStatus",SqlDbType.VarChar,300,AccumulationStatus), db.MakeInParam("@IDNumber",SqlDbType.VarChar,300,IDNumber), db.MakeInParam("@Marriage",SqlDbType.VarChar,300,Marriage), db.MakeInParam("@Address",SqlDbType.VarChar,300,Address), db.MakeInParam("@BirthPlace",SqlDbType.VarChar,300,BirthPlace), db.MakeInParam("@Education ",SqlDbType.VarChar,300,Education ), db.MakeInParam("@Features",SqlDbType.VarChar,300,Features), db.MakeInParam("@Remark",SqlDbType.VarChar,300,Remark), db.MakeInParam("@InsuranceBase",SqlDbType.Money,21, decimal.Parse(InsuranceBase)), db.MakeInParam("@EndowmentCompany",SqlDbType.Money,21, decimal.Parse(EndowmentCompany)), db.MakeInParam("@EndowmentPersonal ",SqlDbType.Money,21, decimal.Parse(EndowmentPersonal )), db.MakeInParam("@UnemploymentCompany ",SqlDbType.Money,21, decimal.Parse(UnemploymentCompany )), db.MakeInParam("@UnemploymentPersonal",SqlDbType.Money,21, decimal.Parse(UnemploymentPersonal)), db.MakeInParam("@Injury",SqlDbType.Money,21, decimal.Parse(Injury)), db.MakeInParam("@Maternity ",SqlDbType.Money,21, decimal.Parse(Maternity )), db.MakeInParam("@MedicalCompany ",SqlDbType.Money,21, decimal.Parse(MedicalCompany )), db.MakeInParam("@MedicalPersonal",SqlDbType.Money,21, decimal.Parse(MedicalPersonal)), db.MakeInParam("@InsuranceCompanyTotal ",SqlDbType.Money,21, decimal.Parse(InsuranceCompanyTotal )), db.MakeInParam("@InsurancePersonalTotal",SqlDbType.Money,21, decimal.Parse(InsurancePersonalTotal)), db.MakeInParam("@AccumulationBase",SqlDbType.Money,21, decimal.Parse(AccumulationBase)), db.MakeInParam("@AccumulationCompany ",SqlDbType.Money,21, decimal.Parse(AccumulationCompany )), db.MakeInParam("@AccumulationPersonal",SqlDbType.Money,21, decimal.Parse(AccumulationPersonal)), db.MakeInParam("@staff_dept",SqlDbType.VarChar,200,staff_dept) }; return db.RunProc("sp_UpdateStaffInfo",prams); }
/// <summary> /// �����û��Ƿ���ҪӲ��KEY��֤ /// </summary> /// <param name="StaffID">��ԱID</param> /// <param name="IsNeedKey">�Ƿ���Ҫ��½</param> /// <returns>�����Ƿ�ɹ�</returns> public bool SetIsNeedKey(string StaffIDs,bool IsNeedKey) { UDS.Components.Database db = new UDS.Components.Database(); if(StaffIDs.Length >0) { SqlParameter[] prams = { db.MakeInParam("@StaffIDs",SqlDbType.VarChar,1000,StaffIDs), db.MakeInParam("@IsNeedKey",SqlDbType.Bit ,1,IsNeedKey) }; return db.RunProc("sp_Staff_SetIsNeedKey",prams)==0?true:false; } else return false; }
/// <summary> /// ʹ��Ա��ְ /// </summary> /// <param name="staffids">��Աid����</param> /// <returns>�Ƿ�ɹ�</returns> public bool ReturnPosition(string staffids) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,staffids) }; return((db.RunProc("sp_StaffRehab",prams)==0)?true:false); }
/// <summary> /// 获得权限列表 /// </summary> /// <param name="UserName">用户名</param> /// <param name="ClassID">权限对象</param> /// <param name="dr">返回DataTable</param> /// <returns>整形是否成功</returns> public int GetProcessList(string UserName,long ClassID,out DataTable dt) { int iReturn=1; SqlDataReader dr; UDS.Components.Database mySQL = new UDS.Components.Database(); SqlParameter[] parameters = { mySQL.MakeInParam("@UserName",SqlDbType.VarChar ,300,UserName), mySQL.MakeInParam("@ClassID",SqlDbType.Int,4,ClassID) }; dt = null; try { mySQL.RunProc("sp_GetRightListToClass",parameters,out dr); dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); } catch(Exception e) { Error.Log(e.ToString()); } finally { //mySQL.Close(); //mySQL = null; } return iReturn; }
/// <summary> /// �����Զ�����ϵ�˷��� /// </summary> /// <param name="mlinkman"></param> public void UpdateCustomLinkmanType(CustomLinkman clinkman) { UDS.Components.Database data = new UDS.Components.Database(); if(clinkman.Type.IndexOf(',',0)!=-1) { string [] arrtype = clinkman.Type.Split(','); for(int i = 0;i<arrtype.Length;i++) { if(arrtype[i].Trim()!="") { SqlParameter[] prams1 = { data.MakeInParam("@typeid",SqlDbType.Int,4,arrtype[i]), data.MakeInParam("@id",SqlDbType.Int,4,clinkman.ID) }; data.RunProc("sp_Linkman_AddCustomLinkmanType",prams1); } } } }
/// <summary> /// �����Զ�����ϵ�� /// </summary> /// <param name="mlinkman"></param> public void UpdateCustomLinkman(CustomLinkman clinkman) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@ID",SqlDbType.Int,4,clinkman.ID), data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name), data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender), data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone), data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email), data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress), data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip), data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress), data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip), data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile), data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone), data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo), data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age), data.MakeInParam("@Type",SqlDbType.VarChar,200,clinkman.Type) }; data.RunProc("sp_Linkman_UpdateCustomLinkman",prams); }
/// <summary> /// 更新自定义联系人 /// </summary> /// <param name="mlinkman"></param> public void UpdateCustomLinkman(CustomLinkman clinkman) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@ID", SqlDbType.Int, 4, clinkman.ID), data.MakeInParam("@name", SqlDbType.VarChar, 100, clinkman.Name), data.MakeInParam("@Gender", SqlDbType.Bit, 1, clinkman.Gender), data.MakeInParam("@UnitTelephone", SqlDbType.VarChar, 50, clinkman.UnitTelephone), data.MakeInParam("@Email", SqlDbType.VarChar, 50, clinkman.Email), data.MakeInParam("@UnitAddress", SqlDbType.VarChar, 200, clinkman.UnitAddress), data.MakeInParam("@UnitZip", SqlDbType.VarChar, 50, clinkman.UnitZip), data.MakeInParam("@FamilyAddress", SqlDbType.VarChar, 200, clinkman.FamilyAddress), data.MakeInParam("@FamilyZip", SqlDbType.VarChar, 50, clinkman.FamilyZip), data.MakeInParam("@Mobile", SqlDbType.VarChar, 100, clinkman.Mobile), data.MakeInParam("@FamilyTelephone", SqlDbType.VarChar, 100, clinkman.FamilyTelephone), data.MakeInParam("@Memo", SqlDbType.VarChar, 1000, clinkman.Memo), data.MakeInParam("@Age", SqlDbType.VarChar, 50, clinkman.Age), data.MakeInParam("@Type", SqlDbType.VarChar, 200, clinkman.Type) }; data.RunProc("sp_Linkman_UpdateCustomLinkman", prams); }
public SqlDataReader GetRoleInfo(long RoleID) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@RoleID",SqlDbType.Int ,4,RoleID), }; db.RunProc("sp_GetRoleInfo",prams,out dr); return(dr); }
private void btn_OK_Click(object sender, System.EventArgs e) { if(lbx_search.Items.Count>0) { string searchstring = ""; string tmp = ""; DateTime begintime = new DateTime(); DateTime endtime = DateTime.Now; foreach(ListItem lt in lbx_search.Items) { string [] searcharr = new string[2]; searcharr = lt.Value.Split(':'); switch(searcharr[0].Trim()) { case "������Ա����": UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]); tmp = "UDS_CM_ClientContact.MarketmanID='"; while(dr_staffid.Read()) { tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientContact.MarketmanID='"; } dr_staffid.Close(); if(tmp=="UDS_CM_ContactInfo.MarketmanID='") searchstring = "1=2"; else { tmp = tmp.Substring(0,tmp.Length-37); searchstring += "(" + tmp + ") and "; } break; case "�ͻ�����": UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr_clientid = cm.GetClientIDByName(searcharr[1]); tmp = "UDS_CM_ClientContact.ClientID='"; while(dr_clientid.Read()) { tmp += dr_clientid["ID"] + "' or UDS_CM_ClientContact.ClientID='"; } dr_clientid.Close(); if(tmp=="UDS_CM_ClientContact.ClientID='") searchstring = "1=2"; else { tmp = tmp.Substring(0,tmp.Length-34); searchstring += "(" + tmp + ") and "; } break; case "�ͻ����": searchstring += "UDS_CM_ClientContact.ClientID=" + searcharr[1] + " and "; break; case "���۽�": switch(searcharr[1]) { case "����": searchstring += "patindex('%trace%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "���": searchstring += "patindex('%boot%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "��Ʒ�Ƽ�": searchstring += "patindex('%commend%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "������": searchstring += "patindex('%requirement%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "�����ύ": searchstring += "patindex('%submit%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "����̸��": searchstring += "patindex('%negotiate%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "��Ŀʵʩ": searchstring += "patindex('%actualize%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "���ٷ���": searchstring += "patindex('%traceservice%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "��β��": searchstring += "patindex('%last%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; } break; case "�ɽ�Ԥ��": searchstring += "UDS_CM_ClientContact.BargainPrognosis='" + searcharr[1] + "' and "; break; case "�ѽ�Ǣ����": searchstring += "UDS_CM_ClientContact.ContactTimes=" + searcharr[1] + " and "; break; case "��Ǣ����ְ��": searchstring += "UDS_CM_Linkman.[Position]='" + searcharr[1] + "' and "; break; case "�״ν�Ǣʱ��": searchstring += "UDS_CM_ClientInfo.FirstContactTime='" + searcharr[1] + "' and "; break; case "���һ�ν�Ǣʱ��": searchstring += "UDS_CM_ClientInfo.ContactTime='" + searcharr[1] + "' and "; break; case "�´�Լ��ʱ��": searchstring += "UDS_CM_ClientInfo.NextContactTime='" + searcharr[1] + "' and "; break; case "����������¼": //�õ�������ʼ��(��һ -- ����) begintime = DateTime.Now; switch((int)DateTime.Now.DayOfWeek) { case 0: begintime = begintime.AddDays(-6); break; default: begintime = begintime.AddDays(1-(int)DateTime.Now.DayOfWeek); break; } searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and "; break; case "����������¼": //�õ�������ʼ�� begintime = DateTime.Now; begintime = begintime.AddDays(1-DateTime.Now.Day); searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and "; break; } } searchstring = "select * from UDS_CM_ClientInfo where ID IN (select UDS_CM_ClientInfo.ID from UDS_CM_ClientContact left join UDS_CM_ClientContact_Linkman ON UDS_CM_ClientContact.ID=UDS_CM_ClientContact_Linkman.ContactID left join UDS_CM_Linkman ON UDS_CM_ClientContact_Linkman.LinkmanID=UDS_CM_ClientContact_Linkman.id,UDS_CM_ClientInfo where UDS_CM_ClientContact.clientid=UDS_CM_ClientInfo.id and " + searchstring; if(searchstring.EndsWith("and ")) { searchstring = searchstring.Substring(0,searchstring.Length-4); } searchstring += " group by UDS_CM_ClientInfo.ID)"; DataSet ds = new DataSet(); UDS.Components.Staff staff1 = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff1.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL",SqlDbType.NText,5000,searchstring) }; SqlDataReader dr = null; db.RunProc("sp_RunSql",prams,out dr); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "Client"; ds.Tables.Add(dt); ltl_Client.Text = dt.Rows.Count.ToString(); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); dgrd_ContactList.DataSource = dt.DefaultView; dgrd_ContactList.DataBind(); } }
private void cmdSubmit_Click(object sender, System.EventArgs e) { if (rb_male.Checked == true) { sex = 1; } else { sex = 0; } if (EditStatus == 0) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr; if (mydepartment.Visible == true) { DeptID = cboDepartment.Items[cboDepartment.SelectedIndex].Value.ToString(); } SqlParameter[] prams = { db.MakeInParam("@StaffName", SqlDbType.VarChar, 300, txtStaffName.Text), db.MakeInParam("@Password", SqlDbType.VarChar, 300, txtPassword.Text), db.MakeInParam("@RealName", SqlDbType.VarChar, 300, txtRealName.Text), db.MakeInParam("@Sex", SqlDbType.Int, 4, sex), db.MakeInParam("@Status", SqlDbType.Int, 4, 0), db.MakeInParam("@Email", SqlDbType.VarChar, 300, txtEmail.Text), db.MakeInParam("@RegistedDate", SqlDbType.DateTime, 8, DateTime.Now.ToString()), db.MakeInParam("@DeptID", SqlDbType.Int, 4, Int32.Parse(DeptID)), db.MakeInParam("@Phone", SqlDbType.VarChar, 50, txtPhone.Text), db.MakeInParam("@Mobile", SqlDbType.VarChar, 50, txtMobile.Text), db.MakeInParam("@Birthday", SqlDbType.DateTime, 8, (txtBirthday.Text.Trim() == "")?"1900-1-1":txtBirthday.Text) }; db.RunProc("sp_AddStaff", prams, out dr); if (dr.Read()) { if (ReturnPage == 0) { Response.Redirect("ListView.aspx?Dep_ID=" + DeptID); } else { Response.Redirect("../Staff/ManageStaff.aspx"); } } else { message.Text = "该用户已经存在!"; } } else { UDS.Components.Staff person = new UDS.Components.Staff(); switch (person.UpdateInfo(StaffID, txtRealName.Text, sex, txtBirthday.Text, txtPassword.Text, txtEmail.Text, txtPhone.Text, txtMobile.Text, Int32.Parse(cboDepartment.Items[cboDepartment.SelectedIndex].Value))) { case 0: message.Text = "修改成功!"; break; case -1: message.Text = "验证密码不对!"; break; default: break; } } }
public SqlDataReader GetStaffIDByRealName(string realname) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@realname",SqlDbType.VarChar,100,realname) }; db.RunProc("sp_GetStaffIDByRealName",prams,out dr); return(dr); }
/// <summary> /// ��Ա��ְ /// </summary> /// <param name="StaffID">��ԱID</param> /// <returns>�����Ƿ�ɹ�</returns> public bool Rehab(string StaffIDS) { UDS.Components.Database db = new UDS.Components.Database(); if(StaffIDS.Length >0) { SqlParameter[] prams = { db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,StaffIDS.ToString()) }; return db.RunProc("sp_StaffRehab",prams)==0?true:false; } else return false; }
/// <summary> /// 添加自定义联系人 /// </summary> /// <param name="clinkman">CustomLinkman结构</param> /// <returns>添加的ID</returns> public int AddCustomLinkman(CustomLinkman clinkman, int staffid) { int result = 0; UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@name", SqlDbType.VarChar, 100, clinkman.Name), data.MakeInParam("@Gender", SqlDbType.Bit, 1, clinkman.Gender), data.MakeInParam("@UnitTelephone", SqlDbType.VarChar, 50, clinkman.UnitTelephone), data.MakeInParam("@Email", SqlDbType.VarChar, 50, clinkman.Email), data.MakeInParam("@UnitAddress", SqlDbType.VarChar, 200, clinkman.UnitAddress), data.MakeInParam("@UnitZip", SqlDbType.VarChar, 50, clinkman.UnitZip), data.MakeInParam("@FamilyAddress", SqlDbType.VarChar, 200, clinkman.FamilyAddress), data.MakeInParam("@FamilyZip", SqlDbType.VarChar, 50, clinkman.FamilyZip), data.MakeInParam("@Mobile", SqlDbType.VarChar, 100, clinkman.Mobile), data.MakeInParam("@FamilyTelephone", SqlDbType.VarChar, 100, clinkman.FamilyTelephone), data.MakeInParam("@Memo", SqlDbType.VarChar, 1000, clinkman.Memo), data.MakeInParam("@Staffid", SqlDbType.Int, 4, staffid), data.MakeInParam("@Age", SqlDbType.VarChar, 50, clinkman.Age) }; result = data.RunProc("sp_Linkman_AddCustomLinkman", prams); if (clinkman.Type.IndexOf(',', 0) != -1) { string [] arrtype = clinkman.Type.Split(','); for (int i = 0; i < arrtype.Length; i++) { if (arrtype[i].Trim() != "") { SqlParameter[] prams1 = { data.MakeInParam("@typeid", SqlDbType.Int, 4, arrtype[i]), data.MakeInParam("@id", SqlDbType.Int, 4, result) }; data.RunProc("sp_Linkman_AddCustomLinkmanType", prams1); } } } return(result); }
/// <summary> /// �Ľ�ɫ��Ϣ /// </summary> /// <param name="roleid">��ɫID</param> /// <param name="rolename">��ɫ����</param> /// <param name="roledescription">��ɫ����</param> /// <returns>����ֵ��0�ɹ�1���ɹ���</returns> public static int Modify(int roleid,string rolename,string roledescription) { UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@role_id",SqlDbType.Int ,4,roleid), db.MakeInParam("@role_name",SqlDbType.VarChar,300,rolename.Trim()), db.MakeInParam("@role_description",SqlDbType.VarChar,300,roledescription.Trim()) }; return(db.RunProc("sp_UpdateRoleInfo",prams)); }
public SqlDataReader GetCustomLinkmanType(int id) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@id",SqlDbType.Int,4,id) }; SqlDataReader dr = null; data.RunProc("sp_Linkman_GetCustomLinkmanTypeByCustomLinkmanID",prams,out dr); return(dr); }
public string GetRoleInfo(long RoleID,string FiledName) { UDS.Components.Database db = new UDS.Components.Database(); SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@RoleID",SqlDbType.Int ,4,RoleID), }; db.RunProc("sp_GetRoleInfo",prams,out dr); try { if(dr.Read()) { try { return dr[FiledName].ToString(); } catch { return ""; } } else return ""; } finally { if (db != null) { db.Close(); } if (dr != null) { dr.Close(); dr.Dispose(); } dr = null; db = null; } }
/// <summary> /// �õ��ҵ���ϵ�� /// </summary> /// <param name="type">��ϵ������(0:������ϵ��1:Ա����ϵ��2:�ͻ���ϵ��3:�Զ�����ϵ��)</param> /// <param name="staffid">�û�id</param> /// <returns></returns> public SqlDataReader GetMyLinkman(int type,int staffid) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@type",SqlDbType.Int,4,type), data.MakeInParam("@staffid",SqlDbType.Int,4,staffid) }; SqlDataReader dr = null; data.RunProc("sp_Linkman_GetList",prams,out dr); return(dr); }
/// <summary> /// ����Զ�����ϵ�� /// </summary> /// <param name="clinkman">CustomLinkman�ṹ</param> /// <returns>��ӵ�ID</returns> public int AddCustomLinkman(CustomLinkman clinkman,int staffid) { int result = 0; UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name), data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender), data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone), data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email), data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress), data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip), data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress), data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip), data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile), data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone), data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo), data.MakeInParam("@Staffid",SqlDbType.Int,4,staffid), data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age) }; result = data.RunProc("sp_Linkman_AddCustomLinkman",prams); if(clinkman.Type.IndexOf(',',0)!=-1) { string [] arrtype = clinkman.Type.Split(','); for(int i = 0;i<arrtype.Length;i++) { if(arrtype[i].Trim()!="") { SqlParameter[] prams1 = { data.MakeInParam("@typeid",SqlDbType.Int,4,arrtype[i]), data.MakeInParam("@id",SqlDbType.Int,4,result) }; data.RunProc("sp_Linkman_AddCustomLinkmanType",prams1); } } } return(result); }
/// <summary> /// �������Ƿ��Ѿ�����ϵ���б��� /// </summary> /// <param name="type">��ϵ������(0:������ϵ��1:Ա����ϵ��2:�ͻ���ϵ��3:�Զ�����ϵ��)</param> /// <param name="staffid">�û�id</param> /// <param name="id">��ϵ��id</param> /// <returns></returns> public bool HaveInList(int type,int staffid,int id) { UDS.Components.Database data = new UDS.Components.Database(); SqlParameter[] prams = { data.MakeInParam("@type",SqlDbType.Int,4,type), data.MakeInParam("@staffid",SqlDbType.Int,4,staffid), data.MakeInParam("@id",SqlDbType.Int,4,id) }; return((data.RunProc("sp_Linkman_HaveInList",prams)==1)?true:false); }
/// <summary> /// ����rolename�õ�roleid /// </summary> /// <param name="rolename">��ɫ����</param> /// <returns>��ɫid</returns> public static int GetRoleIDByName(string rolename) { UDS.Components.Database db = new UDS.Components.Database(); int roleid = 0; SqlDataReader dr = null; SqlParameter[] prams = { db.MakeInParam("@rolename",SqlDbType.VarChar,100,rolename), }; try { db.RunProc("sp_GetRoleIDFromName", prams, out dr); while (dr.Read()) { roleid = Int32.Parse(dr["role_id"].ToString()); } } finally { db.Close(); } return(roleid); }
private void btn_OK_Click(object sender, System.EventArgs e) { if (lbx_search.Items.Count > 0) { string searchstring = ""; string tmp = ""; DateTime begintime = new DateTime(); DateTime endtime = DateTime.Now; foreach (ListItem lt in lbx_search.Items) { string [] searcharr = new string[2]; searcharr = lt.Value.Split(':'); switch (searcharr[0].Trim()) { case "销售人员姓名": UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]); tmp = "UDS_CM_ClientContact.MarketmanID='"; while (dr_staffid.Read()) { tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientContact.MarketmanID='"; } dr_staffid.Close(); if (tmp == "UDS_CM_ContactInfo.MarketmanID='") { searchstring = "1=2"; } else { tmp = tmp.Substring(0, tmp.Length - 37); searchstring += "(" + tmp + ") and "; } break; case "客户名称": UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr_clientid = cm.GetClientIDByName(searcharr[1]); tmp = "UDS_CM_ClientContact.ClientID='"; while (dr_clientid.Read()) { tmp += dr_clientid["ID"] + "' or UDS_CM_ClientContact.ClientID='"; } dr_clientid.Close(); if (tmp == "UDS_CM_ClientContact.ClientID='") { searchstring = "1=2"; } else { tmp = tmp.Substring(0, tmp.Length - 34); searchstring += "(" + tmp + ") and "; } break; case "客户编号": searchstring += "UDS_CM_ClientContact.ClientID=" + searcharr[1] + " and "; break; case "销售阶段": switch (searcharr[1]) { case "跟踪": searchstring += "patindex('%trace%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "启动": searchstring += "patindex('%boot%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "产品推荐": searchstring += "patindex('%commend%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "需求定义": searchstring += "patindex('%requirement%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "方案提交": searchstring += "patindex('%submit%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "商务谈判": searchstring += "patindex('%negotiate%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "项目实施": searchstring += "patindex('%actualize%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "跟踪服务": searchstring += "patindex('%traceservice%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; case "收尾款": searchstring += "patindex('%last%',UDS_CM_ClientContact.curstatus)>=0" + " and "; break; } break; case "成交预估": searchstring += "UDS_CM_ClientContact.BargainPrognosis='" + searcharr[1] + "' and "; break; case "已接洽次数": searchstring += "UDS_CM_ClientContact.ContactTimes=" + searcharr[1] + " and "; break; case "接洽对象职务": searchstring += "UDS_CM_Linkman.[Position]='" + searcharr[1] + "' and "; break; case "首次接洽时间": searchstring += "UDS_CM_ClientInfo.FirstContactTime='" + searcharr[1] + "' and "; break; case "最后一次接洽时间": searchstring += "UDS_CM_ClientInfo.ContactTime='" + searcharr[1] + "' and "; break; case "下次约见时间": searchstring += "UDS_CM_ClientInfo.NextContactTime='" + searcharr[1] + "' and "; break; case "本周新增记录": //得到本周起始日(周一 -- 周日) begintime = DateTime.Now; switch ((int)DateTime.Now.DayOfWeek) { case 0: begintime = begintime.AddDays(-6); break; default: begintime = begintime.AddDays(1 - (int)DateTime.Now.DayOfWeek); break; } searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and "; break; case "本月新增记录": //得到本月起始日 begintime = DateTime.Now; begintime = begintime.AddDays(1 - DateTime.Now.Day); searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and "; break; } } searchstring = "select * from UDS_CM_ClientInfo where ID IN (select UDS_CM_ClientInfo.ID from UDS_CM_ClientContact left join UDS_CM_ClientContact_Linkman ON UDS_CM_ClientContact.ID=UDS_CM_ClientContact_Linkman.ContactID left join UDS_CM_Linkman ON UDS_CM_ClientContact_Linkman.LinkmanID=UDS_CM_ClientContact_Linkman.id,UDS_CM_ClientInfo where UDS_CM_ClientContact.clientid=UDS_CM_ClientInfo.id and " + searchstring; if (searchstring.EndsWith("and ")) { searchstring = searchstring.Substring(0, searchstring.Length - 4); } searchstring += " group by UDS_CM_ClientInfo.ID)"; DataSet ds = new DataSet(); UDS.Components.Staff staff1 = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff1.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); UDS.Components.Database db = new UDS.Components.Database(); SqlParameter[] prams = { db.MakeInParam("@SQL", SqlDbType.NText, 5000, searchstring) }; SqlDataReader dr = null; db.RunProc("sp_RunSql", prams, out dr); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "Client"; ds.Tables.Add(dt); ltl_Client.Text = dt.Rows.Count.ToString(); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); dgrd_ContactList.DataSource = dt.DefaultView; dgrd_ContactList.DataBind(); } }