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