/// <summary>
/// 取消车辆申请确认信息
/// </summary>
/// <param name="CarApplyM">车辆申请信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateCarApplyCancelConfirm(string BillStatus, string Confirmor, string ConfirmDate, string ID, string userID, string CompanyID)
{
try
{
#region 车辆申请信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.CarApply");
sql.AppendLine(" SET BillStatus=@BillStatus ");
sql.AppendLine(" ,Confirmor=@Confirmor ");
sql.AppendLine(" ,ConfirmDate=@ConfirmDate ");
sql.AppendLine(" ,ModifiedDate=@ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
sql.AppendLine("WHERE ");
sql.AppendLine(" ID=@ID ");
#endregion
#region 车辆申请信息参数设置
SqlParameter[] param;
param = new SqlParameter[6];
param[0] = SqlHelper.GetParameter("@BillStatus", BillStatus);
param[1] = SqlHelper.GetParameter("@Confirmor", Confirmor);
param[2] = SqlHelper.GetParameter("@ConfirmDate", ConfirmDate);
param[3] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[4] = SqlHelper.GetParameter("@ModifiedUserID", userID);
param[5] = SqlHelper.GetParameter("@ID", ID);
#endregion
//SqlHelper.ExecuteTransSql(sql.ToString(), param);
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
FlowDBHelper.OperateCancelConfirm(CompanyID, 3, 8, Convert.ToInt32(ID), userID, tran);//取消确认
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
}
catch
{
return(false);
}
}
public static bool UpdateMoveApplyCancelConfirm(string BillStatus, string ID, string userID, string CompanyID, string ReprotNo)
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.RectApply");
sql.AppendLine(" SET BillStatus=@Status ");
sql.AppendLine(" ,ModifiedDate=getdate() ");
sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
sql.AppendLine(" ,ConfirmDate = null ");
sql.AppendLine(" ,Confirmor = null ");
sql.AppendLine("WHERE ");
sql.AppendLine(" CompanyCD = @CompanyCD ");
sql.AppendLine(" AND RectApplyNo = @RectApplyNo ");
SqlParameter[] param;
param = new SqlParameter[4];
param[0] = SqlHelper.GetParameter("@Status", BillStatus);
param[1] = SqlHelper.GetParameter("@ModifiedUserID", userID);
param[2] = SqlHelper.GetParameter("@CompanyCD", CompanyID);
param[3] = SqlHelper.GetParameter("@RectApplyNo", ReprotNo);
//SqlHelper.ExecuteTransSql(sql.ToString(), param);
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
FlowDBHelper.OperateCancelConfirm(CompanyID, Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPEFLAG_HUMAN), Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPECODE_HUMAN_RECT_APPLY), Convert.ToInt32(ID), userID, tran);//取消确认
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
}
catch
{
return(false);
}
}