/// <summary>
/// 获取公告内容
/// </summary>
public static List <SMS.Model.Annunciate> GetAnnunciates(DateTime beginTime, DateTime endTime)
{
List <SMS.Model.Annunciate> list = new List <SMS.Model.Annunciate>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from plat_annunciate ");
strSql.Append(" where CreateTime>=@BeginTime and CreateTime<=@EndTime order by CreateTime desc");
MySqlParameter[] parameters =
{
new MySqlParameter("@BeginTime", MySqlDbType.DateTime),
new MySqlParameter("@EndTime", MySqlDbType.DateTime)
};
parameters[0].Value = beginTime;
parameters[1].Value = endTime;
SMS.Model.Annunciate model = new SMS.Model.Annunciate();
DataSet ds = DBUtility.MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables.Count == 0)
{
return(list);
}
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(DataRowToModel(row));
}
}
return(list);
}
/// <summary>
/// 根据帐号获取发布的公告
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public static List <SMS.Model.Annunciate> GetAnnunciateByAccount(string account)
{
List <SMS.Model.Annunciate> list = new List <SMS.Model.Annunciate>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from plat_annunciate ");
strSql.Append(" where AnnunciateAccount=@AnnunciateAccount order by CreateTime desc");
MySqlParameter[] parameters =
{
new MySqlParameter("@AnnunciateAccount", MySqlDbType.VarChar, 64)
};
parameters[0].Value = account;
SMS.Model.Annunciate model = new SMS.Model.Annunciate();
DataSet ds = DBUtility.MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables.Count == 0)
{
return(list);
}
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(DataRowToModel(row));
}
}
return(list);
}
public static SMS.Model.Annunciate GetAnnunciate(string annunciateID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from plat_annunciate ");
strSql.Append(" where AnnunciateID=@AnnunciateID");
MySqlParameter[] parameters =
{
new MySqlParameter("@AnnunciateID", MySqlDbType.VarChar, 64)
};
parameters[0].Value = annunciateID;
SMS.Model.Annunciate model = new SMS.Model.Annunciate();
DataSet ds = DBUtility.MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables.Count == 0)
{
return(null);
}
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
return(null);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(SMS.Model.Annunciate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update plat_annunciate set ");
strSql.Append("AnnunciateAccount=@AnnunciateAccount,");
strSql.Append("AnnunciateTitle=@AnnunciateTitle,");
strSql.Append("AnnunciateContent=@AnnunciateContent,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("AnnunciateType=@AnnunciateType,");
strSql.Append("UserLists=@UserLists");
strSql.Append(" where AnnunciateID=@AnnunciateID");
MySqlParameter[] parameters =
{
new MySqlParameter("@AnnunciateID", MySqlDbType.VarChar, 64),
new MySqlParameter("@AnnunciateAccount", MySqlDbType.VarChar, 64),
new MySqlParameter("@AnnunciateTitle", MySqlDbType.VarChar, 256),
new MySqlParameter("@AnnunciateContent", MySqlDbType.Text),
new MySqlParameter("@CreateTime", MySqlDbType.DateTime),
new MySqlParameter("@AnnunciateType", MySqlDbType.Int32, 11),
new MySqlParameter("@UserLists", MySqlDbType.LongText)
};
parameters[0].Value = model.AnnunciateID;
parameters[1].Value = model.AnnunciateAccount;
parameters[2].Value = model.AnnunciateTitle;
parameters[3].Value = model.AnnunciateContent;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.Type;
if (model.Users != null && model.Users.Count > 0)
{
string s = "";
foreach (var v in model.Users)
{
s += v + ",";
}
parameters[6].Value = s.Remove(s.Length - 1, 1);
}
else
{
parameters[6].Value = "";
}
int rows = DBUtility.MySqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(SMS.Model.Annunciate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into plat_annunciate(");
strSql.Append("AnnunciateID,AnnunciateAccount,AnnunciateTitle,AnnunciateContent,CreateTime,AnnunciateType,UserLists,PlatType)");
strSql.Append(" values (");
strSql.Append("@AnnunciateID,@AnnunciateAccount,@AnnunciateTitle,@AnnunciateContent,@CreateTime,@AnnunciateType,@UserLists,@PlatType)");
MySqlParameter[] parameters =
{
new MySqlParameter("@AnnunciateID", MySqlDbType.VarChar, 64),
new MySqlParameter("@AnnunciateAccount", MySqlDbType.VarChar, 64),
new MySqlParameter("@AnnunciateTitle", MySqlDbType.VarChar, 256),
new MySqlParameter("@AnnunciateContent", MySqlDbType.Text),
new MySqlParameter("@CreateTime", MySqlDbType.DateTime),
new MySqlParameter("@AnnunciateType", MySqlDbType.Int32, 11),
new MySqlParameter("@UserLists", MySqlDbType.LongText),
new MySqlParameter("@PlatType", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.AnnunciateID;
parameters[1].Value = model.AnnunciateAccount;
parameters[2].Value = model.AnnunciateTitle;
parameters[3].Value = model.AnnunciateContent;
parameters[4].Value = model.CreateTime;
parameters[5].Value = (int)model.Type;
if (model.Users != null && model.Users.Count > 0)
{
string s = "";
foreach (var v in model.Users)
{
s += v + ",";
}
parameters[6].Value = s.Remove(s.Length - 1, 1);
}
else
{
parameters[6].Value = "";
}
parameters[7].Value = (int)model.PlatType;
int rows = DBUtility.MySqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
static SMS.Model.Annunciate DataRowToModel(DataRow row)
{
SMS.Model.Annunciate model = new SMS.Model.Annunciate();
if (row != null)
{
if (row["AnnunciateID"] != null)
{
model.AnnunciateID = row["AnnunciateID"].ToString();
}
if (row["AnnunciateAccount"] != null)
{
model.AnnunciateAccount = row["AnnunciateAccount"].ToString();
}
if (row["AnnunciateTitle"] != null)
{
model.AnnunciateTitle = row["AnnunciateTitle"].ToString();
}
if (row["AnnunciateContent"] != null)
{
model.AnnunciateContent = row["AnnunciateContent"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["AnnunciateType"] != null && row["AnnunciateType"].ToString() != "")
{
model.Type = (SMS.Model.AnnunciateType) int.Parse(row["AnnunciateType"].ToString());
}
if (row["PlatType"] != null && row["PlatType"].ToString() != "")
{
model.PlatType = (SMS.Model.SysPlatType) int.Parse(row["PlatType"].ToString());
}
model.Users = new List <string>();
if (row["UserLists"] != null && row["UserLists"].ToString() != "")
{
foreach (var v in row["UserLists"].ToString().Split(','))
{
model.Users.Add(v);
}
}
}
return(model);
}
