public ActionResult AddTerminalType()
{
TerminalTypeAddModel model = new TerminalTypeAddModel();
model.Filter = true; //默认过滤
model.ACCOFF_Frequency = 180; //默认3分钟
model.ACCON_Frequency = 15; //默认15秒
model.TerminalManufacturerSelectList = new SelectList(TerminalManufacturerBLL.GetTerminalManufacturers(), "ID", "ManufacturerName");
return(PartialView("_AddTerminalType", model));
}
public ActionResult AddTerminalType(TerminalTypeAddModel model)
{
if (ModelState.IsValid)
{
var result = TerminalTypeBLL.AddTerminalType(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Add, result, "TerminalName:" + model.TerminalName);
return(Json(result));
}
else
{
model.TerminalManufacturerSelectList = new SelectList(TerminalManufacturerBLL.GetTerminalManufacturers(), "ID", "ManufacturerName");
return(PartialView("_AddTerminalType", model));
}
}
public static OperationResult AddTerminalType(TerminalTypeAddModel model, int CreateUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@TerminalName", SqlDbType.NVarChar, 200),
new SqlParameter("@TerminalManufacturerID", SqlDbType.Int),
new SqlParameter("@ACCON_Frequency", SqlDbType.Int),
new SqlParameter("@ACCOFF_Frequency", SqlDbType.Int),
new SqlParameter("@Filter", SqlDbType.Bit),
new SqlParameter("@CommunicationMode", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@CreateUserID", SqlDbType.Int),
};
paras[0].Value = model.TerminalName.Trim();
paras[1].Value = model.TerminalManufacturerID;
paras[2].Value = model.ACCON_Frequency;
paras[3].Value = model.ACCOFF_Frequency;
paras[4].Value = model.Filter;
if (string.IsNullOrWhiteSpace(model.CommunicationMode))
{
paras[5].Value = DBNull.Value;
}
else
{
paras[5].Value = model.CommunicationMode.Trim();
}
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[6].Value = DBNull.Value;
}
else
{
paras[6].Value = model.Remark.Trim();
}
paras[7].Value = CreateUserID;
#region SQL
string sql = @"INSERT INTO dbo.TerminalTypes
( TerminalName ,
TerminalManufacturerID ,
ACCON_Frequency ,
ACCOFF_Frequency ,
Filter ,
CommunicationMode ,
Remark,
CreateUserID
)
VALUES ( @TerminalName , -- TerminalName - nvarchar(20)
@TerminalManufacturerID , -- TerminalManufacturerID - int
@ACCON_Frequency , -- ACCON_Frequency - int
@ACCOFF_Frequency , -- ACCOFF_Frequency - int
@Filter , -- Filter - bit
@CommunicationMode , -- CommunicationMode - nvarchar(50)
@Remark, -- Remark - nvarchar(50)
@CreateUserID
)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
