public Hashtable GetTransationsTop(Hashtable htLcoAllParams2, string username2, string catid2, string operator_id2) { string whereString = ""; string lcd = htLcoAllParams2["lcd"].ToString(); string lnm = htLcoAllParams2["lnm"].ToString(); string txtsear = htLcoAllParams2["txtsear"].ToString(); string searchParamStr = ""; if (lcd == "0") { whereString += " UPPER(lcocode) LIKE UPPER('" + txtsear.ToString().Trim() + "') "; } if (lnm == "1") { whereString += " UPPER(lconame) LIKE UPPER('" + txtsear.ToString().Trim() + "') "; } //if (catid2 == "2") //{ // whereString += " and PARENTID= '" + operator_id2 + "' "; //} //else if (catid2 == "5") //{ // whereString += " and DISTID= '" + operator_id2 + "' "; //} //else if (catid2 == "3") //{ whereString += " and OPERID= '" + operator_id2 + "' "; //} //else if (catid2 == "10") //{ // whereString += " and hoid= '" + operator_id2 + "' "; //} //else //{ //} Cls_Data_RptLcoAll objDataRptLcoAll = new Cls_Data_RptLcoAll(); Hashtable htResponse = new Hashtable(); htResponse.Add("htResponse2", objDataRptLcoAll.GetTransationsTopDets(whereString, username2)); htResponse.Add("ParamStr2", searchParamStr); return(htResponse); }
public Hashtable GetTransationsLastF(Hashtable htLcoAllParams1, string username1, string catid1, string operator_id1) { string whereString = ""; string lcd = htLcoAllParams1["lcd"].ToString(); string lnm = htLcoAllParams1["lnm"].ToString(); string txtsear = htLcoAllParams1["txtsear"].ToString(); string searchParamStr = ""; if (lcd == "0") { whereString += " UPPER(lcocode) LIKE UPPER('" + txtsear.ToString().Trim() + "') "; } if (lnm == "1") { whereString += " UPPER(lconame) LIKE UPPER('" + txtsear.ToString().Trim() + "') "; } if (catid1 == "2") { whereString += " and PARENTID= '" + operator_id1 + "' "; } else if (catid1 == "5") { whereString += " and DISTID= '" + operator_id1 + "' "; } else if (catid1 == "3") { whereString += " and OPERID= '" + operator_id1 + "' "; } else if (catid1 == "10") { whereString += " and hoid= '" + operator_id1 + "' "; } else { } Cls_Data_RptLcoAll objDataRptLcoAll = new Cls_Data_RptLcoAll(); Hashtable htResponse = new Hashtable(); htResponse.Add("htResponse1", objDataRptLcoAll.GetTransationsLastFDets(whereString, username1)); htResponse.Add("ParamStr1", searchParamStr); return(htResponse); }
public DataTable GetLedgerData(string _lcoid, string username, string catid, string operator_id) { string whereString = ""; string from = DateTime.Today.ToString("dd-MMM-yyyy"); string to = DateTime.Today.ToString("dd-MMM-yyyy"); string lcoid = _lcoid; if (from != null && from != "") { whereString += " dt >= '" + from + "' "; } if (to != null && to != "") { whereString += " and dt <= '" + to + "' "; } if (lcoid != null && lcoid != "") { whereString += " and lcoid = '" + lcoid + "' "; } //if (catid == "2") //{ // whereString += " and PARENTID= '" + operator_id + "' "; //} //else if (catid == "5") //{ // whereString += " and DISTID= '" + operator_id + "' "; //} //else if (catid == "3") //{ whereString += " and OPERID= '" + operator_id + "' "; //} //else if (catid == "10") //{ // whereString += " and hoid= '" + operator_id + "' "; //} Cls_Data_RptLcoAll objDataRptAddPlan = new Cls_Data_RptLcoAll(); return(objDataRptAddPlan.GetPartyLedger(whereString, username)); }
public DataTable GetLedgerDet(string _lcoid, string username2) { string whereString = ""; string from = DateTime.Today.ToString("dd-MMM-yyyy"); string to = DateTime.Today.ToString("dd-MMM-yyyy"); string lcoid = _lcoid; if (from != null && from != "") { whereString += " dt >= '" + from + "' "; } if (to != null && to != "") { whereString += " and dt <= '" + to + "' "; } if (lcoid != null && lcoid != "") { whereString += " and lcoid = '" + lcoid + "' "; } Cls_Data_RptLcoAll objDataRptAddPlan = new Cls_Data_RptLcoAll(); return(objDataRptAddPlan.GetPartyLedgerDet(whereString, username2)); }
public DataTable GetUserDet(string username, string catid, string operid) { Cls_Data_RptLcoAll objDataRptAddPlan = new Cls_Data_RptLcoAll(); return(objDataRptAddPlan.GetUserDet(username, operid)); }
public string[] getLcoDataById(string username, string operid) { Cls_Data_RptLcoAll obj = new Cls_Data_RptLcoAll(); return(obj.GetLcoDataById(username, operid)); }
public string[] getLcoDatadetails(string username, string LcoName, string type, string operid, string catid) { Cls_Data_RptLcoAll obj = new Cls_Data_RptLcoAll(); return(obj.GetLcoDetails(username, LcoName, type, operid, catid)); }