private void SetData(ProductTypeSearchData data) { this.txtLOID.Text = data.LOID.ToString(); this.txtCode.Text = data.CODE.Trim(); this.chkActive.Checked = (data.ACTIVE == Constz.ActiveStatus.Active); this.txtName.Text = data.NAME.Trim(); this.rbtIsType.SelectedValue = data.TYPE; }
private ProductTypeSearchData GetData() { ProductTypeSearchData data = new ProductTypeSearchData(); data.ACTIVE = (this.chkActive.Checked ? Constz.ActiveStatus.Active : Constz.ActiveStatus.InActive); data.CODE = this.txtCode.Text.Trim(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.NAME = this.txtName.Text.Trim(); data.TYPE = this.rbtIsType.SelectedItem.Value.Trim(); return data; }
public ProductTypeSearchData GetData(double loid) { ProductTypeSearchData data = new ProductTypeSearchData(); if (DALObj.GetDataByLOID(loid, null)) { data.ACTIVE = DALObj.ACTIVE; data.CODE = DALObj.CODE; data.LOID = DALObj.LOID; data.NAME = DALObj.NAME; data.TYPE = DALObj.TYPE; } return data; }
private bool VeridateData(ProductTypeSearchData data) { bool ret = true; if (data.CODE.Trim() == "") { ret = false; _error = "¡ÃسÒÃкØÃËÑÊ»ÃÐàÀ·ÊÔ¹¤éÒ"; } else if (data.NAME.Trim() == "") { ret = false; _error = "¡ÃسÒÃкت×èÍ»ÃÐàÀ·ÊÔ¹¤éÒ"; } return ret; }
public bool UpdateData(string userID, ProductTypeSearchData 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.ACTIVE = data.ACTIVE.Trim(); DALObj.CODE = data.CODE.Trim(); DALObj.TYPE = data.TYPE.Trim(); int check = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT( *) FROM PRODUCTTYPE WHERE CODE ='" + data.CODE.Trim() + "' AND LOID != " + data.LOID)); int check1 = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT( *) FROM PRODUCTTYPE WHERE NAME ='" + data.NAME.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; }