public ActionResult AddReceiverMailInfo() { ReceiverMailInfoFormModel model = new ReceiverMailInfoFormModel(); model.Status = true; return(PartialView("_AddReceiverMailInfo", model)); }
public static SelectResult <ReceiverMailInfoFormModel> GetReceiverMailInfo(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@id", SqlDbType.Int), }; paras[0].Value = id; string sql = @" select ID ,Email,Name,Remark,Status FROM dbo.ReceiverMailInfo WHERE ID=@id"; List <ReceiverMailInfoFormModel> list = ConvertToList <ReceiverMailInfoFormModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); ReceiverMailInfoFormModel data = null; string msg = string.Empty; if (list == null) { msg = PromptInformation.DBError; } else if (list.Count == 0) { msg = PromptInformation.NotExists; } else { data = list[0]; } return(new SelectResult <ReceiverMailInfoFormModel>() { DataResult = data, Message = msg }); }
public static OperationResult AddReceiverMailInfo(ReceiverMailInfoFormModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@Email", SqlDbType.NVarChar, 60), new SqlParameter("@Name", SqlDbType.NVarChar, 20), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@Status", SqlDbType.TinyInt), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@CreateTime", SqlDbType.DateTime), }; if (string.IsNullOrWhiteSpace(model.Email)) { paras[0].Value = DBNull.Value; } else { paras[0].Value = model.Email.Trim(); } if (string.IsNullOrWhiteSpace(model.Name)) { paras[1].Value = DBNull.Value; } else { paras[1].Value = model.Name.Trim(); } if (string.IsNullOrWhiteSpace(model.Remark)) { paras[2].Value = DBNull.Value; } else { paras[2].Value = model.Remark; } paras[3].Value = model.Status; paras[4].Value = CreateUserID; paras[5].Value = DateTime.Now; string sql = @"INSERT INTO dbo.ReceiverMailInfo(Email,Name,Remark,Status,CreateUserID,CreateTime) VALUES (@Email,@Name,@Remark,@Status,@CreateUserID,@CreateTime)"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult EditReceiverMailInfo(ReceiverMailInfoFormModel model) { if (ModelState.IsValid) { var result = ReceiverMailInfoBLL.EditReceiverMailInfo(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID); return(Json(result)); } else { return(PartialView("_EditReceiverMailInfo", model)); } }
public ActionResult EditReceiverMailInfo(int id) { SelectResult <ReceiverMailInfoFormModel> result = ReceiverMailInfoBLL.GetReceiverMailInfo(id); if (result.DataResult == null) { return(Content(result.Message)); } ReceiverMailInfoFormModel model = result.DataResult; return(PartialView("_EditReceiverMailInfo", model)); }
public ActionResult AddReceiverMailInfo(ReceiverMailInfoFormModel model) { OperationResult result; if (ModelState.IsValid) { result = ReceiverMailInfoBLL.AddReceiverMailInfo(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "Email:" + model.Email); return(Json(result)); } else { return(PartialView("_AddReceiverMailInfo", model)); } }
public static OperationResult EditReceiverMailInfo(ReceiverMailInfoFormModel model, int EditUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@Email", SqlDbType.NVarChar, 60), new SqlParameter("@Name", SqlDbType.NVarChar, 20), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@Status", SqlDbType.TinyInt), new SqlParameter("@UpdateUserID", SqlDbType.Int), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int), }; if (string.IsNullOrWhiteSpace(model.Email)) { paras[0].Value = DBNull.Value; } else { paras[0].Value = model.Email.Trim(); } if (string.IsNullOrWhiteSpace(model.Name)) { paras[1].Value = DBNull.Value; } else { paras[1].Value = model.Name.Trim(); } if (string.IsNullOrWhiteSpace(model.Remark)) { paras[2].Value = DBNull.Value; } else { paras[2].Value = model.Remark; } paras[3].Value = model.Status; paras[4].Value = EditUserID; paras[5].Value = DateTime.Now; paras[6].Value = model.ID; string sql; sql = @"UPDATE dbo.ReceiverMailInfo SET Email=@Email,Name = @Name,Remark=@Remark, Status=@Status,UpdateUserID = @UpdateUserID,UpdateTime = @UpdateTime WHERE ID = @ID"; int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()); string msg = string.Empty; switch (result) { case 1: msg = PromptInformation.OperationSuccess; break; case 0: msg = PromptInformation.NotExists; break; case -1: msg = PromptInformation.DBError; break; } return(new OperationResult() { Success = result > 0, Message = msg }); }