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
});
}
