/// <summary>
/// 获取对象实例
/// </summary>
/// <param name="SKid">库存ID</param>
/// <returns>DAO.Stock</returns>
public DAO.Stock GetModel(string SKid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from db_stock where sk_id="+SKid);
DataSet myDS = DBHelperSQL.Query(strSql.ToString());
DAO.Stock myModel = new DAO.Stock();
if(myDS.Tables[0].Rows.Count>0)
{
myModel.SKid = SKid;
myModel.SKCKid = myDS.Tables[0].Rows[0]["SK_CK_ID"].ToString().Trim();
myModel.SKGSid = myDS.Tables[0].Rows[0]["SK_GS_ID"].ToString().Trim();
myModel.SKquantity =int.Parse( myDS.Tables[0].Rows[0]["SK_quantity"].ToString());
return myModel;
}
else
{
return null;
}
}
//,DAO.Stock myDAOSK,delegateAddStorage myStorage)//, delegeteAddStock myStock)
/// <summary>
///
/// </summary>
/// <param name="myDAOST"></param>
/// <param name="myDAOSK"></param>
/// <param name="myStorage"></param>
/// <returns></returns>
public string AddSTMore_StockMore(DAO.Storage[] myDAOST)
{
Control.StockManage mySM=new StockManage();
DAO.Stock[] myDAOsk=new DAO.Stock[myDAOST.Length];
//把storage[]转为Stock[]
for (int i = 0; i < myDAOsk.Length;i++ )
{
}
try
{
if (myModel_SM.AddST_More(myDAOST) & mySM.StockAddorUpdate(myDAOsk))
{
return "添加入库单成功";
}
else
{
return "添加入库单失败";
}
}
catch
{ return "添加入库单异常"; }
}
/// <summary>
/// 设置对象实例
/// </summary>
/// <param name="SKid">ID</param>
/// <param name="SKCKid">仓库</param>
/// <param name="SKGSid">物品</param>
/// <param name="SKquantity">数量</param>
/// <returns>DAO.Stock</returns>
public DAO.Stock SetModel(string SKid,string SKCKid,string SKGSid,int SKquantity)
{
DAO.Stock myModel = new DAO.Stock();
myModel.SKid = SKid;
myModel.SKCKid = SKCKid;
myModel.SKGSid = SKGSid;
myModel.SKquantity = SKquantity;
return myModel;
}
