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()));
}
private void LoadInfo(int nFmId)
{
USER_SHARE_COMPANYFUNMODEL usfModel = CompanyFunBusiness.GetCompanyFunModel(nFmId, CompanyId);
if (usfModel != null)
{
txtFMName.Text = usfModel.CFANOTHERNAME;
txtFMDesc.Text = CommonMethod.FinalString(usfModel.CFDESC);
//txtFMPageUrl.Text = CommonMethod.FinalString(usfModel.CFPAGEURL);
txtFMSortNum.Text = usfModel.CFSORTNUM.ToString();
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
private static USER_SHARE_COMPANYFUNMODEL ReaderBind(DataRow dataReader)
{
USER_SHARE_COMPANYFUNMODEL model = new USER_SHARE_COMPANYFUNMODEL();
model.CFID = ValidatorHelper.ToInt(dataReader["CFID"], 0);
model.FMID = ValidatorHelper.ToInt(dataReader["FMID"], 0);
model.PROJECTID = ValidatorHelper.ToInt(dataReader["PROJECTID"], 0);
model.COMPANYID = ValidatorHelper.ToInt(dataReader["COMPANYID"], 0);
model.CFNAME = CommonMethod.FinalString(dataReader["CFNAME"]);
model.CFANOTHERNAME = dataReader["CFANOTHERNAME"].ToString();
model.CFPAGEURL = dataReader["CFPAGEURL"].ToString();
model.CFPARENTID = ValidatorHelper.ToInt(dataReader["CFPARENTID"], 0);
model.CFSORTNUM = ValidatorHelper.ToInt(dataReader["CFSORTNUM"], 0);
model.CFSTEP = CommonMethod.FinalString(dataReader["CFSTEP"]);
model.CFISLAST = ValidatorHelper.ToInt(dataReader["CFISLAST"], 0);
model.CFDESC = CommonMethod.FinalString(dataReader["CFDESC"]);
model.CFSTATUS = ValidatorHelper.ToInt(dataReader["CFSTATUS"], 0);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static USER_SHARE_COMPANYFUNMODEL GetCompanyFunModel(int FmID, int nCompanyId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CFID,FMID,PROJECTID,COMPANYID,CFNAME,CFANOTHERNAME,CFPAGEURL,CFPARENTID,CFSORTNUM,CFSTEP,CFISLAST,CFDESC,CFSTATUS from USER_SHARE_COMPANYFUN ");
strSql.Append(" where FMID=:FMID AND COMPANYID=:COMPANYID ");
ParamList param = new ParamList();
param["FMID"] = FmID;
param["COMPANYID"] = nCompanyId;
DataTable dt = StaticConnectionProvider.ExecuteDataTable(strSql.ToString(), param);
USER_SHARE_COMPANYFUNMODEL model = null;
if (dt != null && dt.Rows.Count > 0)
{
model = ReaderBind(dt.Rows[0]);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool UpdateCompanyFun(USER_SHARE_COMPANYFUNMODEL model, USER_SHARE_LOGMODEL log)
{
bool blResult = false;
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_COMPANYFUN set ");
strSql.Append("FMID=:FMID,");
strSql.Append("PROJECTID=:PROJECTID,");
strSql.Append("COMPANYID=:COMPANYID,");
strSql.Append("CFNAME=:CFNAME,");
strSql.Append("CFANOTHERNAME=:CFANOTHERNAME,");
strSql.Append("CFPAGEURL=:CFPAGEURL,");
strSql.Append("CFPARENTID=:CFPARENTID,");
strSql.Append("CFSORTNUM=:CFSORTNUM,");
strSql.Append("CFSTEP=:CFSTEP,");
strSql.Append("CFISLAST=:CFISLAST,");
strSql.Append("CFDESC=:CFDESC,");
strSql.Append("CFSTATUS=:CFSTATUS");
strSql.Append(" where CFID=:CFID ");
ParamList param = new ParamList();
param["CFID"] = model.CFID;
param["FMID"] = model.FMID;
param["PROJECTID"] = model.PROJECTID;
param["COMPANYID"] = model.COMPANYID;
param["CFNAME"] = model.CFNAME;
param["CFANOTHERNAME"] = model.CFANOTHERNAME;
param["CFPAGEURL"] = model.CFPAGEURL;
param["CFPARENTID"] = model.CFPARENTID;
param["CFSORTNUM"] = model.CFSORTNUM;
param["CFSTEP"] = model.CFSTEP;
param["CFISLAST"] = model.CFISLAST;
param["CFDESC"] = model.CFDESC;
param["CFSTATUS"] = model.CFSTATUS;
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.FMID, ex);
}
return(blResult);
}
