Exemplo n.º 1
0
 private UnitSearchData GetData()
 {
     UnitSearchData data = new UnitSearchData();
     data.ACTIVE = (this.chkActive.Checked ? Constz.ActiveStatus.Active : Constz.ActiveStatus.InActive);
     data.CODE = txtCode.Text.Trim();
     data.LOID = this.txtLOID.Text == "" ? 0 : Convert.ToDouble(this.txtLOID.Text);
     data.NAME = this.txtName.Text.Trim();
     data.ENAME = this.txtEName.Text.Trim();
     data.TYPE = this.rbtIsType.SelectedItem.Value.Trim();
     return data;
 }
Exemplo n.º 2
0
 private void SetData(UnitSearchData data)
 {
     if (data.LOID == 0)
     {
         this.rbtIsType.SelectedIndex = 0;
         this.chkActive.Checked = true;
     }
     this.txtLOID.Text = data.LOID.ToString();
     this.txtCode.Text = data.CODE;
     this.txtName.Text = data.NAME.Trim();
     this.txtEName.Text = data.ENAME.Trim();
     this.rbtIsType.SelectedIndex = this.rbtIsType.Items.IndexOf(this.rbtIsType.Items.FindByValue(data.TYPE));
     this.chkActive.Checked = (data.ACTIVE == Constz.ActiveStatus.Active);
 }
Exemplo n.º 3
0
 private bool VeridateData(UnitSearchData data)
 {
     bool ret = true;
     if (data.NAME.Trim() == "")
     {
         ret = false;
         _error = "¡ÃسÒÃкت×èÍ˹èǹѺÀÒÉÒä·Â";
     }
     else if (data.ENAME.Trim() == "")
     {
         ret = false;
         _error = "¡ÃسÒÃкت×èÍ˹èǹѺÀÒÉÒÍѧ¡ÄÉ";
     }
     else if (data.TYPE.Trim() == "")
     {
         ret = false;
         _error = "¡ÃسÒÃкØà¾×èÍãªéÊÓËÃѺ";
     }
     return ret;
 }
Exemplo n.º 4
0
        public ArrayList GetSearchUnit(UnitSearchData uSearch)
        {
            //string str = "";
            ArrayList arrResult = new ArrayList();

            //str = " SELECT * FROM UNIT ";
            //str += " WHERE NAME = '" + name + "'";
            //str += " AND E = " + Ename;

            //if (Barcode != "")
            //{
            //    str += " AND BARCODE  = '" + Barcode + "'";
            //}

            //if (PName != "")
            //{
            //    str += " AND PNAME LIKE '%" + PName + "%'";
            //}

            //try
            //{
            //    OracleDataReader zRd = OracleDB.ExecQueryCmd(str);
            //    arrResult.Clear();
            //    int i = 1;
            //    while (zRd.Read())
            //    {
            //        V_Product_List_RequisitionData irData = new V_Product_List_RequisitionData();
            //        irData.ORDERNO = i;
            //        irData.BARCODE = zRd["BARCODE"].ToString();
            //        irData.PNAME = zRd["PNAME"].ToString();
            //        arrResult.Add(irData);
            //        i = i + 1;
            //    }
            //}
            //catch (Exception ex)
            //{
            //    throw ex;
            //}
            return arrResult;
        }
Exemplo n.º 5
0
        public bool UpdateData(string userID, UnitSearchData data)
        {
            bool ret = true;
            if (VeridateData(data))
            {

                OracleDBObj obj = new OracleDBObj();
                obj.CreateConnection();
                obj.CreateTransaction();
                try
                {
                    DALObj.GetDataByLOID(data.LOID, obj.zTrans);
                    DALObj.LOID = data.LOID;
                    DALObj.NAME = data.NAME.Trim();
                    DALObj.ENAME = data.ENAME.Trim();
                    DALObj.TYPE = data.TYPE.Trim();
                    DALObj.CODE = data.CODE.Trim();
                    DALObj.ACTIVE = data.ACTIVE.Trim();

                    int check = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT(*) FROM UNIT WHERE NAME ='" + data.NAME.Trim() + "' AND LOID != " + data.LOID));
                    int check1 = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT(*) FROM UNIT WHERE ENAME ='" + data.ENAME.Trim() + "' AND LOID != " + data.LOID));
                    if (check > 0)
                    {
                        ret = false;
                        _error = "ª×èÍ˹èǹѺÀÒÉÒä·Â«éÓ";
                    }
                    else if (check1 > 0)
                    {
                        ret = false;
                        _error = "ª×èÍ˹èǹѺÀÒÉÒÍѧ¡ÄÉ«éÓ";
                    }
                    else
                    {
                        // äÁè«éÓ ·Ó¡Òà insert 
                    if (DALObj.OnDB)
                        ret = DALObj.UpdateCurrentData(userID, obj.zTrans);
                    else
                        ret = DALObj.InsertCurrentData(userID, obj.zTrans);

                    _LOID = DALObj.LOID;
                    if (ret)
                        {
                            obj.zTrans.Commit();
                            obj.CloseConnection();
                        }
                        else
                        {
                            throw new ApplicationException(DALObj.ErrorMessage);
                        }
                    }
                }
                catch (Exception ex)
                {
                    obj.zTrans.Rollback();
                    obj.CloseConnection();
                    ret = false;
                    _error = ex.Message;
                }
            }
            else ret = false;
            return ret;
        }
Exemplo n.º 6
0
 public UnitSearchData GetData(double loid)
 {
     UnitSearchData data = new UnitSearchData();
     if (DALObj.GetDataByLOID(loid, null))
     {
         data.ACTIVE = DALObj.ACTIVE;
         data.TYPE = DALObj.TYPE;
         data.CODE = DALObj.CODE;
         data.LOID = DALObj.LOID;
         data.NAME = DALObj.NAME;
         data.ENAME = DALObj.ENAME;
     }
     return data;
 }