/// <summary>
/// 根据账号Id得到可以查看的车辆信息
/// </summary>
/// <param name="nAccountId"></param>
/// <returns></returns>
public static DataTable GetAccountVehicel(USER_SHARE_ACCOUNTMODEL account)
{
string strSql = string.Empty;
if (!(account.ISADMIN == 1))
{
strSql = string.Format(@" SELECT RTRIM(LTRIM(ROLEIDS,','),',') FROM USER_SHARE_ACCOUNT WHERE
ACCOUNTID={0} AND COMPANYID={1} AND STATUS={2} ", account.ACCOUNTID, account.COMPANYID,
ShareEnum.AccountStatus.Normal.ToString("d"));
string roleids = CommonMethod.FinalString(StaticConnectionProvider.ExecuteScalar(strSql));
if (roleids.Length > 0)
{
strSql = string.Format(@"SELECT * FROM USER_SHARE_VEHICLE_GROUP WHERE SHAREGROUPID IN(
SELECT DISTINCT(SHAREGROUPID) FROM USER_SHARE_ROLE_GROUP WHERE ROLEID IN({0})
)", roleids);
}
else
{
return(null);
}
}
else
{
strSql = string.Format(@"SELECT * FROM USER_SHARE_VEHICLE_GROUP WHERE SHAREGROUPID IN(
SELECT ID FROM USER_SHARE_GROUP WHERE COMPANYCODE={0}
AND STATE={1} )", account.COMPANYID, ShareEnum.CompanyGroupStatus.Normal.ToString("d"));
}
return(StaticConnectionProvider.ExecuteDataTable(strSql));
}
private void LoadNavigation()
{
#region 导航信息
NavigationMenu.Items.Clear();
int nCompanyId = ((BasePage)this.Page).CompanyId;
int nAccountId = ((BasePage)this.Page).AccountId;
int nSysProjectId = ValidatorHelper.ToInt(CommonMethod.GetConfigValue("SYSPROJECTID"), 1);
int nSysCompanyId = ValidatorHelper.ToInt(CommonMethod.GetConfigValue("SYSCOMPANYID"), 1);
USER_SHARE_ACCOUNTMODEL account = AccountBusiness.GetAccountModel(nAccountId);
DataTable dt = CompanyFunBusiness.GetAccountFunMenu(nAccountId, account.ISADMIN, nSysProjectId, nCompanyId);
if (dt != null)
{
DataRow[] rows = dt.Select("PROJECTID=" + nSysProjectId, "");
divNavigation.Visible = nAccountId > 0 && rows.Length > 0;
MenuItem menu = null;
foreach (DataRow dr in rows)
{
menu = new MenuItem();
menu.Text = CommonMethod.FinalString(dr["CFANOTHERNAME"]);
menu.NavigateUrl = ResolveUrl("~/" + CommonMethod.FinalString(dr["CFPAGEURL"]));
menu.ToolTip = CommonMethod.FinalString(dr["CFDESC"]);
NavigationMenu.Items.Add(menu);
}
}
else
{
((BasePage)this.Page).Alert("您没有此系统权限！");
Response.Redirect(ResolveUrl("~/Login.aspx"));
}
#endregion
#region 欢迎信息
if (this.Page is BasePage && ((BasePage)this.Page).AccountId > 0)
{
lblCompany.Text = ((BasePage)this.Page).CompanyName;
lblWelcome.Text = string.Format("欢迎您，<span class=\"bold\">{0}</span> ", ((BasePage)this.Page).RealName);
lblWelcome.Visible = true;
lnkLogOut.Visible = true;
}
else
{
lblWelcome.Visible = false;
lnkLogOut.Visible = false;
}
#endregion
}
/// <summary>
/// 是否存在该记录
/// </summary>
public static USER_SHARE_ACCOUNTMODEL GetAccountModel(string strAccountName, string strCompanyCode)
{
string strSql = "select * from USER_SHARE_ACCOUNT where ACCOUNTNAME=:ACCOUNTNAME AND COMPANYID=:COMPANYID AND STATUS!=:STATUS ";
ParamList param = new ParamList();
param["ACCOUNTNAME"] = strAccountName;
param["COMPANYID"] = strCompanyCode;
param["STATUS"] = ShareEnum.AccountStatus.Del.ToString("d");
USER_SHARE_ACCOUNTMODEL model = null;
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSql.ToString(), param);
if (dt != null && dt.Rows.Count > 0)
{
model = ReaderBind(dt.Rows[0]);
}
return(model);
}
/// <summary>
/// 判断账号名是否重复
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string ValidateAccountName(HttpContext context)
{
string strResult = string.Empty;
string strAccountName = GlobalObject.unescape(context.Request.QueryString["AccountName"]);
int nAccountId = ValidatorHelper.ToInt(context.Request.QueryString["AccountId"], 0);
string strCompanyCode = context.Request.QueryString["CompanyCode"];
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(strAccountName, strCompanyCode);
if (accountModel != null)
{
// 新增时，存在证明重复，修改时 判断与自身之外的记录重复才算重复
strResult = (nAccountId == 0 || (nAccountId > 0 && accountModel.ACCOUNTID != nAccountId)) ? "1" : "0";
}
else
{
strResult = "0";
}
return(strResult);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
private static USER_SHARE_ACCOUNTMODEL ReaderBind(DataRow dataReader)
{
USER_SHARE_ACCOUNTMODEL model = new USER_SHARE_ACCOUNTMODEL();
model.ACCOUNTID = ValidatorHelper.ToInt(dataReader["ACCOUNTID"], 0);
model.ACCOUNTNAME = ValidatorHelper.FinalString(dataReader["ACCOUNTNAME"]);
model.COMPANYID = ValidatorHelper.ToInt(dataReader["COMPANYID"], 0);
model.ACCOUNTPWD = ValidatorHelper.FinalString(dataReader["ACCOUNTPWD"]);
model.ORIGNALPWD = ValidatorHelper.FinalString(dataReader["ORIGNALPWD"]);
model.REALNAME = ValidatorHelper.FinalString(dataReader["REALNAME"]);
model.EMAIL = ValidatorHelper.FinalString(dataReader["EMAIL"]);
model.ROLEIDS = ValidatorHelper.FinalString(dataReader["ROLEIDS"]);
model.LINKPHONE = ValidatorHelper.FinalString(dataReader["LINKPHONE"]);
model.CREATEDATE = ValidatorHelper.ToDateTime(dataReader["CREATEDATE"], DateTime.Now);
model.CREATORID = ValidatorHelper.ToInt(dataReader["CREATORID"], 0);
model.ISADMIN = ValidatorHelper.ToInt(dataReader["ISADMIN"], 0);
model.STATUS = ValidatorHelper.ToInt(dataReader["Status"], 0);
return(model);
}
/// <summary>
/// 获取账号信息
/// </summary>
/// <param name="nAccountId"></param>
/// <returns></returns>
public static USER_SHARE_ACCOUNTMODEL GetAccountModel(int nAccountId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ACCOUNTID,ACCOUNTNAME,COMPANYID,ACCOUNTPWD,ORIGNALPWD,REALNAME,EMAIL,ROLEIDS,LINKPHONE,CREATEDATE,CREATORID,ISADMIN,STATUS from USER_SHARE_ACCOUNT ");
strSql.Append(" where ACCOUNTID=:ACCOUNTID AND STATUS!=:STATUS ");
ParamList param = new ParamList();
param["ACCOUNTID"] = nAccountId;
param["STATUS"] = ShareEnum.AccountStatus.Del.ToString("d");
USER_SHARE_ACCOUNTMODEL model = null;
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSql.ToString(), param);
if (dt != null && dt.Rows.Count > 0)
{
model = ReaderBind(dt.Rows[0]);
}
return(model);
}
private void InitPage()
{
//账号状态
ControlHelper.ListContolDataBindFromEnum(rbtAccountStatus, typeof(ShareEnum.AccountStatus), "", "", ShareEnum.AccountStatus.Normal.ToString("d"));
rbtAccountStatus.Items.Remove(rbtAccountStatus.Items.FindByValue(ShareEnum.AccountStatus.Del.ToString("d")));
//账号Id
hidAccountId.Value = PageAccountId.ToString();
string strRoleIds = string.Empty;
hidCompanyCode.Value = CompanyCode.ToString();
if (PageAccountId > 0)//修改页面
{
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(PageAccountId);
if (accountModel != null)
{
txtAccountName.Text = accountModel.ACCOUNTNAME;
txtRealName.Text = accountModel.REALNAME;
txtPwd.Attributes["value"] = accountModel.ORIGNALPWD;
txtPwd2.Attributes["value"] = accountModel.ORIGNALPWD;
txtLinkPhone.Text = CommonMethod.FinalString(accountModel.LINKPHONE);
hidEmail.Value = CommonMethod.FinalString(accountModel.EMAIL);
hidCompanyCode.Value = accountModel.COMPANYID.ToString();
ControlHelper.SelectFlg(rbtAccountStatus, accountModel.STATUS.ToString());
strRoleIds = CommonMethod.FinalString(accountModel.ROLEIDS);
}
else
{
Response.Write("不存在的账号信息！");
Response.End();
}
}
#region 角色
if (!IsInit)
{
DataTable dtProjects = CompanyBusiness.GetCompanyProjects(CompanyCode.ToString());
DataTable dtRoles = RoleBusiness.GetAccountRoleList(" AND R.COMPANYID=" + CompanyId);
if (dtProjects != null && dtProjects.Rows.Count > 0 && dtRoles != null)
{
StringBuilder sbContent = new StringBuilder("");
foreach (DataRow dr in dtProjects.Rows)
{
sbContent.Append("<table class=\"table\" style=\"float:left; width:33%; margin-left:3px;\">");
sbContent.AppendFormat("<tr><td class='rhead' style=\"text-align:left;background-image: url('../../Resource/images/searchthead.gif');\" >{0}</td></tr>", dr["ProjectName"]);
DataRow[] drRoles = dtRoles.Select("PROJECTID=" + dr["PROJECTID"], " ROLEID ASC ");
foreach (DataRow drRole in drRoles)
{
sbContent.AppendFormat("<tr><td><input type='checkbox' name='role' id='{0}' value='{0}' {2} />{1}</td></tr>",
drRole["ROLEID"], drRole["ROLENAME"], strRoleIds.IndexOf("," + drRole["ROLEID"] + ",") >= 0 ? "checked='checked'" : "");
}
sbContent.Append("</table>");
}
tdRoles.InnerHtml = sbContent.ToString();
}
}
else
{
trRoles.Visible = false;
hidCompanyCode.Value = Enc.Decrypt(CommonMethod.FinalString(Request.QueryString["code"]), UrlEncKey);
}
#endregion
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 务端验证
if (txtAccountName.Text.Trim().Length == 0)
{
Alert("请输入账号名称！");
Select(txtAccountName);
return;
}
if (txtRealName.Text.Trim().Length == 0)
{
Alert("请输入真实姓名！");
Select(txtRealName);
return;
}
if (txtPwd.Text.Trim().Length == 0)
{
Alert("请输入登录密码！");
Select(txtPwd);
return;
}
if (txtPwd2.Text.Trim().Length == 0)
{
Alert("请确认登录密码！");
Select(txtPwd2);
return;
}
if (!txtPwd.Text.Trim().Equals(txtPwd2.Text.Trim()))
{
Alert("两次输入密码不一致！");
Select(txtPwd2);
return;
}
if (txtEmail.Text.Trim().Length == 0)
{
Alert("请输入邮箱！");
Select(txtEmail);
return;
}
string strRoles = CommonMethod.FinalString(Request.Form["role"]);
if (strRoles.Length > 0)
{
strRoles = "," + strRoles + ",";
}
#endregion
#region 账号信息保存
USER_SHARE_ACCOUNTMODEL accountModel = null;
int nCompanyCode = IsInit ? ValidatorHelper.ToInt(Enc.Decrypt(Request.QueryString["code"], UrlEncKey), 0) : CompanyCode;
//日志信息
USER_SHARE_LOGMODEL logModel = new USER_SHARE_LOGMODEL();
logModel.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
logModel.OPERATEDATE = DateTime.Now;
logModel.OPERATORID = AccountId;
logModel.PROJECTID = ProjectId;
logModel.COMPANYID = CompanyId;
if (PageAccountId > 0)
{
accountModel = AccountBusiness.GetAccountModel(PageAccountId);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditAccount.ToString("d"));
logModel.OPERATECONTENT = string.Format("修改账号信息，修改后账号名称：{0}，公司编码：{1}，账号Id:{2} ", txtAccountName.Text.Trim(), CompanyCode, PageAccountId);
}
else
{
accountModel = new USER_SHARE_ACCOUNTMODEL();
accountModel.ACCOUNTID = CommonBusiness.GetSeqID("S_USER_SHARE_ACCOUNT");
accountModel.COMPANYID = nCompanyCode;
accountModel.CREATORID = AccountId;
if (IsInit)
{
accountModel.ISADMIN = 1;
}
accountModel.CREATEDATE = DateTime.Now;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddAccount.ToString("d"));
logModel.OPERATECONTENT = string.Format("新增账号信息，账号名称：{0}，公司ID：{1} ", txtAccountName.Text.Trim(), accountModel.COMPANYID);
}
accountModel.ACCOUNTNAME = txtAccountName.Text.Trim();
accountModel.REALNAME = txtRealName.Text.Trim();
accountModel.ORIGNALPWD = txtPwd.Text.Trim();
accountModel.ACCOUNTPWD = Enc.Encrypt(txtPwd.Text.Trim(), nCompanyCode.ToString().PadLeft(8, '0'));
accountModel.LINKPHONE = txtLinkPhone.Text.Trim();
accountModel.EMAIL = txtEmail.Text.Trim();
accountModel.ROLEIDS = strRoles;
accountModel.STATUS = ValidatorHelper.ToInt(rbtAccountStatus.SelectedValue, 0);
bool blSuccess = false;
if (PageAccountId == 0)
{
blSuccess = AccountBusiness.AddAccount(accountModel, logModel);
}
else
{
blSuccess = AccountBusiness.EditAccount(accountModel, logModel);
}
Alert((PageAccountId > 0 ? "修改" : "新增") + "账号" + (blSuccess ? "成功" : "失败，请重试！"));
ExecScript("parent.__doPostBack('ctl00$MainContent$btnSearch','');");
#endregion
}
/// <summary>
/// 获取TMS项目的公司账号信息
/// </summary>
/// <param name="context"></param>
/// <param name="xmlDoc"></param>
/// <param name="sResponse"></param>
private void GetAccounts(HttpContext context, XmlDocument xmlDoc, ServiceResponse sResponse)
{
XmlNode xnAccountName = xmlDoc.SelectSingleNode("request/accountname");
XmlNode xnAccountPwd = xmlDoc.SelectSingleNode("request/accountpwd");
XmlNode xnCompanyCode = xmlDoc.SelectSingleNode("request/companyid");
if (CommonMethod.FinalString(xnAccountName.InnerText).Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountname";
return;
}
if (CommonMethod.FinalString(xnAccountPwd.InnerText).Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountpwd";
return;
}
if (CommonMethod.FinalString(xnCompanyCode.InnerText).Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数companyid";
return;
}
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(xnCompanyCode.InnerText.Trim(), xnAccountName.InnerText.Trim(), xnAccountPwd.InnerText.Trim());
if (accountModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidUser;
sResponse.ErrorDesc = "用户名和密码不匹配";
return;
}
if (accountModel.STATUS != int.Parse(ShareEnum.AccountStatus.Normal.ToString("d")))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidUser;
sResponse.ErrorDesc = "此用户已停用";
return;
}
USER_SHARE_COMPANYRELATEMODEL companyModel = CompanyBusiness.GetModel(accountModel.COMPANYID);
//不存在公司信息或 公司编码和传入的编码不一致
if (companyModel == null || companyModel.COMPANYCODE.ToString() != xnCompanyCode.InnerText.Trim())
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.CompanyNotMatchAccount;
sResponse.ErrorDesc = "公司信息和账号信息不匹配";
return;
}
if (companyModel.STATUS != int.Parse(ShareEnum.CompanyRelateStatus.Normal.ToString("d")))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.CompanyStopUse;
sResponse.ErrorDesc = "此公司已停用";
return;
}
//获取账号信息
string strWhere = string.Format(" AND COMPANYID={0} ", xnCompanyCode.InnerText.Trim());
strWhere += string.Format(" AND STATUS={0} ", ShareEnum.AccountStatus.Normal.ToString("d"));
int count = 0;
DataTable dt = AccountBusiness.GetAccountList(0, int.MaxValue, strWhere, out count);
StringBuilder sbContent = new StringBuilder("<accounts>");
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sbContent.AppendFormat(@"<accountitem><accountname>{0}</accountname><accountpwd>{1}</accountpwd>
<truename>{2}</truename><isadmin>{3}</isadmin></accountitem> ",
dr["ACCOUNTNAME"], dr["ACCOUNTPWD"], dr["REALNAME"], dr["ISADMIN"]);
}
}
sbContent.Append("</accounts>");
sResponse.Result = sbContent.ToString();
}
/// <summary>
/// 危险品，运管项目公司和账号自动注册接口(临时用)
/// </summary>
/// <param name="context"></param>
/// <param name="xmlDoc"></param>
/// <param name="sResponse"></param>
private void AutoRegister(HttpContext context, XmlDocument xmlDoc, ServiceResponse sResponse)
{
//传入参数验证
XmlNode xnCompanyType = xmlDoc.SelectSingleNode("request/companytype");
XmlNode xnCompanyName = xmlDoc.SelectSingleNode("request/companyname");
XmlNode xnGroupId = xmlDoc.SelectSingleNode("request/groupid");
XmlNode xnGroupIdn = xmlDoc.SelectSingleNode("request/groupidn");
XmlNode xnAccountName = xmlDoc.SelectSingleNode("request/accountname");
XmlNode xnAccountPwd = xmlDoc.SelectSingleNode("request/accountpwd");
XmlNode xnRealName = xmlDoc.SelectSingleNode("request/realname");
if (xnCompanyType == null || xnCompanyType.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数companytype";
return;
}
if (xnCompanyName == null || xnCompanyName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数companyname";
return;
}
if (xnGroupId == null || xnGroupId.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数groupid";
return;
}
if (xnGroupIdn == null || xnGroupIdn.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数groupidn";
return;
}
if (xnAccountName == null || xnAccountName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountname";
return;
}
if (xnAccountPwd == null || xnAccountPwd.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountpwd";
return;
}
if (xnRealName == null || xnRealName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数realname";
return;
}
int ntype = 0;
string projectids = "";
string productids = "";
switch (xnCompanyType.InnerText.Trim())
{
//危险品运输
case "0":
ntype = int.Parse(ShareEnum.CompanyType.PlatCompany.ToString("d"));
projectids = ",1,21,"; //开通项目，危险品整合 和权限系统
productids = ",15,2,"; //权限系统维护和危险品运输
break;
//运管平台
case "2":
ntype = int.Parse(ShareEnum.CompanyType.YgCompany.ToString("d"));
projectids = ",1,"; //开通项目，危险品整合 和权限系统
productids = ",15,"; //权限系统维护
break;
default:
return;
}
int ncode = CompanyBusiness.IsCompanyExists(xnCompanyName.InnerText.Trim(), xnGroupId.InnerText.Trim(), ntype);
int companyid = PlatFormBusiness.GetYgCompanyId(xnCompanyName.InnerText.Trim());
if (ncode > 0)
{
//判断账号是否存在
USER_SHARE_ACCOUNTMODEL accountModel1 = AccountBusiness.GetAccountModel(xnAccountName.InnerText.Trim(), ncode.ToString());
if (accountModel1 != null)
{
//已存在的账号，判断密码是否改动，如果改动，更新密码
if (accountModel1.ORIGNALPWD.Trim() != xnAccountPwd.InnerText.Trim())
{
accountModel1.ORIGNALPWD = xnAccountPwd.InnerText.Trim();
accountModel1.ACCOUNTPWD = Enc.Encrypt(xnAccountPwd.InnerText.Trim(), ncode.ToString().PadLeft(8, '0'));
//日志信息
USER_SHARE_LOGMODEL logModele = new USER_SHARE_LOGMODEL();
logModele.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
logModele.OPERATEDATE = DateTime.Now;
logModele.OPERATORID = 0;
logModele.PROJECTID = 21;
logModele.COMPANYID = ncode;
logModele.OPERATETYPE = int.Parse(ShareEnum.LogType.EditAccount.ToString("d"));
logModele.OPERATECONTENT = string.Format("通过自动注册接口更改账号密码，账号名称：{0}，公司ID：{1} ", xnAccountName.InnerText.Trim(), accountModel1.COMPANYID);
AccountBusiness.EditAccount(accountModel1, logModele);
}
//之前遗漏了公司Id ,已经注册过的，公司 Id更新进去
if (companyid > 0)
{
CompanyBusiness.UpdateRelateCompanyId(companyid, ncode);
}
return;
}
}
else
{
//公司注册 产品开通
USER_SHARE_COMPANYRELATEMODEL uscrModel = new USER_SHARE_COMPANYRELATEMODEL();
ncode = CompanyBusiness.GetCompanyCode();
uscrModel.CID = CommonBusiness.GetSeqID("S_USER_SHARE_COMPANYRELATE");
uscrModel.COMPANYID = companyid;
uscrModel.COMPANYTYPE = ntype;
uscrModel.COMPANYNAME = xnCompanyName.InnerText.Trim();
uscrModel.STATUS = int.Parse(ShareEnum.CompanyRelateStatus.Normal.ToString("d"));
uscrModel.GROUPID = xnGroupId.InnerText.Trim();
uscrModel.GROUPIDN = xnGroupIdn.InnerText.Trim();
uscrModel.PROJECTIDS = projectids; //开通项目
uscrModel.PRODUCTIDS = productids; //开通产品
uscrModel.CREATEDATE = DateTime.Now;
uscrModel.COMPANYCODE = ncode;
//日志记录
USER_SHARE_LOGMODEL logModel = new USER_SHARE_LOGMODEL();
logModel.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
logModel.OPERATEDATE = DateTime.Now;
logModel.OPERATORID = 0;
logModel.PROJECTID = 21;
logModel.COMPANYID = ncode;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddCompanyRelate.ToString("d"));
logModel.OPERATECONTENT = "通过接口新增公司注册信息,公司名称:" + uscrModel.COMPANYNAME;
CompanyBusiness.AddCompanyRelate(uscrModel, logModel);
}
//账号信息
USER_SHARE_ACCOUNTMODEL accountModel = new USER_SHARE_ACCOUNTMODEL();
accountModel.ACCOUNTID = CommonBusiness.GetSeqID("S_USER_SHARE_ACCOUNT");
accountModel.ACCOUNTNAME = xnAccountName.InnerText.Trim();
accountModel.ACCOUNTPWD = Enc.Encrypt(xnAccountPwd.InnerText.Trim(), ncode.ToString().PadLeft(8, '0'));
accountModel.COMPANYID = ncode;
accountModel.ORIGNALPWD = xnAccountPwd.InnerText.Trim();
accountModel.CREATEDATE = DateTime.Now;
accountModel.REALNAME = xnRealName.InnerText.Trim();
accountModel.EMAIL = "";
accountModel.STATUS = int.Parse(ShareEnum.AccountStatus.Normal.ToString("d"));
accountModel.ISADMIN = 0;
accountModel.CREATORID = 0;
//日志信息
USER_SHARE_LOGMODEL logModel2 = new USER_SHARE_LOGMODEL();
logModel2.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
logModel2.OPERATEDATE = DateTime.Now;
logModel2.OPERATORID = 0;
logModel2.PROJECTID = 21;
logModel2.COMPANYID = ncode;
logModel2.OPERATETYPE = int.Parse(ShareEnum.LogType.AddAccount.ToString("d"));
logModel2.OPERATECONTENT = string.Format("通过公司自动注册接口注册公司后新增账号信息，账号名称：{0}，公司ID：{1} ", xnAccountName.InnerText.Trim(), accountModel.COMPANYID);
AccountBusiness.AddAccount(accountModel, logModel2);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="context"></param>
/// <param name="xmlDoc"></param>
/// <param name="sResponse"></param>
private void EditAccountPwd(HttpContext context, XmlDocument xmlDoc, ServiceResponse sResponse)
{
XmlNode xnKey = xmlDoc.SelectSingleNode("request/appkey");
XmlNode xnAccountId = xmlDoc.SelectSingleNode("request/accountid");
XmlNode xnOldPwd = xmlDoc.SelectSingleNode("request/oldpwd");
XmlNode xnNewPwd = xmlDoc.SelectSingleNode("request/newpwd");
USER_SHARE_PROJECTMODEL projectModel = ProjectBusiness.GetProjectModelByKey(xnKey.InnerText.Trim());
if (projectModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.KeyErr;
sResponse.ErrorDesc = "不存在的密钥KEY";
return;
}
else
{
//oldpwd参数验证
if (xnOldPwd == null || xnOldPwd.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数oldpwd";
return;
}
//newpwd参数验证
if (xnNewPwd == null || xnNewPwd.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数oldpwd";
return;
}
//账号Id
int nAccountId = ValidatorHelper.ToInt(xnAccountId.InnerText.Trim(), 0);
//accountid参数验证
if (xnAccountId == null || nAccountId <= 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountid";
return;
}
string strAppKey = xnKey.InnerText.Trim();
string strPwd = xnNewPwd.InnerText.Trim();
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(nAccountId);
if (accountModel == null || accountModel.ACCOUNTPWD != xnOldPwd.InnerText.Trim())
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.OldPassUnCorrect;
sResponse.ErrorDesc = "旧密码不正确";
return;
}
USER_SHARE_COMPANYRELATEMODEL companyModel = CompanyBusiness.GetModel(accountModel.COMPANYID);
if (companyModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.CompanyNotMatchAccount;
sResponse.ErrorDesc = "公司信息和账号信息不匹配";
return;
}
//得到原始密码
string strOrignalPwd = Enc.Decrypt(strPwd, companyModel.COMPANYCODE.ToString().PadLeft(8, '0'));
//更新账号密码
if (!AccountBusiness.UpdatePwd(accountModel.ACCOUNTID, strPwd, strOrignalPwd))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.ExceptionErr;
sResponse.ErrorDesc = "更改密码时出现并发错误，请重试！";
return;
}
}
}
/// <summary>
/// 账号登陆
/// </summary>
/// <param name="context"></param>
/// <param name="xmlDoc"></param>
/// <param name="sResponse"></param>
private void AccountLogin(HttpContext context, XmlDocument xmlDoc, ServiceResponse sResponse)
{
XmlNode xnKey = xmlDoc.SelectSingleNode("request/appkey");
XmlNode xnCompanyCode = xmlDoc.SelectSingleNode("request/companycode");
XmlNode xnAccountName = xmlDoc.SelectSingleNode("request/accountname");
XmlNode xnAccountPwd = xmlDoc.SelectSingleNode("request/accountpwd");
USER_SHARE_PROJECTMODEL projectModel = null;
//appkey参数验证
if (xnKey.InnerText.Trim().Length > 0)
{
projectModel = ProjectBusiness.GetProjectModelByKey(xnKey.InnerText.Trim());
if (projectModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.KeyErr;
sResponse.ErrorDesc = "不存在的密钥KEY";
context.Response.Write(sResponse.GetXML());
return;
}
else
{
//companycode参数验证
if (xnCompanyCode == null || xnCompanyCode.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数companycode";
return;
}
if (!CompanyBusiness.IsCompanyCodeExists(xnCompanyCode.InnerText.Trim()))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidCompanyCode;
sResponse.ErrorDesc = "不存在的公司编码信息";
return;
}
//accountpwd参数验证
if (xnAccountPwd == null || xnAccountPwd.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountpwd";
return;
}
//accountname参数验证
if (xnAccountName == null || xnAccountName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountname";
return;
}
string strAppKey = xnKey.InnerText.Trim();
string strCompanyCode = xnCompanyCode.InnerText.Trim();
string strAccountName = xnAccountName.InnerText.Trim();
string strPwd = xnAccountPwd.InnerText.Trim();
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(strCompanyCode, strAccountName, strPwd);
if (accountModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidUser;
sResponse.ErrorDesc = "用户名和密码不匹配";
return;
}
if (accountModel.STATUS != int.Parse(ShareEnum.AccountStatus.Normal.ToString("d")))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidUser;
sResponse.ErrorDesc = "此用户已停用";
return;
}
USER_SHARE_COMPANYRELATEMODEL companyModel = CompanyBusiness.GetModel(accountModel.COMPANYID);
//不存在公司信息或 公司编码和传入的编码不一致
if (companyModel == null || companyModel.COMPANYCODE.ToString() != strCompanyCode)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.CompanyNotMatchAccount;
sResponse.ErrorDesc = "公司信息和账号信息不匹配";
return;
}
if (companyModel.STATUS != int.Parse(ShareEnum.CompanyRelateStatus.Normal.ToString("d")))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.CompanyStopUse;
sResponse.ErrorDesc = "此公司已停用";
return;
}
StringBuilder sbContent = new StringBuilder();
sbContent.AppendFormat("<accountid>{0}</accountid>", accountModel.ACCOUNTID);
sbContent.AppendFormat("<truename>{0}</truename>", accountModel.REALNAME);
sbContent.AppendFormat("<companyid>{0}</companyid>", companyModel.COMPANYID);
sbContent.AppendFormat("<companyname>{0}</companyname>", companyModel.COMPANYNAME);
sbContent.AppendFormat("<sharecompanyid>{0}</sharecompanyid>", companyModel.SHARECOMPANYID);
sbContent.AppendFormat("<sharecompanyname>{0}</sharecompanyname>", companyModel.COMPANYNAME);
sbContent.AppendFormat("<productids>{0}</productids>", companyModel.PRODUCTIDS);
sbContent.AppendFormat("<groupid>{0}</groupid>", companyModel.GROUPID);
sbContent.AppendFormat("<groupname>{0}</groupname>", companyModel.COMPANYNAME);
sbContent.AppendFormat("<groupidn>{0}</groupidn>", companyModel.GROUPIDN);
sbContent.Append("<accountmenu>");
//账户拥有的菜单返回
DataTable dt = CompanyFunBusiness.GetAccountFunMenu(accountModel.ACCOUNTID, accountModel.ISADMIN, projectModel.PROJECTID, accountModel.COMPANYID);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sbContent.AppendFormat(@"<menuitem><menuid>{0}</menuid><name>{1}</name>
<linkurl>{2}</linkurl><parentid>{3}</parentid><sortnum>{4}</sortnum>
<desc>{5}</desc></menuitem>", dr["FMID"], dr["CFANOTHERNAME"],
dr["CFPAGEURL"], dr["CFPARENTID"], dr["CFSORTNUM"], dr["CFDESC"]);
}
}
sbContent.Append("</accountmenu>");
sResponse.Result = sbContent.ToString();
}
}
}
/// <summary>
/// 新开通账号
/// </summary>
/// <param name="context"></param>
/// <param name="xmlDoc"></param>
/// <param name="sResponse"></param>
private void AddAccount(HttpContext context, XmlDocument xmlDoc, ServiceResponse sResponse)
{
XmlNode xnKey = xmlDoc.SelectSingleNode("request/appkey");
XmlNode xnCompanyCode = xmlDoc.SelectSingleNode("request/companycode");
XmlNode xnAccountName = xmlDoc.SelectSingleNode("request/accountname");
XmlNode xnAccountPwd = xmlDoc.SelectSingleNode("request/accountpwd");
XmlNode xnRealName = xmlDoc.SelectSingleNode("request/realname");
XmlNode xnEmail = xmlDoc.SelectSingleNode("request/email");
XmlNode xnCreatorId = xmlDoc.SelectSingleNode("request/creatorid");
USER_SHARE_PROJECTMODEL projectModel = null;
//appkey参数验证
if (xnKey.InnerText.Trim().Length > 0)
{
projectModel = ProjectBusiness.GetProjectModelByKey(xnKey.InnerText.Trim());
if (projectModel == null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.KeyErr;
sResponse.ErrorDesc = "不存在的密钥KEY";
context.Response.Write(sResponse.GetXML());
return;
}
else
{
//companycode参数验证
if (xnCompanyCode == null || xnCompanyCode.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数companycode";
return;
}
if (!CompanyBusiness.IsCompanyCodeExists(xnCompanyCode.InnerText.Trim()))
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.UnValidCompanyCode;
sResponse.ErrorDesc = "不存在的公司编码信息";
return;
}
//accountpwd参数验证
if (xnAccountPwd == null || xnAccountPwd.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountpwd";
return;
}
//accountname参数验证
if (xnAccountName == null || xnAccountName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数accountname";
return;
}
//判断账号是否重复
USER_SHARE_ACCOUNTMODEL accountModel = AccountBusiness.GetAccountModel(xnAccountName.InnerText.Trim(), xnCompanyCode.InnerText.Trim());
if (accountModel != null)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.AccountNameExists;
sResponse.ErrorDesc = "已经存在此账号，请确认！";
return;
}
//realname参数验证
if (xnRealName == null || xnRealName.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数realname";
return;
}
//email参数验证
if (xnEmail == null || xnEmail.InnerText.Trim().Length == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数email";
return;
}
//creatorid参数验证
if (xnCreatorId == null || xnCreatorId.InnerText.Trim().Length == 0 || ValidatorHelper.ToInt(xnCreatorId.InnerText.Trim(), 0) == 0)
{
sResponse.ErrorType = ShareEnum.ApiResultStatus.InputParaErr;
sResponse.ErrorDesc = "缺少传入参数creatorid";
return;
}
//账号信息
accountModel = new USER_SHARE_ACCOUNTMODEL();
accountModel.ACCOUNTID = CommonBusiness.GetSeqID("S_USER_SHARE_ACCOUNT");
accountModel.ACCOUNTNAME = xnAccountName.InnerText.Trim();
accountModel.ACCOUNTPWD = xnAccountPwd.InnerText.Trim();
accountModel.COMPANYID = Convert.ToInt32(xnCompanyCode.InnerText.Trim());
accountModel.ORIGNALPWD = Enc.Decrypt(accountModel.ACCOUNTPWD, accountModel.COMPANYID.ToString().PadLeft(8, '0'));
accountModel.CREATEDATE = DateTime.Now;
accountModel.REALNAME = xnRealName.InnerText.Trim();
accountModel.EMAIL = xnEmail.InnerText.Trim();
accountModel.STATUS = int.Parse(ShareEnum.AccountStatus.Normal.ToString("d"));
accountModel.ISADMIN = 0;
accountModel.CREATORID = Convert.ToInt32(xnCreatorId.InnerText.Trim());
//日志信息
USER_SHARE_LOGMODEL logModel = new USER_SHARE_LOGMODEL();
logModel.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
logModel.OPERATEDATE = DateTime.Now;
logModel.OPERATORID = accountModel.CREATORID;
logModel.PROJECTID = projectModel.PROJECTID;
logModel.COMPANYID = accountModel.COMPANYID;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddAccount.ToString("d"));
logModel.OPERATECONTENT = string.Format("通过接口新增账号信息，账号名称：{0}，公司ID：{1} ", xnAccountName.InnerText.Trim(), accountModel.COMPANYID);
if (AccountBusiness.AddAccount(accountModel, logModel))
{
sResponse.Result = string.Format("<accountid>{0}</accountid>", accountModel.ACCOUNTID);
}
}
}
}
private void SysLogin(int nAccountId, string strAccount, string strPwd, string strAppKey, string strCompanyCode)
{
#region 登录
USER_SHARE_ACCOUNTMODEL account = null;
if (nAccountId > 0)
{
account = AccountBusiness.GetAccountModel(nAccountId);
}
else
{
account = AccountBusiness.GetAccountModel(strCompanyCode, strAccount, strPwd);
}
if (account == null)
{
Alert(nAccountId > 0 ? "不存在此账号!" : "用户名密码不匹配！");
return;
}
else
{
if (account.STATUS != int.Parse(ShareEnum.AccountStatus.Normal.ToString("d")))
{
Alert("此账号已无效，请确认！");
return;
}
USER_SHARE_PROJECTMODEL project = null;
if (strAppKey.Length > 0)
{
project = ProjectBusiness.GetProjectModelByKey(strAppKey);
if (project == null)
{
Alert("不存在的项目密钥，请确认！");
return;
}
if (project.STATUS == int.Parse(ShareEnum.ProjectStatus.StopUse.ToString("d")))
{
Alert("此项目已停用，请确认！");
return;
}
}
USER_SHARE_COMPANYRELATEMODEL company = CompanyBusiness.GetModel(account.COMPANYID);
if (company == null)
{
Alert("不存在的公司信息，请确认！");
return;
}
if (company.STATUS.ToString() == ShareEnum.CompanyRelateStatus.StopUse.ToString("d"))
{
Alert("此公司信息已无效，请确认！");
return;
}
if (company.COMPANYCODE.ToString() != strCompanyCode)
{
Alert("公司信息和账号信息不匹配");
return;
}
int nProjectId = ValidatorHelper.ToInt(CommonMethod.GetConfigValue("SYSPROJECTID"), 0);
HttpCookie ck = new HttpCookie("USP");
ck.Values.Add("AccountId", account.ACCOUNTID.ToString());
ck.Values.Add("RealName", Server.UrlEncode(account.REALNAME));
ck.Values.Add("ProjectId", project == null ? "0" : project.PROJECTID.ToString());
ck.Values.Add("CompanyId", account.COMPANYID.ToString());
ck.Values.Add("GroupId", CommonMethod.FinalString(company.GROUPID));
ck.Values.Add("CompanyName", Server.UrlEncode(company.COMPANYNAME));
ck.Values.Add("CompanyCode", company.COMPANYCODE.ToString());
Response.Cookies.Add(ck);
//由登录页面进入
if (strAppKey.Length == 0)
{
//公司编码记录到Cookie
HttpCookie ckCode = new HttpCookie("CompanyCode");
ckCode.Values.Add("CompanyCode", txtCompanyCode.Text.Trim());
Response.Cookies.Add(ckCode);
}
//获取菜单
DataTable dt = CompanyFunBusiness.GetAccountFunMenu(account.ACCOUNTID, account.ISADMIN, nProjectId, account.COMPANYID);
if (dt != null)
{
DataRow[] rows = dt.Select("PROJECTID=" + nProjectId, "");
if (rows != null && rows.Length > 0)
{
Response.Redirect(rows[0]["CFPAGEURL"].ToString());
}
else
{
Alert("您没有此系统权限！");
return;
}
}
else
{
Alert("您没有此系统权限！");
return;
}
}
#endregion
}
/// <summary>
/// 新增账号信息
/// </summary>
/// <param name="AccountModel"></param>
/// <returns></returns>
public static bool AddAccount(USER_SHARE_ACCOUNTMODEL AccountModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_ACCOUNT(");
strSql.Append("ACCOUNTID,ACCOUNTNAME,COMPANYID,ACCOUNTPWD,ORIGNALPWD,REALNAME,EMAIL,ROLEIDS,LINKPHONE,CREATEDATE,CREATORID,ISADMIN,STATUS)");
strSql.Append(" values (");
strSql.Append(":ACCOUNTID,:ACCOUNTNAME,:COMPANYID,:ACCOUNTPWD,:ORIGNALPWD,:REALNAME,:EMAIL,:ROLEIDS,:LINKPHONE,:CREATEDATE,:CREATORID,:ISADMIN,:STATUS)");
ParamList param = new ParamList();
param["ACCOUNTID"] = AccountModel.ACCOUNTID;
param["ACCOUNTNAME"] = AccountModel.ACCOUNTNAME;
param["COMPANYID"] = AccountModel.COMPANYID;
param["ACCOUNTPWD"] = AccountModel.ACCOUNTPWD;
param["ORIGNALPWD"] = AccountModel.ORIGNALPWD;
param["REALNAME"] = AccountModel.REALNAME;
param["EMAIL"] = AccountModel.EMAIL;
param["ROLEIDS"] = AccountModel.ROLEIDS;
param["LINKPHONE"] = AccountModel.LINKPHONE;
param["CREATEDATE"] = AccountModel.CREATEDATE;
param["CREATORID"] = AccountModel.CREATORID;
param["ISADMIN"] = AccountModel.ISADMIN;
param["STATUS"] = AccountModel.STATUS;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//增加账号信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
if (AccountModel.ISADMIN == 1)//初始账号时更新公司关联信息表
{
string strUpSql = string.Format("UPDATE USER_SHARE_COMPANYRELATE SET ADMINID={0} WHERE COMPANYCODE={1} ",
AccountModel.ACCOUNTID, AccountModel.COMPANYID);
connection.ExecuteNonQuery(strUpSql);
}
//操作日志
strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_LOG(");
strSql.Append("LOGID,OPERATETYPE,OPERATORID,PROJECTID,COMPANYID,OPERATECONTENT,OPERATEDATE)");
strSql.Append(" values (");
strSql.Append(":LOGID,:OPERATETYPE,:OPERATORID,:PROJECTID,:COMPANYID,:OPERATECONTENT,:OPERATEDATE)");
param["LOGID"] = log.LOGID;
param["OPERATETYPE"] = log.OPERATETYPE;
param["OPERATORID"] = log.OPERATORID;
param["PROJECTID"] = log.PROJECTID;
param["COMPANYID"] = log.COMPANYID;
param["OPERATECONTENT"] = log.OPERATECONTENT;
param["OPERATEDATE"] = log.OPERATEDATE;
connection.ExecuteNonQuery(strSql.ToString(), param);
connection.CommitTranscation();
blSuccess = true;
}
}
catch (Exception ex)
{
connection.RollbackTranscation();
LogHelper.WriteErr("新增账号信息时发生错误，账号名称：" + AccountModel.ACCOUNTNAME, ex);
}
return(blSuccess);
}
/// <summary>
/// 修改账号信息
/// </summary>
/// <param name="AccountModel"></param>
/// <returns></returns>
public static bool EditAccount(USER_SHARE_ACCOUNTMODEL AccountModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_ACCOUNT set ");
strSql.Append("ACCOUNTNAME=:ACCOUNTNAME,");
strSql.Append("COMPANYID=:COMPANYID,");
strSql.Append("ACCOUNTPWD=:ACCOUNTPWD,");
strSql.Append("ORIGNALPWD=:ORIGNALPWD,");
strSql.Append("REALNAME=:REALNAME,");
strSql.Append("EMAIL=:EMAIL,");
strSql.Append("ROLEIDS=:ROLEIDS,");
strSql.Append("LINKPHONE=:LINKPHONE,");
strSql.Append("CREATEDATE=:CREATEDATE,");
strSql.Append("CREATORID=:CREATORID,");
strSql.Append("ISADMIN=:ISADMIN,");
strSql.Append("STATUS=:STATUS");
strSql.Append(" where ACCOUNTID=:ACCOUNTID ");
ParamList param = new ParamList();
param["ACCOUNTID"] = AccountModel.ACCOUNTID;
param["ACCOUNTNAME"] = AccountModel.ACCOUNTNAME;
param["COMPANYID"] = AccountModel.COMPANYID;
param["ACCOUNTPWD"] = AccountModel.ACCOUNTPWD;
param["ORIGNALPWD"] = AccountModel.ORIGNALPWD;
param["REALNAME"] = AccountModel.REALNAME;
param["EMAIL"] = AccountModel.EMAIL;
param["ROLEIDS"] = AccountModel.ROLEIDS;
param["LINKPHONE"] = AccountModel.LINKPHONE;
param["CREATEDATE"] = AccountModel.CREATEDATE;
param["CREATORID"] = AccountModel.CREATORID;
param["ISADMIN"] = AccountModel.ISADMIN;
param["STATUS"] = AccountModel.STATUS;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//修改账号信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//操作日志
strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_LOG(");
strSql.Append("LOGID,OPERATETYPE,OPERATORID,PROJECTID,COMPANYID,OPERATECONTENT,OPERATEDATE)");
strSql.Append(" values (");
strSql.Append(":LOGID,:OPERATETYPE,:OPERATORID,:PROJECTID,:COMPANYID,:OPERATECONTENT,:OPERATEDATE)");
param["LOGID"] = log.LOGID;
param["OPERATETYPE"] = log.OPERATETYPE;
param["OPERATORID"] = log.OPERATORID;
param["PROJECTID"] = log.PROJECTID;
param["COMPANYID"] = log.COMPANYID;
param["OPERATECONTENT"] = log.OPERATECONTENT;
param["OPERATEDATE"] = log.OPERATEDATE;
connection.ExecuteNonQuery(strSql.ToString(), param);
connection.CommitTranscation();
blSuccess = true;
}
}
catch (Exception ex)
{
connection.RollbackTranscation();
LogHelper.WriteErr("修改账号信息时发生错误，账号名称：" + AccountModel.ACCOUNTNAME, ex);
}
return(blSuccess);
}
