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