using System;
using System.Collections.Generic;
using Model;
using System.Data;
using System.Data.SqlClient; namespace DAL
{
/// <summary>
/// 发布活动信息
/// </summary>
public class ActivityBulletinDA
{
/// <summary>
/// 发布活动
/// </summary>
/// <param name="activityBulletin"></param>
/// <returns></returns>
public static int Save(Model.ActivityBulletin activityBulletin)
{
if (activityBulletin.ID.HasValue)
{
return Update(activityBulletin);
}
else
{
return Insert(activityBulletin);
} } /// <summary>
/// 执行插入
/// </summary>
/// <param name="activityBulletin"></param>
/// <returns></returns>
internal static int Insert(Model.ActivityBulletin activityBulletin)
{
activityBulletin.ID = Guid.NewGuid();
string sql = @" INSERT INTO [dbo].[ActivityBulletin]
(
[ID],
[AssociationsID],
[Title] ,
[Details] ,
[Type] ,
[SponsorEnterpriseName] ,
[LinkMan],
[Phone],
[beginTime] ,
[endTime] ,
[imgName],
[TIndex],
[Recommend]
)
VALUES (
@ID,
@AssociationsID,
@Title ,
@Details ,
@Type ,
@SponsorEnterpriseName ,
@LinkMan ,
@Phone ,
@beginTime ,
@endTime ,
@imgName,
@TIndex,
@Recommend
)";
List<SqlParameter> parms = new List<SqlParameter>();
parms.Add(SqlHelper.CreateParameter("@ID", activityBulletin.ID));
parms.Add(SqlHelper.CreateParameter("@AssociationsID", activityBulletin.AssociationsID));
parms.Add(SqlHelper.CreateParameter("@Title", activityBulletin.Title));
parms.Add(SqlHelper.CreateParameter("@Details", activityBulletin.Details));
parms.Add(SqlHelper.CreateEnumParamter("@Type", activityBulletin.Type));
parms.Add(SqlHelper.CreateParameter("@SponsorEnterpriseName", activityBulletin.SponsorEnterpriseName));
parms.Add(SqlHelper.CreateParameter("@LinkMan", activityBulletin.LinkMan));
parms.Add(SqlHelper.CreateParameter("@Phone", activityBulletin.Phone));
parms.Add(SqlHelper.CreateParameter("@beginTime", activityBulletin.BeginTime));
parms.Add(SqlHelper.CreateParameter("@endTime", activityBulletin.EndTime));
parms.Add(SqlHelper.CreateParameter("@imgName", activityBulletin.IMGName));
parms.Add(SqlHelper.CreateParameter("@TIndex", ));
parms.Add(SqlHelper.CreateParameter("@Recommend", )); string connStr = SqlConnectionHelper.GetConnection();
int resultCount = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, sql, parms.ToArray());
return resultCount;
} /// <summary>
/// 执行更新
/// </summary>
/// <param name="activityBulletin"></param>
/// <returns></returns>
public static int Update( Model.ActivityBulletin activityBulletin)
{
string sql = @" UPDATE [dbo].[ActivityBulletin]
SET
[title] = ISNULL(@title, title),
[Details] =ISNULL(@Details, Details),
[Type] = ISNULL(@Type, Type),
[SponsorEnterpriseName] = ISNULL(@SponsorEnterpriseName, SponsorEnterpriseName),
[LinkMan] = ISNULL(@LinkMan, LinkMan),
[Phone] =ISNULL(@Phone, Phone),
[beginTime]=ISNULL(@beginTime, beginTime),
[endTime]=ISNULL(@endTime, endTime),
[IMGName]=ISNULL(@IMGName, IMGName),
[TIndex]=ISNULL(@TIndex, TIndex),
[Recommend]=ISNULL(@Recommend, Recommend)
WHERE ID=@ID"; List<SqlParameter> parms = new List<SqlParameter>();
parms.Add(SqlHelper.CreateParameter("@ID", activityBulletin.ID));
parms.Add(SqlHelper.CreateParameter("@title", activityBulletin.Title));
parms.Add(SqlHelper.CreateParameter("@Details", activityBulletin.Details));
parms.Add(SqlHelper.CreateEnumParamter("@Type", activityBulletin.Type));
parms.Add(SqlHelper.CreateParameter("@SponsorEnterpriseName", activityBulletin.SponsorEnterpriseName));
parms.Add(SqlHelper.CreateParameter("@LinkMan", activityBulletin.LinkMan));
parms.Add(SqlHelper.CreateParameter("@beginTime", activityBulletin.BeginTime));
parms.Add(SqlHelper.CreateParameter("@endTime", activityBulletin.EndTime));
parms.Add(SqlHelper.CreateParameter("@Phone", activityBulletin.Phone));
parms.Add(SqlHelper.CreateParameter("@IMGName", activityBulletin.IMGName));
parms.Add(SqlHelper.CreateParameter("@TIndex", activityBulletin.TIndex));
parms.Add(SqlHelper.CreateParameter("@Recommend", activityBulletin.Recommend)); string connStr = SqlConnectionHelper.GetConnection();
int resultCount = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, sql, parms.ToArray());
return resultCount;
} public List<Model.ActivityBulletin> GetInfo(ActivityBulletinQueryEntity query)
{
return GetActivityBulletinList(query);
} public static int Delete(Guid? id)
{
int count = ;
if (id.HasValue)
{
string sql = "delete from [ActivityBulletin] where [ID]=@ID";
List<SqlParameter> parms = new List<SqlParameter>();
parms.Add(SqlHelper.CreateParameter("@ID", id));
string connStr = SqlConnectionHelper.GetConnection();
count = SqlHelper.ExecuteNonQuery(connStr, CommandType.Text, sql, parms.ToArray());
}
return count;
} /// <summary>
/// 根据查询条件获取活动信息集合
/// </summary>
/// <returns></returns>
public static List<Model.ActivityBulletin> GetActivityBulletinList(ActivityBulletinQueryEntity query)
{
List<Model.ActivityBulletin> result = new List<Model.ActivityBulletin>();
string tempStr = string.Empty;
List<SqlParameter> parms = new List<SqlParameter>();
parms.Add(SqlHelper.CreateParameter("@RowCount", query.TotalRecord));
parms[].Direction = ParameterDirection.Output;
parms.Add(SqlHelper.CreateParameter("@PageIndex", query.PageIndex));
parms.Add(SqlHelper.CreateParameter("@PageSize", query.PageSize));
parms.Add(SqlHelper.CreateEnumParamter("@Type", query.Type));
parms.Add(SqlHelper.CreateEnumParamter("@ID", query.ActivityID));
parms.Add(SqlHelper.CreateParameter("@AssociationsID", query.AssociationsID));
parms.Add(SqlHelper.CreateParameter("@TIndex", query.TIndex));
parms.Add(SqlHelper.CreateParameter("@BlurInfo", query.BlurInfo));
parms.Add(SqlHelper.CreateParameter("@EndTime", query.EndTime));
string connStr = SqlConnectionHelper.GetConnection();
using (IDataReader reader = SqlHelper.ExecuteReader(connStr, CommandType.StoredProcedure, "Proc_GetActivityBulletinList", parms.ToArray()))
{
while (reader.Read())
{
result.Add(new Model.ActivityBulletin
{
Title = SqlHelper.ReadNullableString(reader, ),
IMGName = SqlHelper.ReadNullableString(reader, ),
Details = SqlHelper.ReadNullableString(reader, ),
ID = SqlHelper.ReadNullableValue<Guid>(reader, ),
BeginTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Type = SqlHelper.ReadNullableEnum<AssociationsTypeEnum>(reader, ),
SponsorEnterpriseName= SqlHelper.ReadNullableString(reader, ),
LinkMan = SqlHelper.ReadNullableString(reader, ),
Phone = SqlHelper.ReadNullableString(reader, ),
EndTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Recommend = SqlHelper.ReadNullableValue<int>(reader, ),
AssociationsID = SqlHelper.ReadNullableValue<Guid>(reader,),
TIndex = SqlHelper.ReadNullableValue<int>(reader,)
});
}
}
query.TotalRecord = (int)parms[].Value;
return result;
}
/// <summary>
/// 前10活动信息集合
/// </summary>
/// <returns></returns>
public static List<Model.ActivityBulletin> GetActivityBulletinList()
{
List<Model.ActivityBulletin> result = new List<Model.ActivityBulletin>();
string sql = @" SELECT top 10 id,title,imgName,Details,beginTime,Type,SponsorEnterpriseName,
LinkMan,Phone,endTime,Recommend,AssociationsID,TIndex FROM
[dbo].[ActivityBulletin] order by TIndex";
string connStr = SqlConnectionHelper.GetConnection();
using (IDataReader reader = SqlHelper.ExecuteReader(connStr, CommandType.Text, sql, null))
{
while (reader.Read())
{
result.Add(new Model.ActivityBulletin
{
ID = SqlHelper.ReadNullableValue<Guid>(reader, ),
Title = SqlHelper.ReadNullableString(reader, ),
IMGName = SqlHelper.ReadNullableString(reader, ),
Details = SqlHelper.ReadNullableString(reader, ),
BeginTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Type = SqlHelper.ReadNullableEnum<AssociationsTypeEnum>(reader, ),
SponsorEnterpriseName = SqlHelper.ReadNullableString(reader, ),
LinkMan = SqlHelper.ReadNullableString(reader, ),
Phone = SqlHelper.ReadNullableString(reader, ),
EndTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Recommend = SqlHelper.ReadNullableValue<int>(reader, ),
AssociationsID = SqlHelper.ReadNullableValue<Guid>(reader, ),
TIndex = SqlHelper.ReadNullableValue<int>(reader, )
});
}
}
return result;
}
/// <summary>
/// 活动信息集合根据时间
/// </summary>
/// <returns></returns>
public static List<Model.ActivityBulletin> GetActivityBulletinList(int count)
{
List<Model.ActivityBulletin> result = new List<Model.ActivityBulletin>();
string sql = string.Format(@" SELECT top {0} id,title FROM
[dbo].[ActivityBulletin] order by InDate Desc",count);
string connStr = SqlConnectionHelper.GetConnection();
using (IDataReader reader = SqlHelper.ExecuteReader(connStr, CommandType.Text, sql, null))
{
while (reader.Read())
{
result.Add(new Model.ActivityBulletin
{
ID = SqlHelper.ReadNullableValue<Guid>(reader, ),
Title = SqlHelper.ReadNullableString(reader, )
});
}
}
return result;
}
public static List<ActivityBulletin> GetMyActivityBulletinList(ActivityBulletinQueryEntity query)
{
List<Model.ActivityBulletin> result = new List<Model.ActivityBulletin>();
string tempStr = string.Empty; List<SqlParameter> parms = new List<SqlParameter>();
parms.Add(SqlHelper.CreateParameter("@RowCount", query.TotalRecord));
parms[].Direction = ParameterDirection.Output;
parms.Add(SqlHelper.CreateParameter("@PageIndex", query.PageIndex));
parms.Add(SqlHelper.CreateParameter("@PageSize", query.PageSize));
parms.Add(SqlHelper.CreateEnumParamter("@Type", query.Type));
parms.Add(SqlHelper.CreateEnumParamter("@ID", query.ActivityID));
parms.Add(SqlHelper.CreateParameter("@AssociationsID", query.AssociationsID));
parms.Add(SqlHelper.CreateParameter("@TIndex", query.TIndex));
parms.Add(SqlHelper.CreateParameter("@BlurInfo", query.BlurInfo));
parms.Add(SqlHelper.CreateParameter("@EndTime", query.EndTime));
parms.Add(SqlHelper.CreateParameter("@BeginTime", query.BeginTime)); string connStr = SqlConnectionHelper.GetConnection();
using (IDataReader reader = SqlHelper.ExecuteReader(connStr, CommandType.StoredProcedure, "Proc_GetMyActivityBulletinList", parms.ToArray()))
{
while (reader.Read())
{
result.Add(new Model.ActivityBulletin
{
Title = SqlHelper.ReadNullableString(reader, ),
IMGName = SqlHelper.ReadNullableString(reader, ),
Details = SqlHelper.ReadNullableString(reader, ),
ID = SqlHelper.ReadNullableValue<Guid>(reader, ),
BeginTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Type = SqlHelper.ReadNullableEnum<AssociationsTypeEnum>(reader, ),
SponsorEnterpriseName = SqlHelper.ReadNullableString(reader, ),
LinkMan = SqlHelper.ReadNullableString(reader, ),
Phone = SqlHelper.ReadNullableString(reader, ),
EndTime = SqlHelper.ReadNullableValue<DateTime>(reader, ),
Recommend = SqlHelper.ReadNullableValue<int>(reader, ),
AssociationsID = SqlHelper.ReadNullableValue<Guid>(reader, ),
TIndex = SqlHelper.ReadNullableValue<int>(reader, )
});
}
}
query.TotalRecord = (int)parms[].Value;
return result;
}
}
}
相关推荐
python开发_常用的python模块及安装方法
adodb：我们领导推荐的数据库连接组件bsddb3：BerkeleyDB的连接组件Cheetah-1.0：我比较喜欢这个版本的cheeta…
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接：http://www.codeforces.com/contest/660/problem/CDes…
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式，并且由于涉及到要把拍到的照片显…
