public view_Deduct_head GET(string strCriteria) { view_Deduct_head result = null; var strMessage = string.Empty; DataSet ds = null; if (SP_DEDUCT_HEAD_SEL(strCriteria, ref ds, ref strMessage)) { result = Helper.ToClassInstanceCollection <view_Deduct_head>(ds.Tables[0]).FirstOrDefault(); } return(result); }
private void BindGridView(int nPageNo) { var oDeduct = new cDeduct(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; var deduct_head = new view_Deduct_head(); string strScript = string.Empty; #region Criteria deduct_head.deduct_year = cboYear.SelectedValue; deduct_head.degree_code = cboDegree.SelectedValue; deduct_head.deduct_doc_no = txtdeduct_doc.Text.Replace("'", "''").Trim(); deduct_head.budget_plan_code = txtbudget_plan_code.Text.Replace("'", "''").Trim(); deduct_head.unit_code = cboUnit.SelectedValue; deduct_head.budget_code = cboBudget.SelectedValue; deduct_head.produce_code = cboProduce.SelectedValue; deduct_head.activity_code = cboActivity.SelectedValue; deduct_head.plan_code = cboPlan_code.SelectedValue; deduct_head.item_group_detail_code = cboItem_group_detail.SelectedValue; if (!deduct_head.deduct_year.Equals("")) { strCriteria = strCriteria + " And (deduct_year = '" + deduct_head.deduct_year + "') "; } if (!deduct_head.degree_code.Equals("")) { strCriteria = strCriteria + " And (degree_code = '" + deduct_head.degree_code + "') "; } if (!string.IsNullOrEmpty(txtdate_begin.Text)) { strCriteria = strCriteria + " And (deduct_date >= '" + cCommon.SeekDate(txtdate_begin.Text) + "') "; } if (!string.IsNullOrEmpty(txtdate_end.Text)) { strCriteria = strCriteria + " And (deduct_date <= '" + cCommon.SeekDate(txtdate_end.Text) + "') "; } if (!deduct_head.deduct_doc_no.Equals("")) { strCriteria = strCriteria + " And (deduct_doc_no LIKE '%" + deduct_head.deduct_doc_no + "%') "; } if (!deduct_head.budget_plan_code.Equals("")) { strCriteria = strCriteria + " And (budget_plan_code ='" + deduct_head.budget_plan_code + "') "; } if (!deduct_head.unit_code.Equals("")) { strCriteria = strCriteria + " And (unit_code ='" + deduct_head.unit_code + "') "; } if (!deduct_head.budget_code.Equals("")) { strCriteria = strCriteria + " And (budget_code ='" + deduct_head.budget_code + "') "; } if (!deduct_head.produce_code.Equals("")) { strCriteria = strCriteria + " And (produce_code ='" + deduct_head.produce_code + "') "; } if (!deduct_head.activity_code.Equals("")) { strCriteria = strCriteria + " And (activity_code = '" + deduct_head.activity_code + "') "; } if (!deduct_head.plan_code.Equals("")) { strCriteria = strCriteria + " And (plan_code = '" + deduct_head.plan_code + "') "; } if (!deduct_head.item_group_detail_code.Equals("")) { strCriteria = strCriteria + " And (item_group_detail_code = '" + deduct_head.item_group_detail_code + "') "; } if (DirectorLock == "Y") { strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; } #endregion //strCriteria = strCriteria + " and budget_type ='" + this.BudgetType + "' "; try { if (!oDeduct.SP_DEDUCT_HEAD_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oDeduct.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
private void setData() { view_Deduct_head deduct_head = null; cDeduct oDeduct = new cDeduct(); try { _strCriteria = " and deduct_doc_no = '" + ViewState["deduct_doc"].ToString() + "' "; deduct_head = oDeduct.GET(_strCriteria); if (deduct_head != null) { #region set Control TabContainer1.Tabs[1].Visible = true; //Tab 1 txtUpdatedBy.Text = deduct_head.c_updated_by; txtUpdatedDate.Text = deduct_head.d_updated_date.ToString(); txtdeduct_doc.Text = deduct_head.deduct_doc_no; txtdeduct_date.Text = deduct_head.deduct_date.Value.ToString("dd/MM/yyyy"); txtbudget_money_doc.Text = deduct_head.budget_money_doc; InitcboYear(); if (cboYear.Items.FindByValue(deduct_head.deduct_year) != null) { cboYear.SelectedIndex = -1; cboYear.Items.FindByValue(deduct_head.deduct_year).Selected = true; } InitcboDegree(); if (cboDegree.Items.FindByValue(deduct_head.degree_code) != null) { cboDegree.SelectedIndex = -1; cboDegree.Items.FindByValue(deduct_head.degree_code).Selected = true; } InitcboMajor(); if (cboMajor.Items.FindByValue(deduct_head.major_code) != null) { cboMajor.SelectedIndex = -1; cboMajor.Items.FindByValue(deduct_head.major_code).Selected = true; } txtbudget_plan_code.Text = deduct_head.budget_plan_code; txtbudget_name.Text = deduct_head.budget_name; txtproduce_name.Text = deduct_head.produce_name; txtactivity_name.Text = deduct_head.activity_name; txtplan_name.Text = deduct_head.plan_name; txtwork_name.Text = deduct_head.work_name; txtfund_name.Text = deduct_head.fund_name; txtdirector_name.Text = deduct_head.director_name; txtunit_name.Text = deduct_head.unit_name; txtcomment.Text = deduct_head.deduct_remark; txtrecv_total_amount.Value = deduct_head.recv_total_amount; txtdeduct_total_reduce.Value = deduct_head.deduct_total_reduce; txtdeduct_total_reduce_director.Value = deduct_head.deduct_total_reduce_director; txtdeduct_total_remain.Value = deduct_head.deduct_total_remain; txtrecv_doc_no.Text = deduct_head.recv_doc_no; InitcboItem_group_detail(); if (cboItem_group_detail.Items.FindByValue(deduct_head.item_group_detail_id.ToString()) != null) { cboItem_group_detail.SelectedIndex = -1; cboItem_group_detail.Items.FindByValue(deduct_head.item_group_detail_id.ToString()).Selected = true; } BindGridDetail(); TabContainer1.Tabs[2].Visible = true; txtbudget_receive_doc.Text = deduct_head.budget_receive_doc; BindGridDetailReceive(); #endregion } } catch (Exception ex) { //lblError.Text = ex.Message.ToString(); } }