/// <summary>
/// 保存批次规则设置
/// </summary>
/// <param name="model">BachNoRuleSet实体</param>
/// <param name="strMsg">返回信息</param>
/// <returns>规则ID</returns>
public static int SaveBatchRule(BatchNoRuleSet model, out string strMsg)
{
int ruleID = 0;
strMsg = "";
StringBuilder strSql = new StringBuilder();
if (!IsExisted(model.CompanyCD))
{
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
strSql.AppendLine(" insert into officedba.BatchRule ");
strSql.AppendLine(" (CompanyCD,RuleName,RulePrefix,RuleDateType,RuleNoLen,LastNo,RuleExample,");
strSql.AppendLine(" Remark,IsDefault,UsedStatus,ModifiedDate,ModifiedUserID) values");
strSql.AppendLine(" (@CompanyCD,@RuleName,@RulePrefix,@RuleDateType,@RuleNoLen,@LastNo,@RuleExample,");
strSql.AppendLine(" @Remark,@IsDefault,@UsedStatus,getdate(),@ModifiedUserID)");
strSql.AppendLine(" ;select @@IDENTITY ");
SqlParameter[] param = {
new SqlParameter("@CompanyCD",model.CompanyCD),
new SqlParameter("@RuleName",model.RuleName),
new SqlParameter("@RulePrefix",model.RulePrefix),
new SqlParameter("@RuleDateType",model.RuleDateType),
new SqlParameter("@RuleNoLen",model.RuleNoLen),
new SqlParameter("@LastNo",model.LastNo),
new SqlParameter("@RuleExample",model.RuleExample),
new SqlParameter("@Remark",model.Remark),
new SqlParameter("@IsDefault",model.IsDefault),
new SqlParameter("@UsedStatus",model.UsedStatus),
new SqlParameter("@ModifiedUserID",model.ModifiedUserID)
};
foreach (SqlParameter para in param)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
ruleID = Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), param));
tran.Commit();
strMsg = "保存成功！";
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
throw ex;
}
}
else
{
strMsg = "保存失败，已存在批次规则！";
}
return ruleID;
}
/// <summary>
/// 修改批次规则设置
/// </summary>
/// <param name="tbModel">ModuleTableModel模板实体</param>
/// <param name="strMsg"></param>
public static bool UpdateBatchRule(BatchNoRuleSet model, out string strMsg)
{
return BatchNoRuleSetDBHelper.UpdateBatchRule(model, out strMsg);
}
/// <summary>
/// 修改批次规则设置
/// </summary>
/// <param name="tbModel">ModuleTableModel模板实体</param>
/// <param name="strMsg"></param>
public static bool UpdateBatchRule(BatchNoRuleSet model, out string strMsg)
{
StringBuilder strSql = new StringBuilder();
strMsg = "";
bool isSuc = false;
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
strSql.AppendLine(" update officedba.BatchRule set ");
strSql.AppendLine(" RuleName=@RuleName,RulePrefix=@RulePrefix,RuleDateType=@RuleDateType,RuleNoLen=@RuleNoLen,");
strSql.AppendLine(" RuleExample=@RuleExample,Remark=@Remark,IsDefault=@IsDefault,");
strSql.AppendLine(" UsedStatus=@UsedStatus,ModifiedDate=getdate(),ModifiedUserID=@ModifiedUserID ");
strSql.AppendLine(" where ID=@ID and CompanyCD=@CompanyCD ");
SqlParameter[] param = {
new SqlParameter("@ID",model.ID),
new SqlParameter("@CompanyCD",model.CompanyCD),
new SqlParameter("@RuleName",model.RuleName),
new SqlParameter("@RulePrefix",model.RulePrefix),
new SqlParameter("@RuleDateType",model.RuleDateType),
new SqlParameter("@RuleNoLen",model.RuleNoLen),
//new SqlParameter("@LastNo",model.LastNo),
new SqlParameter("@RuleExample",model.RuleExample),
new SqlParameter("@Remark",model.Remark),
new SqlParameter("@IsDefault",model.IsDefault),
new SqlParameter("@UsedStatus",model.UsedStatus),
new SqlParameter("@ModifiedUserID",model.ModifiedUserID)
};
foreach (SqlParameter para in param)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), param);
tran.Commit();
strMsg = "保存成功！";
isSuc = true;
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
isSuc = false;
throw ex;
}
return isSuc;
}
/// <summary>
/// 保存批次规则设置
/// </summary>
/// <param name="model">BachNoRuleSet实体</param>
/// <param name="strMsg">返回信息</param>
/// <returns>规则ID</returns>
public static int SaveBatchRule(BatchNoRuleSet model, out string strMsg)
{
return BatchNoRuleSetDBHelper.SaveBatchRule(model, out strMsg);
}