/// <summary> /// 添加车辆维修信息 /// </summary> /// <param name="RepairInfos">车辆维修信息</param> /// <param name="userID">用户ID</param> /// <param name="CompanyID">公司代码</param> /// <returns>成功:true,失败:false</returns> public static bool AddCarRepairInfo(string RepairInfos, string userID, string CompanyID, int Employeeid) { try { CarRepairModel CarRepairM = new CarRepairModel(); string[] GasInfoArrary = RepairInfos.Split('|'); SqlCommand[] comms = new SqlCommand[GasInfoArrary.Length - 1]; //申明cmd数组 DateTime NowDate = System.DateTime.Now; string recorditems = ""; string[] gasfield = null; for (int i = 1; i < GasInfoArrary.Length; i++) //循环数组 { recorditems = GasInfoArrary[i].ToString(); gasfield = recorditems.Split(','); string CarNo = gasfield[0].ToString(); //车辆编号 string CarMark = gasfield[1].ToString(); //车牌号 string User = gasfield[2].ToString(); //经办人 string Factory = gasfield[3].ToString(); //修理厂 string HappenDate = gasfield[4].ToString(); //维修日期 string RepairReason = gasfield[5].ToString(); //维修原因 string RepairFee = gasfield[6].ToString(); //维修费用 string BillNo = gasfield[7].ToString(); //相关票据号 string Remark = gasfield[8].ToString(); //备注 CarRepairM.BillNo = BillNo; CarRepairM.CarNo = CarNo; CarRepairM.CompanyCD = CompanyID; CarRepairM.EmployeeID = Convert.ToInt32(User); CarRepairM.Fee = Convert.ToDecimal(RepairFee); CarRepairM.Factory = Factory; CarRepairM.HappenDate = Convert.ToDateTime(HappenDate); CarRepairM.ModifiedDate = NowDate; CarRepairM.ModifiedUserID = userID; CarRepairM.Remark = Remark; CarRepairM.RepairReason = RepairReason; #region 拼写添加维修记录信息sql语句 StringBuilder sqlgas = new StringBuilder(); sqlgas.AppendLine("INSERT INTO officedba.CarRepair"); sqlgas.AppendLine("(CompanyCD"); sqlgas.AppendLine(",CarNo "); sqlgas.AppendLine(",EmployeeID"); sqlgas.AppendLine(",HappenDate "); sqlgas.AppendLine(",Factory "); sqlgas.AppendLine(",RepairReason "); sqlgas.AppendLine(",Fee "); sqlgas.AppendLine(",BillNo "); sqlgas.AppendLine(",Remark "); sqlgas.AppendLine(",ModifiedDate"); sqlgas.AppendLine(",ModifiedUserID)"); sqlgas.AppendLine(" values "); sqlgas.AppendLine("(@CompanyCD"); sqlgas.AppendLine(",@CarNo "); sqlgas.AppendLine(",@EmployeeID"); sqlgas.AppendLine(",@HappenDate "); sqlgas.AppendLine(",@Factory "); sqlgas.AppendLine(",@RepairReason "); sqlgas.AppendLine(",@Fee "); sqlgas.AppendLine(",@BillNo "); sqlgas.AppendLine(",@Remark "); sqlgas.AppendLine(",@ModifiedDate"); sqlgas.AppendLine(",@ModifiedUserID)"); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[11]; paramgas[0] = SqlHelper.GetParameter("@CompanyCD", CarRepairM.CompanyCD); paramgas[1] = SqlHelper.GetParameter("@CarNo", CarRepairM.CarNo); paramgas[2] = SqlHelper.GetParameter("@EmployeeID", CarRepairM.EmployeeID); paramgas[3] = SqlHelper.GetParameter("@HappenDate", CarRepairM.HappenDate); paramgas[4] = SqlHelper.GetParameter("@Factory", CarRepairM.Factory); paramgas[5] = SqlHelper.GetParameter("@RepairReason", CarRepairM.RepairReason); paramgas[6] = SqlHelper.GetParameter("@Fee", CarRepairM.Fee); paramgas[7] = SqlHelper.GetParameter("@BillNo", CarRepairM.BillNo); paramgas[8] = SqlHelper.GetParameter("@Remark", CarRepairM.Remark); paramgas[9] = SqlHelper.GetParameter("@ModifiedDate", CarRepairM.ModifiedDate); paramgas[10] = SqlHelper.GetParameter("@ModifiedUserID", CarRepairM.ModifiedUserID); #endregion SqlCommand cmdgasinfo = new SqlCommand(sqlgas.ToString()); cmdgasinfo.Parameters.AddRange(paramgas); comms[i - 1] = cmdgasinfo; } //执行 SqlHelper.ExecuteTransForList(comms); return(SqlHelper.Result.OprateCount > 0 ? true : false); } catch { return(false); } }
/// <summary> /// 修改车辆年检信息 /// </summary> /// <param name="YearCheckInfos">车辆年检信息</param> /// <param name="userID">用户ID</param> /// <param name="CompanyID">公司代码</param> /// <returns>成功:true,失败:false</returns> public static bool UpdateYearCheckInfo(string YearCheckInfos, string userID, string CompanyID, int Employeeid) { try { CarRepairModel CarRepairM = new CarRepairModel(); string[] GasInfoArrary = YearCheckInfos.Split('|'); SqlCommand[] comms = new SqlCommand[GasInfoArrary.Length - 1];//申明cmd数组 DateTime NowDate = System.DateTime.Now; string recorditems = ""; string[] gasfield = null; for (int i = 1; i < GasInfoArrary.Length; i++) //循环数组 { recorditems = GasInfoArrary[i].ToString(); gasfield = recorditems.Split(','); string CarNo = gasfield[0].ToString(); //车辆编号 string CarMark = gasfield[1].ToString(); //车牌号 string User = gasfield[2].ToString(); //经办人 string HappenDate = gasfield[3].ToString(); //年检日期 string RepairFee = gasfield[4].ToString(); //年检费用 string Remark = gasfield[5].ToString(); //备注 string ID = gasfield[6].ToString(); //ID CarRepairM.CarNo = CarNo; CarRepairM.CompanyCD = CompanyID; CarRepairM.EmployeeID = Convert.ToInt32(User); CarRepairM.Fee = Convert.ToDecimal(RepairFee); CarRepairM.HappenDate = Convert.ToDateTime(HappenDate); CarRepairM.ModifiedDate = NowDate; CarRepairM.ModifiedUserID = userID; CarRepairM.Remark = Remark; StringBuilder sqlgas = new StringBuilder(); if (ID == "0") { #region 拼写添加年检记录信息sql语句 sqlgas.AppendLine("INSERT INTO officedba.CarYearCheck"); sqlgas.AppendLine("(CompanyCD"); sqlgas.AppendLine(",CarNo "); sqlgas.AppendLine(",EmployeeID"); sqlgas.AppendLine(",HappenDate "); sqlgas.AppendLine(",Fee "); sqlgas.AppendLine(",Remark "); sqlgas.AppendLine(",ModifiedDate"); sqlgas.AppendLine(",ModifiedUserID)"); sqlgas.AppendLine(" values "); sqlgas.AppendLine("(@CompanyCD"); sqlgas.AppendLine(",@CarNo "); sqlgas.AppendLine(",@EmployeeID"); sqlgas.AppendLine(",@HappenDate "); sqlgas.AppendLine(",@Fee "); sqlgas.AppendLine(",@Remark "); sqlgas.AppendLine(",@ModifiedDate"); sqlgas.AppendLine(",@ModifiedUserID)"); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[8]; paramgas[0] = SqlHelper.GetParameter("@CompanyCD", CarRepairM.CompanyCD); paramgas[1] = SqlHelper.GetParameter("@CarNo", CarRepairM.CarNo); paramgas[2] = SqlHelper.GetParameter("@EmployeeID", CarRepairM.EmployeeID); paramgas[3] = SqlHelper.GetParameter("@HappenDate", CarRepairM.HappenDate); paramgas[4] = SqlHelper.GetParameter("@Fee", CarRepairM.Fee); paramgas[5] = SqlHelper.GetParameter("@Remark", CarRepairM.Remark); paramgas[6] = SqlHelper.GetParameter("@ModifiedDate", CarRepairM.ModifiedDate); paramgas[7] = SqlHelper.GetParameter("@ModifiedUserID", CarRepairM.ModifiedUserID); #endregion SqlCommand cmdgasinfo = new SqlCommand(sqlgas.ToString()); cmdgasinfo.Parameters.AddRange(paramgas); comms[i - 1] = cmdgasinfo; } else { #region 拼写添加维修记录信息sql语句 sqlgas.AppendLine("UPDATE officedba.CarYearCheck"); sqlgas.AppendLine("SET CompanyCD=@CompanyCD"); sqlgas.AppendLine(",CarNo=@CarNo "); sqlgas.AppendLine(",EmployeeID=@EmployeeID"); sqlgas.AppendLine(",HappenDate=@HappenDate "); sqlgas.AppendLine(",Fee=@Fee "); sqlgas.AppendLine(",Remark=@Remark "); sqlgas.AppendLine(",ModifiedDate=@ModifiedDate"); sqlgas.AppendLine(",ModifiedUserID=@ModifiedUserID"); sqlgas.AppendLine(" WHERE ID=@ID "); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[9]; paramgas[0] = SqlHelper.GetParameter("@CompanyCD", CarRepairM.CompanyCD); paramgas[1] = SqlHelper.GetParameter("@CarNo", CarRepairM.CarNo); paramgas[2] = SqlHelper.GetParameter("@EmployeeID", CarRepairM.EmployeeID); paramgas[3] = SqlHelper.GetParameter("@HappenDate", CarRepairM.HappenDate); paramgas[4] = SqlHelper.GetParameter("@Fee", CarRepairM.Fee); paramgas[5] = SqlHelper.GetParameter("@Remark", CarRepairM.Remark); paramgas[6] = SqlHelper.GetParameter("@ModifiedDate", CarRepairM.ModifiedDate); paramgas[7] = SqlHelper.GetParameter("@ModifiedUserID", CarRepairM.ModifiedUserID); paramgas[8] = SqlHelper.GetParameter("@ID", Convert.ToInt32(ID)); #endregion SqlCommand cmdgasinfo = new SqlCommand(sqlgas.ToString()); cmdgasinfo.Parameters.AddRange(paramgas); comms[i - 1] = cmdgasinfo; } } //执行 SqlHelper.ExecuteTransForList(comms); return(SqlHelper.Result.OprateCount > 0 ? true : false); } catch { return(false); } }