private void bind_emp() { string str = ""; if (ddlEmpType.SelectedIndex > 0) { str = " select NAME+' ('+CODE+')' NAME, CODE from V_paybill where DESG_TYPE='" + ddlEmpType.SelectedValue.ToString().Trim() + "' and GPF_TYPE='" + ddlGpsMps.SelectedItem.Text + "' order by NAME"; } else { str = " select NAME+' ('+CODE+')' NAME, CODE from V_paybill order by NAME"; } DataTable dt = cc.EQ(str); if (dt.Rows.Count > 0) { ddl_emp.DataTextField = "NAME"; ddl_emp.DataValueField = "CODE"; ddl_emp.DataSource = dt; ddl_emp.DataBind(); ddl_emp.Items.Insert(0, new ListItem("--Select--", "0")); } else { ddl_emp.Items.Clear(); } }
public void SearchDesignation() { string strSearch = ""; string MName = txtSearchDesignationName.Text.Trim(); strSearch = @"SELECT Name, (CASE WHEN MDesignation.SHName='HO' THEN 'Head Officer' WHEN MDesignation.SHName='RO' THEN 'Divisional Officer' WHEN MDesignation.SHName='DO' THEN 'District Officer' ELSE 'Auditor' END )SHName1, SHName, ID,HName, isnull(TreeLevel,0) as TreeLevel, isnull(MDesignation.ParentID,null)ParentID, (select Name from MDesignation mm where mm.ID=MDesignation.ParentID )PName from MDesignation where Name like '" + MName + "%'"; DataTable dt1 = cc.EQ(strSearch); if (dt1.Rows.Count > 0) { grd.DataSource = dt1; grd.DataBind(); } else { grd.DataSource = null; grd.DataBind(); } }
public DataTable Get_Trn_No() { DataTable dtTRN_NO = new DataTable(); return(dtTRN_NO = cc.EQ("SELECT ISNULL(MAX([TRN_NO]),0) AS TRN_NO FROM [Trans].[MEMBERS]")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserID"] == null) { Response.Redirect("~\\Login.aspx"); } else { string str = "~" + Request.FilePath; DataTable dtYear = new DataTable(); dtYear = cc.EQ("select dbo.FIN_YEAR('" + Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd") + "')"); if (Session["FinYear"].ToString().Trim() == dtYear.Rows[0][0].ToString().Trim()) { btnSave.Enabled = true; btnReset.Enabled = true; } else { btnSave.Enabled = false; btnReset.Enabled = false; } string Userid = Session["UserID"].ToString(); if (!cc.FormAuthorize(Userid, str)) { Response.Redirect("~\\MessagePage.aspx"); } } BindgrdApplForMendatoryDocs(); cc.FillDDL2(ref ddlVendor, "---Select---", "V_Name", "V_Code", "Master.VENDOR"); if (Session["TypeCode"] != null) { ddlVendor.SelectedValue = Session["TypeCode"].ToString(); ddlVendor.Enabled = false; string strDistributor = "SELECT V_CODE, Distb_CODE, Distb_NAME, Status FROM Master.Distributor WHERE V_Code='" + ddlVendor.SelectedValue.Trim() + "' And Status='A'"; DataTable dtDistributor = SQL_DBCS.ExecuteDataTable(strDistributor); ddlDistributor.DataSource = dtDistributor; ddlDistributor.DataTextField = "Distb_NAME"; ddlDistributor.DataValueField = "Distb_CODE"; ddlDistributor.DataBind(); ddlDistributor.Items.Insert(0, "---Select---"); ddlDistributor.SelectedIndex = 0; //cc.FillDDLFrom2(ref ddlDistributor, "---Select---", "Distb_NAME", "Distb_CODE", "Master.Distributor", "V_Code", ddlVendor.SelectedValue.Trim()); txtApplNo.Focus(); } BindgrdgrdUploadedMendatoryDocs(); if (Request.QueryString["ApplNo"] != null) { //txtApplNo.Text = Request.QueryString["ApplNo"].ToString(); string SQL = "", App_no; App_no = Request.QueryString["ApplNo"].ToString(); SQL = @"SELECT App_No,Name,V_NAME,B_NAME,D_NAME FROM Trans.APPLICATIONS INNER JOIN Master.VILLMST ON Trans.APPLICATIONS.V_CODE=Master.VILLMST.V_CODE INNER JOIN Master.DSTMST ON Trans.APPLICATIONS.D_Code=Master.DSTMST.D_CODE INNER JOIN Master.BLOCKMST ON Master.DSTMST.D_CODE = Master.BLOCKMST.D_CODE WHERE APP_NO='" + App_no + "'"; DataTable dt = new DataTable(); dt = cc.EQ(SQL); if (dt.Rows.Count > 0) { lblAppNo.Text = dt.Rows[0]["App_No"].ToString(); lblFarmerName.Text = dt.Rows[0]["Name"].ToString(); lblAddress.Text = "Village:" + dt.Rows[0]["V_NAME"].ToString() + ", Block:" + dt.Rows[0]["B_NAME"].ToString() + ", District:" + dt.Rows[0]["D_NAME"].ToString(); } } } }