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