/// <summary>
/// 判断是否在库存里次物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool IsNewMaterials(InvBalRealAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from InvBalRealAccount ");
strSql.Append(" where WareHouseID=@WareHouseID and MaterialID=@MaterialID");
SqlParameter[] parameters =
{
new SqlParameter("@WareHouseID", SqlDbType.VarChar, 36),
new SqlParameter("@MaterialID", SqlDbType.VarChar, 36)
};
parameters[0].Value = model.WareHouseID;
parameters[1].Value = model.MaterialID;
int rows = (int)DBAccess.ExecuteScalar(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 入库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InWH(InvBalRealAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update InvBalRealAccount set ");
strSql.Append("CurQtyBalance=CurQtyBalance + @CurQtyBalance");
strSql.Append(" where WareHouseID=@WareHouseID and MaterialID=@MaterialID");
SqlParameter[] parameters =
{
new SqlParameter("@WareHouseID", SqlDbType.VarChar, 36),
new SqlParameter("@MaterialID", SqlDbType.VarChar, 36),
new SqlParameter("@CurQtyBalance", SqlDbType.Decimal, 13)
};
parameters[0].Value = model.WareHouseID;
parameters[1].Value = model.MaterialID;
parameters[2].Value = model.CurQtyBalance;
int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 导入新入库物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int NewIn(InvBalRealAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into InvBalRealAccount(");
strSql.Append("ID,WareHouseID,MaterialID,CurQtyBalance)");
strSql.Append(" values (");
strSql.Append("@ID,@WareHouseID,@MaterialID,@CurQtyBalance)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 36),
new SqlParameter("@WareHouseID", SqlDbType.VarChar, 36),
new SqlParameter("@MaterialID", SqlDbType.VarChar, 36),
new SqlParameter("@CurQtyBalance", SqlDbType.Decimal, 13)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.WareHouseID;
parameters[2].Value = model.MaterialID;
parameters[3].Value = model.CurQtyBalance;
return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters));
}
/// <summary>
/// 判断是否在库存里次物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool IsNewMaterials(InvBalRealAccount model)
{
return(iInvBalRealAccountDAL.IsNewMaterials(model));
}
/// <summary>
/// 修改入库数量
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCurQtyBalance(InvBalRealAccount model)
{
return(iInvBalRealAccountDAL.UpdateCurQtyBalance(model));
}
/// <summary>
/// 出库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InWH(InvBalRealAccount model)
{
return(iInvBalRealAccountDAL.InWH(model));
}
/// <summary>
/// 新入库物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int NewIn(InvBalRealAccount model)
{
return(iInvBalRealAccountDAL.NewIn(model));
}
