/// <summary> /// 删除单位信息 /// </summary> /// <param name="DeleteBM"></param> /// <returns></returns> public static bool DeleteDepart(string DeleteBM) { string strSql = string.Format("Delete From department Where BM_Name='{0}'", DeleteBM); DataService.DataService dCurService = new DataService.DataService(); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); if (bSuced) { strSql = string.Format("update USER_INFOR set group_name=' ' Where group_name='{0}'", DeleteBM); bSuced = dCurService.ExecOleSql(strSql); } return(bSuced); }
/// <summary> /// 删除用户 /// 需要继续做修改的地方 /// 1、模块权限表 /// 2、角色用户表 /// </summary> /// <param name="szUserCode"></param> /// <returns></returns> public static bool DeleteUser(string szUserCode, out string strErrInfo) { strErrInfo = ""; strErrInfo = "已成功将该用户删除"; string strSql = string.Format("Delete From user_infor Where User_Name='{0}'", szUserCode); DataService.DataService dCurService = new DataService.DataService(); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); strSql = string.Format("Delete From user_role Where UserName='******'", szUserCode); bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }
/// <summary> /// 注册新的用户 /// </summary> /// <param name="szUserCode">用户代码</param> /// <param name="szUserName">用户姓名</param> /// <param name="szCreator">创建者</param> /// <param name="szDepID">归属部门</param> /// <param name="szDescription">用户描述</param> /// <param name="szInitMap">起始地图</param> /// <returns></returns> public static bool RegisterUser(long szUserCode, string szUserName, string szPWD, string szPhone, string szEmail, string szUserDep, string szUserDesc) { string strSql = string.Format("insert into USER_INFOR (USER_ID,USER_NAME,PAS,PHONE_NUMBER,EMAIL,GROUP_NAME,BZ) values({0},'{1}','{2}','{3}','{4}','{5}','{6}')", szUserCode, szUserName, szPWD, szPhone, szEmail, szUserDep, szUserDesc); DataService.DataService dCurService = new DataService.DataService(); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }
public static bool insertSBWD(string SB_ID, string wdm, string scsj, string bz, string wdlx) { DataService.DataService dCurService = new DataService.DataService(); string strSql = string.Format("INSERT INTO [SBWD] ([SB_ID], [文档名], [上传时间], [备注], [类型]) VALUES ('{0}','{1}','{2}','{3}','{4}') ", SB_ID, wdm, scsj, bz, wdlx); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }
/// <summary> /// 添加设备信息 /// </summary> /// <param name="SB_NAME"></param> /// <param name="SB_ID"></param> /// <param name="BM_NAME"></param> /// <param name="SB_ZT"></param> /// <param name="SB_XH"></param> /// <param name="SB_ZZS"></param> /// <param name="SB_ZJID"></param> /// <param name="SB_ZJNAME"></param> /// <param name="SB_BZ"></param> /// <param name="SB_CCID"></param> /// <param name="SB_PIC"></param> /// <param name="SB_WZ"></param> /// <param name="SB_NF"></param> /// <param name="SB_FZR"></param> /// <returns></returns> public static bool insertSB(string SB_NAME, string SB_ID, string BM_NAME, string SB_ZT, string SB_XH, string SB_ZZS, string SB_ZJID, string SB_ZJNAME, string SB_BZ, string SB_CCID, string SB_PIC, string SB_WZ, string SB_NF, string SB_FZR) { DataService.DataService dCurService = new DataService.DataService(); string strSql = string.Format("insert into SB_INFOR (SB_NAME, SB_ID,BM_NAME,SB_ZT, SB_XH, SB_ZZS, SB_ZJID,SB_ZJNAME, SB_BZ, SB_CCID, SB_PIC, SB_WZ, SB_NF,SB_FZR) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}') ", SB_NAME, SB_ID, BM_NAME, SB_ZT, SB_XH, SB_ZZS, SB_ZJID, SB_ZJNAME, SB_BZ, SB_CCID, SB_PIC, SB_WZ, SB_NF, SB_FZR); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }
/// <summary> /// 修改设备信息 /// </summary> /// <param name="SB_ID"></param> /// <param name="JXNR"></param> /// <param name="JXJG"></param> /// <param name="JXFY"></param> /// <param name="BYNR"></param> /// <param name="BYFY"></param> /// <param name="BYJG"></param> /// <param name="date_by1"></param> /// <param name="date_by2"></param> /// <returns></returns> public static bool CHANGSBXX(string SB_NAME, string SB_ID, string BM_NAME, string SB_ZT, string SB_XH, string SB_ZZS, string SB_ZJID, string SB_ZJNAME, string SB_BZ, string SB_CCID, string SB_PIC, string SB_WZ, string SB_NF, string SB_FZR) { DataService.DataService dCurService = new DataService.DataService(); string strSql = string.Format("update SB_INFOR SET SB_NAME='{0}',BM_NAME='{2}',SB_ZT='{3}', SB_XH='{4}', SB_ZZS='{5}', SB_ZJID='{6}',SB_ZJNAME='{7}', SB_BZ='{8}', SB_CCID='{9}', SB_PIC='{10}', SB_WZ='{11}', SB_NF='{12}',SB_FZR='{13}' Where SB_ID='{1}'", SB_NAME, SB_ID, BM_NAME, SB_ZT, SB_XH, SB_ZZS, SB_ZJID, SB_ZJNAME, SB_BZ, SB_CCID, SB_PIC, SB_WZ, SB_NF, SB_FZR); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }
/// <summary> /// 管理员更新用户信息 /// 如果部门信息不是临时部门的话就将用户解除锁定 /// 如果部门信息是临时部门的话将用户锁定 /// </summary> /// <param name="szUserName"></param> /// <param name="szPassword"></param> /// <param name="szDescription"></param> /// <param name="szCreator"></param> /// <param name="szCreateDate"></param> /// <param name="szMAC"></param> /// <param name="szDepment"></param> /// <param name="szIninNavMap"></param> /// <returns></returns> public static bool UpdateUserInfo(string szUserName, string szPWD, string szPhone, string szEmail, string szUserDep, string szUserDesc, long szUserCode) { string strSql = string.Format("Update user_infor Set user_NAME='{0}',PAS='******',PHONE_NUMBER='{2}',EMAIL='{3}',group_name='{4}',bz='{5}' Where USER_id={6}", szUserName, szPWD, szPhone, szEmail, szUserDep, szUserDesc, szUserCode); DataService.DataService dCurService = new DataService.DataService(); bool bSuced = false; bSuced = dCurService.ExecOleSql(strSql); return(bSuced); }