Пример #1
0
    public bool UpdatePDItem(double LOID, double PRODUCT, double MASTER, string PRODUCTNAME, double UNIT, double USEQTY, double WASTEQTYMAT, double RETURNQTY, double RANK)
    {
        ReturnItemData data = new ReturnItemData();
        data.LOID = Convert.ToDouble(LOID);
        data.RETURNQTY = Convert.ToDouble(RETURNQTY);
        data.PDLOID = Convert.ToDouble(PRODUCT);
        data.PRODUCTNAME = PRODUCTNAME;
        data.MASTER = Convert.ToDouble(MASTER);
        data.USEQTY = Convert.ToDouble(USEQTY);
        data.WASTEQTYMAT = Convert.ToDouble(WASTEQTYMAT);
        data.UNIT = Convert.ToDouble(UNIT);
        bool ret = true;
        ret = VerifyData(data);

        if (ret)
        {
            DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
            if (dt != null)
            {
                DataRow[] dRows = dt.Select("LOID = " + LOID.ToString());
                DataRow dRow = dRows[0];
                //dRow["LOID"] = data.LOID;
                dRow["RETURNQTY"] = data.RETURNQTY;
                //dRow["PRODUCT"] = data.PDLOID;
                //dRow["MASTER"] = data.MASTER;
                //dRow["PRODUCTNAME"] = data.PRODUCTNAME;
                //dRow["USEQTY"] = data.USEQTY;
                //dRow["WASTEQTYMAT"] = data.WASTEQTYMAT;
                //dRow["UNIT"] = data.UNIT;

                ReOrder(dt);
                System.Web.HttpContext.Current.Session[sessionName] = dt;
            }
        }
        return ret;
    }
Пример #2
0
 //0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 MINSTOCK, 0 MAXSTOCK, 0 STOCK, 0 OLDPRICE, 0 CURPRICE, 0 MINPRICE, 0 LAST3MON, 0 LASTYEAR, ''DUEDATE, '' BARCODE, '' UNITNAME
 public bool InsertPDItem(ReturnItemData data)
 {
     bool ret = true;
     //ret = VerifyData(data);
     //if (ret)
     //{
     //    DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
     //    if (dt != null)
     //    {
     //        ReOrder(dt);
     //        DataRow dRow = dt.NewRow();
     //        dRow["LOID"] = Convert.ToDouble(dt.Rows.Count) + 1;
     //        dRow["RANK"] = Convert.ToDouble(dRow["LOID"]);
     //        dRow["RWBARCODE"] = Convert.ToDouble(dRow["RWBARCODE"]);
     //        dRow["RWNAME"] = Convert.ToDouble(dRow["RWNAME"]);
     //        dRow["RWGROUPNAME"] = Convert.ToDouble(dRow["RWGROUPNAME"]);
     //        //ProductSearchData product = FlowObj.GetProductData(data.PRODUCT);
     //        //dRow["BARCODE"] = product.BARCODE;
     //        //dRow["UNAME"] = FlowObj.GetUnitData(data.UNAME).NAME;
     //        dt.Rows.Add(dRow);
     //        System.Web.HttpContext.Current.Session[sessionName] = dt;
     //    }
     //}
     return ret;
 }
Пример #3
0
 public ArrayList GetRecentItemList()
 {
     DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
     ArrayList arr = new ArrayList();
     if (dt != null)
     {
         foreach (DataRow dRow in dt.Rows)
         {
             ReturnItemData data = new ReturnItemData();
             data.LOID = Convert.ToDouble(dRow["LOID"]);
             data.PDLOID = Convert.ToDouble(dRow["PRODUCT"]);
             data.MASTER = Convert.ToDouble(dRow["MASTER"]);
             data.PRODUCTNAME = dRow["PRODUCTNAME"].ToString();
             data.USEQTY = Convert.ToDouble(dRow["USEQTY"]);
             data.WASTEQTYMAT = Convert.ToDouble(dRow["WASTEQTYMAT"]);
             data.RETURNQTY = Convert.ToDouble(dRow["RETURNQTY"]);
             data.UNIT = Convert.ToDouble(dRow["UNIT"]);
             arr.Add(data);
         }
     }
     return arr;
 }
Пример #4
0
 private bool VerifyData(ReturnItemData data)
 {
     bool ret = true;
     //if (data.RWNAME = "")
     //{
     //    ret = false;
     //    _error = "¡ÃسÒàÅ×Í¡Çѵ¶Ø´Ôº";
     //}
     if (data.RETURNQTY == 0)
     {
         ret = false;
         _error = "¡ÃسÒÃкبӹǹ·Õè¤×¹";
     }
     //else
     //{
     //    DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
     //    foreach (DataRow dRow in dt.Rows)
     //    {
     //        if (dRow["RWBARCODE"] == data.RWBARCODE && Convert.ToDouble(dRow["LOID"]) != data.LOID)
     //        {
     //            _error = "ÃÒ¡ÒÃÇѵ¶Ø´Ôº¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
     //            ret = false;
     //            break;
     //        }
     //    }
     //}
     return ret;
 }