/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.ResumeCollectionListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ResumeCollectionID", SqlDbType.Int,4), new SqlParameter("@ResumeCollectionGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ResumeCollectionType", SqlDbType.Int,4), new SqlParameter("@ResumeGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseIsDel", SqlDbType.Int,4), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50), new SqlParameter("@Other04", SqlDbType.NVarChar,50), new SqlParameter("@Other05", SqlDbType.Int,4)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.ResumeCollectionType; parameters[3].Value = model.ResumeGuid; parameters[4].Value = model.EnterpriseGuid; parameters[5].Value = model.EnterpriseIsDel; parameters[6].Value = model.IsEnable; parameters[7].Value = model.PublishDate; parameters[8].Value = model.Other01; parameters[9].Value = model.Other02; parameters[10].Value = model.Other03; parameters[11].Value = model.Other04; parameters[12].Value = model.Other05; DbHelperSQL.RunProcedure("ResumeCollectionList_ADD",parameters,out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.jjzpListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@SysGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@PublishID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@jjzpContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50)}; parameters[0].Value = model.id; parameters[1].Value = model.SysGUID; parameters[2].Value = model.PublishID; parameters[3].Value = model.jjzpContent; parameters[4].Value = model.PublishDate; parameters[5].Value = model.IsEnable; parameters[6].Value = model.Other01; parameters[7].Value = model.Other02; parameters[8].Value = model.Other03; DbHelperSQL.RunProcedure("jjzpList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.NavigateListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@NavigateID", SqlDbType.Int,4), new SqlParameter("@NavigateGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@NavigateName", SqlDbType.NVarChar,50), new SqlParameter("@IsShow", SqlDbType.Int,4), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@OrderNumber", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.NavigateName; parameters[3].Value = model.IsShow; parameters[4].Value = model.IsEnable; parameters[5].Value = model.OrderNumber; parameters[6].Value = model.PublishDate; parameters[7].Value = model.Other01; parameters[8].Value = model.Other02; DbHelperSQL.RunProcedure("NavigateList_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.RechargeListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@RechargeID", SqlDbType.Int,4), new SqlParameter("@RechargeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@UserGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Expand_RechargeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@RechargeSum", SqlDbType.Float,8), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.EnterpriseGuid; parameters[3].Value = model.UserGuid; parameters[4].Value = model.Expand_RechargeGUID; parameters[5].Value = model.RechargeSum; parameters[6].Value = model.PublishDate; parameters[7].Value = model.IsEnable; parameters[8].Value = model.Other01; parameters[9].Value = model.Other02; parameters[10].Value = model.Other03; DbHelperSQL.RunProcedure("RechargeList_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.ExchangeCornerListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ExchangeCornerID", SqlDbType.Int,4), new SqlParameter("@ExchangeCornerTypeKey", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ExchangeCornerTitle", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerFilePath", SqlDbType.NVarChar,200), new SqlParameter("@ExchangeCornerFileSize", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.ExchangeCornerTypeKey; parameters[2].Value = Guid.NewGuid(); parameters[3].Value = model.ExchangeCornerTitle; parameters[4].Value = model.ExchangeCornerFilePath; parameters[5].Value = model.ExchangeCornerFileSize; parameters[6].Value = model.ExchangeCornerContent; parameters[7].Value = model.PublishDate; parameters[8].Value = model.IsEnable; parameters[9].Value = model.Other01; parameters[10].Value = model.Other02; DbHelperSQL.RunProcedure("ExchangeCornerList_ADD",parameters,out rowsAffected); return (int)parameters[0].Value; }
private void Update_UserInfo(zlzw.BLL.CoreUserBLL coreUserBLL,string strUserGUID) { System.Data.DataTable dt = coreUserBLL.GetList("UserGuid='" + strUserGUID + "'").Tables[0]; zlzw.Model.CoreUserModel coreUserModel = coreUserBLL.GetModel(int.Parse(dt.Rows[0]["UserID"].ToString()));; coreUserModel.UserLastDateTime = DateTime.Now; coreUserBLL.Update(coreUserModel); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.NavigateListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@NavigateID", SqlDbType.Int,4), new SqlParameter("@NavigateGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@NavigateName", SqlDbType.NVarChar,50), new SqlParameter("@IsShow", SqlDbType.Int,4), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@OrderNumber", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Value = model.NavigateID; parameters[1].Value = model.NavigateGUID; parameters[2].Value = model.NavigateName; parameters[3].Value = model.IsShow; parameters[4].Value = model.IsEnable; parameters[5].Value = model.OrderNumber; parameters[6].Value = model.PublishDate; parameters[7].Value = model.Other01; parameters[8].Value = model.Other02; DbHelperSQL.RunProcedure("NavigateList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.ParticipatingCompaniesListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ParticipatingCompaniesID", SqlDbType.Int,4), new SqlParameter("@ParticipatingCompaniesGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ParticipatingCompaniesContent", SqlDbType.NVarChar,-1), new SqlParameter("@IsShow", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50), new SqlParameter("@Other04", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.EnterpriseGuid; parameters[3].Value = model.ParticipatingCompaniesContent; parameters[4].Value = model.IsShow; parameters[5].Value = model.PublishDate; parameters[6].Value = model.IsEnable; parameters[7].Value = model.Other01; parameters[8].Value = model.Other02; parameters[9].Value = model.Other03; parameters[10].Value = model.Other04; DbHelperSQL.RunProcedure("ParticipatingCompaniesList_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.MerchantsJoinListModel model) { int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@MerchantsJoinID", SqlDbType.Int,4), new SqlParameter("@MerchantsJoinGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@MerchantsJoinConetnt", SqlDbType.NVarChar,-1), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@PublisDate", SqlDbType.DateTime), new SqlParameter("@PublishName", SqlDbType.NVarChar,50), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Value = model.MerchantsJoinID; parameters[1].Value = model.MerchantsJoinGUID; parameters[2].Value = model.MerchantsJoinConetnt; parameters[3].Value = model.IsEnable; parameters[4].Value = model.PublisDate; parameters[5].Value = model.PublishName; parameters[6].Value = model.Other01; parameters[7].Value = model.Other02; DbHelperSQL.RunProcedure("MerchantsJoinList_Update",parameters,out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.jjzpListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@SysGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@PublishID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@jjzpContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = Guid.NewGuid(); parameters[3].Value = model.jjzpContent; parameters[4].Value = model.PublishDate; parameters[5].Value = model.IsEnable; parameters[6].Value = model.Other01; parameters[7].Value = model.Other02; parameters[8].Value = model.Other03; DbHelperSQL.RunProcedure("jjzpList_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.GeneralBasicSettingModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@SettingID", SqlDbType.Int,4), new SqlParameter("@SettingKey", SqlDbType.NVarChar,50), new SqlParameter("@SettingValue", SqlDbType.NVarChar,200), new SqlParameter("@SettingDesc", SqlDbType.NVarChar,-1), new SqlParameter("@SettingCategory", SqlDbType.NVarChar,50), new SqlParameter("@DisplayName", SqlDbType.NVarChar,50), new SqlParameter("@OrderNumber", SqlDbType.Int,4), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@IsInnerSetting", SqlDbType.Int,4)}; parameters[0].Value = model.SettingID; parameters[1].Value = model.SettingKey; parameters[2].Value = model.SettingValue; parameters[3].Value = model.SettingDesc; parameters[4].Value = model.SettingCategory; parameters[5].Value = model.DisplayName; parameters[6].Value = model.OrderNumber; parameters[7].Value = model.CanUsable; parameters[8].Value = model.IsInnerSetting; DbHelperSQL.RunProcedure("GeneralBasicSetting_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.GeneralBasicSettingModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@SettingID", SqlDbType.Int,4), new SqlParameter("@SettingKey", SqlDbType.NVarChar,50), new SqlParameter("@SettingValue", SqlDbType.NVarChar,200), new SqlParameter("@SettingDesc", SqlDbType.NVarChar,-1), new SqlParameter("@SettingCategory", SqlDbType.NVarChar,50), new SqlParameter("@DisplayName", SqlDbType.NVarChar,50), new SqlParameter("@OrderNumber", SqlDbType.Int,4), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@IsInnerSetting", SqlDbType.Int,4)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.SettingKey; parameters[2].Value = model.SettingValue; parameters[3].Value = model.SettingDesc; parameters[4].Value = model.SettingCategory; parameters[5].Value = model.DisplayName; parameters[6].Value = model.OrderNumber; parameters[7].Value = model.CanUsable; parameters[8].Value = model.IsInnerSetting; DbHelperSQL.RunProcedure("GeneralBasicSetting_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.EnterpriseServiceInfoListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@EnterpriseServiceInfoID", SqlDbType.Int,4), new SqlParameter("@EnterpriseServiceTypeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceInfoGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceInfoTitle", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseServiceInfointroduction", SqlDbType.NVarChar,200), new SqlParameter("@EnterpriseServiceInfoContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.EnterpriseServiceTypeGUID; parameters[2].Value = Guid.NewGuid(); parameters[3].Value = model.EnterpriseServiceInfoTitle; parameters[4].Value = model.EnterpriseServiceInfointroduction; parameters[5].Value = model.EnterpriseServiceInfoContent; parameters[6].Value = model.PublishID; parameters[7].Value = model.PublishDate; parameters[8].Value = model.IsEnable; parameters[9].Value = model.Other01; parameters[10].Value = model.Other02; DbHelperSQL.RunProcedure("EnterpriseServiceInfoList_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.GeneralActivityModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ActivityID", SqlDbType.Int,4), new SqlParameter("@ActivityGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ActivityType", SqlDbType.Int,4), new SqlParameter("@ActivityKind", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ActivityCategory", SqlDbType.NVarChar,50), new SqlParameter("@ActivityDate", SqlDbType.DateTime), new SqlParameter("@ActivityAreaCode", SqlDbType.NVarChar,50), new SqlParameter("@ActivityAreaDetails", SqlDbType.NVarChar,200), new SqlParameter("@ActivityAddress", SqlDbType.NVarChar,200), new SqlParameter("@ActivityAddressDetails", SqlDbType.NVarChar,200), new SqlParameter("@ActivityTitle", SqlDbType.NVarChar,50), new SqlParameter("@ActivityDesc", SqlDbType.NVarChar,-1), new SqlParameter("@ActivitySummary", SqlDbType.NVarChar,-1), new SqlParameter("@ActivityAddon", SqlDbType.NVarChar,-1), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@CreateUserKey", SqlDbType.NVarChar,50), new SqlParameter("@CreateUserName", SqlDbType.NVarChar,50), new SqlParameter("@SpecialType", SqlDbType.Int,4), new SqlParameter("@JoinUserCount", SqlDbType.Int,4), new SqlParameter("@ActivityReviewDetails", SqlDbType.NVarChar,-1), new SqlParameter("@ActivityReviewKey", SqlDbType.NVarChar,50), new SqlParameter("@ActivityReviewTarget", SqlDbType.NVarChar,200), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.ActivityType; parameters[3].Value = Guid.NewGuid(); parameters[4].Value = model.ActivityCategory; parameters[5].Value = model.ActivityDate; parameters[6].Value = model.ActivityAreaCode; parameters[7].Value = model.ActivityAreaDetails; parameters[8].Value = model.ActivityAddress; parameters[9].Value = model.ActivityAddressDetails; parameters[10].Value = model.ActivityTitle; parameters[11].Value = model.ActivityDesc; parameters[12].Value = model.ActivitySummary; parameters[13].Value = model.ActivityAddon; parameters[14].Value = model.PublishDate; parameters[15].Value = model.CanUsable; parameters[16].Value = model.CreateUserKey; parameters[17].Value = model.CreateUserName; parameters[18].Value = model.SpecialType; parameters[19].Value = model.JoinUserCount; parameters[20].Value = model.ActivityReviewDetails; parameters[21].Value = model.ActivityReviewKey; parameters[22].Value = model.ActivityReviewTarget; parameters[23].Value = model.PropertyNames; parameters[24].Value = model.PropertyValues; DbHelperSQL.RunProcedure("GeneralActivity_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.GeneralImageModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ImageID", SqlDbType.Int,4), new SqlParameter("@ImageGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ImageName", SqlDbType.NVarChar,200), new SqlParameter("@RelativeGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ImageCategoryCode", SqlDbType.NVarChar,50), new SqlParameter("@ImageKind", SqlDbType.NVarChar,50), new SqlParameter("@OwnerGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ImageRelativePath", SqlDbType.NVarChar,500), new SqlParameter("@ImageSize", SqlDbType.Int,4), new SqlParameter("@ImageWidth", SqlDbType.Int,4), new SqlParameter("@ImageHeight", SqlDbType.Int,4), new SqlParameter("@ImageStatus", SqlDbType.Int,4), new SqlParameter("@ImageOrder", SqlDbType.Int,4), new SqlParameter("@ImageIsMain", SqlDbType.Int,4), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@ImageType", SqlDbType.NVarChar,50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ImageDescription", SqlDbType.NVarChar,-1), new SqlParameter("@ImageDownCount", SqlDbType.Int,4), new SqlParameter("@ImageDisplayCount", SqlDbType.Int,4), new SqlParameter("@PropertyNames", SqlDbType.NText), new SqlParameter("@PropertyValues", SqlDbType.NText)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.ImageName; parameters[3].Value = Guid.NewGuid(); parameters[4].Value = model.ImageCategoryCode; parameters[5].Value = model.ImageKind; parameters[6].Value = Guid.NewGuid(); parameters[7].Value = model.ImageRelativePath; parameters[8].Value = model.ImageSize; parameters[9].Value = model.ImageWidth; parameters[10].Value = model.ImageHeight; parameters[11].Value = model.ImageStatus; parameters[12].Value = model.ImageOrder; parameters[13].Value = model.ImageIsMain; parameters[14].Value = model.CanUsable; parameters[15].Value = model.ImageType; parameters[16].Value = model.CreateTime; parameters[17].Value = model.ImageDescription; parameters[18].Value = model.ImageDownCount; parameters[19].Value = model.ImageDisplayCount; parameters[20].Value = model.PropertyNames; parameters[21].Value = model.PropertyValues; DbHelperSQL.RunProcedure("GeneralImage_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.JobEnterpriseResumeFavoriteModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@FavoriteID", SqlDbType.Int,4), new SqlParameter("@FavoriteGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@FavoriteStatus", SqlDbType.Int,4), new SqlParameter("@FavoriteType", SqlDbType.Int,4), new SqlParameter("@FavoriteCategory", SqlDbType.NVarChar,50), new SqlParameter("@FavoriteCustomCategory", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseKey", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseName", SqlDbType.NVarChar,50), new SqlParameter("@PersonResumeKey", SqlDbType.NVarChar,50), new SqlParameter("@PersonResumeName", SqlDbType.NVarChar,50), new SqlParameter("@PersonUserKey", SqlDbType.NVarChar,50), new SqlParameter("@PersonUserName", SqlDbType.NVarChar,50), new SqlParameter("@FavoriteMemo", SqlDbType.NVarChar,-1), new SqlParameter("@FavoriteDate", SqlDbType.DateTime), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Value = model.FavoriteID; parameters[1].Value = model.FavoriteGuid; parameters[2].Value = model.FavoriteStatus; parameters[3].Value = model.FavoriteType; parameters[4].Value = model.FavoriteCategory; parameters[5].Value = model.FavoriteCustomCategory; parameters[6].Value = model.EnterpriseKey; parameters[7].Value = model.EnterpriseName; parameters[8].Value = model.PersonResumeKey; parameters[9].Value = model.PersonResumeName; parameters[10].Value = model.PersonUserKey; parameters[11].Value = model.PersonUserName; parameters[12].Value = model.FavoriteMemo; parameters[13].Value = model.FavoriteDate; parameters[14].Value = model.PropertyNames; parameters[15].Value = model.PropertyValues; DbHelperSQL.RunProcedure("JobEnterpriseResumeFavorite_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.JobEnterpriseServiceModel model) { int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@EnterpriseServiceID", SqlDbType.Int,4), new SqlParameter("@EnterpriseServiceGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceStatus", SqlDbType.Int,4), new SqlParameter("@EnterpriseName", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseKey", SqlDbType.NVarChar,50), new SqlParameter("@JobPositionPublishAllowCount", SqlDbType.Int,4), new SqlParameter("@JobPositionPublishUsedCount", SqlDbType.Int,4), new SqlParameter("@EnterpriseServiceCurrentContractKey", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseServiceCurrentContractStartDate", SqlDbType.DateTime), new SqlParameter("@EnterpriseServiceCurrentContractEndDate", SqlDbType.DateTime), new SqlParameter("@ResumeDownAllowCount", SqlDbType.Int,4), new SqlParameter("@ResumeDownUsedCount", SqlDbType.Int,4), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Value = model.EnterpriseServiceID; parameters[1].Value = model.EnterpriseServiceGuid; parameters[2].Value = model.EnterpriseServiceStatus; parameters[3].Value = model.EnterpriseName; parameters[4].Value = model.EnterpriseKey; parameters[5].Value = model.JobPositionPublishAllowCount; parameters[6].Value = model.JobPositionPublishUsedCount; parameters[7].Value = model.EnterpriseServiceCurrentContractKey; parameters[8].Value = model.EnterpriseServiceCurrentContractStartDate; parameters[9].Value = model.EnterpriseServiceCurrentContractEndDate; parameters[10].Value = model.ResumeDownAllowCount; parameters[11].Value = model.ResumeDownUsedCount; parameters[12].Value = model.CanUsable; parameters[13].Value = model.PublishDate; parameters[14].Value = model.PropertyNames; parameters[15].Value = model.PropertyValues; DbHelperSQL.RunProcedure("JobEnterpriseService_Update",parameters,out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.JobEnterpriseServiceContractModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ServiceContractID", SqlDbType.Int,4), new SqlParameter("@ServiceContractGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceKey", SqlDbType.NVarChar,50), new SqlParameter("@ServiceContractStatus", SqlDbType.Int,4), new SqlParameter("@EnterpriseKey", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseName", SqlDbType.NVarChar,50), new SqlParameter("@ServiceContractStartDate", SqlDbType.DateTime), new SqlParameter("@ServiceContractEndDate", SqlDbType.DateTime), new SqlParameter("@ServiceContractMemo", SqlDbType.NVarChar,-1), new SqlParameter("@ServiceFee", SqlDbType.Decimal,9), new SqlParameter("@ServiceFeeIsPaid", SqlDbType.Int,4), new SqlParameter("@ServiceFeeManageUserName", SqlDbType.NVarChar,50), new SqlParameter("@ServiceFeeManageUserKey", SqlDbType.NVarChar,50), new SqlParameter("@CreateUserKey", SqlDbType.NVarChar,50), new SqlParameter("@CreateUserName", SqlDbType.NVarChar,50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.EnterpriseServiceKey; parameters[3].Value = model.ServiceContractStatus; parameters[4].Value = model.EnterpriseKey; parameters[5].Value = model.EnterpriseName; parameters[6].Value = model.ServiceContractStartDate; parameters[7].Value = model.ServiceContractEndDate; parameters[8].Value = model.ServiceContractMemo; parameters[9].Value = model.ServiceFee; parameters[10].Value = model.ServiceFeeIsPaid; parameters[11].Value = model.ServiceFeeManageUserName; parameters[12].Value = model.ServiceFeeManageUserKey; parameters[13].Value = model.CreateUserKey; parameters[14].Value = model.CreateUserName; parameters[15].Value = model.CreateDate; parameters[16].Value = model.CanUsable; parameters[17].Value = model.PropertyNames; parameters[18].Value = model.PropertyValues; DbHelperSQL.RunProcedure("JobEnterpriseServiceContract_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.PaidServicesListModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@PaidServicesID", SqlDbType.Int,4), new SqlParameter("@PaidServicesGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@PublishJobCount", SqlDbType.Int,4), new SqlParameter("@PublishJobPrice", SqlDbType.Float,8), new SqlParameter("@MainResumeCount", SqlDbType.Int,4), new SqlParameter("@MainResumePrice", SqlDbType.Float,8), new SqlParameter("@SearchStrangeResumeCount", SqlDbType.Int,4), new SqlParameter("@SearchStrangeResumePrice", SqlDbType.Float,8), new SqlParameter("@DownloadStrangeResumeCount", SqlDbType.Int,4), new SqlParameter("@DownloadStrangeResumePrice", SqlDbType.Float,8), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@PublishID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@JobAdLargePrice", SqlDbType.Float,8), new SqlParameter("@JobAdSmallPrice", SqlDbType.Float,8), new SqlParameter("@EmergencyRecruitmentPrice", SqlDbType.Float,8), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NChar,10), new SqlParameter("@Other03", SqlDbType.Int,4)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.PublishJobCount; parameters[3].Value = model.PublishJobPrice; parameters[4].Value = model.MainResumeCount; parameters[5].Value = model.MainResumePrice; parameters[6].Value = model.SearchStrangeResumeCount; parameters[7].Value = model.SearchStrangeResumePrice; parameters[8].Value = model.DownloadStrangeResumeCount; parameters[9].Value = model.DownloadStrangeResumePrice; parameters[10].Value = model.PublishDate; parameters[11].Value = model.PublishID; parameters[12].Value = model.JobAdLargePrice; parameters[13].Value = model.JobAdSmallPrice; parameters[14].Value = model.EmergencyRecruitmentPrice; parameters[15].Value = model.Other01; parameters[16].Value = model.Other02; parameters[17].Value = model.Other03; DbHelperSQL.RunProcedure("PaidServicesList_ADD",parameters,out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.GeneralFriendlyLinkModel model) { int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@LinkID", SqlDbType.Int,4), new SqlParameter("@LinkGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@LinkType", SqlDbType.Int,4), new SqlParameter("@LinkCategory", SqlDbType.NVarChar,50), new SqlParameter("@LinkTitle", SqlDbType.NVarChar,200), new SqlParameter("@LinkTargetUrl", SqlDbType.NVarChar,200), new SqlParameter("@LinkImageKey", SqlDbType.NVarChar,50), new SqlParameter("@LinkImagePath", SqlDbType.NVarChar,200), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@LinkDesc", SqlDbType.NVarChar,-1), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@LinkOrderNumber", SqlDbType.Int,4), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Value = model.LinkID; parameters[1].Value = model.LinkGuid; parameters[2].Value = model.LinkType; parameters[3].Value = model.LinkCategory; parameters[4].Value = model.LinkTitle; parameters[5].Value = model.LinkTargetUrl; parameters[6].Value = model.LinkImageKey; parameters[7].Value = model.LinkImagePath; parameters[8].Value = model.PublishDate; parameters[9].Value = model.LinkDesc; parameters[10].Value = model.CanUsable; parameters[11].Value = model.LinkOrderNumber; parameters[12].Value = model.PropertyNames; parameters[13].Value = model.PropertyValues; DbHelperSQL.RunProcedure("GeneralFriendlyLink_Update",parameters,out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.ResumeCollectionListModel model) { int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@ResumeCollectionID", SqlDbType.Int,4), new SqlParameter("@ResumeCollectionGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ResumeCollectionType", SqlDbType.Int,4), new SqlParameter("@ResumeGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseIsDel", SqlDbType.Int,4), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50), new SqlParameter("@Other04", SqlDbType.NVarChar,50), new SqlParameter("@Other05", SqlDbType.Int,4)}; parameters[0].Value = model.ResumeCollectionID; parameters[1].Value = model.ResumeCollectionGUID; parameters[2].Value = model.ResumeCollectionType; parameters[3].Value = model.ResumeGuid; parameters[4].Value = model.EnterpriseGuid; parameters[5].Value = model.EnterpriseIsDel; parameters[6].Value = model.IsEnable; parameters[7].Value = model.PublishDate; parameters[8].Value = model.Other01; parameters[9].Value = model.Other02; parameters[10].Value = model.Other03; parameters[11].Value = model.Other04; parameters[12].Value = model.Other05; DbHelperSQL.RunProcedure("ResumeCollectionList_Update",parameters,out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.JobEnterpriseResumeFavoriteModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@FavoriteID", SqlDbType.Int,4), new SqlParameter("@FavoriteGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@FavoriteStatus", SqlDbType.Int,4), new SqlParameter("@FavoriteType", SqlDbType.Int,4), new SqlParameter("@FavoriteCategory", SqlDbType.NVarChar,50), new SqlParameter("@FavoriteCustomCategory", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseKey", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseName", SqlDbType.NVarChar,50), new SqlParameter("@PersonResumeKey", SqlDbType.NVarChar,50), new SqlParameter("@PersonResumeName", SqlDbType.NVarChar,50), new SqlParameter("@PersonUserKey", SqlDbType.NVarChar,50), new SqlParameter("@PersonUserName", SqlDbType.NVarChar,50), new SqlParameter("@FavoriteMemo", SqlDbType.NVarChar,-1), new SqlParameter("@FavoriteDate", SqlDbType.DateTime), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.FavoriteStatus; parameters[3].Value = model.FavoriteType; parameters[4].Value = model.FavoriteCategory; parameters[5].Value = model.FavoriteCustomCategory; parameters[6].Value = model.EnterpriseKey; parameters[7].Value = model.EnterpriseName; parameters[8].Value = model.PersonResumeKey; parameters[9].Value = model.PersonResumeName; parameters[10].Value = model.PersonUserKey; parameters[11].Value = model.PersonUserName; parameters[12].Value = model.FavoriteMemo; parameters[13].Value = model.FavoriteDate; parameters[14].Value = model.PropertyNames; parameters[15].Value = model.PropertyValues; DbHelperSQL.RunProcedure("JobEnterpriseResumeFavorite_ADD", parameters, out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.EnterpriseServiceInfoListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@EnterpriseServiceInfoID", SqlDbType.Int,4), new SqlParameter("@EnterpriseServiceTypeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceInfoGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseServiceInfoTitle", SqlDbType.NVarChar,50), new SqlParameter("@EnterpriseServiceInfointroduction", SqlDbType.NVarChar,200), new SqlParameter("@EnterpriseServiceInfoContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Value = model.EnterpriseServiceInfoID; parameters[1].Value = model.EnterpriseServiceTypeGUID; parameters[2].Value = model.EnterpriseServiceInfoGUID; parameters[3].Value = model.EnterpriseServiceInfoTitle; parameters[4].Value = model.EnterpriseServiceInfointroduction; parameters[5].Value = model.EnterpriseServiceInfoContent; parameters[6].Value = model.PublishID; parameters[7].Value = model.PublishDate; parameters[8].Value = model.IsEnable; parameters[9].Value = model.Other01; parameters[10].Value = model.Other02; DbHelperSQL.RunProcedure("EnterpriseServiceInfoList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.ADImageListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@ADImageID", SqlDbType.Int,4), new SqlParameter("@ADImageGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@AdImageTitle", SqlDbType.NVarChar,50), new SqlParameter("@ADContent", SqlDbType.NVarChar,-1), new SqlParameter("@ADLink", SqlDbType.NVarChar,200), new SqlParameter("@ADImagePath", SqlDbType.NVarChar,200), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@IsHot", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Value = model.ADImageID; parameters[1].Value = model.ADImageGUID; parameters[2].Value = model.AdImageTitle; parameters[3].Value = model.ADContent; parameters[4].Value = model.ADLink; parameters[5].Value = model.ADImagePath; parameters[6].Value = model.PublishDate; parameters[7].Value = model.IsEnable; parameters[8].Value = model.IsHot; parameters[9].Value = model.Other01; parameters[10].Value = model.Other02; DbHelperSQL.RunProcedure("ADImageList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.ParticipatingCompaniesListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@ParticipatingCompaniesID", SqlDbType.Int,4), new SqlParameter("@ParticipatingCompaniesGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ParticipatingCompaniesContent", SqlDbType.NVarChar,-1), new SqlParameter("@IsShow", SqlDbType.Int,4), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50), new SqlParameter("@Other04", SqlDbType.NVarChar,50)}; parameters[0].Value = model.ParticipatingCompaniesID; parameters[1].Value = model.ParticipatingCompaniesGUID; parameters[2].Value = model.EnterpriseGuid; parameters[3].Value = model.ParticipatingCompaniesContent; parameters[4].Value = model.IsShow; parameters[5].Value = model.PublishDate; parameters[6].Value = model.IsEnable; parameters[7].Value = model.Other01; parameters[8].Value = model.Other02; parameters[9].Value = model.Other03; parameters[10].Value = model.Other04; DbHelperSQL.RunProcedure("ParticipatingCompaniesList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.RechargeListModel model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@RechargeID", SqlDbType.Int,4), new SqlParameter("@RechargeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@EnterpriseGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@UserGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@Expand_RechargeGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@RechargeSum", SqlDbType.Float,8), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50), new SqlParameter("@Other03", SqlDbType.NVarChar,50)}; parameters[0].Value = model.RechargeID; parameters[1].Value = model.RechargeGUID; parameters[2].Value = model.EnterpriseGuid; parameters[3].Value = model.UserGuid; parameters[4].Value = model.Expand_RechargeGUID; parameters[5].Value = model.RechargeSum; parameters[6].Value = model.PublishDate; parameters[7].Value = model.IsEnable; parameters[8].Value = model.Other01; parameters[9].Value = model.Other02; parameters[10].Value = model.Other03; DbHelperSQL.RunProcedure("RechargeList_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.ExchangeCornerListModel model) { int rowsAffected=0; SqlParameter[] parameters = { new SqlParameter("@ExchangeCornerID", SqlDbType.Int,4), new SqlParameter("@ExchangeCornerTypeKey", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerGUID", SqlDbType.UniqueIdentifier,16), new SqlParameter("@ExchangeCornerTitle", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerFilePath", SqlDbType.NVarChar,200), new SqlParameter("@ExchangeCornerFileSize", SqlDbType.NVarChar,50), new SqlParameter("@ExchangeCornerContent", SqlDbType.NVarChar,-1), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@IsEnable", SqlDbType.Int,4), new SqlParameter("@Other01", SqlDbType.NVarChar,50), new SqlParameter("@Other02", SqlDbType.NVarChar,50)}; parameters[0].Value = model.ExchangeCornerID; parameters[1].Value = model.ExchangeCornerTypeKey; parameters[2].Value = model.ExchangeCornerGUID; parameters[3].Value = model.ExchangeCornerTitle; parameters[4].Value = model.ExchangeCornerFilePath; parameters[5].Value = model.ExchangeCornerFileSize; parameters[6].Value = model.ExchangeCornerContent; parameters[7].Value = model.PublishDate; parameters[8].Value = model.IsEnable; parameters[9].Value = model.Other01; parameters[10].Value = model.Other02; DbHelperSQL.RunProcedure("ExchangeCornerList_Update",parameters,out rowsAffected); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.GeneralFriendlyLinkModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@LinkID", SqlDbType.Int,4), new SqlParameter("@LinkGuid", SqlDbType.UniqueIdentifier,16), new SqlParameter("@LinkType", SqlDbType.Int,4), new SqlParameter("@LinkCategory", SqlDbType.NVarChar,50), new SqlParameter("@LinkTitle", SqlDbType.NVarChar,200), new SqlParameter("@LinkTargetUrl", SqlDbType.NVarChar,200), new SqlParameter("@LinkImageKey", SqlDbType.NVarChar,50), new SqlParameter("@LinkImagePath", SqlDbType.NVarChar,200), new SqlParameter("@PublishDate", SqlDbType.DateTime), new SqlParameter("@LinkDesc", SqlDbType.NVarChar,-1), new SqlParameter("@CanUsable", SqlDbType.Int,4), new SqlParameter("@LinkOrderNumber", SqlDbType.Int,4), new SqlParameter("@PropertyNames", SqlDbType.NVarChar,-1), new SqlParameter("@PropertyValues", SqlDbType.NVarChar,-1)}; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = Guid.NewGuid(); parameters[2].Value = model.LinkType; parameters[3].Value = model.LinkCategory; parameters[4].Value = model.LinkTitle; parameters[5].Value = model.LinkTargetUrl; parameters[6].Value = model.LinkImageKey; parameters[7].Value = model.LinkImagePath; parameters[8].Value = model.PublishDate; parameters[9].Value = model.LinkDesc; parameters[10].Value = model.CanUsable; parameters[11].Value = model.LinkOrderNumber; parameters[12].Value = model.PropertyNames; parameters[13].Value = model.PropertyValues; DbHelperSQL.RunProcedure("GeneralFriendlyLink_ADD",parameters,out rowsAffected); return (int)parameters[0].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zlzw.Model.jjzpListModel model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zlzw.Model.jjzpListModel model) { return dal.Add(model); }