/// <summary>
/// 修改车辆申请信息
/// </summary>
/// <param name="CarApplyM">车辆申请信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateCarApplyInfoData(CarApplyModel CarApplyM)
{
return CarApplyDBHelper.UpdateCarApplyInfoData(CarApplyM);
}
/// <summary>
/// 车辆申请添加操作
/// </summary>
/// <param name="CarApplyM">车辆申请信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool InsertCarApplyInfoData(CarApplyModel CarApplyM, out int RetValID)
{
try
{
#region 车辆申请信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.CarApply");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,RecordNo ");
sql.AppendLine(" ,Title ");
sql.AppendLine(" ,CarNo ");
sql.AppendLine(" ,ApplyDate ");
sql.AppendLine(" ,Appler ");
sql.AppendLine(" ,Reason ");
sql.AppendLine(" ,LoadHumans ");
sql.AppendLine(" ,LoadGoods ");
sql.AppendLine(" ,PlanDate ");
sql.AppendLine(" ,PlanTime ");
sql.AppendLine(" ,ReturnDate ");
sql.AppendLine(" ,ReturnTime ");
sql.AppendLine(" ,PlanMileage ");
sql.AppendLine(" ,BillStatus ");
sql.AppendLine(" ,Creator ");
sql.AppendLine(" ,CreateDate ");
sql.AppendLine(" ,Remark ");
sql.AppendLine(" ,ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID) ");
sql.AppendLine("VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@RecordNo ");
sql.AppendLine(" ,@Title ");
sql.AppendLine(" ,@CarNo ");
sql.AppendLine(" ,@ApplyDate ");
sql.AppendLine(" ,@Appler ");
sql.AppendLine(" ,@Reason ");
sql.AppendLine(" ,@LoadHumans ");
sql.AppendLine(" ,@LoadGoods ");
sql.AppendLine(" ,@PlanDate ");
sql.AppendLine(" ,@PlanTime ");
sql.AppendLine(" ,@ReturnDate ");
sql.AppendLine(" ,@ReturnTime ");
sql.AppendLine(" ,@PlanMileage ");
sql.AppendLine(" ,@BillStatus ");
sql.AppendLine(" ,@Creator ");
sql.AppendLine(" ,@CreateDate ");
sql.AppendLine(" ,@Remark ");
sql.AppendLine(" ,@ModifiedDate ");
sql.AppendLine(" ,@ModifiedUserID) ");
sql.AppendLine("set @ID=@@IDENTITY");
#endregion
#region 车辆申请信息参数设置
SqlParameter[] param;
param = new SqlParameter[21];
param[0] = SqlHelper.GetParameter("@CompanyCD", CarApplyM.CompanyCD);
param[1] = SqlHelper.GetParameter("@RecordNo", CarApplyM.RecordNo);
param[2] = SqlHelper.GetParameter("@Title", CarApplyM.Title);
param[3] = SqlHelper.GetParameter("@CarNo", CarApplyM.CarNo);
param[4] = SqlHelper.GetParameter("@ApplyDate", CarApplyM.ApplyDate);
param[5] = SqlHelper.GetParameter("@Appler", CarApplyM.Appler);
param[6] = SqlHelper.GetParameter("@Reason", CarApplyM.Reason);
param[7] = SqlHelper.GetParameter("@LoadHumans", CarApplyM.LoadHumans);
param[8] = SqlHelper.GetParameter("@LoadGoods", CarApplyM.LoadGoods);
param[9] = SqlHelper.GetParameter("@PlanDate", CarApplyM.PlanDate);
param[10] = SqlHelper.GetParameter("@PlanTime", CarApplyM.PlanTime);
param[11] = SqlHelper.GetParameter("@ReturnDate", CarApplyM.ReturnDate);
param[12] = SqlHelper.GetParameter("@ReturnTime", CarApplyM.ReturnTime);
param[13] = SqlHelper.GetParameter("@PlanMileage", CarApplyM.PlanMileage);
param[14] = SqlHelper.GetParameter("@BillStatus", CarApplyM.BillStatus);
param[15] = SqlHelper.GetParameter("@Creator", CarApplyM.Creator);
param[16] = SqlHelper.GetParameter("@CreateDate", CarApplyM.CreateDate);
param[17] = SqlHelper.GetParameter("@Remark", CarApplyM.Remark);
param[18] = SqlHelper.GetParameter("@ModifiedDate", CarApplyM.ModifiedDate);
param[19] = SqlHelper.GetParameter("@ModifiedUserID", CarApplyM.ModifiedUserID);
param[20] = SqlHelper.GetOutputParameter("@ID", SqlDbType.Int);
#endregion
SqlHelper.ExecuteTransSql(sql.ToString(), param);
RetValID =Convert.ToInt32(param[20].Value.ToString());
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
RetValID = 0;
return false;
}
}
/// <summary>
/// 添加车辆申请信息
/// </summary>
/// <param name="CarApplyM">车辆申请信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool InsertCarApplyInfoData(CarApplyModel CarApplyM,out int RetValID)
{
return CarApplyDBHelper.InsertCarApplyInfoData(CarApplyM,out RetValID);
}
/// <summary>
/// 车辆申请修改操作
/// </summary>
/// <param name="CarApplyM">车辆申请信息</param>
/// <returns>修改是否成功 false:失败，true:成功</returns>
public static bool UpdateCarApplyInfoData(CarApplyModel CarApplyM)
{
try
{
#region 车辆申请信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.CarApply");
//sql.AppendLine(" SET CompanyCD=@CompanyCD ");
//sql.AppendLine(" ,RecordNo ");
sql.AppendLine(" SET Title=@Title ");
sql.AppendLine(" ,CarNo=@CarNo ");
sql.AppendLine(" ,ApplyDate=@ApplyDate ");
sql.AppendLine(" ,Appler=@Appler ");
sql.AppendLine(" ,Reason=@Reason ");
sql.AppendLine(" ,LoadHumans=@LoadHumans ");
sql.AppendLine(" ,LoadGoods=@LoadGoods ");
sql.AppendLine(" ,PlanDate=@PlanDate ");
sql.AppendLine(" ,PlanTime=@PlanTime ");
sql.AppendLine(" ,ReturnDate=@ReturnDate ");
sql.AppendLine(" ,ReturnTime=@ReturnTime ");
sql.AppendLine(" ,PlanMileage=@PlanMileage ");
sql.AppendLine(" ,BillStatus=@BillStatus ");
sql.AppendLine(" ,Creator=@Creator ");
sql.AppendLine(" ,CreateDate=@CreateDate ");
sql.AppendLine(" ,Remark=@Remark ");
sql.AppendLine(" ,ModifiedDate=@ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
sql.AppendLine("WHERE ");
sql.AppendLine(" CompanyCD=@CompanyCD AND RecordNo=@RecordNo ");
#endregion
#region 车辆申请信息参数设置
SqlParameter[] param;
param = new SqlParameter[20];
param[0] = SqlHelper.GetParameter("@Title", CarApplyM.Title);
param[1] = SqlHelper.GetParameter("@CarNo", CarApplyM.CarNo);
param[2] = SqlHelper.GetParameter("@ApplyDate", CarApplyM.ApplyDate);
param[3] = SqlHelper.GetParameter("@Appler", CarApplyM.Appler);
param[4] = SqlHelper.GetParameter("@Reason", CarApplyM.Reason);
param[5] = SqlHelper.GetParameter("@LoadHumans", CarApplyM.LoadHumans);
param[6] = SqlHelper.GetParameter("@LoadGoods", CarApplyM.LoadGoods);
param[7] = SqlHelper.GetParameter("@PlanDate", CarApplyM.PlanDate);
param[8] = SqlHelper.GetParameter("@PlanTime", CarApplyM.PlanTime);
param[9] = SqlHelper.GetParameter("@ReturnDate", CarApplyM.ReturnDate);
param[10] = SqlHelper.GetParameter("@ReturnTime", CarApplyM.ReturnTime);
param[11] = SqlHelper.GetParameter("@PlanMileage", CarApplyM.PlanMileage);
param[12] = SqlHelper.GetParameter("@BillStatus", CarApplyM.BillStatus);
param[13] = SqlHelper.GetParameter("@Creator", CarApplyM.Creator);
param[14] = SqlHelper.GetParameter("@CreateDate", CarApplyM.CreateDate);
param[15] = SqlHelper.GetParameter("@Remark", CarApplyM.Remark);
param[16] = SqlHelper.GetParameter("@ModifiedDate", CarApplyM.ModifiedDate);
param[17] = SqlHelper.GetParameter("@ModifiedUserID", CarApplyM.ModifiedUserID);
param[18] = SqlHelper.GetParameter("@CompanyCD", CarApplyM.CompanyCD);
param[19] = SqlHelper.GetParameter("@RecordNo", CarApplyM.RecordNo);
#endregion
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
