protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 车辆绑定
if (GroupId.Length > 0)
{
DataTable dt = PlatFormBusiness.GetVechiles(GroupId);
ControlHelper.BindListControl(cblVehicles, dt, "TARGET_ID", "MAC_ID");
}
//修改时包含的车辆进行选中
if (CompanyGroupId > 0)
{
foreach (ListItem item in cblVehicles.Items)
{
if (CompanyGroupBusiness.IsGroupContainVehicel(CompanyGroupId, item.Value))
{
item.Selected = true;
}
}
USER_SHARE_GROUPMODEL group = CompanyGroupBusiness.GetGroupModel(CompanyGroupId);
if (group != null)
{
txtGroupName.Text = group.GROUPNAME;
txtGroupDesc.Text = CommonMethod.FinalString(group.GROUPDESC);
}
}
#endregion
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static USER_SHARE_GROUPMODEL GetGroupModel(int groupid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,COMPANYCODE,GROUPNAME,PARENTID,STATE,GRADE,GROUPDESC FROM USER_SHARE_GROUP ");
strSql.Append(" where ID=:ID AND STATE=:STATE");
ParamList param = new ParamList();
param["ID"] = groupid;
param["STATE"] = ShareEnum.CompanyGroupStatus.Normal.ToString("d");
USER_SHARE_GROUPMODEL model = null;
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSql.ToString(), param);
if (dt != null && dt.Rows.Count > 0)
{
model = ReaderBind(dt.Rows[0]);
}
return(model);
}
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);
}
