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; }
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); }
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; }
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; }
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; }
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; }