/// <summary> /// 修改车辆信息 /// </summary> /// <param name="CarInfoM">车辆信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateCarInfo(CarInfoModel CarInfoM) { return CarInfoDBHelper.UpdateCarInfo(CarInfoM); }
/// <summary> /// 添加车辆信息 /// </summary> /// <param name="CarInfoM">车辆信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddCarInfo(CarInfoModel CarInfoM) { try { #region 添加车辆信息SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.CarInfo"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,CarNo "); sql.AppendLine(" ,CarName "); sql.AppendLine(" ,CarMark "); sql.AppendLine(" ,CarType "); sql.AppendLine(" ,Factory "); sql.AppendLine(" ,Displacement "); sql.AppendLine(" ,SeatCount "); sql.AppendLine(" ,Carrying "); sql.AppendLine(" ,FuelType "); sql.AppendLine(" ,EngineNo "); sql.AppendLine(" ,BuyMoney "); sql.AppendLine(" ,BuyDate "); sql.AppendLine(" ,Motorman "); sql.AppendLine(" ,VendorName "); sql.AppendLine(" ,VendorAddress "); sql.AppendLine(" ,Contact "); sql.AppendLine(" ,ContactTel "); sql.AppendLine(" ,Status "); sql.AppendLine(" ,Creator "); sql.AppendLine(" ,CreateDate "); sql.AppendLine(" ,Remark "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine("VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@CarNo "); sql.AppendLine(" ,@CarName "); sql.AppendLine(" ,@CarMark "); sql.AppendLine(" ,@CarType "); sql.AppendLine(" ,@Factory "); sql.AppendLine(" ,@Displacement "); sql.AppendLine(" ,@SeatCount "); sql.AppendLine(" ,@Carrying "); sql.AppendLine(" ,@FuelType "); sql.AppendLine(" ,@EngineNo "); sql.AppendLine(" ,@BuyMoney "); sql.AppendLine(" ,@BuyDate "); sql.AppendLine(" ,@Motorman "); sql.AppendLine(" ,@VendorName "); sql.AppendLine(" ,@VendorAddress "); sql.AppendLine(" ,@Contact "); sql.AppendLine(" ,@ContactTel "); sql.AppendLine(" ,@Status "); sql.AppendLine(" ,@Creator "); sql.AppendLine(" ,@CreateDate "); sql.AppendLine(" ,@Remark "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); #endregion #region 添加车辆信息参数设置 SqlParameter[] param; param = new SqlParameter[24]; param[0] = SqlHelper.GetParameter("@CompanyCD", CarInfoM.CompanyCD); param[1] = SqlHelper.GetParameter("@CarNo", CarInfoM.CarNo); param[2] = SqlHelper.GetParameter("@CarName", CarInfoM.CarName); param[3] = SqlHelper.GetParameter("@CarMark", CarInfoM.CarMark); param[4] = SqlHelper.GetParameter("@CarType", CarInfoM.CarType); param[5] = SqlHelper.GetParameter("@Factory", CarInfoM.Factory); param[6] = SqlHelper.GetParameter("@Displacement",Convert.ToDecimal(CarInfoM.Displacement)); param[7] = SqlHelper.GetParameter("@SeatCount", CarInfoM.SeatCount); param[8] = SqlHelper.GetParameter("@Carrying", CarInfoM.Carrying); param[9] = SqlHelper.GetParameter("@FuelType", CarInfoM.FuelType); param[10] = SqlHelper.GetParameter("@EngineNo", CarInfoM.EngineNo); param[11] = SqlHelper.GetParameter("@BuyMoney", CarInfoM.BuyMoney); param[12] = SqlHelper.GetParameter("@BuyDate", CarInfoM.BuyDate); param[13] = SqlHelper.GetParameter("@Motorman", CarInfoM.Motorman); param[14] = SqlHelper.GetParameter("@VendorName", CarInfoM.VendorName); param[15] = SqlHelper.GetParameter("@VendorAddress", CarInfoM.VendorAddress); param[16] = SqlHelper.GetParameter("@Contact", CarInfoM.Contact); param[17] = SqlHelper.GetParameter("@ContactTel", CarInfoM.ContactTel); param[18] = SqlHelper.GetParameter("@Status", CarInfoM.Status); param[19] = SqlHelper.GetParameter("@Creator", CarInfoM.Creator); param[20] = SqlHelper.GetParameter("@CreateDate", CarInfoM.CreateDate); param[21] = SqlHelper.GetParameter("@Remark", CarInfoM.Remark); param[22] = SqlHelper.GetParameter("@ModifiedDate", CarInfoM.ModifiedDate); param[23] = SqlHelper.GetParameter("@ModifiedUserID", CarInfoM.ModifiedUserID); #endregion SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }
/// <summary> /// 添加车辆信息 /// </summary> /// <param name="CarInfoM">车辆信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddCarInfo(CarInfoModel CarInfoM) { return CarInfoDBHelper.AddCarInfo(CarInfoM); }