/// <summary> /// 添加入库库存信息 /// </summary> /// <param name="OfficeThingsBuyM">入库单主信息</param> /// <param name="OfficeThingsInStorageInfos">入库详细信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool ConfirmInstorageInfo(OfficeThingsBuyModel OfficeThingsBuyM, string OfficeThingsInStorageInfos) { try { #region 添加入库库存信息sql语句 StringBuilder OfficeThingsBuySql = new StringBuilder(); OfficeThingsBuySql.AppendLine("Update officedba.OfficeThingsBuy"); OfficeThingsBuySql.AppendLine("SET BillStatus=@BillStatus"); OfficeThingsBuySql.AppendLine(",Confirmor=@Confirmor "); OfficeThingsBuySql.AppendLine(",ConfirmDate=@ConfirmDate "); OfficeThingsBuySql.AppendLine(",ModifiedDate=@ModifiedDate"); OfficeThingsBuySql.AppendLine(",ModifiedUserID=@ModifiedUserID"); OfficeThingsBuySql.AppendLine(" WHERE BuyRecordNo=@BuyRecordNo AND CompanyCD=@CompanyCD"); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[7]; paramgas[0] = SqlHelper.GetParameter("@BillStatus", OfficeThingsBuyM.BillStatus); paramgas[1] = SqlHelper.GetParameter("@Confirmor", OfficeThingsBuyM.Confirmor); paramgas[2] = SqlHelper.GetParameter("@ConfirmDate", OfficeThingsBuyM.ConfirmDate); paramgas[3] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsBuyM.ModifiedDate); paramgas[4] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsBuyM.ModifiedUserID); paramgas[5] = SqlHelper.GetParameter("@BuyRecordNo", OfficeThingsBuyM.BuyRecordNo); paramgas[6] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyM.CompanyCD); #endregion return ConfirmAll(OfficeThingsBuySql.ToString(), OfficeThingsInStorageInfos, OfficeThingsBuyM.BuyRecordNo, OfficeThingsBuyM.CompanyCD, OfficeThingsBuyM.ModifiedUserID, paramgas); } catch { return false; } }
/// <summary> /// 修改入库库存信息 /// </summary> /// <param name="OfficeThingsBuyM">入库单主信息</param> /// <param name="OfficeThingsInStorageInfos">入库详细信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateInstorageInfo(OfficeThingsBuyModel OfficeThingsBuyM, string OfficeThingsInStorageInfos) { try { #region 添加入库库存信息sql语句 StringBuilder OfficeThingsBuySql = new StringBuilder(); OfficeThingsBuySql.AppendLine("UPDATE officedba.OfficeThingsBuy"); OfficeThingsBuySql.AppendLine("SET Title=@Title"); OfficeThingsBuySql.AppendLine(",FromType=@FromType "); OfficeThingsBuySql.AppendLine(",BuyerID=@BuyerID "); OfficeThingsBuySql.AppendLine(",BuyDeptID=@BuyDeptID "); OfficeThingsBuySql.AppendLine(",BuyDate=@BuyDate "); OfficeThingsBuySql.AppendLine(",ToWarehouseDate=@ToWarehouseDate "); OfficeThingsBuySql.AppendLine(",TotalCount=@TotalCount "); OfficeThingsBuySql.AppendLine(",TotalPrice=@TotalPrice "); OfficeThingsBuySql.AppendLine(",BillStatus=@BillStatus"); //OfficeThingsBuySql.AppendLine(",Creator=@Creator"); //OfficeThingsBuySql.AppendLine(",CreateDate=@CreateDate"); OfficeThingsBuySql.AppendLine(",Remark=@Remark"); OfficeThingsBuySql.AppendLine(",ModifiedDate=@ModifiedDate"); OfficeThingsBuySql.AppendLine(",ModifiedUserID=@ModifiedUserID"); OfficeThingsBuySql.AppendLine(" WHERE CompanyCD=@CompanyCD AND BuyRecordNo=@BuyRecordNo"); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[14]; paramgas[0] = SqlHelper.GetParameter("@Title", OfficeThingsBuyM.Title); paramgas[1] = SqlHelper.GetParameter("@BuyerID", OfficeThingsBuyM.BuyerID); paramgas[2] = SqlHelper.GetParameter("@BuyDeptID", OfficeThingsBuyM.BuyDeptID); paramgas[3] = SqlHelper.GetParameter("@BuyDate", OfficeThingsBuyM.BuyDate); paramgas[4] = SqlHelper.GetParameter("@ToWarehouseDate", OfficeThingsBuyM.ToWarehouseDate); paramgas[5] = SqlHelper.GetParameter("@TotalCount", OfficeThingsBuyM.TotalCount); paramgas[6] = SqlHelper.GetParameter("@TotalPrice", OfficeThingsBuyM.TotalPrice); paramgas[7] = SqlHelper.GetParameter("@BillStatus", OfficeThingsBuyM.BillStatus); //paramgas[8] = SqlHelper.GetParameter("@Creator", OfficeThingsBuyM.Creator); // paramgas[9] = SqlHelper.GetParameter("@CreateDate", OfficeThingsBuyM.CreateDate); paramgas[8] = SqlHelper.GetParameter("@Remark", OfficeThingsBuyM.Remark); paramgas[9] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsBuyM.ModifiedDate); paramgas[10] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsBuyM.ModifiedUserID); paramgas[11] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyM.CompanyCD); paramgas[12] = SqlHelper.GetParameter("@BuyRecordNo", OfficeThingsBuyM.BuyRecordNo); paramgas[13] = SqlHelper.GetParameter("@FromType", OfficeThingsBuyM.FromType); #endregion return UpdateAll(OfficeThingsBuySql.ToString(), OfficeThingsInStorageInfos, OfficeThingsBuyM.BuyRecordNo, OfficeThingsBuyM.CompanyCD, OfficeThingsBuyM.ModifiedUserID, paramgas); } catch { return false; } }
/// <summary> /// 添加入库库存信息 /// </summary> /// <param name="OfficeThingsBuyM">入库单主信息</param> /// <param name="OfficeThingsInStorageInfos">入库详细信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool InserInstorageInfo(OfficeThingsBuyModel OfficeThingsBuyM, string OfficeThingsInStorageInfos) { try { #region 添加入库库存信息sql语句 StringBuilder OfficeThingsBuySql = new StringBuilder(); OfficeThingsBuySql.AppendLine("INSERT INTO officedba.OfficeThingsBuy"); OfficeThingsBuySql.AppendLine("(CompanyCD"); OfficeThingsBuySql.AppendLine(",BuyRecordNo "); OfficeThingsBuySql.AppendLine(",FromType "); OfficeThingsBuySql.AppendLine(",Title"); OfficeThingsBuySql.AppendLine(",BuyerID "); OfficeThingsBuySql.AppendLine(",BuyDeptID "); OfficeThingsBuySql.AppendLine(",BuyDate "); OfficeThingsBuySql.AppendLine(",ToWarehouseDate "); OfficeThingsBuySql.AppendLine(",TotalCount "); OfficeThingsBuySql.AppendLine(",TotalPrice "); OfficeThingsBuySql.AppendLine(",BillStatus"); OfficeThingsBuySql.AppendLine(",Creator"); OfficeThingsBuySql.AppendLine(",CreateDate"); OfficeThingsBuySql.AppendLine(",Remark"); OfficeThingsBuySql.AppendLine(",ModifiedDate"); OfficeThingsBuySql.AppendLine(",ModifiedUserID)"); OfficeThingsBuySql.AppendLine(" values "); OfficeThingsBuySql.AppendLine("(@CompanyCD"); OfficeThingsBuySql.AppendLine(",@BuyRecordNo "); OfficeThingsBuySql.AppendLine(",@FromType "); OfficeThingsBuySql.AppendLine(",@Title"); OfficeThingsBuySql.AppendLine(",@BuyerID "); OfficeThingsBuySql.AppendLine(",@BuyDeptID "); OfficeThingsBuySql.AppendLine(",@BuyDate "); OfficeThingsBuySql.AppendLine(",@ToWarehouseDate "); OfficeThingsBuySql.AppendLine(",@TotalCount "); OfficeThingsBuySql.AppendLine(",@TotalPrice "); OfficeThingsBuySql.AppendLine(",@BillStatus"); OfficeThingsBuySql.AppendLine(",@Creator"); OfficeThingsBuySql.AppendLine(",@CreateDate"); OfficeThingsBuySql.AppendLine(",@Remark"); OfficeThingsBuySql.AppendLine(",@ModifiedDate"); OfficeThingsBuySql.AppendLine(",@ModifiedUserID)"); #endregion #region 设置参数 SqlParameter[] paramgas = new SqlParameter[16]; paramgas[0] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyM.CompanyCD); paramgas[1] = SqlHelper.GetParameter("@BuyRecordNo", OfficeThingsBuyM.BuyRecordNo); paramgas[2] = SqlHelper.GetParameter("@Title", OfficeThingsBuyM.Title); paramgas[3] = SqlHelper.GetParameter("@BuyerID", OfficeThingsBuyM.BuyerID); paramgas[4] = SqlHelper.GetParameter("@BuyDeptID", OfficeThingsBuyM.BuyDeptID); paramgas[5] = SqlHelper.GetParameter("@BuyDate", OfficeThingsBuyM.BuyDate); paramgas[6] = SqlHelper.GetParameter("@ToWarehouseDate", OfficeThingsBuyM.ToWarehouseDate); paramgas[7] = SqlHelper.GetParameter("@TotalCount", OfficeThingsBuyM.TotalCount); paramgas[8] = SqlHelper.GetParameter("@TotalPrice", OfficeThingsBuyM.TotalPrice); paramgas[9] = SqlHelper.GetParameter("@BillStatus", OfficeThingsBuyM.BillStatus); paramgas[10] = SqlHelper.GetParameter("@Creator", OfficeThingsBuyM.Creator); paramgas[11] = SqlHelper.GetParameter("@CreateDate", OfficeThingsBuyM.CreateDate); paramgas[12] = SqlHelper.GetParameter("@Remark", OfficeThingsBuyM.Remark); paramgas[13] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsBuyM.ModifiedDate); paramgas[14] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsBuyM.ModifiedUserID); paramgas[15] = SqlHelper.GetParameter("@FromType", OfficeThingsBuyM.FromType); #endregion return InsertAll(OfficeThingsBuySql.ToString(), OfficeThingsInStorageInfos, OfficeThingsBuyM.BuyRecordNo, OfficeThingsBuyM.CompanyCD, OfficeThingsBuyM.ModifiedUserID, paramgas); } catch { return false; } }
/// <summary> /// 入库确认 /// </summary> /// <param name="OfficeThingsBuyM">入库单主信息</param> /// <param name="OfficeThingsInStorageInfos">入库详细信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool ConfirmInstorageInfo(OfficeThingsBuyModel OfficeThingsBuyM, string OfficeThingsInStorageInfos) { return OfficeThingsStorageDBHelper.ConfirmInstorageInfo(OfficeThingsBuyM, OfficeThingsInStorageInfos); }