/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ZQUSR.Model.sr_Message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sr_Message set ");
strSql.Append("Title=@Title,");
strSql.Append("MessContent=@MessContent,");
strSql.Append("FK_RecieverID=@FK_RecieverID,");
strSql.Append("FK_SenderID=@FK_SenderID,");
strSql.Append("SendTime=@SendTime,");
strSql.Append("IsRead=@IsRead");
strSql.Append(" where PK_MID=@PK_MID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_MID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@MessContent", SqlDbType.NVarChar, 500),
new SqlParameter("@FK_RecieverID", SqlDbType.NVarChar, 10),
new SqlParameter("@FK_SenderID", SqlDbType.NVarChar, 10),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@IsRead", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.PK_MID;
parameters[1].Value = model.Title;
parameters[2].Value = model.MessContent;
parameters[3].Value = model.FK_RecieverID;
parameters[4].Value = model.FK_SenderID;
parameters[5].Value = model.SendTime;
parameters[6].Value = model.IsRead;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZQUSR.Model.sr_Message GetModel(int PK_MID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PK_MID,Title,MessContent,FK_RecieverID,FK_SenderID,SendTime,IsRead from sr_Message ");
strSql.Append(" where PK_MID=@PK_MID ");
SqlParameter[] parameters =
{
new SqlParameter("@PK_MID", SqlDbType.Int, 4)
};
parameters[0].Value = PK_MID;
ZQUSR.Model.sr_Message model = new ZQUSR.Model.sr_Message();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["PK_MID"].ToString() != "")
{
model.PK_MID = int.Parse(ds.Tables[0].Rows[0]["PK_MID"].ToString());
}
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
model.MessContent = ds.Tables[0].Rows[0]["MessContent"].ToString();
model.FK_RecieverID = ds.Tables[0].Rows[0]["FK_RecieverID"].ToString();
model.FK_SenderID = ds.Tables[0].Rows[0]["FK_SenderID"].ToString();
if (ds.Tables[0].Rows[0]["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString());
}
if (ds.Tables[0].Rows[0]["IsRead"].ToString() != "")
{
model.IsRead = int.Parse(ds.Tables[0].Rows[0]["IsRead"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZQUSR.Model.sr_Message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sr_Message(");
strSql.Append("Title,MessContent,FK_RecieverID,FK_SenderID,SendTime,IsRead)");
strSql.Append(" values (");
strSql.Append("@Title,@MessContent,@FK_RecieverID,@FK_SenderID,@SendTime,@IsRead)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@MessContent", SqlDbType.NVarChar, 500),
new SqlParameter("@FK_RecieverID", SqlDbType.NVarChar, 10),
new SqlParameter("@FK_SenderID", SqlDbType.NVarChar, 10),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@IsRead", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.MessContent;
parameters[2].Value = model.FK_RecieverID;
parameters[3].Value = model.FK_SenderID;
parameters[4].Value = model.SendTime;
parameters[5].Value = model.IsRead;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public ZQUSR.Model.sr_Message GetModel(int PK_MID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 PK_MID,Title,MessContent,FK_RecieverID,FK_SenderID,SendTime,IsRead from sr_Message ");
strSql.Append(" where PK_MID=@PK_MID ");
SqlParameter[] parameters = {
new SqlParameter("@PK_MID", SqlDbType.Int,4)};
parameters[0].Value = PK_MID;
ZQUSR.Model.sr_Message model=new ZQUSR.Model.sr_Message();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["PK_MID"].ToString()!="")
{
model.PK_MID=int.Parse(ds.Tables[0].Rows[0]["PK_MID"].ToString());
}
model.Title=ds.Tables[0].Rows[0]["Title"].ToString();
model.MessContent=ds.Tables[0].Rows[0]["MessContent"].ToString();
model.FK_RecieverID=ds.Tables[0].Rows[0]["FK_RecieverID"].ToString();
model.FK_SenderID=ds.Tables[0].Rows[0]["FK_SenderID"].ToString();
if(ds.Tables[0].Rows[0]["SendTime"].ToString()!="")
{
model.SendTime=DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString());
}
if(ds.Tables[0].Rows[0]["IsRead"].ToString()!="")
{
model.IsRead=int.Parse(ds.Tables[0].Rows[0]["IsRead"].ToString());
}
return model;
}
else
{
return null;
}
}
