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