public ActionResult AddTerminalManufacturer(TerminalManufacturerAddModel model)
{
if (ModelState.IsValid)
{
var result = TerminalManufacturerBLL.AddTerminalManufacturer(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Add, result, "TerminalManufacturerName:" + model.ManufacturerName);
return(Json(result));
}
else
{
return(PartialView("_AddTerminalManufacturer", model));
}
}
public static OperationResult AddTerminalManufacturer(TerminalManufacturerAddModel model, int CreateUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ManufacturerName", SqlDbType.NVarChar, 200),
new SqlParameter("@ManufacturerCode", SqlDbType.Char, 5),
new SqlParameter("@Nationality", SqlDbType.Char, 6),
new SqlParameter("@CreateUserID", SqlDbType.Int)
};
paras[0].Value = model.ManufacturerName.Trim();
paras[1].Value = model.ManufacturerCode.Trim();
paras[2].Value = model.Nationality.Trim();
paras[3].Value = CreateUserID;
#region SQL
string sql = @"INSERT INTO dbo.TerminalManufacturer
( ManufacturerName ,
ManufacturerCode ,
Nationality,
CreateUserID
)
VALUES ( @ManufacturerName , -- ManufacturerName - nvarchar(20)
@ManufacturerCode, -- ManufacturerCode - char(5)
@Nationality, -- Nationality - char(6)
@CreateUserID
)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public ActionResult AddTerminalManufacturer()
{
TerminalManufacturerAddModel model = new TerminalManufacturerAddModel();
return(PartialView("_AddTerminalManufacturer", model));
}
