private void LoadGRN_DDL(string strGRNNo) { if (ddlPayInvNo.SelectedIndex == 0) { string WhereQuery = "A.DealerCode = '" + Session["DealerCode"].ToString() + "' " + "and A.DCNo=B.DCNo And A.DealerCode=B.DealerCode " + "and A.DelFlag = 'N' " + "and A.VendorCode = '" + ddlVendor.SelectedValue.ToString() + "'" + "And A.GRNNo in(Select GRNNo From GRNDetail Where DealerCode ='" + Session["DealerCode"].ToString() + "' And AccQty <> PayablePaidQty)"; //"Order by a.PRNo Desc"; string[] Columns = new string[] { "A.GRNNo", "convert(varchar(20),A.GRnDate,105)", "'PO: '+A.PoNo", "'Vend DCNo: ' +B.VendorDCNo" }; SysFunc.GetMultiColumnsDDL(ddlGRN, Columns, "GRNMaster A , DCMaster B", WhereQuery, "GRNNo", "Order by A.GRNNo Desc", false, false); } else { string WhereQuery = "A.DealerCode = '" + Session["DealerCode"].ToString() + "' " + "and A.DCNo=B.DCNo And A.DealerCode=B.DealerCode " + "and A.DelFlag = 'N' " + "and A.VendorCode = '" + ddlVendor.SelectedValue.ToString() + "'" + "And A.GRNNo ='" + strGRNNo + "'"; //"Order by a.PRNo Desc"; string[] Columns = new string[] { "A.GRNNo", "convert(varchar(20),A.GRnDate,105)", "'PO: '+A.PoNo", "'Vend DCNo: ' +B.VendorDCNo" }; SysFunc.GetMultiColumnsDDL(ddlGRN, Columns, "GRNMaster A , DCMaster B", WhereQuery, "GRNNo", "Order by A.GRNNo Desc", false, false); } }
private void Load_ddlIssueNo() { if (ddlStockReturnNo.SelectedIndex == 0) { string WhereClause = "A.DealerCode = '" + Session["DealerCode"].ToString() + "' " + "And A.DealerCode = B.DealerCode " + "And A.IssueNo = B.IssueNo " + "AND A.DelFlag = 'N' " + "AND A.PostFlag = 'Y' " + "AND ( (A.JobCardNo <> '' And A.JobCardNo IN (Select JobCardCode From Jobcardmaster Where DelFlag = 'N' and Gatepass='' and DealerCode = '"+ Session["DealerCode"].ToString() + "' )) " + "Or (A.InvoiceNo <> '' And A.InvoiceNo IN (Select SaleInvNo From CounterSaleMaster WHere PostFlag = 'N' And DelFlag = 'N' and DealerCode = '" + Session["DealerCode"].ToString() + "' ) ) ) "; string[] Columns = new string[] { "A.IssueNo", "convert(varchar(10),A.IssueDate,105)", "A.ReqSource", "ISNULL(A.JobCardNo, A.InvoiceNo)" }; SysFunc.GetMultiColumnsDDL(ddlIssueNo, Columns, "StockIssue A , StockIssueDetail B ", WhereClause, "IssueNo", " Order by A.IssueNo Desc ", true, true, "Having(sum(B.IssueQty) > sum(B.RetQty))"); ddlIssueNo.Enabled = true; } else { string WhereClause = "DealerCode = '" + Session["DealerCode"].ToString() + "' " + "And ReturnNo='" + ddlStockReturnNo.SelectedValue.ToString().Trim() + "' " + "and DelFlag = 'N' "; string[] Columns = new string[] { "ReturnNo", "convert(varchar(10),ReturnDate,105)", "ReqSource", "'JC:' + JobCardNo", "'Inv:' + InvoiceNo" }; SysFunc.GetMultiColumnsDDL(ddlIssueNo, Columns, "StockReturn", WhereClause, "ReturnNo", " Order by ReturnNo Desc ", false, false); ddlIssueNo.SelectedIndex = 1; ddlIssueNo.Enabled = false; } }
private void LoadDDL_Bank() { string WhereQuery = "1=1"; string[] Columns = new string[] { "BankCode", "BankDesc" }; SysFunc.GetMultiColumnsDDL(ddlbank, Columns, "Bank", WhereQuery, "BankCode", "", false, false); }
private void Load_ddlComplaintby() { string WhereClause = "DealerCode = '" + Session["DealerCode"] + "'"; string[] Columns = new string[] { "EmpCode", "EmpName" }; sysFuncs.GetMultiColumnsDDL(ddlComplaintby, Columns, "DealerEmp ", WhereClause, "EmpCode", " Order by EmpCode Desc ", false, false); }
private void Load_ddlCounterNo() { string WhereClause = " a.DealerCode = '" + Session["DealerCode"].ToString() + "' " + "and a.DelFlag = 'N' " + "and a.DealerCode = b.DealerCode And a.IssueNo = b.IssueNo "; string[] Columns = new string[] { "a.IssueNo", "Convert(varchar(10),a.IssueDate,105)", "+'JC: '+IsNull(a.JobCardNo,'')", "+'CS: '+IsNull(a.InvoiceNo,'')" }; SysFunc.GetMultiColumnsDDL(ddlIssueNo, Columns, "StockIssue a,StockIssueDetail b", WhereClause, "IssueNo", " Order by a.IssueNo Desc ", true, false); }
private void Load_ddlLocCode() { string WhereQuery = "DealerCode = '" + Session["DealerCode"].ToString() + "'"; string[] Columns = new string[] { "PartsLocCode", "PartsLocDesc" }; SysFunc.GetMultiColumnsDDL(ddlLocCode, Columns, "PartsLocation", WhereQuery, "PartsLocCode", "", false, false); //SqlParameter[] LocMaster_param = { // new SqlParameter("@DealerCode",SqlDbType.Char,5)}; //LocMaster_param[0].Value = Session["DealerCode"].ToString(); //objMBLL.FillDrp_SP(ddlLocCode, "sp_Load_PartLocCode", "PartsLocCode", "PartsLocDesc", LocMaster_param, true, "--Select--", false, ""); }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["UserName"] == null) { Response.Redirect("~/login.aspx"); } if (!sec.UserRight("2550", "001")) { Response.Redirect("~/Test.aspx"); } if (!IsPostBack) { //ViewState["ObjPOds"] = ObjPOds; createPartsDT(); string[] Columns = new string[] { "CusCode", "CusDesc", "NIC", "Phone1" }; SysFunc.GetMultiColumnsDDL(ddlCustomer, Columns, "Customer", "DealerCode ='" + Session["DealerCode"].ToString() + "'", "CusCode", " Order by CusDesc ", false, false); Load_ddlSRNo(); if (txtRetDate.Text.Length == 0) { txtRetDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); } rdCounterSale.Enabled = false; rdJobCard.Enabled = false; rdJobCard.Checked = false; rdCounterSale.Checked = false; } }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["UserName"] == null) { Response.Redirect("~/login.aspx"); } if (!sec.UserRight("2579", "001")) { Response.Redirect("~/Test.aspx"); } if (!IsPostBack) { DateTime dt = DateTime.Today; txtMonth.Text = dt.ToString("MM/yyyy"); string where = "DealerCode = '" + Session["DealerCode"].ToString() + "'"; string[] col = { "VendorCode", "VendorDesc" }; myFunc.GetMultiColumnsDDL(ddlVendor, col, "Vendor", where, "VendorCode", "", false, false); } }