/// <summary> /// 插入编码规则 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertItemCodingRule(ItemCodingRuleModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.RuleName); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = XBase.Data.Office.SystemManager.ItemCodingRuleDBHelper.InsertItemCodingRule(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception ex) { WriteSystemLog(userInfo, ex); return false; } }
/// <summary> /// 插入编码规则 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertItemCodingRule(ItemCodingRuleModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.ItemCodingRule"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,CodingType "); sql.AppendLine(" ,ItemTypeID "); sql.AppendLine(" ,RuleName "); sql.AppendLine(" ,RulePrefix "); sql.AppendLine(" ,RuleDateType "); sql.AppendLine(" ,RuleNoLen "); sql.AppendLine(" ,LastNo "); sql.AppendLine(" ,RuleExample "); sql.AppendLine(" ,IsDefault "); sql.AppendLine(" ,Remark "); sql.AppendLine(" ,UsedStatus "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@CodingType "); sql.AppendLine(" ,@ItemTypeID "); sql.AppendLine(" ,@RuleName "); sql.AppendLine(" ,@RulePrefix "); sql.AppendLine(" ,@RuleDateType "); sql.AppendLine(" ,@RuleNoLen "); sql.AppendLine(" ,@LastNo "); sql.AppendLine(" ,@RuleExample "); sql.AppendLine(" ,@IsDefault "); sql.AppendLine(" ,@Remark "); sql.AppendLine(" ,@UsedStatus "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); //设置参数 SqlCommand comm = new SqlCommand(); comm.CommandText = sql.ToString(); //设置参数 comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CodingType", model.CodingType)); comm.Parameters.Add(SqlHelper.GetParameter("@ItemTypeID", model.ItemTypeID)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleName", model.RuleName)); comm.Parameters.Add(SqlHelper.GetParameter("@RulePrefix", model.RulePrefix)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleDateType", model.RuleDateType)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleNoLen", model.RuleNoLen)); comm.Parameters.Add(SqlHelper.GetParameter("@LastNo", model.LastNo)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleExample", model.RuleExample)); comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark)); comm.Parameters.Add(SqlHelper.GetParameter("@IsDefault", model.IsDefault)); comm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", model.UsedStatus)); comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now)); comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID)); ArrayList listadd= new ArrayList(); //删除计提信息 Updateinfo(listadd, model.CodingType,model.ItemTypeID,model.IsDefault, model.CompanyCD); listadd.Add(comm); return SqlHelper.ExecuteTransWithArrayList(listadd); }
///// <summary> ///// 修改编码规则 ///// </summary> ///// <param name="model"></param> ///// <returns></returns> public static bool UpdateItemCodingRule(ItemCodingRuleModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE [officedba].[ItemCodingRule] " ); sql.AppendLine(" SET "); sql.AppendLine(" ItemTypeID = @ItemTypeID "); sql.AppendLine(" ,RuleName = @RuleName "); sql.AppendLine(" ,RulePrefix = @RulePrefix "); sql.AppendLine(" ,RuleDateType = @RuleDateType "); sql.AppendLine(" ,RuleNoLen = @RuleNoLen "); sql.AppendLine(" ,RuleExample = @RuleExample "); sql.AppendLine(" ,IsDefault = @IsDefault "); sql.AppendLine(" ,Remark = @Remark "); sql.AppendLine(" ,UsedStatus = @UsedStatus "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); sql.AppendLine(" WHERE ID=@ID "); SqlCommand comm = new SqlCommand(); comm.CommandText = sql.ToString(); //设置参数 comm.Parameters.Add(SqlHelper.GetParameter("@ItemTypeID", model.ItemTypeID)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleName", model.RuleName)); comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID)); comm.Parameters.Add(SqlHelper.GetParameter("@RulePrefix", model.RulePrefix)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleDateType", model.RuleDateType)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleNoLen", model.RuleNoLen)); comm.Parameters.Add(SqlHelper.GetParameter("@RuleExample", model.RuleExample)); comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark)); comm.Parameters.Add(SqlHelper.GetParameter("@IsDefault", model.IsDefault)); comm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", model.UsedStatus)); comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now)); comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID)); //SqlHelper.ExecuteTransSql(sql.ToString(), param); //return SqlHelper.Result.OprateCount > 0 ? true : false; ArrayList listadd = new ArrayList(); //删除计提信息 Updateinfo(listadd, model.CodingType, model.ItemTypeID, model.IsDefault, model.CompanyCD); listadd.Add(comm); return SqlHelper.ExecuteTransWithArrayList(listadd); }