/// <summary>
/// 更新项目信息
/// </summary>
/// <param name="model"></param>
/// <param name="log"></param>
/// <returns></returns>
public static bool UpdateProject(USER_SHARE_PROJECTMODEL model, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_PROJECT set ");
strSql.Append("PROJECTNAME=:PROJECTNAME,");
strSql.Append("APISERVICEKEY=:APISERVICEKEY,");
strSql.Append("CREATEDATE=:CREATEDATE,");
strSql.Append("PROJECTREMARK=:PROJECTREMARK,");
strSql.Append("STATUS=:STATUS");
strSql.Append(" where PROJECTID=:PROJECTID ");
ParamList param = new ParamList();
param["PROJECTID"] = model.PROJECTID;
param["PROJECTNAME"] = model.PROJECTNAME;
param["APISERVICEKEY"] = model.APISERVICEKEY;
param["CREATEDATE"] = model.CREATEDATE;
param["PROJECTREMARK"] = model.PROJECTREMARK;
param["STATUS"] = model.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("修改项目信息时发生错误:项目ID" + model.PROJECTID, ex);
}
return(blSuccess);
}
protected void btnSave_Click(object sender, EventArgs e)
{
USER_SHARE_COMPANYFUNMODEL usfModel = null;
bool isEdit = FmId > 0;
//日志记录
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;
usfModel = CompanyFunBusiness.GetCompanyFunModel(FmId, CompanyId);
usfModel.CFANOTHERNAME = txtFMName.Text.Trim();
//usfModel.CFPAGEURL = txtFMPageUrl.Text.Trim();
usfModel.CFSORTNUM = ValidatorHelper.ToInt(txtFMSortNum.Text, 0);
usfModel.CFDESC = txtFMDesc.Text.Trim();
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditCompanyFun.ToString("d"));
logModel.OPERATECONTENT = "修改公司功能菜单，菜单ID：" + usfModel.CFID + "，修改后菜单名称:" + txtFMName.Text.Trim();
bool isSuccess = CompanyFunBusiness.UpdateCompanyFun(usfModel, logModel);
Alert("修改功能菜单" + (isSuccess ? "成功" : "失败，请重试") + "！");
//刷新父页面
ExecStartScript(string.Format("parent.location='FunMenuManage.aspx?pid={0}&s={1}';", Enc.Encrypt(usfModel.PROJECTID.ToString(), UrlEncKey), new Random(10000).Next()));
}
protected void lnkStopUse_Click(object sender, EventArgs e)
{
if (hidProductId.Value.Trim().Length > 0 && hidStatus.Value.Trim().Length > 0)
{
#region 日志记录
USER_SHARE_LOGMODEL log = new USER_SHARE_LOGMODEL();
log.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
log.OPERATECONTENT = "更改产品状态为:" + EnumPlus.GetEnumDescription(typeof(ShareEnum.ProductFlag), hidStatus.Value);
log.OPERATECONTENT += ",产品Id:" + hidProductId.Value;
log.OPERATEDATE = DateTime.Now;
log.OPERATETYPE = int.Parse(ShareEnum.LogType.ChangeProductStatus.ToString("d"));
log.OPERATORID = AccountId;
log.PROJECTID = ProjectId;
#endregion
#region 保存
if (ProductBusiness.UpdateProductStatus(hidProductId.Value, hidStatus.Value, log))
{
Alert("操作成功！");
BindData(0);
}
else
{
Alert("操作失败，请重试！");
}
#endregion
}
}
protected void lnkStopUse_Click(object sender, EventArgs e)
{
if (hidCId.Value.Trim().Length > 0 && hidStatus.Value.Trim().Length > 0)
{
#region 日志记录
USER_SHARE_LOGMODEL log = new USER_SHARE_LOGMODEL();
log.LOGID = CommonBusiness.GetSeqID("S_USER_SHARE_LOG");
log.OPERATECONTENT = "删除角色信息";
log.OPERATECONTENT += ",角色Id:" + hidCId.Value;
log.OPERATEDATE = DateTime.Now;
log.OPERATETYPE = int.Parse(ShareEnum.LogType.DelRole.ToString("d"));
log.OPERATORID = AccountId;
log.PROJECTID = ProjectId;
#endregion
#region 保存
if (RoleBusiness.DelRole(hidCId.Value, log))
{
Alert("角色删除成功！");
BindData(0);
}
else
{
Alert("角色删除失败，请重试！");
}
#endregion
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool isEdit = Request.QueryString["id"] != null;
//项目信息
USER_SHARE_PROJECTMODEL projectModel = null;
//日志记录
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 (!isEdit)
{
projectModel = new USER_SHARE_PROJECTMODEL();
projectModel.PROJECTID = CommonBusiness.GetSeqID("S_USER_SHARE_PROJECT");
projectModel.PROJECTNAME = txtProjectName.Text.Trim();
projectModel.APISERVICEKEY = lblProjectKey.Text.Trim();
projectModel.PROJECTREMARK = txtProjectDesc.Text.Trim();
projectModel.STATUS = int.Parse(ShareEnum.ProjectStatus.Normal.ToString("d"));
projectModel.CREATEDATE = DateTime.Now;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddProject.ToString("d"));
logModel.OPERATECONTENT = "注册新项目，Id:" + projectModel.PROJECTID + ",名称：" + projectModel.PROJECTNAME;
if (ProjectBusiness.AddProject(projectModel, logModel))
{
Alert("项目注册成功！");
}
else
{
Alert("项目注册失败，请重试！");
}
}
else
{
projectModel = ProjectBusiness.GetProjectModel(ValidatorHelper.ToInt(Enc.Decrypt(Request.QueryString["id"], UrlEncKey), 0));
projectModel.PROJECTNAME = txtProjectName.Text.Trim();
projectModel.PROJECTREMARK = txtProjectDesc.Text.Trim();
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditProject.ToString("d"));
logModel.OPERATECONTENT = "修改项目信息，项目Id:" + projectModel.PROJECTID + ",修改后的名称：" + projectModel.PROJECTNAME;
if (ProjectBusiness.UpdateProject(projectModel, logModel))
{
Alert("项目信息修改成功！");
}
else
{
Alert("项目信息修改失败，请重试！");
}
}
ExecScript("parent.__doPostBack('ctl00$MainContent$btnSearch','');");
}
protected void btnSave_Click(object sender, EventArgs e)
{
USER_SHARE_FUNMENUMODEL usfModel = null;
bool isEdit = FmId > 0 && ActionType.Equals("edit");
bool isSuccess = false;
//日志记录
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;
int nProjectId = ValidatorHelper.ToInt(Enc.Decrypt(Request.QueryString["projectid"], UrlEncKey), 0);
//新增
if (!isEdit)
{
usfModel = new USER_SHARE_FUNMENUMODEL();
usfModel.FMID = CommonBusiness.GetSeqID("S_USER_SHARE_FUNMENU");
usfModel.PROJECTID = nProjectId;
usfModel.FMPARENTID = FmId > 0 ? FmId : 0;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddProjectFunMenu.ToString("d"));
logModel.OPERATECONTENT = "新增项目功能菜单，项目ID：" + usfModel.PROJECTID + "，菜单名称:" + txtFMName.Text.Trim();
}
//修改
else
{
usfModel = ProjectFunBusiness.GetModel(FmId);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditProjectFunMenu.ToString("d"));
logModel.OPERATECONTENT = "修改项目功能菜单，菜单ID：" + FmId + "，修改后菜单名称:" + txtFMName.Text.Trim();
}
usfModel.FMNAME = txtFMName.Text.Trim();
usfModel.FMPAGEURL = txtFMPageUrl.Text.Trim();
usfModel.FMSORTNUM = ValidatorHelper.ToInt(txtFMSortNum.Text, 0);
usfModel.FMDESC = txtFMDesc.Text.Trim();
if (!isEdit)
{
isSuccess = ProjectFunBusiness.AddProjectFun(usfModel, logModel);
}
else
{
isSuccess = ProjectFunBusiness.UpdateProjectFun(usfModel, logModel);
}
Alert((isEdit ? "修改" : "新增") + "功能菜单" + (isSuccess ? "成功" : "失败，请重试") + "！");
//刷新父页面
ExecStartScript(string.Format("parent.location='ProjectFunManage.aspx?pid={0}&s={1}';", Request.QueryString["projectid"], new Random(10000).Next()));
}
/// <summary>
/// 停用功能菜单
/// </summary>
/// <param name="nFmId"></param>
/// <param name="log"></param>
/// <returns></returns>
public static bool SetFunStop(int nFmId, int nCompanyId, USER_SHARE_LOGMODEL log)
{
bool blResult = false;
string strSqls = "UPDATE USER_SHARE_COMPANYFUN SET CFSTATUS=:CFSTATUS WHERE FMID=:FMID AND COMPANYID=:COMPANYID ";
ParamList param = new ParamList();
param["FMID"] = nFmId;
param["COMPANYID"] = nCompanyId;
param["CFSTATUS"] = ShareEnum.FunMenuStatus.StopUse.ToString("d");
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//更改状态
connection.ExecuteNonQuery(strSqls, param);
param.Clear();
//操作日志
StringBuilder 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();
blResult = true;
}
}
catch (Exception ex)
{
connection.RollbackTranscation();
LogHelper.WriteErr("将公司功能菜单设置为无效时出现异常，Id:" + nFmId, ex);
}
return(blResult);
}
/// <summary>
/// 删除一个车辆分组
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string DelGroup(HttpContext context)
{
int nGroupId = ValidatorHelper.ToInt(Enc.Decrypt(context.Request.QueryString["gid"], UrlEncKey), 0);
//日志记录
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;
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.ChangeProjectFunMenuStatus.ToString("d"));
logModel.OPERATECONTENT = "设置车辆分组状态为" + EnumPlus.GetEnumDescription(typeof(ShareEnum.LogType), logModel.OPERATETYPE.ToString());
return(CompanyGroupBusiness.SetGroupStop(nGroupId, logModel) ? "0" : "1");
}
/// <summary>
/// 删除角色信息
/// </summary>
/// <param name="strAccountId"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public static bool DelRole(string strRoleId, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder("UPDATE USER_SHARE_ROLES SET STATUS=:STATUS WHERE ROLEID=:ROLEID");
ParamList param = new ParamList();
param["ROLEID"] = strRoleId;
param["STATUS"] = ShareEnum.RoleStatus.Del.ToString("d");
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//更新项目状态
connection.ExecuteNonQuery(strSql.ToString(), param);
//日志记录
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.Clear();
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("删除角色信息时发生错误:" + ex.Message + ",角色Id:" + strRoleId, ex);
}
return(blSuccess);
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 务端验证
if (txtGroupName.Text.Trim().Length == 0)
{
Alert("请输入分组名称！");
Select(txtGroupName);
return;
}
List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel = new List <USER_SHARE_VEHICLE_GROUPMODEL>();
USER_SHARE_VEHICLE_GROUPMODEL vgmodel = null;
foreach (ListItem item in cblVehicles.Items)
{
if (item.Selected)
{
vgmodel = new USER_SHARE_VEHICLE_GROUPMODEL();
vgmodel.SHAREGROUPID = 0;
vgmodel.MACID = item.Value;
vgmodel.TARGETID = item.Text;
lstVgModel.Add(vgmodel);
}
}
if (lstVgModel.Count == 0)
{
Alert("请选择分组包含车辆！");
return;
}
#endregion
#region 分组信息保存
USER_SHARE_GROUPMODEL groupModel = null;
//日志信息
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 (CompanyGroupId > 0)
{
groupModel = CompanyGroupBusiness.GetGroupModel(CompanyGroupId);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditCompanyGroup.ToString("d"));
logModel.OPERATECONTENT = string.Format("修改分组信息，修改后分组名称：{0}， 分组Id:{1} ", txtGroupName.Text.Trim(), CompanyGroupId);
}
else
{
groupModel = new USER_SHARE_GROUPMODEL();
groupModel.ID = CommonBusiness.GetSeqID("S_USER_SHARE_GROUP");
groupModel.COMPANYCODE = CompanyCode;
groupModel.PARENTID = Request.QueryString["pid"] == null ? 0 : ValidatorHelper.ToInt(Enc.Decrypt(Request.QueryString["pid"], UrlEncKey), 0);
groupModel.STATE = int.Parse(ShareEnum.CompanyGroupStatus.Normal.ToString("d"));
groupModel.GRADE = CompanyGroupBusiness.GetGroupGrade(CompanyCode, groupModel.PARENTID);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddCompanyGroup.ToString("d"));
logModel.OPERATECONTENT = string.Format("新增分组信息，分组名称：{0}，公司编码：{1} ", txtGroupName.Text.Trim(), CompanyCode);
}
groupModel.GROUPNAME = txtGroupName.Text.Trim();
groupModel.VEHICLENUM = lstVgModel.Count;
groupModel.GROUPDESC = txtGroupDesc.Text.Trim();
bool blSuccess = false;
string strRoleFuns = Request.Form["fun"];
if (CompanyGroupId == 0)
{
blSuccess = CompanyGroupBusiness.AddCompanyGroup(groupModel, lstVgModel, logModel);
}
else
{
blSuccess = CompanyGroupBusiness.EditCompanyGroup(groupModel, lstVgModel, logModel);
}
Alert((CompanyGroupId > 0 ? "修改" : "新增") + "分组" + (blSuccess ? "成功" : "失败，请重试！"));
//刷新父页面
ExecStartScript(string.Format("parent.location='CompanyGroupManage.aspx?s={0}';", new Random(10000).Next()));
#endregion
}
/// <summary>
/// 修改公司分组信息
/// </summary>
/// <param name="groupModel"></param>
/// <returns></returns>
public static bool EditCompanyGroup(USER_SHARE_GROUPMODEL groupModel, List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_GROUP set ");
strSql.Append("COMPANYCODE=:COMPANYCODE,");
strSql.Append("GROUPNAME=:GROUPNAME,");
strSql.Append("PARENTID=:PARENTID,");
strSql.Append("STATE=:STATE,");
strSql.Append("GRADE=:GRADE,");
strSql.Append("VEHICLENUM=:VEHICLENUM,");
strSql.Append("GROUPDESC=:GROUPDESC");
strSql.Append(" where ID=:ID ");
ParamList param = new ParamList();
param["ID"] = groupModel.ID;
param["COMPANYCODE"] = groupModel.COMPANYCODE;
param["GROUPNAME"] = groupModel.GROUPNAME;
param["PARENTID"] = groupModel.PARENTID;
param["STATE"] = groupModel.STATE;
param["GRADE"] = groupModel.GRADE;
param["VEHICLENUM"] = groupModel.VEHICLENUM;
param["GROUPDESC"] = groupModel.GROUPDESC;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//修改公司分组信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//删除原来分组下的车辆信息
string strSqlFun = "DELETE FROM USER_SHARE_VEHICLE_GROUP WHERE SHAREGROUPID=" + groupModel.ID;
StaticConnectionProvider.ExecuteNonQuery(strSqlFun);
//分组车辆信息添加
foreach (USER_SHARE_VEHICLE_GROUPMODEL vgModel in lstVgModel)
{
strSqlFun = @"insert into USER_SHARE_VEHICLE_GROUP(SHAREGROUPID,TARGETID,MACID)
values (:SHAREGROUPID,:TARGETID,:MACID)";
param.Clear();
param["SHAREGROUPID"] = groupModel.ID;
param["TARGETID"] = vgModel.TARGETID;
param["MACID"] = vgModel.MACID;
connection.ExecuteNonQuery(strSqlFun, 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("修改公司分组信息时发生错误，分组Id：" + groupModel.ID, ex);
}
return(blSuccess);
}
/// <summary>
/// 新增公司分组信息
/// </summary>
/// <param name="groupModel"></param>
/// <returns></returns>
public static bool AddCompanyGroup(USER_SHARE_GROUPMODEL groupModel, List <USER_SHARE_VEHICLE_GROUPMODEL> lstVgModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_GROUP(");
strSql.Append("ID,COMPANYCODE,GROUPNAME,PARENTID,STATE,GRADE,VEHICLENUM,GROUPDESC)");
strSql.Append(" values (");
strSql.Append(":ID,:COMPANYCODE,:GROUPNAME,:PARENTID,:STATE,:GRADE,:VEHICLENUM,:GROUPDESC)");
ParamList param = new ParamList();
param["ID"] = groupModel.ID;
param["COMPANYCODE"] = groupModel.COMPANYCODE;
param["GROUPNAME"] = groupModel.GROUPNAME;
param["PARENTID"] = groupModel.PARENTID;
param["STATE"] = groupModel.STATE;
param["GRADE"] = groupModel.GRADE;
param["VEHICLENUM"] = groupModel.VEHICLENUM;
param["GROUPDESC"] = groupModel.GROUPDESC;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//增加分组信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
string strSqlFun = string.Empty;
//分组车辆
foreach (USER_SHARE_VEHICLE_GROUPMODEL vgModel in lstVgModel)
{
strSqlFun = string.Format("insert into USER_SHARE_VEHICLE_GROUP(SHAREGROUPID,TARGETID,MACID)values(:SHAREGROUPID,:TARGETID,:MACID)");
param.Clear();
param["SHAREGROUPID"] = groupModel.ID;
param["TARGETID"] = vgModel.TARGETID;
param["MACID"] = vgModel.MACID;
connection.ExecuteNonQuery(strSqlFun, param);
}
//操作日志
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.Clear();
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("新增公司车辆分组信息时发生错误，分组名称：" + groupModel.GROUPNAME, ex);
}
return(blSuccess);
}
/// <summary>
/// 新增角色信息
/// </summary>
/// <param name="roleModel"></param>
/// <returns></returns>
public static bool AddARole(USER_SHARE_ROLESMODEL roleModel, string strFunIds, string strGroupIds, List <RoleAccountModel> lstRaModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_ROLES(");
strSql.Append("ROLEID,ROLENAME,ROLEDESC,PROJECTID,COMPANYID,STATUS,CREATORID,CREATEDATE)");
strSql.Append(" values (");
strSql.Append(":ROLEID,:ROLENAME,:ROLEDESC,:PROJECTID,:COMPANYID,:STATUS,:CREATORID,:CREATEDATE)");
ParamList param = new ParamList();
param["ROLEID"] = roleModel.ROLEID;
param["ROLENAME"] = roleModel.ROLENAME;
param["ROLEDESC"] = roleModel.ROLEDESC;
param["PROJECTID"] = roleModel.PROJECTID;
param["COMPANYID"] = roleModel.COMPANYID;
param["STATUS"] = roleModel.STATUS;
param["CREATORID"] = roleModel.CreatorId;
param["CREATEDATE"] = roleModel.CreateDate;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//增加角色信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
string strSqlFun = string.Empty;
//角色功能
if (strFunIds.Trim().Length > 0)
{
string[] funId = strFunIds.Split(',');
foreach (string str in funId)
{
if (str.Trim().Length > 0)
{
strSqlFun = string.Format("INSERT INTO USER_SHARE_ROLEFUN(ROLEID,FUNID) VALUES({0},{1}) ", roleModel.ROLEID, str);
connection.ExecuteNonQuery(strSqlFun);
}
}
}
//角色下的账号更新
foreach (RoleAccountModel raModel in lstRaModel)
{
//新增时选中的账号，角色更新，未选中的不用做处理
if (raModel.IsChecked)
{
strSqlFun = string.Format("UPDATE USER_SHARE_ACCOUNT SET ROLEIDS=(ROLEIDS||(CASE WHEN ROLEIDS IS NULL THEN ',{0},' ELSE '{0},' END )) WHERE ACCOUNTID={1} ", roleModel.ROLEID, raModel.AccountId);
connection.ExecuteNonQuery(strSqlFun);
}
}
//拥有权限的车辆分组
if (strGroupIds.Trim().Length > 0)
{
string[] funId = strGroupIds.Split(',');
foreach (string str in funId)
{
if (str.Trim().Length > 0)
{
strSqlFun = string.Format("INSERT INTO USER_SHARE_ROLE_GROUP(ROLEID,SHAREGROUPID) VALUES({0},{1}) ", roleModel.ROLEID, str);
connection.ExecuteNonQuery(strSqlFun);
}
}
}
//操作日志
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("新增角色信息时发生错误，角色名称：" + roleModel.ROLENAME, 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);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool AddProjectFun(USER_SHARE_FUNMENUMODEL model, USER_SHARE_LOGMODEL log)
{
bool blResult = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_FUNMENU(");
strSql.Append("FMID,PROJECTID,FMNAME,FMPAGEURL,FMPARENTID,FMSORTNUM,FMSTEP,FMISLAST,FMDESC,FMSTATUS)");
strSql.Append(" values (");
strSql.Append(":FMID,:PROJECTID,:FMNAME,:FMPAGEURL,:FMPARENTID,:FMSORTNUM,:FMSTEP,:FMISLAST,:FMDESC,:FMSTATUS)");
ParamList param = new ParamList();
param["FMID"] = model.FMID;
param["PROJECTID"] = model.PROJECTID;
param["FMNAME"] = model.FMNAME;
param["FMPAGEURL"] = model.FMPAGEURL;
param["FMPARENTID"] = model.FMPARENTID;
param["FMSORTNUM"] = model.FMSORTNUM;
param["FMSTEP"] = model.FMSTEP;
param["FMISLAST"] = model.FMISLAST;
param["FMDESC"] = model.FMDESC;
param["FMSTATUS"] = model.FMSTATUS;
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();
blResult = true;
}
}
catch (Exception ex)
{
connection.RollbackTranscation();
LogHelper.WriteErr("新增项目功能菜单时出现异常，项目Id:" + model.PROJECTID, ex);
}
return(blResult);
}
/// <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);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 务端验证
if (txtRoleName.Text.Trim().Length == 0)
{
Alert("请输入角色名称！");
Select(txtRoleName);
return;
}
if (CommonMethod.FinalString(Request.Form["fun"]).Length == 0)
{
Alert("请选择角色拥有的权限！");
return;
}
#endregion
#region 角色信息保存
USER_SHARE_ROLESMODEL roleModel = null;
//日志信息
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 (RoleId > 0)
{
roleModel = RoleBusiness.GetRoleModel(RoleId);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditRole.ToString("d"));
logModel.OPERATECONTENT = string.Format("修改角色信息，修改后角色名称：{0}， 角色Id:{1} ", txtRoleName.Text.Trim(), RoleId);
}
else
{
roleModel = new USER_SHARE_ROLESMODEL();
roleModel.ROLEID = CommonBusiness.GetSeqID("S_USER_SHARE_ROLES");
roleModel.CreatorId = AccountId;
roleModel.CreateDate = DateTime.Now;
roleModel.COMPANYID = CompanyId;
roleModel.STATUS = int.Parse(ShareEnum.RoleStatus.Normal.ToString("d"));
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddRole.ToString("d"));
logModel.OPERATECONTENT = string.Format("新增角色信息，角色名称：{0}，公司编码：{1} ", txtRoleName.Text.Trim(), CompanyCode);
}
roleModel.PROJECTID = ValidatorHelper.ToInt(ddlProject.SelectedValue, 0);
roleModel.ROLENAME = txtRoleName.Text.Trim();
roleModel.ROLEDESC = txtRoleDesc.Text.Trim();
bool blSuccess = false;
string strRoleFuns = Request.Form["fun"];
#region 账号信息
List <RoleAccountModel> raModel = new List <RoleAccountModel>();
RoleAccountModel model = null;
foreach (ListItem item in cblAccounts.Items)
{
model = new RoleAccountModel();
model.AccountId = ValidatorHelper.ToInt(item.Value.Split('$')[0], 0);
model.IsChecked = item.Selected;
raModel.Add(model);
}
#endregion
#region 角色拥有车辆分组
string strGroup = string.Empty;
foreach (TreeNode tn in tvGroups.Nodes)
{
if (tn.Checked)
{
strGroup += tn.Value + ",";
}
}
strGroup = strGroup.TrimEnd(',');
#endregion
if (RoleId == 0)
{
blSuccess = RoleBusiness.AddARole(roleModel, strRoleFuns, strGroup, raModel, logModel);
}
else
{
blSuccess = RoleBusiness.EditRole(roleModel, strRoleFuns, strGroup, raModel, logModel);
}
Alert((RoleId > 0 ? "修改" : "新增") + "角色" + (blSuccess ? "成功" : "失败，请重试！"));
ExecScript("parent.__doPostBack('ctl00$MainContent$btnSearch','');");
#endregion
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool UpdateCompanyRelate(USER_SHARE_COMPANYRELATEMODEL model, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_COMPANYRELATE set ");
strSql.Append("COMPANYTYPE=:COMPANYTYPE,");
strSql.Append("COMPANYNAME=:COMPANYNAME,");
strSql.Append("COMPANYID=:COMPANYID,");
strSql.Append("GROUPID=:GROUPID,");
strSql.Append("PROJECTIDS=:PROJECTIDS,");
strSql.Append("PRODUCTIDS=:PRODUCTIDS,");
strSql.Append("COMPANYCODE=:COMPANYCODE,");
strSql.Append("SHARECOMPANYID=:SHARECOMPANYID, ");
strSql.Append("ADMINID=:ADMINID,");
strSql.Append("GROUPIDN=:GROUPIDN ");
strSql.Append(" where CID=:CID ");
ParamList param = new ParamList();
param["CID"] = model.CID;
param["COMPANYTYPE"] = model.COMPANYTYPE;
param["COMPANYNAME"] = model.COMPANYNAME;
param["COMPANYID"] = model.COMPANYID;
param["GROUPID"] = model.GROUPID;
param["PROJECTIDS"] = model.PROJECTIDS;
param["PRODUCTIDS"] = model.PRODUCTIDS;
param["COMPANYCODE"] = model.COMPANYCODE;
param["SHARECOMPANYID"] = model.SHARECOMPANYID;
param["ADMINID"] = model.ADMINID;
param["GROUPIDN"] = model.GROUPIDN;
string strSqlS = string.Format(@"SELECT M.* FROM USER_SHARE_PRODUCTFUN P INNER JOIN USER_SHARE_FUNMENU M
ON P.FUNID=M.FMID WHERE M.FMSTATUS={0} AND P.PRODUCTID IN ({1}) AND P.FUNID
NOT IN (SELECT FMID FROM USER_SHARE_COMPANYFUN WHERE COMPANYID={2} )
", ShareEnum.FunMenuStatus.Normal.ToString("d"),
model.PRODUCTIDS.TrimStart(',').TrimEnd(','),
model.COMPANYCODE);
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSqlS);
//原来公司自己删除的菜单如果再次开通了要恢复
strSqlS = string.Format(@"SELECT M.FMID FROM USER_SHARE_PRODUCTFUN P INNER JOIN USER_SHARE_FUNMENU M
ON P.FUNID=M.FMID WHERE M.FMSTATUS={0} AND P.PRODUCTID IN ({1}) AND P.FUNID
IN (SELECT FMID FROM USER_SHARE_COMPANYFUN WHERE COMPANYID={2} AND CFSTATUS={3} )
", ShareEnum.FunMenuStatus.Normal.ToString("d"),
model.PRODUCTIDS.TrimStart(',').TrimEnd(','),
model.COMPANYCODE, ShareEnum.CompanyFunMenuStatus.StopUse.ToString("d"));
DataTable dtStop = StaticConnectionProvider.ExecuteDataTable(strSqlS);
int nCfId = 0;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.CommitTranscation();
//增加项目信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//公司菜单初始化
foreach (DataRow dr in dt.Rows)
{
nCfId = CommonBusiness.GetSeqID("S_USER_SHARE_COMPANYFUN");
strSqlS = string.Format(@"insert into USER_SHARE_COMPANYFUN(CFID,FMID,PROJECTID,COMPANYID,CFNAME,
CFANOTHERNAME,CFPAGEURL,CFPARENTID,CFSORTNUM,CFSTEP,CFISLAST,CFDESC,CFSTATUS) values (
:CFID,:FMID,:PROJECTID,:COMPANYID,:CFNAME,:CFANOTHERNAME,:CFPAGEURL,:CFPARENTID,:CFSORTNUM,
:CFSTEP,:CFISLAST,:CFDESC,:CFSTATUS)");
param["CFID"] = nCfId;
param["FMID"] = dr["FMID"];
param["PROJECTID"] = dr["PROJECTID"];
param["COMPANYID"] = model.COMPANYCODE;
param["CFNAME"] = dr["FMNAME"];
param["CFANOTHERNAME"] = dr["FMNAME"];
param["CFPAGEURL"] = CommonMethod.FinalString(dr["FMPAGEURL"]);
param["CFPARENTID"] = CommonMethod.FinalString(dr["FMPARENTID"]);
param["CFSORTNUM"] = dr["FMSORTNUM"];
param["CFSTEP"] = CommonMethod.FinalString(dr["FMSTEP"]);
param["CFISLAST"] = CommonMethod.FinalString(dr["FMISLAST"]);
param["CFDESC"] = CommonMethod.FinalString(dr["FMDESC"]);
param["CFSTATUS"] = ShareEnum.CompanyFunMenuStatus.Normal.ToString("d");
connection.ExecuteNonQuery(strSqlS, param);
}
//原来公司自己删除的菜单如果再次开通了要恢复
foreach (DataRow dr in dtStop.Rows)
{
strSqlS = "UPDATE USER_SHARE_COMPANYFUN SET CFSTATUS={0} WHERE COMPANYID={1} AND FMID={2} AND CFSTATUS={3}";
connection.ExecuteNonQuery(string.Format(strSqlS, ShareEnum.CompanyFunMenuStatus.Normal.ToString("d"),
model.COMPANYCODE, dr["FMID"], ShareEnum.CompanyFunMenuStatus.StopUse.ToString("d")));
}
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("修改公司关联信息时发生错误:公司名称-" + model.COMPANYNAME, ex);
}
return(blSuccess);
}
/// <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);
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 验证
if (txtProductName.Text.Trim().Length == 0)
{
Alert("请填写产品名称！");
Select(txtProductName);
return;
}
if (CommonMethod.FinalString(Request.Form["fun"]).Length == 0)
{
Alert("请选择产品拥有的功能！");
return;
}
#endregion
#region 基础信息和日志记录
USER_SHARE_PRODUCTMODEL uspModel = null;
//日志记录
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 (ProductId > 0)
{
uspModel = ProductBusiness.GetProductModel(ProductId);
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditProduct.ToString("d"));
logModel.OPERATECONTENT = string.Format("修改产品信息,产品Id:{0},修改后的名称：{1}", ProductId, txtProductName.Text.Trim());
}
//新增
else
{
uspModel = new USER_SHARE_PRODUCTMODEL();
uspModel.PRODUCTID = CommonBusiness.GetSeqID("S_USER_SHARE_PRODUCT");
uspModel.PRODUCTFLAG = int.Parse(ShareEnum.ProductFlag.Normal.ToString("d"));
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddProduct.ToString("d"));
logModel.OPERATECONTENT = string.Format("新增产品信息,产品Id:{0}, 名称：{1}", uspModel.PRODUCTID, txtProductName.Text.Trim());
}
uspModel.PRODUCTNAME = txtProductName.Text.Trim();
uspModel.PROJECTID = ValidatorHelper.ToInt(ddlProjects.SelectedValue, 0);
uspModel.PRODUCTDESC = txtProductDesc.Text.Trim();
#endregion
#region 产品功能
string strFunIds = CommonMethod.FinalString(Request.Form["fun"]);
List <USER_SHARE_PRODUCTFUNMODEL> lstModels = new List <USER_SHARE_PRODUCTFUNMODEL>();
if (strFunIds.Length > 0)
{
USER_SHARE_PRODUCTFUNMODEL funModel = null;
string[] funs = strFunIds.Split(',');
foreach (string funid in funs)
{
funModel = new USER_SHARE_PRODUCTFUNMODEL();
funModel.PROCUTID = uspModel.PRODUCTID;
funModel.FUNID = ValidatorHelper.ToInt(funid, 0);
lstModels.Add(funModel);
}
}
else
{
Alert("请先选择此产品包含的功能！");
return;
}
#endregion
#region 保存
bool isSuccess = false;
string strTip = ProductId > 0 ? "修改" : "新增";
if (ProductId > 0)
{
isSuccess = ProductBusiness.EditProduct(uspModel, lstModels, logModel);
}
else
{
isSuccess = ProductBusiness.AddProduct(uspModel, lstModels, logModel);
}
if (isSuccess)
{
Alert(strTip + "产品成功！");
ExecScript("parent.__doPostBack('ctl00$MainContent$btnSearch','');");
}
else
{
Alert(strTip + "产品失败，请重试！");
}
#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>
/// 修改一条数据
/// </summary>
public static bool EditProduct(USER_SHARE_PRODUCTMODEL model, List <USER_SHARE_PRODUCTFUNMODEL> lstFunModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_PRODUCT set ");
strSql.Append("PROJECTID=:PROJECTID,");
strSql.Append("PRODUCTNAME=:PRODUCTNAME,");
strSql.Append("PRODUCTDESC=:PRODUCTDESC");
strSql.Append(" where PRODUCTID=:PRODUCTID ");
ParamList param = new ParamList();
param["PRODUCTID"] = model.PRODUCTID;
param["PROJECTID"] = model.PROJECTID;
param["PRODUCTNAME"] = model.PRODUCTNAME;
param["PRODUCTDESC"] = model.PRODUCTDESC;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//增加产品基础信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//产品功能信息
//删除原来的
connection.ExecuteNonQuery("DELETE FROM USER_SHARE_PRODUCTFUN WHERE PRODUCTID=" + model.PRODUCTID);
//增加现在的
foreach (USER_SHARE_PRODUCTFUNMODEL funmodel in lstFunModel)
{
strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_PRODUCTFUN(");
strSql.Append("PRODUCTID,FUNID)");
strSql.Append(" values (");
strSql.Append(":PRODUCTID,:FUNID)");
param["PRODUCTID"] = funmodel.PROCUTID;
param["FUNID"] = funmodel.FUNID;
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("修改产品信息时发生错误，产品名称：" + model.PRODUCTNAME, ex);
}
return(blSuccess);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool UpdateProjectFun(USER_SHARE_FUNMENUMODEL model, USER_SHARE_LOGMODEL log)
{
bool blResult = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_FUNMENU set ");
strSql.Append("PROJECTID=:PROJECTID,");
strSql.Append("FMNAME=:FMNAME,");
strSql.Append("FMPAGEURL=:FMPAGEURL,");
strSql.Append("FMPARENTID=:FMPARENTID,");
strSql.Append("FMSORTNUM=:FMSORTNUM,");
strSql.Append("FMSTEP=:FMSTEP,");
strSql.Append("FMISLAST=:FMISLAST,");
strSql.Append("FMDESC=:FMDESC,");
strSql.Append("FMSTATUS=:FMSTATUS");
strSql.Append(" where FMID=:FMID ");
ParamList param = new ParamList();
param["FMID"] = model.FMID;
param["PROJECTID"] = model.PROJECTID;
param["FMNAME"] = model.FMNAME;
param["FMPAGEURL"] = model.FMPAGEURL;
param["FMPARENTID"] = model.FMPARENTID;
param["FMSORTNUM"] = model.FMSORTNUM;
param["FMSTEP"] = model.FMSTEP;
param["FMISLAST"] = model.FMISLAST;
param["FMDESC"] = model.FMDESC;
param["FMSTATUS"] = model.FMSTATUS;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//增加项目信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//链接地址改动，更新公司菜单表的链接地址
strSql = new StringBuilder("UPDATE USER_SHARE_COMPANYFUN SET CFPAGEURL=:CFPAGEURL WHERE CFPAGEURL!=:CFPAGEURL AND FMID=:FMID ");
param["FMID"] = model.FMID;
param["CFPAGEURL"] = model.FMPAGEURL;
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();
blResult = true;
}
}
catch (Exception ex)
{
connection.RollbackTranscation();
LogHelper.WriteErr("修改项目功能菜单时出现异常，Id:" + model.FMID, ex);
}
return(blResult);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool AddCompanyRelate(USER_SHARE_COMPANYRELATEMODEL model, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_COMPANYRELATE(");
strSql.Append("CID,COMPANYTYPE,COMPANYNAME,COMPANYID,GROUPID,PRODUCTIDS,PROJECTIDS,COMPANYCODE,SHARECOMPANYID,ADMINID,CREATEDATE,STATUS,GROUPIDN)");
strSql.Append(" values (");
strSql.Append(":CID,:COMPANYTYPE,:COMPANYNAME,:COMPANYID,:GROUPID,:PRODUCTIDS,:PROJECTIDS,:COMPANYCODE,:SHARECOMPANYID,:ADMINID,:CREATEDATE,:STATUS,:GROUPIDN)");
ParamList param = new ParamList();
param["CID"] = model.CID;
param["COMPANYTYPE"] = model.COMPANYTYPE;
param["COMPANYNAME"] = model.COMPANYNAME;
param["COMPANYID"] = model.COMPANYID;
param["GROUPID"] = model.GROUPID;
param["PRODUCTIDS"] = model.PRODUCTIDS;
param["PROJECTIDS"] = model.PROJECTIDS;
param["COMPANYCODE"] = model.COMPANYCODE;
param["SHARECOMPANYID"] = model.SHARECOMPANYID;
param["ADMINID"] = model.ADMINID;
param["CREATEDATE"] = model.CREATEDATE;
param["STATUS"] = model.STATUS;
param["ADMINID"] = model.ADMINID;
param["GROUPIDN"] = model.GROUPIDN;
//应用系统注册
if (model.COMPANYTYPE == int.Parse(ShareEnum.CompanyType.ShareCompany.ToString("d")))
{
//user_share_company插入
int nShareCompanyId = CommonBusiness.GetSeqID("S_USER_SHARE_COMPANY");
model.SHARECOMPANYID = nShareCompanyId;
param["SHARECOMPANYID"] = nShareCompanyId;
}
string strSqlS = string.Format(@"SELECT M.* FROM USER_SHARE_PRODUCTFUN P INNER JOIN USER_SHARE_FUNMENU M
ON P.FUNID=M.FMID WHERE M.FMSTATUS={0} AND P.PRODUCTID IN ({1}) ",
ShareEnum.FunMenuStatus.Normal.ToString("d"), model.PRODUCTIDS.TrimStart(',').TrimEnd(','));
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSqlS);
int nCfId = 0;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//公司关联信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
if (model.COMPANYTYPE == int.Parse(ShareEnum.CompanyType.ShareCompany.ToString("d")))
{
strSqlS = "INSERT INTO USER_SHARE_COMPANY(COMPANYID,COMPANYNAME) VALUES({0},'{1}')";
connection.ExecuteNonQuery(string.Format(strSqlS, model.SHARECOMPANYID, model.COMPANYNAME));
}
//公司菜单初始化
foreach (DataRow dr in dt.Rows)
{
nCfId = CommonBusiness.GetSeqID("S_USER_SHARE_COMPANYFUN");
strSqlS = string.Format(@"insert into USER_SHARE_COMPANYFUN(CFID,FMID,PROJECTID,COMPANYID,CFNAME,
CFANOTHERNAME,CFPAGEURL,CFPARENTID,CFSORTNUM,CFSTEP,CFISLAST,CFDESC,CFSTATUS) values (
:CFID,:FMID,:PROJECTID,:COMPANYID,:CFNAME,:CFANOTHERNAME,:CFPAGEURL,:CFPARENTID,:CFSORTNUM,
:CFSTEP,:CFISLAST,:CFDESC,:CFSTATUS)");
param["CFID"] = nCfId;
param["FMID"] = dr["FMID"];
param["PROJECTID"] = dr["PROJECTID"];
param["COMPANYID"] = model.COMPANYCODE;
param["CFNAME"] = dr["FMNAME"];
param["CFANOTHERNAME"] = dr["FMNAME"];
param["CFPAGEURL"] = CommonMethod.FinalString(dr["FMPAGEURL"]);
param["CFPARENTID"] = CommonMethod.FinalString(dr["FMPARENTID"]);
param["CFSORTNUM"] = dr["FMSORTNUM"];
param["CFSTEP"] = CommonMethod.FinalString(dr["FMSTEP"]);
param["CFISLAST"] = CommonMethod.FinalString(dr["FMISLAST"]);
param["CFDESC"] = CommonMethod.FinalString(dr["FMDESC"]);
param["CFSTATUS"] = ShareEnum.CompanyFunMenuStatus.Normal.ToString("d");
connection.ExecuteNonQuery(strSqlS, 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("注册公司时发生错误:公司名称-" + model.COMPANYNAME, ex);
}
return(blSuccess);
}
/// <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);
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 基本信息
USER_SHARE_COMPANYRELATEMODEL uscrModel = null;
//日志记录
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;
#region 产品
string strProjectIds = CommonMethod.FinalString(Request.Form["project"]);
string strProductIds = CommonMethod.FinalString(Request.Form["ppfun"]);
if (strProjectIds.Length > 0)
{
strProjectIds = "," + strProjectIds + ",";
}
if (strProductIds.Length > 0)
{
strProductIds = "," + strProductIds + ",";
}
if (strProjectIds.Length == 0 || strProductIds.Length == 0)
{
Alert("请选择公司开通的项目和产品！");
return;
}
#endregion
//新增
if (Cid.Length == 0)
{
uscrModel = new USER_SHARE_COMPANYRELATEMODEL();
uscrModel.CID = CommonBusiness.GetSeqID("S_USER_SHARE_COMPANYRELATE");
uscrModel.STATUS = int.Parse(ShareEnum.CompanyRelateStatus.Normal.ToString("d"));
uscrModel.CREATEDATE = DateTime.Now;
uscrModel.COMPANYCODE = CompanyBusiness.GetCompanyCode();
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.AddCompanyRelate.ToString("d"));
logModel.OPERATECONTENT = "新增公司注册关联信息,公司名称:" + txtCompanyName.Text.Trim();
}
//修改
else
{
uscrModel = CompanyBusiness.GetModelByCid(ValidatorHelper.ToInt(Cid, 0));
logModel.OPERATETYPE = int.Parse(ShareEnum.LogType.EditCompanyRelate.ToString("d"));
logModel.OPERATECONTENT = "修改公司注册关联信息,公司名称:" + txtCompanyName.Text.Trim();
}
uscrModel.COMPANYNAME = txtCompanyName.Text.Trim();
uscrModel.COMPANYTYPE = int.Parse(ddlCompanyType.SelectedValue);
if (uscrModel.COMPANYTYPE != int.Parse(ShareEnum.CompanyType.ShareCompany.ToString("d")))
{
uscrModel.COMPANYID = ValidatorHelper.ToInt(hidCompanyId.Value, 0);
uscrModel.SHARECOMPANYID = 0;
}
else
{
uscrModel.SHARECOMPANYID = ValidatorHelper.ToInt(hidCompanyId.Value, 0);
uscrModel.COMPANYID = 0;
}
uscrModel.GROUPID = hidGroupId.Value;
uscrModel.GROUPIDN = hidGroupIdn.Value;
uscrModel.PROJECTIDS = strProjectIds;
uscrModel.PRODUCTIDS = strProductIds;
if (Cid.Length == 0)
{
if (CompanyBusiness.AddCompanyRelate(uscrModel, logModel))
{
Alert("注册成功！");
}
else
{
Alert("注册失败，请重试！");
}
}
else
{
if (CompanyBusiness.UpdateCompanyRelate(uscrModel, logModel))
{
Alert("修改成功！");
}
else
{
Alert("操作失败，请重试！");
}
}
ExecScript("parent.__doPostBack('ctl00$MainContent$btnSearch','');");
#endregion
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="roleModel"></param>
/// <returns></returns>
public static bool EditRole(USER_SHARE_ROLESMODEL roleModel, string strFunIds, string strGroupIds, List <RoleAccountModel> lstRaModel, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_ROLES set ");
strSql.Append("ROLENAME=:ROLENAME,");
strSql.Append("ROLEDESC=:ROLEDESC,");
strSql.Append("PROJECTID=:PROJECTID,");
strSql.Append("COMPANYID=:COMPANYID,");
strSql.Append("STATUS=:STATUS");
strSql.Append(" where ROLEID=:ROLEID ");
ParamList param = new ParamList();
param["ROLEID"] = roleModel.ROLEID;
param["ROLENAME"] = roleModel.ROLENAME;
param["ROLEDESC"] = roleModel.ROLEDESC;
param["PROJECTID"] = roleModel.PROJECTID;
param["COMPANYID"] = roleModel.COMPANYID;
param["STATUS"] = roleModel.STATUS;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//修改账号信息
connection.ExecuteNonQuery(strSql.ToString(), param);
param.Clear();
//角色功能
//删除旧的信息
string strSqlFun = "DELETE FROM USER_SHARE_ROLEFUN WHERE ROLEID=" + roleModel.ROLEID;
connection.ExecuteNonQuery(strSqlFun);
//新的信息插入
if (strFunIds.Trim().Length > 0)
{
string[] funId = strFunIds.Split(',');
foreach (string str in funId)
{
if (str.Trim().Length > 0)
{
strSqlFun = string.Format("INSERT INTO USER_SHARE_ROLEFUN(ROLEID,FUNID) VALUES({0},{1}) ", roleModel.ROLEID, str);
connection.ExecuteNonQuery(strSqlFun);
}
}
}
//角色下的账号更新
foreach (RoleAccountModel raModel in lstRaModel)
{
//修改时账号角色更新
if (raModel.IsChecked)
{
strSqlFun = string.Format(@"UPDATE USER_SHARE_ACCOUNT SET ROLEIDS=(CASE WHEN REPLACE(ROLEIDS,',{0},',',')=',' OR ROLEIDS IS NULL
THEN ',{0},' ELSE REPLACE(ROLEIDS,',{0},',',')||'{0},' end) WHERE ACCOUNTID={1} ", roleModel.ROLEID, raModel.AccountId);
}
else
{
strSqlFun = string.Format(@"UPDATE USER_SHARE_ACCOUNT SET ROLEIDS=(CASE WHEN REPLACE(ROLEIDS,',{0},',',')=',' OR ROLEIDS IS NULL
THEN '' ELSE REPLACE(ROLEIDS,',{0},',',') end) WHERE ACCOUNTID={1} ", roleModel.ROLEID, raModel.AccountId);
}
connection.ExecuteNonQuery(strSqlFun);
}
//车辆分组
//删除旧的信息
strSqlFun = "DELETE FROM USER_SHARE_ROLE_GROUP WHERE ROLEID=" + roleModel.ROLEID;
connection.ExecuteNonQuery(strSqlFun);
//新的信息插入
if (strGroupIds.Trim().Length > 0)
{
string[] funId = strGroupIds.Split(',');
foreach (string str in funId)
{
if (str.Trim().Length > 0)
{
strSqlFun = string.Format("INSERT INTO USER_SHARE_ROLE_GROUP(ROLEID,SHAREGROUPID) VALUES({0},{1}) ", roleModel.ROLEID, str);
connection.ExecuteNonQuery(strSqlFun);
}
}
}
//操作日志
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("修改角色信息时发生错误，角色Id：" + roleModel.ROLEID, ex);
}
return(blSuccess);
}
/// <summary>
/// 更新产品状态
/// </summary>
/// <param name="strProductId"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public static bool UpdateProductStatus(string strProductId, string strStatus, USER_SHARE_LOGMODEL log)
{
bool blSuccess = false;
StringBuilder strSql = new StringBuilder("UPDATE USER_SHARE_PRODUCT SET PRODUCTFLAG=:PRODUCTFLAG WHERE PRODUCTID=:PRODUCTID");
ParamList param = new ParamList();
param["PRODUCTID"] = strProductId;
param["PRODUCTFLAG"] = strStatus;
IConnectionProvider connection = ConnectionProviderBuilder.CreateConnectionProvider();
try
{
using (connection)
{
connection.BeginTranscation();
//更新项目状态
connection.ExecuteNonQuery(strSql.ToString(), param);
//日志记录
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.Clear();
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("更新产品状态时发生错误:" + ex.Message + ",产品Id:" + strProductId, ex);
}
return(blSuccess);
}
