public Messagesinfo Messages_Sel_MessageID(int id) { Messagesinfo x = new Messagesinfo(); DataTable a = new DataTable(); Messagesdal t = new Messagesdal(); a = t.Messages_Sel_MessageID(id).Tables[0]; x.MessageID = id; if (a.Rows[0]["MessageSubject"].ToString() != string.Empty) { x.MessageSubject = a.Rows[0]["MessageSubject"].ToString(); } if (a.Rows[0]["MessageBody"].ToString() != string.Empty) { x.MessageBody = a.Rows[0]["MessageBody"].ToString(); } if (a.Rows[0]["FileAttach"].ToString() != string.Empty) { x.FileAttach = a.Rows[0]["FileAttach"].ToString(); } if (a.Rows[0]["MessageHot"].ToString() != string.Empty) { x.MessageHot = bool.Parse(a.Rows[0]["MessageHot"].ToString()); } return(x); }
public bool NewsAdd(Messagesinfo x) { Messagesdal t = new Messagesdal(); try { //t.NewsAdd2(x); } catch { } return(t.NewsAdd(x)); }
public bool NewsUps(Messagesinfo x) { Messagesdal t = new Messagesdal(); try { // t.NewsUpdate2(x); } catch { } return(t.NewsUpdate(x)); }
public Messagesinfo News_Sel_MessageID(int id) { Messagesinfo x = new Messagesinfo(); DataTable a = new DataTable(); Messagesdal t = new Messagesdal(); a = t.News_Sel_MessageID(id).Tables[0]; x.MessageID = id; if (a.Rows[0]["MessageSubject"].ToString() != string.Empty) { x.MessageSubject = a.Rows[0]["MessageSubject"].ToString(); } if (a.Rows[0]["MessageBody"].ToString() != string.Empty) { x.MessageBody = a.Rows[0]["MessageBody"].ToString(); } if (a.Rows[0]["MessageNote"].ToString() != string.Empty) { x.MessageNote = a.Rows[0]["MessageNote"].ToString(); } if (a.Rows[0]["FileAttach"].ToString() != string.Empty) { x.FileAttach = a.Rows[0]["FileAttach"].ToString(); } if (a.Rows[0]["CreationDate"].ToString() != string.Empty) { x.CreationDate = a.Rows[0]["CreationDate"].ToString(); } if (a.Rows[0]["SenderName"].ToString() != string.Empty) { x.SenderName = a.Rows[0]["SenderName"].ToString(); } if (a.Rows[0]["MessageCateID"].ToString() != string.Empty) { x.MessageCateID = int.Parse(a.Rows[0]["MessageCateID"].ToString()); } if ((a.Rows[0]["Note"].ToString() != string.Empty) && (a.Rows[0]["Note"].ToString() == "1")) { x.Note = 1; } else { x.Note = 0; } return(x); }
public bool MessageUpdate(Messagesinfo x) { Messagesdal t = new Messagesdal(); return(t.MessageUpdate(x)); }
public bool MessageUpdate(Messagesinfo x) { try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_psc_ws_Message_Ups"; // SqlParameter para; para = cmd.Parameters.Add("MessageID", SqlDbType.Int); para.Direction = ParameterDirection.Input; para.Value = x.MessageID; para = cmd.Parameters.Add("MessageSubject", SqlDbType.NVarChar); para.Direction = ParameterDirection.Input; if (x.MessageSubject == null) { para.Value = ""; } else { para.Value = x.MessageSubject; } para = cmd.Parameters.Add("MessageBody", SqlDbType.NText); para.Direction = ParameterDirection.Input; if (x.MessageBody == null) { para.Value = ""; } else { para.Value = x.MessageBody; } para = cmd.Parameters.Add("FileAttach", SqlDbType.VarChar); para.Direction = ParameterDirection.Input; if (x.FileAttach == null) { para.Value = DBNull.Value; } else { para.Value = x.FileAttach; } cmd.ExecuteNonQuery(); return(true); } catch { return(false); } finally { con.Close(); } }