/// <summary>
///根据SQL语句返回集合
/// </summary>
private IList <Tbl_Gbook> getTbl_GbooksBySql(string sql)
{
IList <Tbl_Gbook> list = new List <Tbl_Gbook>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_Gbook tbl_gbook = new Tbl_Gbook();
tbl_gbook.ID = Convert.ToInt32(dr["ID"]);
tbl_gbook.G_Title = Convert.ToString(dr["G_Title"]);
tbl_gbook.UserName = Convert.ToString(dr["UserName"]);
tbl_gbook.G_Content = Convert.ToString(dr["G_Content"]);
tbl_gbook.UserPwd = Convert.ToString(dr["UserPwd"]);
tbl_gbook.G_Reply = Convert.ToString(dr["G_Reply"]);
tbl_gbook.G_Name = Convert.ToString(dr["G_Name"]);
tbl_gbook.G_Phone = Convert.ToString(dr["G_Phone"]);
tbl_gbook.G_Mobile = Convert.ToString(dr["G_Mobile"]);
tbl_gbook.G_QQ = Convert.ToString(dr["G_QQ"]);
tbl_gbook.G_Email = Convert.ToString(dr["G_Email"]);
tbl_gbook.Status = Convert.ToString(dr["Status"]);
tbl_gbook.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_gbook.DealUser = Convert.ToString(dr["DealUser"]);
tbl_gbook.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_gbook.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_gbook);
}
}
return(list);
}
public static int UpdateTbl_Gbook(Tbl_Gbook tbl_gbook)
{
WebCommon.Public.WriteLog("ÐÞ¸ÄÁôÑÔ£º" + tbl_gbook.G_Content);
tbl_gbook.DealUser = WebCommon.Public.GetUserName();
tbl_gbook.DealTime = DateTime.Now;
return(new Tbl_GbookService().UpdateTbl_GbookById(tbl_gbook));
}
public int AddTbl_Gbook(Tbl_Gbook tbl_gbook)
{
string sql = "insert into [Tbl_Gbook] ([G_Title],[UserName],[G_Content],[UserPwd],[G_Reply],[G_Name],[G_Phone],[G_Mobile],[G_QQ],[G_Email],[Status],[DealUser]) values (@G_Title,@UserName,@G_Content,@UserPwd,@G_Reply,@G_Name,@G_Phone,@G_Mobile,@G_QQ,@G_Email,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@G_Title", tbl_gbook.G_Title),
new SqlParameter("@UserName", tbl_gbook.UserName),
new SqlParameter("@G_Content", tbl_gbook.G_Content),
new SqlParameter("@UserPwd", tbl_gbook.UserPwd),
new SqlParameter("@G_Reply", tbl_gbook.G_Reply),
new SqlParameter("@G_Name", tbl_gbook.G_Name),
new SqlParameter("@G_Phone", tbl_gbook.G_Phone),
new SqlParameter("@G_Mobile", tbl_gbook.G_Mobile),
new SqlParameter("@G_QQ", tbl_gbook.G_QQ),
new SqlParameter("@G_Email", tbl_gbook.G_Email),
new SqlParameter("@Status", tbl_gbook.Status),
new SqlParameter("@DealUser", tbl_gbook.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_GbookById(Tbl_Gbook tbl_gbook)
{
string sql = "update [Tbl_Gbook] set [G_Title]=@G_Title,[UserName]=@UserName,[G_Content]=@G_Content,[UserPwd]=@UserPwd,[G_Reply]=@G_Reply,[G_Name]=@G_Name,[G_Phone]=@G_Phone,[G_Mobile]=@G_Mobile,[G_QQ]=@G_QQ,[G_Email]=@G_Email,[Status]=@Status,[DealFlag]=@DealFlag,[DealUser]=@DealUser,[DealTime]=@DealTime where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@G_Title", tbl_gbook.G_Title),
new SqlParameter("@UserName", tbl_gbook.UserName),
new SqlParameter("@G_Content", tbl_gbook.G_Content),
new SqlParameter("@UserPwd", tbl_gbook.UserPwd),
new SqlParameter("@G_Reply", tbl_gbook.G_Reply),
new SqlParameter("@G_Name", tbl_gbook.G_Name),
new SqlParameter("@G_Phone", tbl_gbook.G_Phone),
new SqlParameter("@G_Mobile", tbl_gbook.G_Mobile),
new SqlParameter("@G_QQ", tbl_gbook.G_QQ),
new SqlParameter("@G_Email", tbl_gbook.G_Email),
new SqlParameter("@Status", tbl_gbook.Status),
new SqlParameter("@DealFlag", tbl_gbook.DealFlag),
new SqlParameter("@DealUser", tbl_gbook.DealUser),
new SqlParameter("@DealTime", tbl_gbook.DealTime.ToString()),
new SqlParameter("@ID", tbl_gbook.ID)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_Gbook(Tbl_Gbook tbl_gbook)
{
WebCommon.Public.WriteLog("Ìí¼ÓÁôÑÔ£º" + tbl_gbook.G_Content);
return(new Tbl_GbookService().AddTbl_Gbook(tbl_gbook));
}
