本文整理汇总了C#中Handler.GetTable方法的典型用法代码示例。如果您正苦于以下问题:C# Handler.GetTable方法的具体用法?C# Handler.GetTable怎么用?C# Handler.GetTable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Handler
的用法示例。
在下文中一共展示了Handler.GetTable方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: FillData
protected void FillData(string vehicleid)
{
Handler hd = new Handler();
DataTable dtcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION CATEGORY' and lm.headid=hm.srno ");
ddleditcategory.DataSource = dtcategory;
ddleditcategory.DataTextField = "NAME";
ddleditcategory.DataValueField = "VALUE";
ddleditcategory.DataBind();
DataTable dtsubcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION SUBCATEGORY' and lm.headid=hm.srno ");
ddleditsubcategory.DataSource = dtsubcategory;
ddleditsubcategory.DataTextField = "NAME";
ddleditsubcategory.DataValueField = "VALUE";
ddleditsubcategory.DataBind();
ddleditsubcategory.Items.Insert(0, "--Select--");
string sql = "SELECT * FROM TERMSCONDITION TM WHERE TM.SRNO=" + ViewState["termid"].ToString().Trim().ToString();
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sql);
txteditterms.Text = dtstate.Rows[0]["TERMS"].ToString().Trim();
txteditdescription.Text = dtstate.Rows[0]["DESCRIPTION"].ToString().Trim();
ddleditcategory.Items.FindByText(dtstate.Rows[0]["CATEGORY"].ToString().Trim()).Selected = true;
if (dtstate.Rows[0]["STATUS"].ToString().Trim() == "True")
{
ddlstatus.SelectedValue = "1";
}
else
{
ddlstatus.SelectedValue = "0";
}
}
示例2: ShowMenu
private void ShowMenu()
{
Handler hd = new Handler();
string rights = " select mt.menuid,mt.menuname,mt.menutype ,mt.mainmenu from menumaster mt inner join userrights ur on " +
"ur.menuid=mt.menuid inner join userrolemaster urm on urm.srno=ur.roleid " +
"where urm.userdesignation='" + Session["designation"].ToString() + "' and mt.status=0 and menutype='menu' order by mt.menutype";
DataTable dtrights = hd.GetTable(rights);
string subrights = " select mt.menuid,mt.menuname,mt.menutype ,mt.mainmenu,mm.menuname as mainmaenuname" +
" from menumaster mt inner join userrights ur on ur.menuid=mt.menuid inner join userrolemaster urm on urm.srno=ur.roleid " +
" inner join menumaster mm on mt.mainmenu=mm.menuid where urm.userdesignation='" + Session["designation"].ToString() + "' and mt.status=0 order by mt.menutype";
DataTable dtsubrights = hd.GetTable(subrights);
string main = string.Empty;
string menu = string.Empty;
rights = string.Empty;
foreach (DataRow dr in dtrights.Rows)
{
rights += dr["menuname"] + ",";
}
foreach (DataRow dr in dtsubrights.Rows)
{
menu += dr["menuname"] + ",";
main += dr["mainmaenuname"] + ",";
}
hdnrights.Value = rights;
hdnmenu.Value = menu;
hdnmainmenu.Value = main;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "hidediv();", true);
}
示例3: FillPreviousData
public void FillPreviousData()
{
string sqlcolliery = "SELECT CM.SRNO AS COLLIERYID,CM.COLLIERYNAME FROM COLLIERYMASTER CM WHERE STATUS=0";
Handler hdncolliery = new Handler();
DataTable dtcolliery = hdncolliery.GetTable(sqlcolliery);
ddlcolliery.DataSource = dtcolliery;
ddlcolliery.DataTextField = "COLLIERYNAME";
ddlcolliery.DataValueField = "COLLIERYID";
ddlcolliery.DataBind();
ddlcolliery.Items.Insert(0, "--Select--");
string sqldepartment = "SELECT LM.PARTYNAME,LM.SRNO FROM PARTYMASTER LM ORDER BY LM.PARTYNAME";
Handler hdndepartment = new Handler();
DataTable dtdepartment = hdndepartment.GetTable(sqldepartment);
ddlparty.DataSource = dtdepartment;
ddlparty.DataTextField = "PARTYNAME";
ddlparty.DataValueField = "SRNO";
ddlparty.DataBind();
ddlparty.Items.Insert(0, "-- Party --");
string sqlauction = "SELECT AUCTIONID,AUCTIONNAME FROM AUCTIONMASTER WHERE STATUS=0";
Handler hdnauction = new Handler();
DataTable dtauction = hdnauction.GetTable(sqlauction);
ddlauction.DataSource = dtauction;
ddlauction.DataTextField = "AUCTIONNAME";
ddlauction.DataValueField = "AUCTIONID";
ddlauction.DataBind();
ddlauction.Items.Insert(0, "-- Select Auction --");
string sqlcoaltype = "SELECT SRNO,COALTYPE FROM COALMASTER CM WHERE STATUS=0 AND COALTYPEID IS NULL";
Handler hdncoaltype = new Handler();
DataTable dtcoaltype = hdncoaltype.GetTable(sqlcoaltype);
ddlcoaltype.DataSource = dtcoaltype;
ddlcoaltype.DataTextField = "COALTYPE";
ddlcoaltype.DataValueField = "SRNO";
ddlcoaltype.DataBind();
ddlcoaltype.Items.Insert(0, "-- Select Coal --");
string sqlcolliery2 = "SELECT LM.NAME,LM.SRNO FROM LOOKUPMASTER LM INNER JOIN LOOKUPHEADINGMASTER LHM ON LM.HEADID=LHM.SRNO" +
" WHERE LHM.STATUS=0 AND LM.STATUS=0 AND LHM.HEAD='SUPPLY MONTH'";
Handler hdncolliery2 = new Handler();
DataTable dtcolliery2 = hdncolliery.GetTable(sqlcolliery2);
ddlmonth.DataSource = dtcolliery2;
ddlmonth.DataTextField = "NAME";
ddlmonth.DataValueField = "SRNO";
ddlmonth.DataBind();
ddlmonth.Items.Insert(0, "--Select--");
}
示例4: lnkedit_Click
protected void lnkedit_Click(object sender, EventArgs e)
{
LinkButton lnk = (LinkButton)sender;
ViewState["stateid"] = lnk.CommandArgument.ToString();
string sql = "SELECT SM.STATEID,SM.STATENAME,SM.UNIONTERITARY,SM.STATUS FROM STATEMASTER SM WHERE SM.STATEID=" + lnk.CommandArgument.Trim().ToString();
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sql);
txteditname.Text = dtstate.Rows[0]["STATENAME"].ToString().Trim();
if (dtstate.Rows[0]["UNIONTERITARY"].ToString().Trim() == "True")
{
ddledittype.SelectedValue = "1";
}
else
{
ddledittype.SelectedValue = "0";
}
if (dtstate.Rows[0]["STATUS"].ToString().Trim() == "True")
{
ddlstatus.SelectedValue = "1";
}
else
{
ddlstatus.SelectedValue = "0";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "EditState();", true);
}
示例5: btnaccount_Click
protected void btnaccount_Click(object sender, EventArgs e)
{
string sponsorid = string.Empty;
Handler hdn = new Handler();
DataTable dt = hdn.GetTable("SELECT SRNO,NAME FROM REGISTRATIONTABLE RT WHERE SPONSORSEMICODE='" + txtsponsorid.Text.Trim() + "'");
if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
{
registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj.registrationtable_SRNO = -1;
obj.registrationtable_NAME = txtname.Text.Trim();
obj.registrationtable_SEMICODE = txtsemid.Text.Trim();
obj.registrationtable_PHONENO = txtmobileno.Text.Trim();
obj.registrationtable_EMAILID = txtemail.Text.Trim();
if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
{
obj.registrationtable_SPONSORID = General.Parse<int>(dt.Rows[0]["SRNO"].ToString());
obj.registrationtable_SPONSORNAME = dt.Rows[0]["NAME"].ToString();
obj.registrationtable_SPONSORSEMICODE = txtsponsorid.Text.Trim();
}
else
{
obj.registrationtable_SPONSORID = -1;
}
obj.registrationtable_STATUS = -1;
string condition = "SRNO=" + Session["userid"].ToString();
if (obj.Insert(false, "registrationtable", condition))
{
MessageBox("Profile Updated Successfully");
}
}
}
示例6: FillCity
private DataTable FillCity(string stateid)
{
string sqlcity = "SELECT RTRIM(CITYNAME) AS CITYNAME,RTRIM(CITYID) AS CITYID FROM CITYMASTER CM WHERE CM.STATUS=0 AND CM.STATEID=" + stateid + " ORDER BY CM.CITYNAME";
Handler hdncity = new Handler();
DataTable dtcity = hdncity.GetTable(sqlcity);
return dtcity;
}
示例7: FillData
private void FillData(string collieryid)
{
string sqlcolliery = "SELECT * FROM collierymaster CM WHERE CM.SRNO=" + collieryid;
Handler hdncolliery = new Handler();
DataTable dtcolliery = hdncolliery.GetTable(sqlcolliery);
if (dtcolliery.Rows.Count > 0)
{
txtcollieryname.Text =dtcolliery.Rows[0]["COLLIERYNAME"].ToString().Trim();
txtcollierycode.Text = dtcolliery.Rows[0]["COLLIERYCODE"].ToString().Trim();
if (dtcolliery.Rows[0]["COLLIERYREGION"].ToString() == "NAGPUR DEPOT")
{
rdnagpur.Checked = true;
}
else if (dtcolliery.Rows[0]["COLLIERYREGION"].ToString() == "WANI DEPOT")
{
rdwani.Checked = true;
}
}
string sqldetail = "SELECT * FROM collierydetailmaster CDM INNER JOIN COALMASTER CM ON CM.SRNO=CDM.COALID WHERE CM.STATUS=0 AND CDM.COLLIERYID=" + collieryid;
Handler hdndetails = new Handler();
DataTable dtsql = hdndetails.GetTable(sqldetail);
ViewState["data"] = dtsql;
coaltyperepeater.DataSource = dtsql;
coaltyperepeater.DataBind();
}
示例8: FillData
private DataTable FillData(string id)
{
string sql = "SELECT DATE,NAME,CONTACTNO,ACTIVITY,RESULT,REMARK FROM REPORTINGMASTER RM WHERE STATUS=0 AND RELATIONSHIPID=" + id.ToString();
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
return dt;
}
示例9: updateLogin
protected void updateLogin()
{
string sql = "SELECT RELATIONSHIPID FROM USERTABLE UT WHERE UT.USERID='" + ID + "' AND PASSWORD='" + password + "' AND STATUS=2";
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
if (dt.Rows.Count > 0)
{
usertable obj1 = new usertable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj1.usertable_SRNO = -1;
obj1.usertable_RELATIONSHIPID = -1;
obj1.usertable_STATUS = 0;
string condition = "USERID = '" + ID + "' AND PASSWORD = '" + password + "'";
if (obj1.Insert(false, "usertable", condition))
{
}
registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
obj.registrationtable_SRNO = -1;
obj.registrationtable_SPONSORID = -1;
obj.registrationtable_STATUS = 0;
string condition1 = "SRNO =" + dt.Rows[0][0].ToString(); ;
if (obj.Insert(false, "registrationtable", condition1))
{
}
}
}
示例10: FillData
private void FillData(string fromdate,string todate)
{
string sql = "SELECT PT.FIRSTNAME+' '+CASE WHEN PT.MIDDLENAME IS NULL THEN '' ELSE PT.MIDDLENAME END +' '+CASE WHEN PT.LASTNAME IS NULL THEN '' ELSE PT.LASTNAME END +'('+PR.ASSOSIATEDFEILD+')' AS LEDGER," +
" TT.AMOUNT,TT.VOUCHERTYPE,TT.TRANSDATE,TT.NARRATION,TT.LTRNTYPE2 AS LTRNTYPE FROM TRANSACTIONTABLE TT INNER JOIN PERSONALRELATION PR ON PR.SRNO=TT.LEDGER2" +
" INNER JOIN PERSONALTABLE PT ON PT.RELATIONSHIPID=PR.RELATIONSHIPID WHERE TT.BRANCHID =" + Session["branchid"].ToString() + " AND TT.STATUS=0 " +
" AND (convert(datetime, TT.TRANSDATE, 103) BETWEEN convert(datetime, '" + fromdate.Trim().ToString() + "', 103) AND convert(datetime, '" + todate.Trim().ToString() + "', 103)) AND" +
" TT.LEDGER1=(SELECT SRNO FROM PERSONALRELATION PR1 INNER JOIN PERSONALTABLE PT1 ON PT1.RELATIONSHIPID=PR1.RELATIONSHIPID WHERE PT1.FIRSTNAME='CASH ACCOUNT' AND" +
" PT1.BRANCHID=" + Session["branchid"].ToString() + ") AND (TT.TRANSACTIONTYPE=1 OR TT.TRANSACTIONTYPE=2)";
Handler hdn = new Handler();
DataTable dt = hdn.GetTable(sql);
string value = GetOpeningAmount(fromdate);
DataRow newrow = dt.NewRow();
string[] columnarr = value.Split('~');
dt.Rows.InsertAt(newrow, 0);
dt.Rows[0]["LEDGER"] = "OPENING AMOUNT";
dt.Rows[0]["AMOUNT"] = columnarr[0].ToString();
dt.Rows[0]["LTRNTYPE"] = columnarr[1].ToString();
DataTable dtcash = GetBalance(dt, "AMOUNT", "LTRNTYPE");
ViewState["cashbook"] = dtcash;
if (dt.Rows.Count > 0)
{
gvcashbook.DataSource = (DataTable)ViewState["cashbook"];
gvcashbook.DataBind();
}
else
{
gvcashbook.DataSource = null;
gvcashbook.DataBind();
}
}
示例11: btnsubmit_Click
protected void btnsubmit_Click(object sender, EventArgs e)
{
Handler hdnpartycode=new Handler();
DataTable dtpartycode = hdnpartycode.GetTable("SELECT VEHICLEID FROM VEHICLEMASTER VM WHERE TRANSPORTERID=" + ddltransporter.SelectedValue.ToString().Trim() + " AND VEHICLENO='" + txtvehicleno.Text.Trim().ToString() + "'");
if (dtpartycode.Rows.Count == 0)
{
vehiclemaster objvehiclemaster = new vehiclemaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objvehiclemaster.vehiclemaster_VEHICLEID = -1;
objvehiclemaster.vehiclemaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.ToString().Trim());
objvehiclemaster.vehiclemaster_STATUS = 0;
objvehiclemaster.vehiclemaster_CAPACITY = ddlcapacity.SelectedItem.Text.Trim();
objvehiclemaster.vehiclemaster_VEHICLENO = txtvehicleno.Text.Trim().ToString();
objvehiclemaster.vehiclemaster_VEHICLENAME = txtvehiclename.Text.Trim().ToString();
if (objvehiclemaster.Insert(true, "vehiclemaster"))
{
MessageBox("Vehicle Added Successfully");
ddltransporter.SelectedIndex = 0;
ddlcapacity.SelectedIndex = 0;
txtvehicleno.Text = string.Empty;
txtvehiclename.Text = string.Empty;
FillVehicle();
}
}
else
{
MessageBox("Vehicle Already Present");
}
}
示例12: FillState
private void FillState()
{
string sqlstate = "SELECT STATENAME,STATEID FROM STATEMASTER SM WHERE SM.STATUS=0 ORDER BY STATENAME";
Handler hdnstate = new Handler();
DataTable dtstate = hdnstate.GetTable(sqlstate);
ddlstate.DataSource = dtstate;
ddlstate.DataTextField = "STATENAME";
ddlstate.DataValueField = "STATEID";
ddlstate.DataBind();
ddlworkstate.DataSource = dtstate;
ddlworkstate.DataTextField = "STATENAME";
ddlworkstate.DataValueField = "STATEID";
ddlworkstate.DataBind();
DataTable dtcity = FillCity(dtstate.Rows[0]["STATEID"].ToString());
ddlcity.Enabled = true;
ddlcity.DataSource = dtcity;
ddlcity.DataTextField = "CITYNAME";
ddlcity.DataValueField = "CITYID";
ddlcity.DataBind();
ddlworkcity.Enabled = true;
ddlworkcity.DataSource = dtcity;
ddlworkcity.DataTextField = "CITYNAME";
ddlworkcity.DataValueField = "CITYID";
ddlworkcity.DataBind();
}
示例13: FillCoolieryList
private DataTable FillCoolieryList()
{
string sqlpartylist = "SELECT CM.SRNO AS COLLIERYID,CM.COLLIERYNAME,CM.COLLIERYCODE,CM.COLLIERYREGION,CASE WHEN STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM collierymaster CM";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}
示例14: FillData
private void FillData(string contractid)
{
string sqldepartment = "SELECT * FROM CONTRACTMASTER CM WHERE CONTRACTID=" + contractid;
Handler hdndepartment = new Handler();
DataTable dtcontract = hdndepartment.GetTable(sqldepartment);
if (dtcontract.Rows[0]["CONTRACTTYPEID"].ToString() == "1")
{
rdservicecontract.Checked = true;
}
else
{
rdtransportcontract.Checked = true;
}
ddlparty.SelectedValue = dtcontract.Rows[0]["PARTYID"].ToString();
FillPartyDetails(contractid.Trim().ToString());
ddlcontactperson.SelectedValue = dtcontract.Rows[0]["PARTYCONTACTPERSONID"].ToString();
txtdate.Text = dtcontract.Rows[0]["CONTRACTDATE"].ToString();
txtrefno.Text = dtcontract.Rows[0]["REFNO"].ToString();
txtrefdate.Text = dtcontract.Rows[0]["REFDATE"].ToString();
txtcontractdate.Text = dtcontract.Rows[0]["STARTDATE"].ToString();
txtexpirydate.Text = dtcontract.Rows[0]["ENDDATE"].ToString();
txtquantity.Text = dtcontract.Rows[0]["QUANTITY"].ToString();
ddlquantitytype.SelectedValue = dtcontract.Rows[0]["QUANTITYPER"].ToString();
txtrate.Text = dtcontract.Rows[0]["RATE"].ToString();
txtchargservice.Text = dtcontract.Rows[0]["SERVICECHARGE"].ToString();
if (dtcontract.Rows[0]["CONTRACTTYPEID"].ToString() == "1")
{
rdservicetaxapplicable.Checked = true;
}
else
{
rdservicetaxnotapplicable.Checked = true;
}
}
示例15: FillTransporterList
private DataTable FillTransporterList()
{
string sqlpartylist = "SELECT TM.SRNO AS TRANSPORTERID,TM.TRANSPORTERNAME,TM.TRANSPORTERCODE,TM.TRANTYPE,TM.MOBILENO,TM.EMAILID,TM.ADDRESS,CASE WHEN TM.STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM transportermaster TM WHERE TM.STATUS=0";
Handler hdnpartylist = new Handler();
DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
return dtpartylist;
}