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