/// <summary>
/// 修改公共分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCodePublicType(CodePublicTypeModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.CodePublicType ");
sql.AppendLine(" SET ");
sql.AppendLine(" TypeName = @TypeName ");
sql.AppendLine(" ,Description = @Description ");
sql.AppendLine(" ,UsedStatus = @UsedStatus ");
sql.AppendLine(" ,ModifiedDate = @ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
sql.AppendLine(" WHERE CompanyCD = @CompanyCD and ID=@ID ");
//设置参数
SqlParameter[] param = new SqlParameter[7];
int i = 0;
param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[i++] = SqlHelper.GetParameter("@ID", model.ID);
param[i++] = SqlHelper.GetParameter("@TypeName", model.TypeName);
param[i++] = SqlHelper.GetParameter("@Description", model.Description);
param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus);
param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改公共分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCodePublicType(CodePublicTypeModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.TypeName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = XBase.Data.Office.SystemManager.CodePublicTypeDBHelper.UpdateCodePublicType(model);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception)
{
return false;
throw;
}
}
/// <summary>
/// 插入公共分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertCodePublicType(CodePublicTypeModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.CodePublicType");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,TypeFlag ");
sql.AppendLine(" ,TypeCode ");
sql.AppendLine(" ,TypeName ");
sql.AppendLine(" ,Description ");
sql.AppendLine(" ,UsedStatus ");
sql.AppendLine(" ,ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID) ");
sql.AppendLine(" VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@TypeFlag ");
sql.AppendLine(" ,@TypeCode ");
sql.AppendLine(" ,@TypeName ");
sql.AppendLine(" ,@Description ");
sql.AppendLine(" ,@UsedStatus ");
sql.AppendLine(" ,@ModifiedDate ");
sql.AppendLine(" ,@ModifiedUserID) ");
//设置参数
SqlParameter[] param = new SqlParameter[8];
int i = 0;
param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[i++] = SqlHelper.GetParameter("@TypeFlag", model.TypeFlag);
param[i++] = SqlHelper.GetParameter("@TypeCode", model.TypeCode);
param[i++] = SqlHelper.GetParameter("@TypeName", model.TypeName);
param[i++] = SqlHelper.GetParameter("@Description", model.Description);
param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus);
param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
