/// <summary>
/// 用品领用确认
/// </summary>
/// <returns>领用是否成功 false:失败，true:成功</returns>
public static bool ConfirmAll(string OfficeThingsUsedSql, string OfficeThingsUsedInfos, string ApplyNo, string CompanyCD, string UserID, SqlParameter[] paramgas)
{
try
{
OfficeThingsUsedDetailModel OfficeThingsUsedDetailM = new OfficeThingsUsedDetailModel();
string[] OfficeThingsUsedArrary = OfficeThingsUsedInfos.Split('|');
SqlCommand[] comms = new SqlCommand[OfficeThingsUsedArrary.Length]; //申明cmd数组(主表，明细表，每条明细生成一条库存记录)
SqlCommand OfficeThingsUsedCom = new SqlCommand(OfficeThingsUsedSql.ToString());
OfficeThingsUsedCom.Parameters.AddRange(paramgas);
comms[0] = OfficeThingsUsedCom;
string recorditems = "";
string[] gasfield = null;
for (int i = 1; i < OfficeThingsUsedArrary.Length; i++) //循环数组
{
recorditems = OfficeThingsUsedArrary[i].ToString();
gasfield = recorditems.Split(',');
string ThingNo = gasfield[0].ToString();//用品编号
string BuyCount = gasfield[1].ToString();//领用数量
OfficeThingsUsedDetailM.ThingNo = ThingNo;
OfficeThingsUsedDetailM.Count = Convert.ToDecimal(BuyCount);
OfficeThingsUsedDetailM.ModifiedDate = System.DateTime.Now;
OfficeThingsUsedDetailM.ModifiedUserID = UserID;
OfficeThingsUsedDetailM.CompanyCD = CompanyCD;
OfficeThingsStorageModel OfficeThingsStorageM = new OfficeThingsStorageModel();
#region 拼写更新入库库存信息sql语句
StringBuilder OfficeThingsStorageSql = new StringBuilder();
OfficeThingsStorageSql.AppendLine("UPDATE officedba.OfficeThingsStorage");
OfficeThingsStorageSql.AppendLine("SET SurplusCount=SurplusCount-@ApplyCount");
OfficeThingsStorageSql.AppendLine(",UsedCount=UsedCount+@ApplyCount1 ");
OfficeThingsStorageSql.AppendLine(",ModifiedDate=@ModifiedDate");
OfficeThingsStorageSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
OfficeThingsStorageSql.AppendLine(" WHERE ThingNo=@ThingNo AND CompanyCD=@CompanyCD ");
#endregion
#region 设置参数
SqlParameter[] OfficeThingsStorageParams = new SqlParameter[6];
OfficeThingsStorageParams[0] = SqlHelper.GetParameter("@ApplyCount", OfficeThingsUsedDetailM.Count);
OfficeThingsStorageParams[1] = SqlHelper.GetParameter("@ApplyCount1", OfficeThingsUsedDetailM.Count);
OfficeThingsStorageParams[2] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedDetailM.ModifiedDate);
OfficeThingsStorageParams[3] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedDetailM.ModifiedUserID);
OfficeThingsStorageParams[4] = SqlHelper.GetParameter("@ThingNo", OfficeThingsUsedDetailM.ThingNo);
OfficeThingsStorageParams[5] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedDetailM.CompanyCD);
#endregion
SqlCommand OfficeThingsStorageComInfo = new SqlCommand(OfficeThingsStorageSql.ToString());
OfficeThingsStorageComInfo.Parameters.AddRange(OfficeThingsStorageParams);
comms[i] = OfficeThingsStorageComInfo;
}
//执行
SqlHelper.ExecuteTransForList(comms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 入库确认
/// </summary>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool ConfirmAll(string OfficeThingsBuySql, string OfficeThingsInStorageInfos, string BuyRecordNo, string CompanyCD, string UserID, SqlParameter[] paramgas)
{
try
{
ArrayList listADD = new ArrayList();
OfficeThingsBuyDetailModel OfficeThingsBuyDetailM = new OfficeThingsBuyDetailModel();
string[] OfficeThingsInStorageArrary = OfficeThingsInStorageInfos.Split('|');
SqlCommand[] comms = new SqlCommand[OfficeThingsInStorageArrary.Length]; //申明cmd数组(主表，明细表，每条明细生成一条库存记录)
SqlCommand OfficeThingsBuyCom = new SqlCommand(OfficeThingsBuySql.ToString());
OfficeThingsBuyCom.Parameters.AddRange(paramgas);
//comms[0] = OfficeThingsBuyCom;
listADD.Add(OfficeThingsBuyCom);
string recorditems = "";
string[] gasfield = null;
for (int i = 1; i < OfficeThingsInStorageArrary.Length; i++) //循环数组
{
recorditems = OfficeThingsInStorageArrary[i].ToString();
gasfield = recorditems.Split(',');
string ThingNo = gasfield[0].ToString();//用品编号
string BuyCount = gasfield[1].ToString();//采购数量
string UnitPrice = gasfield[2].ToString();//采购单价
string BuyMoney = gasfield[3].ToString();//采购金额
string Provider = gasfield[4].ToString();//供应商
string FromBillID = gasfield[5].ToString();//采购金额
string FromSortNo = gasfield[6].ToString();//供应商
OfficeThingsBuyDetailM.BuyCount = Convert.ToDecimal(BuyCount);
OfficeThingsBuyDetailM.BuyMoney = Convert.ToDecimal(BuyMoney);
OfficeThingsBuyDetailM.BuyRecordNo = BuyRecordNo;
OfficeThingsBuyDetailM.CompanyCD = CompanyCD;
OfficeThingsBuyDetailM.ModifiedDate = System.DateTime.Now;
OfficeThingsBuyDetailM.ModifiedUserID = UserID;
OfficeThingsBuyDetailM.Provider = Provider;
OfficeThingsBuyDetailM.ThingNo = ThingNo;
OfficeThingsBuyDetailM.UnitPrice = Convert.ToDecimal(UnitPrice);
int RetOfficeThingsVal = OfficeThingsStorageIsExist(ThingNo, CompanyCD);//库存是否有此用品编号的记录，有更新库存，无插入新的库存记录
OfficeThingsStorageModel OfficeThingsStorageM = new OfficeThingsStorageModel();
if (RetOfficeThingsVal == 0)//无此编号的库存，插入库存信息
{
#region 拼写添加入库库存信息sql语句
StringBuilder OfficeThingsStorageSql = new StringBuilder();
OfficeThingsStorageSql.AppendLine("INSERT INTO officedba.OfficeThingsStorage");
OfficeThingsStorageSql.AppendLine("(CompanyCD");
OfficeThingsStorageSql.AppendLine(",ThingNo ");
OfficeThingsStorageSql.AppendLine(",TotalCount");
OfficeThingsStorageSql.AppendLine(",SurplusCount ");
OfficeThingsStorageSql.AppendLine(",UsedCount ");
OfficeThingsStorageSql.AppendLine(",ModifiedDate");
OfficeThingsStorageSql.AppendLine(",ModifiedUserID)");
OfficeThingsStorageSql.AppendLine(" values ");
OfficeThingsStorageSql.AppendLine("(@CompanyCD");
OfficeThingsStorageSql.AppendLine(",@ThingNo ");
OfficeThingsStorageSql.AppendLine(",@TotalCount");
OfficeThingsStorageSql.AppendLine(",@SurplusCount ");
OfficeThingsStorageSql.AppendLine(",@UsedCount ");
OfficeThingsStorageSql.AppendLine(",@ModifiedDate");
OfficeThingsStorageSql.AppendLine(",@ModifiedUserID)");
#endregion
#region 设置参数
SqlParameter[] OfficeThingsStorageParams = new SqlParameter[7];
OfficeThingsStorageParams[0] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyDetailM.CompanyCD);
OfficeThingsStorageParams[1] = SqlHelper.GetParameter("@ThingNo", OfficeThingsBuyDetailM.ThingNo);
OfficeThingsStorageParams[2] = SqlHelper.GetParameter("@TotalCount", OfficeThingsBuyDetailM.BuyCount);
OfficeThingsStorageParams[3] = SqlHelper.GetParameter("@SurplusCount", OfficeThingsBuyDetailM.BuyCount);
OfficeThingsStorageParams[4] = SqlHelper.GetParameter("@UsedCount", 0);
OfficeThingsStorageParams[5] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsBuyDetailM.ModifiedDate);
OfficeThingsStorageParams[6] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsBuyDetailM.ModifiedUserID);
#endregion
SqlCommand OfficeThingsStorageComInfo = new SqlCommand(OfficeThingsStorageSql.ToString());
OfficeThingsStorageComInfo.Parameters.AddRange(OfficeThingsStorageParams);
//comms[i] = OfficeThingsStorageComInfo;
listADD.Add(OfficeThingsStorageComInfo);
}
else //有此编号，更新库存信息
{
#region 拼写添加入库库存信息sql语句
StringBuilder OfficeThingsStorageSql = new StringBuilder();
OfficeThingsStorageSql.AppendLine("UPDATE officedba.OfficeThingsStorage");
OfficeThingsStorageSql.AppendLine("SET TotalCount=TotalCount+@TotalCount");
OfficeThingsStorageSql.AppendLine(",SurplusCount=SurplusCount+@TotalCount1 ");
OfficeThingsStorageSql.AppendLine(",ModifiedDate=@ModifiedDate");
OfficeThingsStorageSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
OfficeThingsStorageSql.AppendLine(" WHERE ThingNo=@ThingNo AND CompanyCD=@CompanyCD ");
#endregion
#region 设置参数
SqlParameter[] OfficeThingsStorageParams = new SqlParameter[6];
OfficeThingsStorageParams[0] = SqlHelper.GetParameter("@TotalCount", OfficeThingsBuyDetailM.BuyCount);
OfficeThingsStorageParams[1] = SqlHelper.GetParameter("@TotalCount1", OfficeThingsBuyDetailM.BuyCount);
OfficeThingsStorageParams[2] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsBuyDetailM.ModifiedDate);
OfficeThingsStorageParams[3] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsBuyDetailM.ModifiedUserID);
OfficeThingsStorageParams[4] = SqlHelper.GetParameter("@ThingNo", OfficeThingsBuyDetailM.ThingNo);
OfficeThingsStorageParams[5] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyDetailM.CompanyCD);
#endregion
SqlCommand OfficeThingsStorageComInfo = new SqlCommand(OfficeThingsStorageSql.ToString());
OfficeThingsStorageComInfo.Parameters.AddRange(OfficeThingsStorageParams);
// comms[i] = OfficeThingsStorageComInfo;
listADD.Add(OfficeThingsStorageComInfo);
}
if (Convert .ToInt32 ( FromBillID) >0)// 回写信息
{
#region 拼写添加入库库存信息sql语句
StringBuilder OfficeThingsStorageSql = new StringBuilder();
OfficeThingsStorageSql.AppendLine("UPDATE officedba.OfficeThingsPurchaseApplyDetail ");
OfficeThingsStorageSql.AppendLine("SET InCount=isnull(InCount,0)+@InCount ");
OfficeThingsStorageSql.AppendLine(" WHERE ID=@FromBillID AND CompanyCD=@CompanyCD ");
#endregion
#region 设置参数
SqlParameter[] OfficeThingsStorageParams = new SqlParameter[3];
OfficeThingsStorageParams[0] = SqlHelper.GetParameter("@FromBillID", FromBillID);
OfficeThingsStorageParams[1] = SqlHelper.GetParameter("@InCount", OfficeThingsBuyDetailM.BuyCount);
OfficeThingsStorageParams[2] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsBuyDetailM.CompanyCD);
#endregion
SqlCommand OfficeThingsStorageComInfo = new SqlCommand(OfficeThingsStorageSql.ToString());
OfficeThingsStorageComInfo.Parameters.AddRange(OfficeThingsStorageParams);
// comms[(i+1)] = OfficeThingsStorageComInfo;
listADD.Add(OfficeThingsStorageComInfo);
}
}
//执行
// SqlHelper.ExecuteTransForList(comms);
SqlHelper.ExecuteTransWithArrayList(listADD);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}