/// <summary>
/// 添加办公用品领用信息
/// </summary>
/// <param name="OfficeThingsUsedM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用详细信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool InserOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
{
try
{
#region 添加入库库存信息sql语句
StringBuilder OfficeThingsUsedSql = new StringBuilder();
OfficeThingsUsedSql.AppendLine("INSERT INTO officedba.OfficeThingsUsed");
OfficeThingsUsedSql.AppendLine("(CompanyCD");
OfficeThingsUsedSql.AppendLine(",ApplyNo ");
OfficeThingsUsedSql.AppendLine(",Title");
OfficeThingsUsedSql.AppendLine(",EmployeeID ");
OfficeThingsUsedSql.AppendLine(",DeptID ");
OfficeThingsUsedSql.AppendLine(",UsedDate ");
OfficeThingsUsedSql.AppendLine(",CountTotal ");
OfficeThingsUsedSql.AppendLine(",BillStatus ");
OfficeThingsUsedSql.AppendLine(",Creator ");
OfficeThingsUsedSql.AppendLine(",CreateDate");
OfficeThingsUsedSql.AppendLine(",Remark");
OfficeThingsUsedSql.AppendLine(",ModifiedDate");
OfficeThingsUsedSql.AppendLine(",ModifiedUserID)");
OfficeThingsUsedSql.AppendLine(" values ");
OfficeThingsUsedSql.AppendLine("(@CompanyCD");
OfficeThingsUsedSql.AppendLine(",@ApplyNo ");
OfficeThingsUsedSql.AppendLine(",@Title");
OfficeThingsUsedSql.AppendLine(",@EmployeeID ");
OfficeThingsUsedSql.AppendLine(",@DeptID ");
OfficeThingsUsedSql.AppendLine(",@UsedDate ");
OfficeThingsUsedSql.AppendLine(",@CountTotal ");
OfficeThingsUsedSql.AppendLine(",@BillStatus ");
OfficeThingsUsedSql.AppendLine(",@Creator ");
OfficeThingsUsedSql.AppendLine(",@CreateDate");
OfficeThingsUsedSql.AppendLine(",@Remark");
OfficeThingsUsedSql.AppendLine(",@ModifiedDate");
OfficeThingsUsedSql.AppendLine(",@ModifiedUserID)");
#endregion
#region 设置参数
SqlParameter[] paramgas = new SqlParameter[13];
paramgas[0] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
paramgas[1] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
paramgas[2] = SqlHelper.GetParameter("@Title", OfficeThingsUsedM.Title);
paramgas[3] = SqlHelper.GetParameter("@EmployeeID", OfficeThingsUsedM.EmployeeID);
paramgas[4] = SqlHelper.GetParameter("@DeptID", OfficeThingsUsedM.DeptID);
paramgas[5] = SqlHelper.GetParameter("@UsedDate", OfficeThingsUsedM.UsedDate);
paramgas[6] = SqlHelper.GetParameter("@CountTotal", OfficeThingsUsedM.CountTotal);
paramgas[7] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
paramgas[8] = SqlHelper.GetParameter("@Creator", OfficeThingsUsedM.Creator);
paramgas[9] = SqlHelper.GetParameter("@CreateDate", OfficeThingsUsedM.CreateDate);
paramgas[10] = SqlHelper.GetParameter("@Remark", OfficeThingsUsedM.Remark);
paramgas[11] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
paramgas[12] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
#endregion
return InsertAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
}
catch
{
return false;
}
}
/// <summary>
/// 用品领用确认
/// </summary>
/// <param name="OfficeThingsUsedM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
/// <returns>确认是否成功 false:失败，true:成功</returns>
public static bool ConfirmUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
{
try
{
#region 添加入库库存信息sql语句
StringBuilder OfficeThingsUsedSql = new StringBuilder();
OfficeThingsUsedSql.AppendLine("Update officedba.OfficeThingsUsed");
OfficeThingsUsedSql.AppendLine("SET BillStatus=@BillStatus");
OfficeThingsUsedSql.AppendLine(",Confirmor=@Confirmor ");
OfficeThingsUsedSql.AppendLine(",ConfirmDate=@ConfirmDate ");
OfficeThingsUsedSql.AppendLine(",ModifiedDate=@ModifiedDate");
OfficeThingsUsedSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
OfficeThingsUsedSql.AppendLine(" WHERE ApplyNo=@ApplyNo AND CompanyCD=@CompanyCD");
#endregion
#region 设置参数
SqlParameter[] paramgas = new SqlParameter[7];
paramgas[0] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
paramgas[1] = SqlHelper.GetParameter("@Confirmor", OfficeThingsUsedM.Confirmor);
paramgas[2] = SqlHelper.GetParameter("@ConfirmDate", OfficeThingsUsedM.ConfirmDate);
paramgas[3] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
paramgas[4] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
paramgas[5] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
paramgas[6] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
#endregion
return ConfirmAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
}
catch
{
return false;
}
}
/// <summary>
/// 修改用品领用单信息
/// </summary>
/// <param name="OfficeThingsBuyM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
{
try
{
#region 添加领用单存信息sql语句
StringBuilder OfficeThingsUsedSql = new StringBuilder();
OfficeThingsUsedSql.AppendLine("UPDATE officedba.OfficeThingsUsed");
OfficeThingsUsedSql.AppendLine(" SET Title=@Title");
OfficeThingsUsedSql.AppendLine(",EmployeeID=@EmployeeID ");
OfficeThingsUsedSql.AppendLine(",DeptID=@DeptID ");
OfficeThingsUsedSql.AppendLine(",UsedDate=@UsedDate ");
OfficeThingsUsedSql.AppendLine(",CountTotal=@CountTotal ");
OfficeThingsUsedSql.AppendLine(",BillStatus=@BillStatus ");
OfficeThingsUsedSql.AppendLine(",Remark=@Remark");
OfficeThingsUsedSql.AppendLine(",ModifiedDate=@ModifiedDate");
OfficeThingsUsedSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
OfficeThingsUsedSql.AppendLine(" WHERE CompanyCD=@CompanyCD AND ApplyNo=@ApplyNo");
#endregion
#region 设置参数
SqlParameter[] paramgas = new SqlParameter[11];
paramgas[0] = SqlHelper.GetParameter("@Title", OfficeThingsUsedM.Title);
paramgas[1] = SqlHelper.GetParameter("@EmployeeID", OfficeThingsUsedM.EmployeeID);
paramgas[2] = SqlHelper.GetParameter("@DeptID", OfficeThingsUsedM.DeptID);
paramgas[3] = SqlHelper.GetParameter("@UsedDate", OfficeThingsUsedM.UsedDate);
paramgas[4] = SqlHelper.GetParameter("@CountTotal", OfficeThingsUsedM.CountTotal);
paramgas[5] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
paramgas[6] = SqlHelper.GetParameter("@Remark", OfficeThingsUsedM.Remark);
paramgas[7] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
paramgas[8] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
paramgas[9] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
paramgas[10] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
#endregion
return UpdateAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
}
catch
{
return false;
}
}
/// <summary>
/// 用品领用确认
/// </summary>
/// <param name="OfficeThingsUsedM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
/// <returns>确认是否成功 false:失败，true:成功</returns>
public static bool ConfirmUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM,string OfficeThingsUsedInfos)
{
return OfficeThingsUsedDBHelper.ConfirmUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
}
/// <summary>
/// 修改用品领用单信息
/// </summary>
/// <param name="OfficeThingsBuyM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
{
return OfficeThingsUsedDBHelper.UpdateOfficeThingsUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
}
/// <summary>
/// 添加办公用品领用信息
/// </summary>
/// <param name="OfficeThingsUsedM">领用单主信息</param>
/// <param name="OfficeThingsUsedInfos">领用详细信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool InserOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
{
return OfficeThingsUsedDBHelper.InserOfficeThingsUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
}