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