public ActionResult AddCLCS_ReturnOrder()
{
AddCLCS_ReturnOrderModel model = new AddCLCS_ReturnOrderModel();
//model.StartTime = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
// model.EndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
return(PartialView("AddCLCS_ReturnOrder", model));
}
public static OperationResult AddCLCS_ReturnOrder(AddCLCS_ReturnOrderModel model, int currentUserID)
{
#region 参数
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@PlateNum", SqlDbType.NVarChar),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@ReturnMileage", SqlDbType.Float),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int),
};
paras[0].Value = model.PlateNum;
paras[1].Value = Convert.ToDateTime(model.StartTime);
paras[2].Value = Convert.ToDateTime(model.EndTime);
paras[3].Value = model.ReturnMileage;
if (string.IsNullOrEmpty(model.Remark))
{
paras[4].Value = DBNull.Value;
}
else
{
paras[4].Value = model.Remark;
}
paras[5].Value = DateTime.Now;
paras[6].Value = currentUserID;
#endregion
#region SQL
string sql = @"INSERT INTO dbo.CLCS_MileageManage
( PlateNum ,
StartTime ,
EndTime ,
ReturnMileage ,
Remark ,
CreateTime ,
CreateUserID
)
VALUES ( @PlateNum ,
@StartTime ,
@EndTime ,
@ReturnMileage ,
@Remark ,
@CreateTime ,
@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 AddCLCS_ReturnOrder(AddCLCS_ReturnOrderModel model)
{
if (ModelState.IsValid)
{
var result = CLCS_ReturnOrderManageBLL.AddCLCS_ReturnOrder(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Add, result, "CLCS_ReturnOrderPlateNum:" + model.PlateNum);
return(Json(result));
}
else
{
model.StartTime = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
model.EndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
return(PartialView("AddCLCS_ReturnOrder", model));
}
}
