/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ShiMiao.Model.TD_Donation_Info model, string tranID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TD_Donation_Info(");
strSql.Append("DonationID,Title,ImageURL,Content,ReadCount,IsImage,IsDeleted,CreateTime,CreatorID,CreatorName,UpdateTime,UpdaterID,UpdaterName,PublishOrgID,PublishOrgName");
strSql.Append(") values (");
strSql.Append("@DonationID,@Title,@ImageURL,@Content,@ReadCount,@IsImage,@IsDeleted,@CreateTime,@CreatorID,@CreatorName,@UpdateTime,@UpdaterID,@UpdaterName,@PublishOrgID,@PublishOrgName");
strSql.Append(") ");
MySqlParameter[] parameters =
{
new MySqlParameter("@DonationID", model.DonationID),
new MySqlParameter("@Title", model.Title),
new MySqlParameter("@ImageURL", model.ImageURL),
new MySqlParameter("@Content", model.Content),
new MySqlParameter("@ReadCount", model.ReadCount),
new MySqlParameter("@IsImage", model.IsImage),
new MySqlParameter("@IsDeleted", model.IsDeleted),
new MySqlParameter("@CreateTime", model.CreateTime),
new MySqlParameter("@CreatorID", model.CreatorID),
new MySqlParameter("@CreatorName", model.CreatorName),
new MySqlParameter("@UpdateTime", model.UpdateTime),
new MySqlParameter("@UpdaterID", model.UpdaterID),
new MySqlParameter("@UpdaterName", model.UpdaterName),
new MySqlParameter("@PublishOrgID", model.PublishOrgID),
new MySqlParameter("@PublishOrgName", model.PublishOrgName)
};
return(MySqlHelperUtil.ExecuteNonQuery(tranID, strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ShiMiao.Model.TD_Donation_Info model, string tranID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TD_Donation_Info set ");
strSql.Append(" DonationID = @DonationID , ");
strSql.Append(" Title = @Title , ");
strSql.Append(" ImageURL = @ImageURL , ");
strSql.Append(" Content = @Content , ");
strSql.Append(" ReadCount = @ReadCount , ");
strSql.Append(" IsImage = @IsImage , ");
strSql.Append(" IsDeleted = @IsDeleted , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" CreatorID = @CreatorID , ");
strSql.Append(" CreatorName = @CreatorName , ");
strSql.Append(" UpdateTime = @UpdateTime , ");
strSql.Append(" UpdaterID = @UpdaterID , ");
strSql.Append(" UpdaterName = @UpdaterName , ");
strSql.Append(" PublishOrgID = @PublishOrgID , ");
strSql.Append(" PublishOrgName = @PublishOrgName ");
strSql.Append(" where DonationID=@DonationID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@DonationID", model.DonationID),
new MySqlParameter("@Title", model.Title),
new MySqlParameter("@ImageURL", model.ImageURL),
new MySqlParameter("@Content", model.Content),
new MySqlParameter("@ReadCount", model.ReadCount),
new MySqlParameter("@IsImage", model.IsImage),
new MySqlParameter("@IsDeleted", model.IsDeleted),
new MySqlParameter("@CreateTime", model.CreateTime),
new MySqlParameter("@CreatorID", model.CreatorID),
new MySqlParameter("@CreatorName", model.CreatorName),
new MySqlParameter("@UpdateTime", model.UpdateTime),
new MySqlParameter("@UpdaterID", model.UpdaterID),
new MySqlParameter("@UpdaterName", model.UpdaterName),
new MySqlParameter("@PublishOrgID", model.PublishOrgID),
new MySqlParameter("@PublishOrgName", model.PublishOrgName)
};
return(MySqlHelperUtil.ExecuteNonQuery(tranID, strSql.ToString(), parameters));
}
/// <summary>
/// 获得数据列表
/// </summary>
public IList <ShiMiao.Model.TD_Donation_Info> GetList(string where, string orderBy, IDictionary <string, object> dictParams)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DonationID, Title, ImageURL, Content, ReadCount, IsImage, IsDeleted, CreateTime, CreatorID, CreatorName, UpdateTime, UpdaterID, UpdaterName, PublishOrgID, PublishOrgName ");
strSql.Append(" FROM TD_Donation_Info ");
if (!string.IsNullOrEmpty(where))
{
strSql.AppendFormat(" where {0}", where);
}
if (!string.IsNullOrEmpty(orderBy))
{
strSql.AppendFormat(" order by {0}", orderBy);
}
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (dictParams != null)
{
foreach (var pair in dictParams)
{
MySqlParameter parameter = new MySqlParameter("@" + pair.Key, pair.Value);
parameters.Add(parameter);
}
}
IList <ShiMiao.Model.TD_Donation_Info> list = new List <ShiMiao.Model.TD_Donation_Info>();
using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters.ToArray()))
{
while (dr.Read())
{
ShiMiao.Model.TD_Donation_Info model = new ShiMiao.Model.TD_Donation_Info();
if (dr[0] != DBNull.Value)
{
model.DonationID = dr.GetString(0);
}
if (dr[1] != DBNull.Value)
{
model.Title = dr.GetString(1);
}
if (dr[2] != DBNull.Value)
{
model.ImageURL = dr.GetString(2);
}
if (dr[3] != DBNull.Value)
{
model.Content = dr.GetString(3);
}
if (dr[4] != DBNull.Value)
{
model.ReadCount = dr.GetInt32(4);
}
if (dr[5] != DBNull.Value)
{
model.IsImage = dr.GetString(5);
}
if (dr[6] != DBNull.Value)
{
model.IsDeleted = dr.GetString(6);
}
if (dr[7] != DBNull.Value)
{
model.CreateTime = dr.GetDateTime(7);
}
if (dr[8] != DBNull.Value)
{
model.CreatorID = dr.GetDecimal(8);
}
if (dr[9] != DBNull.Value)
{
model.CreatorName = dr.GetString(9);
}
if (dr[10] != DBNull.Value)
{
model.UpdateTime = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
model.UpdaterID = dr.GetDecimal(11);
}
if (dr[12] != DBNull.Value)
{
model.UpdaterName = dr.GetString(12);
}
if (dr[13] != DBNull.Value)
{
model.PublishOrgID = dr.GetDecimal(13);
}
if (dr[14] != DBNull.Value)
{
model.PublishOrgName = dr.GetString(14);
}
list.Add(model);
}
parameters.Clear();
return(list);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ShiMiao.Model.TD_Donation_Info GetModel(string DonationID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DonationID, Title, ImageURL, Content, ReadCount, IsImage, IsDeleted, CreateTime, CreatorID, CreatorName, UpdateTime, UpdaterID, UpdaterName, PublishOrgID, PublishOrgName ");
strSql.Append(" from TD_Donation_Info ");
strSql.Append(" where DonationID=@DonationID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@DonationID", DonationID)
};
ShiMiao.Model.TD_Donation_Info model = null;
using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters))
{
while (dr.Read())
{
model = new ShiMiao.Model.TD_Donation_Info();
if (dr[0] != DBNull.Value)
{
model.DonationID = dr.GetString(0);
}
if (dr[1] != DBNull.Value)
{
model.Title = dr.GetString(1);
}
if (dr[2] != DBNull.Value)
{
model.ImageURL = dr.GetString(2);
}
if (dr[3] != DBNull.Value)
{
model.Content = dr.GetString(3);
}
if (dr[4] != DBNull.Value)
{
model.ReadCount = dr.GetInt32(4);
}
if (dr[5] != DBNull.Value)
{
model.IsImage = dr.GetString(5);
}
if (dr[6] != DBNull.Value)
{
model.IsDeleted = dr.GetString(6);
}
if (dr[7] != DBNull.Value)
{
model.CreateTime = dr.GetDateTime(7);
}
if (dr[8] != DBNull.Value)
{
model.CreatorID = dr.GetDecimal(8);
}
if (dr[9] != DBNull.Value)
{
model.CreatorName = dr.GetString(9);
}
if (dr[10] != DBNull.Value)
{
model.UpdateTime = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
model.UpdaterID = dr.GetDecimal(11);
}
if (dr[12] != DBNull.Value)
{
model.UpdaterName = dr.GetString(12);
}
if (dr[13] != DBNull.Value)
{
model.PublishOrgID = dr.GetDecimal(13);
}
if (dr[14] != DBNull.Value)
{
model.PublishOrgName = dr.GetString(14);
}
}
return(model);
}
}
/// <summary>
/// 获取数据列表
/// </summary>
public IList <ShiMiao.Model.TD_Donation_Info> GetList(IList <Guid> list)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("CREATE TABLE #TEMP(id uniqueidentifier primary key)");
for (int i = 0; i < list.Count; i++)
{
sql.AppendFormat(" INSERT INTO #TEMP VALUES(@Parameter{0})", i);
sql.AppendLine();
}
sql.Append(" SELECT t1.DonationID, t1.Title, t1.ImageURL, t1.Content, t1.ReadCount, t1.IsImage, t1.IsDeleted, t1.CreateTime, t1.CreatorID, t1.CreatorName, t1.UpdateTime, t1.UpdaterID, t1.UpdaterName, t1.PublishOrgID, t1.PublishOrgName ");
sql.Append(" from TD_Donation_Info t1 INNER JOIN #TEMP t2 ON t1.DonationID=t2.id");
sql.Append(" drop table #TEMP");
List <MySqlParameter> parameters = new List <MySqlParameter>();
for (int i = 0; i < list.Count; i++)
{
MySqlParameter parameter = new MySqlParameter("@Parameter" + i.ToString(), list[i]);
parameters.Add(parameter);
}
IList <ShiMiao.Model.TD_Donation_Info> modelList = new List <ShiMiao.Model.TD_Donation_Info>();
using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(sql.ToString(), parameters.ToArray()))
{
while (dr.Read())
{
ShiMiao.Model.TD_Donation_Info model = new ShiMiao.Model.TD_Donation_Info();
if (dr[0] != DBNull.Value)
{
model.DonationID = dr.GetString(0);
}
if (dr[1] != DBNull.Value)
{
model.Title = dr.GetString(1);
}
if (dr[2] != DBNull.Value)
{
model.ImageURL = dr.GetString(2);
}
if (dr[3] != DBNull.Value)
{
model.Content = dr.GetString(3);
}
if (dr[4] != DBNull.Value)
{
model.ReadCount = dr.GetInt32(4);
}
if (dr[5] != DBNull.Value)
{
model.IsImage = dr.GetString(5);
}
if (dr[6] != DBNull.Value)
{
model.IsDeleted = dr.GetString(6);
}
if (dr[7] != DBNull.Value)
{
model.CreateTime = dr.GetDateTime(7);
}
if (dr[8] != DBNull.Value)
{
model.CreatorID = dr.GetDecimal(8);
}
if (dr[9] != DBNull.Value)
{
model.CreatorName = dr.GetString(9);
}
if (dr[10] != DBNull.Value)
{
model.UpdateTime = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
model.UpdaterID = dr.GetDecimal(11);
}
if (dr[12] != DBNull.Value)
{
model.UpdaterName = dr.GetString(12);
}
if (dr[13] != DBNull.Value)
{
model.PublishOrgID = dr.GetDecimal(13);
}
if (dr[14] != DBNull.Value)
{
model.PublishOrgName = dr.GetString(14);
}
modelList.Add(model);
}
parameters.Clear();
return(modelList);
}
}
