Example #1
0
        private bool UpdatePackageLost(string UserID, DataTable tempTable, OracleDBObj objDB, double PdpLoid)
        {
            bool ret = true;
            double MILoid = 0;
            for (int i = 0; i < tempTable.Rows.Count; i++)
            {
                MaterialItemDAL miDAL = new MaterialItemDAL();
                DataTable dtt = GetMILoid(PdpLoid, Convert.ToDouble(tempTable.Rows[i]["MTRLOID"]));
                if (dtt.Rows.Count > 0)
                    MILoid = Convert.ToDouble(dtt.Rows[0]["LOID"]); miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
                miDAL.GetDataByLOID(MILoid, null);
                miDAL.RETURNQTY = Convert.ToDouble(tempTable.Rows[i]["RETURNQTY"]);
                miDAL.CHANGEQTY = Convert.ToDouble(tempTable.Rows[i]["CHANGEQTY"]);
                miDAL.REMARK = tempTable.Rows[i]["REMARK"].ToString();
                miDAL.WASTEQTYMAT = Convert.ToDouble(tempTable.Rows[i]["WASTEQTYMAT"]);
                miDAL.YIELDMAT = Convert.ToDouble(tempTable.Rows[i]["YIELDMAT"]);

                ret = miDAL.UpdateCurrentData(UserID, objDB.zTrans);

                if (ret == false)
                {
                    _error = miDAL.ErrorMessage;
                    return false;
                }
            }
            return true;
        }