/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Create(IndicatorsRelations model)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_IndicatorsRelations(");
strSql.Append("ApplicationType,FK_MemberTypeCertificationId,FK_TypeIndicatorNameId,Editor,CreateDate)");
strSql.Append(" values (");
strSql.Append("@ApplicationType,@FK_MemberTypeCertificationId,@FK_TypeIndicatorNameId,@Editor,@CreateDate)");
if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetParameter(model)) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { throw; }
}
private string Create(HttpContext context)
{
try
{
SysLogBll.Create("指标对应关系", "创建指标对应关系操作", adminUser.AdminName);
IndicatorsRelations model = null;
int err = 0;
int succ = 0;
string ApplicationType = context.Request.QueryString["ApplicationType"];
string FK_MemberTypeCertificationId = context.Request.QueryString["FK_MemberTypeCertificationId"];
Delete(ApplicationType, FK_MemberTypeCertificationId);
string[] SysFunId = context.Request.QueryString["FunId"].ToString().Split('|');
for (int i = 0; i < SysFunId.Length - 1; i++)
{
model = new IndicatorsRelations();
model.ApplicationType = int.Parse(ApplicationType);
model.FK_TypeIndicatorNameId = int.Parse(SysFunId[i].ToString());
model.FK_MemberTypeCertificationId = int.Parse(FK_MemberTypeCertificationId);
model.Editor = adminUser.AdminLogName;
if (dal.Create(model))
{
succ++;
}
else
{
err++;
}
}
return("授权操作成功了[" + succ.ToString() + "]条，失败了[" + err.ToString() + "]条！");
}
catch (Exception ex)
{
SystemErrorPlug.ErrorRecord("时间:[" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "]类名:[" + this.GetType().Name + "],行号:[" + Component.GetLineNum().ToString() + "行],错误信息:[" + ex.Message + "]");
return("操作失败，错误代码：500 ");
}
}
