public ReturnState AddLeaveMsg(LeaveMsgModel model) { var filters = new UtilityService().GetFilterLisst(); model.Content = Utilities.Filter(model.Content, filters); return(MarketOperator.AddLeaveMsg(model) ? ReturnState.ReturnOK : ReturnState.ReturnError); }
public ReturnState AddLeaveMsg(LeaveMsgModel model) { ReturnState result; marketClient.AddLeaveMsg(model, out result, out specify); return(result); }
public static LeaveMsgModel SqlReaderLeaveMsg(SqlDataReader reader) { var model = new LeaveMsgModel(); model.Id = Convert.ToInt32(reader.GetValue(0)); model.Gid = Convert.ToInt32(reader.GetValue(1)); model.Email = Convert.ToString(reader.GetValue(2)); model.PubDate = Convert.ToDateTime(reader.GetValue(3)); model.Content = Convert.ToString(reader.GetValue(4)); model.Floor = Convert.ToInt32(reader.GetValue(5)); return(model); }
public static bool AddLeaveMsg(LeaveMsgModel model) { var result = false; using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmdText = string.Format("insert into LeaveMsg values({0}, N'{1}', '{2}', N'{3}', {4})", model.Gid, model.Email, DateTime.Now, model.Content, GetValidFloorByGid(model.Gid)); using (var cmd = new SqlCommand(cmdText, conn)) { result = cmd.ExecuteNonQuery() > 0; conn.Close(); } } return(result); }
public static LeaveMsgModel QueryLeaveMsgById(int id) { LeaveMsgModel result = null; using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmdText = string.Format("select * from LeaveMsg where Id = {0}", id); using (var cmd = new SqlCommand(cmdText, conn)) { var reader = cmd.ExecuteReader(); if (reader.HasRows) { result = SqlReaderLeaveMsg(reader); } conn.Close(); } } return(result); }