/// <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 "); } }