/// <summary>
/// 添加车辆年检信息
/// </summary>
/// <param name="YearCheckInfos">车辆年检信息</param>
/// <param name="userID">用户ID</param>
/// <param name="CompanyID">公司代码</param>
/// <returns>成功：true,失败:false</returns>
public static bool AddCarYearCheckInfo(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();//备注
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;
#region 拼写添加维修记录信息sql语句
StringBuilder sqlgas = new StringBuilder();
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;
}
//执行
SqlHelper.ExecuteTransForList(comms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 修改车辆维修信息
/// </summary>
/// <param name="RepairInfos">车辆维修信息</param>
/// <param name="userID">用户ID</param>
/// <param name="CompanyID">公司代码</param>
/// <returns>成功：true,失败:false</returns>
public static bool UpdateRepairInfo(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();//备注
string ID = gasfield[9].ToString();//ID
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;
StringBuilder sqlgas = new StringBuilder();
if (ID == "0")
{
#region 拼写添加维修记录信息sql语句
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;
}
else
{
#region 拼写添加维修记录信息sql语句
sqlgas.AppendLine("UPDATE officedba.CarRepair");
sqlgas.AppendLine("SET CompanyCD=@CompanyCD");
sqlgas.AppendLine(",CarNo=@CarNo ");
sqlgas.AppendLine(",EmployeeID=@EmployeeID");
sqlgas.AppendLine(",HappenDate=@HappenDate ");
sqlgas.AppendLine(",Factory=@Factory ");
sqlgas.AppendLine(",RepairReason=@RepairReason ");
sqlgas.AppendLine(",Fee=@Fee ");
sqlgas.AppendLine(",BillNo=@BillNo ");
sqlgas.AppendLine(",Remark=@Remark ");
sqlgas.AppendLine(",ModifiedDate=@ModifiedDate");
sqlgas.AppendLine(",ModifiedUserID=@ModifiedUserID");
sqlgas.AppendLine(" WHERE ID=@ID ");
#endregion
#region 设置参数
SqlParameter[] paramgas = new SqlParameter[12];
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);
paramgas[11] = 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;
}
}
