private void FillProduct(string[] param) { DataSet ds = CommanDataLoad.ExecuteDataSet("Get_Product", "1", "", param); if (ds != null) { ddlproduct.DataSource = ds; ddlproduct.DataTextField = "Product_Name"; ddlproduct.DataValueField = "Product_Id"; ddlproduct.DataBind(); } ddlproduct.Items.Insert(0, new ListItem("Select", "0")); }
private void FillState(string[] param) { DataSet ds = CommanDataLoad.ExecuteDataSet("Get_State", "1", "", param); if (ds != null) { ddlState.DataSource = ds; ddlState.DataTextField = "state_name"; ddlState.DataValueField = "state_id"; ddlState.DataBind(); } ddlState.Items.Insert(0, new ListItem("Select", "0")); }
private void Load_Vertical(string[] param) { DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_Vertical_Master", "1", "", param); if (ds != null) { ddlVertical.DataSource = ds; ddlVertical.DataTextField = "Vertical_Name"; ddlVertical.DataValueField = "Vertical_Id"; ddlVertical.DataBind(); } ddlVertical.Items.Insert(0, new ListItem("Select", "0")); }
void Load_Data() { DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Select * from lead_Data where lead_id=" + Request.QueryString["leadid"].ToString() + "", "2", ""); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; Name.Text = dr["Name"].ToString(); txtMobile.Text = dr["mobile"].ToString(); txtvremark.Text = dr["remark"].ToString(); txtvfollowupdate.Text = DateTime.Now.ToShortDateString(); if (dr["bank_id"].ToString() != "0" && dr["bank_id"].ToString() != "-1" && dr["bank_id"].ToString() != "") { ddlBank.SelectedValue = dr["bank_id"].ToString(); } if (dr["broker_id"].ToString() != "0" && dr["broker_id"].ToString() != "-1" && dr["broker_id"].ToString() != "") { ddlbroker.SelectedValue = dr["broker_id"].ToString(); } if (dr["lead_status_id"].ToString() != "0" && dr["lead_status_id"].ToString() != "-1" && dr["lead_status_id"].ToString() != "") { ddlvleadstatus.SelectedValue = dr["lead_status_id"].ToString(); } if (dr["productid"].ToString() != "0" && dr["productid"].ToString() != "-1" && dr["productid"].ToString() != "") { ddlproduct.SelectedValue = dr["productid"].ToString(); } if (dr["emp_code"].ToString() != "0" && dr["emp_code"].ToString() != "-1" && dr["emp_code"].ToString() != "") { ddlvAssignTo.SelectedValue = dr["emp_code"].ToString(); } if (dr["demo_given"].ToString() == "1") { chkdemo.Checked = true; } else { chkdemo.Checked = false; } } } }
public static string[] GetCities(string prefix) { List <string> data = new List <string>(); DataSet ds = CommanDataLoad.ExecuteDataSet("select City_name, City_Id from City_master where City_Name like '%" + prefix + "%'", "2", "Lead Assign Telecaller New", ""); int i = 0; while (i < ds.Tables[0].Rows.Count) { data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i]["City_Name"], ds.Tables[0].Rows[i]["City_ID"])); i = i + 1; } return(data.ToArray()); }
public static string[] Getstatus(string prefix) { List <string> data = new List <string>(); DataSet ds = CommanDataLoad.ExecuteDataSet("select lead_status_id, lead_status from lead_status_master where lead_status like '%" + prefix + "%' order by lead_status", "2", "Manage Lead", ""); int i = 0; while (i < ds.Tables[0].Rows.Count) { data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0])); i = i + 1; } return(data.ToArray()); }
public static string[] Getemp(string prefix) { List <string> data = new List <string>(); string empcode = HttpContext.Current.Request.Cookies["empcode"].Value.ToString(); DataSet ds = CommanDataLoad.ExecuteDataSet("select emp_code,name from dbo.get_child_emp('" + empcode + "') where name like '%" + prefix + "%' order by name", "2", "Lead Assign Telecaller New", ""); int i = 0; while (i < ds.Tables[0].Rows.Count) { data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0])); i = i + 1; } return(data.ToArray()); }
private void Load_City(string CityNm) { string[] param = new string[2]; param[0] = "City_Name"; param[1] = CityNm; DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_StateByCityNm", "1", "", param); if (ds != null) { ddlCity.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString(); } else { ddlCity.SelectedIndex = -1; } }
private void Load_SourceType(string SourceNm) { string[] param = new string[2]; param[0] = "source_name"; param[1] = SourceNm; DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_SourceType", "1", "", param); if (ds != null) { ddlsouce.SelectedValue = ds.Tables[0].Rows[0]["source_id"].ToString(); } else { ddlsouce.SelectedIndex = -1; } }
private string Load_City(string CityNm) { string cityid = "-1"; string[] param = new string[2]; param[0] = "City_Name"; param[1] = CityNm; DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_CityIDbyCityNm", "1", "", param); if (ds != null) { cityid = ds.Tables[0].Rows[0]["City_Id"].ToString(); } else { cityid = "-1"; } return(cityid); }
private void Load_Emp_Details() { string[] param = new string[2]; param[0] = "Emp_Code"; param[1] = Request.Cookies["empcode"].Value.ToString(); //param[1] = "RB40000255"; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Usp_Load_User_Detail_Sp", "1", "LogRequest", param); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { lblusername.Text = ds.Tables[0].Rows[0]["Emp_Name"].ToString(); lbluseremail.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString(); lblreportingemail.Text = ds.Tables[0].Rows[0]["Reporting_Email_Id"].ToString(); } } }
protected void Load_Bank_Mapping_Detail(string Map_Id) { try { string[] param = new string[2]; param[0] = "Map_Id"; param[1] = Map_Id; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Bank_Product_Mapping_Detail", "1", "Edit Bank Product Mapping", param); if (ds != null) { lblMapId.Text = ds.Tables[0].Rows[0]["Map_Id"].ToString(); Load_Bank(); ddlbName.SelectedValue = ds.Tables[0].Rows[0]["Bank_Id"].ToString(); Load_City(); ddlcName.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString(); Load_Product(); ddlpName.SelectedValue = ds.Tables[0].Rows[0]["Product_Id"].ToString(); txtcPerson.Text = ds.Tables[0].Rows[0]["Contact_Person"].ToString(); txtDesign.Text = ds.Tables[0].Rows[0]["Designation"].ToString(); txtmNo.Text = ds.Tables[0].Rows[0]["Mobile_No"].ToString(); txtlandNo.Text = ds.Tables[0].Rows[0]["Landline_No"].ToString(); txtfNo.Text = ds.Tables[0].Rows[0]["Fax_No"].ToString(); txteId.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString(); Popup(true); } else { Popup(false); } } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void ddlEndTime_SelectedIndexChanged(object sender, EventArgs e) { string Emp_Code = Request.Cookies["empcode"].Value.ToString(); DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Select User_Remark,User_Achieve from Employee_Daily_Planning where StartTime = '" + ddlStartTime.Text + "' And EndTime = '" + ddlEndTime.Text + "' And Plan_Date = '" + txtDate.Text + "' And Emp_Code = '" + Emp_Code + "'", "2", "Daily_Planning", ""); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { txtRemark.Text = ds.Tables[0].Rows[0]["User_Remark"].ToString(); txtAchieve.Text = ds.Tables[0].Rows[0]["User_Achieve"].ToString(); } else { txtRemark.Text = ""; txtAchieve.Text = ""; ds.Tables.Clear(); Emp_Code = ""; } } }
private void Load_State(string CityName) { string[] param = new string[2]; param[0] = "City_Name"; param[1] = CityName; DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_StateByCityNm", "1", "", param); if (ds != null) { ddlState.SelectedValue = ds.Tables[0].Rows[0]["state_id"].ToString(); string[] param1 = new string[2]; param1[0] = "state_id"; param1[1] = ddlState.SelectedValue; FillCity(param1); Load_City(CityName); } else { ddlState.SelectedIndex = -1; } }
protected void Load_Sub_Division_Detail(string Sub_Division_Id) { try { string[] param = new string[2]; param[0] = "Sub_Division_Id"; param[1] = Sub_Division_Id; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Load_Sub_Division_Detail", "1", "Edit Sub Division Master", param); if (ds != null) { lblSubDivisionId.Text = ds.Tables[0].Rows[0]["Sub_Division_Id"].ToString(); Load_Div(); ddlDiv.SelectedValue = ds.Tables[0].Rows[0]["Division_Id"].ToString(); txtSubDiv.Text = ds.Tables[0].Rows[0]["Sub_Division_Name"].ToString(); if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "Y") { chkIsAct.Checked = true; } else { chkIsAct.Checked = false; } Popup(true); } else { Popup(false); } } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void Load_Source_Detail(string Source_Id) { try { string[] param = new string[2]; param[0] = "source_id"; param[1] = Source_Id; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Load_Source_Detail", "1", "Edit Source Master", param); if (ds != null) { txtsource.Text = ds.Tables[0].Rows[0]["source_Id"].ToString(); if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "Y") { chkIsAct.Checked = true; } else { chkIsAct.Checked = false; } Popup(true); } else { Popup(false); } } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void Load_Bank_Detail(string Bank_Id) { try { string[] param = new string[2]; param[0] = "Bank_Id"; param[1] = Bank_Id; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Load_Bank_Detail", "1", "Edit Bank Master", param); if (ds != null) { lblBankId.Text = ds.Tables[0].Rows[0]["Bank_Id"].ToString(); txtBankName.Text = ds.Tables[0].Rows[0]["Bank_Name"].ToString(); txtBankAddress.Text = ds.Tables[0].Rows[0]["Bank_Address"].ToString(); if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "1") { chkIsAct.Checked = true; } else { chkIsAct.Checked = false; } Popup(true); } else { Popup(false); } } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
private void Load_Request_Details() { string[] param = new string[2]; param[0] = "Request_Id"; param[1] = Request.QueryString["Request_Id"].ToString(); DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Usp_Load_Request_Detail", "1", "Approve_Request_By_HOD", param); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { txtrequestno.Text = ds.Tables[0].Rows[0]["Request_ID"].ToString(); txtrequestdate.Text = ds.Tables[0].Rows[0]["Request_Date"].ToString(); txtreportingauth.Text = ds.Tables[0].Rows[0]["ReportAuthId"].ToString(); txtrequestedby.Text = ds.Tables[0].Rows[0]["Requested_By"].ToString(); txtrequesttitle.Text = ds.Tables[0].Rows[0]["RequestTitle"].ToString(); txtshortdescription.Text = ds.Tables[0].Rows[0]["Short_Description"].ToString(); txtreasonforchange.Text = ds.Tables[0].Rows[0]["Detail_Description"].ToString(); txtcategory.Text = ds.Tables[0].Rows[0]["RequestType"].ToString(); } } }
private void BindGrid() { DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("SpDispEmployee_List", "1", "Employee List", ""); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { String UnreadText = ""; Int32 i = 0; for (i = 0; i < ds.Tables[0].Rows.Count; i++) { UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >"; UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["EmployeeName"].ToString() + "</td>"; UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["EmpCode"].ToString() + "</td>"; UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["Company"].ToString() + "</td>"; UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["EMailID"].ToString() + "</td>"; UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["Department"].ToString() + "</td>"; UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["Reporting_Emp_name"].ToString() + "</td>"; UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["empid"].ToString() + "</td>"; UnreadText += " <td class=\"center\">"; UnreadText += " <a class=\"btn btn-info\" href=\"Employee_Master_Edit.aspx?empid="+ ds.Tables[0].Rows[i]["empid"] + "\">"; UnreadText += " <i class=\"icon-edit icon-white\"></i> "; UnreadText += " Edit"; UnreadText += " </a>"; UnreadText += " </td>"; UnreadText += " </tr>"; tlist.InnerHtml = UnreadText; //i++; } } } }
protected void Page_Load(object sender, EventArgs e) { try { Response.Cookies["user_id"].Value = "0"; Response.Cookies["UserId"].Value = "0"; Response.Cookies["UserName"].Value = ""; Response.Cookies["Name"].Value = ""; Response.Cookies["Company_id"].Value = "0"; Response.Cookies["VendorId"].Value = "0"; Response.Cookies["IbsPer"].Value = "0"; if (Request.QueryString.Count > 0) { if (Request.QueryString["msg"].ToString().Equals("1")) { Response.Redirect("http://erp.rupeeboss.com/default.aspx?msg=Session Expired, Please login again...!"); } lblmsg.Text = Request.QueryString["msg"].ToString(); } DataSet ds = CommanDataLoad.ExecuteDataSet("sp_news_update", "1", "Default", ""); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { lblnews.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString(); } } } } catch (Exception ex) { lblmsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); //bool blnResult = false; //string strUserGroup = ""; // Session["UserName"] = "******"; string strIP = ""; //int intBOSessionId; DataSet dsMenus; //strUserGroup = clsBOMisc.strGetCookie(this, "BO_UserGroupId", ""); strIP = Request.UserHostAddress.ToString(); try { string strUserId = Session["UserName"].ToString(); tdwelcome.Attributes.Add("class", "lblDefault"); tdwelcome.Attributes.Add("style", "color:#000"); tdwelcome.InnerHtml = "Welcome, " + strUserId + " | <a href=\"default.aspx\">Logout</a> | <a href=\"Change_password.aspx\">Change Password</a>"; string[] Param = new string[6]; Param[0] = "strUserLogin"; Param[1] = strUserId; Param[2] = "userid"; Param[3] = "1867"; Param[4] = "groupid"; Param[5] = Request.Cookies["UserGroupId"].Value.ToString(); ds = CommanDataLoad.ExecuteDataSet("[uspUser_Menu]", "1", "RBHome", Param); if (ds.Tables[0].Rows.Count > 0) { dsMenus = ds; sbmenus = new StringBuilder(); sbAdded = new StringBuilder(); sbmenus.Append("<ul class='nav'><li>"); for (int i = 0; i < dsMenus.Tables[0].Rows.Count; i++) { if (dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString() == "Logout") { continue; } if (sbAdded.ToString().IndexOf(dsMenus.Tables[0].Rows[i]["Menu_Parent"].ToString() + ",") < 0 && Convert.ToInt32(dsMenus.Tables[0].Rows[i]["Menu_Level"].ToString()) > 0) { continue; } if (sbAdded.ToString().IndexOf(dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString() + ",") < 0 || Convert.ToInt32(dsMenus.Tables[0].Rows[i]["Menu_Level"]) == 0) { CreateMenu(dsMenus, dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString(), dsMenus.Tables[0].Rows[i]["Menu_Action"].ToString(), dsMenus.Tables[0].Rows[i]["Menu_Level"].ToString()); } } sbmenus.Append("</ul>"); menus.InnerHtml = sbmenus.ToString(); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "OnSessionClosed", "<script language=javascript>subRedirectToDefault();</script>"); return; } } catch (Exception ex) { // clsBOMisc.subDisplayError(this, udcErrorSource, udcErrorMethod, "ERROR", ex.ToString()); } // objDB.blnCloseConnection(); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int rowaffected; string Emp_Code = Request.Cookies["empcode"].Value.ToString(); //DateTime currentTime = new DateTime(); //currentTime.TimeOfDay; if (Convert.ToDateTime(ddlStartTime.Text) > (Convert.ToDateTime(ddlEndTime.Text))) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Start date must be less than end Date')", true); return; } string[] param = new string[14]; param[0] = "Plan_Date"; param[1] = txtDate.Text; param[2] = "StartTime"; param[3] = ddlStartTime.SelectedValue; param[4] = "EndTime"; param[5] = ddlEndTime.SelectedValue; param[6] = "User_Remark"; param[7] = txtRemark.Text; param[8] = "User_Achieve"; param[9] = txtAchieve.Text; param[10] = "Emp_Code"; param[11] = Request.Cookies["empcode"].Value.ToString(); param[12] = "Ip_Addr"; param[13] = ClsConnection.StrIP; string[] param1 = new string[8]; param1[0] = "Plan_Date"; param1[1] = txtDate.Text; param1[2] = "StartTime"; param1[3] = ddlStartTime.SelectedValue; param1[4] = "EndTime"; param1[5] = ddlEndTime.SelectedValue; param1[6] = "Emp_Code"; param1[7] = Request.Cookies["empcode"].Value.ToString(); DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Select * from Employee_Daily_Planning where StartTime = '" + ddlStartTime.SelectedValue + "' And EndTime = '" + ddlEndTime.SelectedValue + "' And Emp_Code = '" + Emp_Code + "' And Plan_Date = '" + txtDate.Text + "'", "2", "Daily_Planing", ""); //ds = CommanDataLoad.ExecuteDataSet("usp_Load_Employee_planning", "1", "Daily_Planing", param1); if (ds.Tables[0].Rows.Count > 0) { rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Daily_Planning", "1", "Daily_Planing", param); } else { rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_Emp_Daily_Planing", "1", "Daily_Planing", param); } if (rowaffected > 0) { Response.Write("<script>alert('Record Saved Successfully.');</script>"); } Load_SelfGrid(); ClearControls(); ds.Tables.Clear(); } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = new DataSet(); Session["checkExits"] = "Edit"; btnSubmit.Text = "Update"; string[] param = new string[2]; param[0] = "ID_Bank_Product"; param[1] = GridView1.SelectedRow.Cells[1].Text; ds = CommanDataLoad.ExecuteDataSet("USP_Load_Bank_Product_Web_Edit", "1", "Edit Bank_Product_Web", param); //lblid.Text = GridView1.SelectedRow.Cells[1].Text; //lblid.Text = lblBank_Pro_Id.Text; //ddlBank.SelectedValue = GridView1.SelectedRow.Cells[2].Text; ddlProduct.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["product_id"]).ToString(); if (Convert.ToInt32(ds.Tables[0].Rows[0]["Bank_id"]).ToString() != "0") { ddlBank.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["Bank_id"]).ToString(); } else { ddlBank.SelectedIndex = -1; } btnSubmit.CausesValidation = true; lblBank_Pro_Id.Text = GridView1.SelectedRow.Cells[1].Text; lblid.Text = lblBank_Pro_Id.Text; //ddlBank.Items[ddlBank.SelectedIndex].Text = GridView1.SelectedRow.Cells[2].Text; //ddlProduct.Items[ddlProduct.SelectedIndex].Text = GridView1.SelectedRow.Cells[3].Text; txtMinAge.Text = ds.Tables[0].Rows[0]["Min_Age"].ToString(); txtMaxAge.Text = ds.Tables[0].Rows[0]["Max_Age"].ToString(); txtMinInte.Text = ds.Tables[0].Rows[0]["Min_Intrest"].ToString(); txtMaxInte.Text = ds.Tables[0].Rows[0]["Max_Intrest"].ToString(); txtProFee.Text = ds.Tables[0].Rows[0]["ProcessingFee"].ToString(); txtProFeeType.Text = ds.Tables[0].Rows[0]["ProcessingFeeType"].ToString(); txtMinLoan.Text = ds.Tables[0].Rows[0]["Min_Loan"].ToString(); txtMaxLoan.Text = ds.Tables[0].Rows[0]["Max_Loan"].ToString(); txtMinLAmt.Text = ds.Tables[0].Rows[0]["Min_Loan_Amt"].ToString(); txtMaxLAmt.Text = ds.Tables[0].Rows[0]["Max_Loan_Amt"].ToString(); txtMinInSal.Text = ds.Tables[0].Rows[0]["Min_Income_Salary"].ToString(); txtMinInSelf.Text = ds.Tables[0].Rows[0]["Min_Income_Self"].ToString(); txtMinTen.Text = ds.Tables[0].Rows[0]["Min_Tenure"].ToString(); txtPreCharge.Text = ds.Tables[0].Rows[0]["Prepay_Charges"].ToString(); txtCloserCharge.Text = ds.Tables[0].Rows[0]["Closer_Charges"].ToString(); txtMinCreSco.Text = ds.Tables[0].Rows[0]["MinCredit_Score"].ToString(); //txtMinAge.Text = GridView1.SelectedRow.Cells[4].Text; //txtMaxAge.Text = GridView1.SelectedRow.Cells[5].Text; //txtMinInte.Text = GridView1.SelectedRow.Cells[6].Text; //txtMaxInte.Text = GridView1.SelectedRow.Cells[7].Text; //txtProFee.Text = GridView1.SelectedRow.Cells[8].Text; //txtProFeeType.Text = GridView1.SelectedRow.Cells[9].Text; //txtMinLoan.Text = GridView1.SelectedRow.Cells[10].Text; //txtMaxLoan.Text = GridView1.SelectedRow.Cells[11].Text; //txtMinLAmt.Text = GridView1.SelectedRow.Cells[12].Text; //txtMaxLAmt.Text = GridView1.SelectedRow.Cells[13].Text; //txtMinInSal.Text = GridView1.SelectedRow.Cells[14].Text; //txtMinInSelf.Text = GridView1.SelectedRow.Cells[15].Text; //txtMinTen.Text = GridView1.SelectedRow.Cells[16].Text; //txtPreCharge.Text = GridView1.SelectedRow.Cells[17].Text; //txtCloserCharge.Text = GridView1.SelectedRow.Cells[18].Text; //txtMinCreSco.Text = GridView1.SelectedRow.Cells[19].Text; if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Msg"].ToString())) { txtMsg.Text = ds.Tables[0].Rows[0]["Msg"].ToString(); } else { txtMsg.Text = ""; } //if (!string.IsNullOrEmpty(GridView1.SelectedRow.Cells[20].Text)) //{ // txtMsg.Text = ""; //} //else //{ // txtMsg.Text = GridView1.SelectedRow.Cells[20].Text; //} //txtMaxTenure.Text = GridView1.SelectedRow.Cells[21].Text; txtMaxTenure.Text = ds.Tables[0].Rows[0]["Max_Tenure"].ToString(); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["guarantor_required"].ToString())) { txtGuarantor.Text = ds.Tables[0].Rows[0]["guarantor_required"].ToString(); } else { txtGuarantor.Text = ""; } //if (!string.IsNullOrEmpty(GridView1.SelectedRow.Cells[22].Text)) //{ // txtGuarantor.Text = ""; //} //else //{ // txtGuarantor.Text = GridView1.SelectedRow.Cells[22].Text; //} }
private void BindGrid() { ds = new DataSet(); if (hfCityId.Value == "") { hfCityId.Value = "0"; } if (hfemp.Value == "") { hfemp.Value = "0"; } // DataSet ds = new DataSet(); string[] param = new string[6]; param[0] = "empcode"; if (Request.QueryString.Count > 0) { param[1] = Request.QueryString["emp_code"].ToString(); } else { param[1] = Session["empcode"].ToString(); } // param[1] = hfemp.Value; param[2] = "cityid"; param[3] = hfCityId.Value; param[4] = "@Status_Id"; param[5] = ddlstatus.SelectedValue; ds = CommanDataLoad.ExecuteDataSet("SpDispLeads_Telecaller", "1", "Lead Assign Telecaller New", param); //tlist.InnerHtml = ""; //if (ds != null) //{ // if (ds.Tables[0].Rows.Count > 0) // { // String UnreadText = ""; // Int32 i = 0; // for (i = 0; i < ds.Tables[0].Rows.Count; i++) // { // UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >"; // UnreadText += " <td class=\"center\"><input class=\"checkbox\" id='chk' value=" + ds.Tables[0].Rows[i]["lead_id"] + " name=\"check[]\" type =checkbox /> </td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_id"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["name"].ToString() + "</td>"; // UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["companyname"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Designation"].ToString() + "</td>"; // UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["phone"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["mobile"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["city_name"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["email"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Profession_name"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["monthlyincome"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Product_name"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_source"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["assign"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_type"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_status"].ToString() + "</td>"; // UnreadText += " </tr>"; // tlist.InnerHtml = UnreadText; // //i++; // } // } //} }
public void Load_Employee_EditData() { string[] Param = new string[2]; Param[0] = "EmpId"; Param[1] = Convert.ToInt16(Request.QueryString["EmpId"]).ToString(); DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_EditEmployee_List", "1", "Edit", Param); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { txtename.Text = ds.Tables[0].Rows[0]["EmployeeName"].ToString(); txtecode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString(); txtectc.Text = ds.Tables[0].Rows[0]["ctc"].ToString(); txteml.Text = ds.Tables[0].Rows[0]["EMailID"].ToString(); txtevariable.Text = ds.Tables[0].Rows[0]["variable"].ToString(); if (Convert.ToInt32(ds.Tables[0].Rows[0]["company_id"]) > 0) { ddlcom.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["company_id"]).ToString(); } else { ddlcom.SelectedValue = "-1"; } if (Convert.ToInt16(ds.Tables[0].Rows[0]["Department_Id"]) > 0) { ddledept.SelectedValue = Convert.ToInt16(ds.Tables[0].Rows[0]["Department_Id"]).ToString(); } else { ddledept.SelectedValue = "-1"; } if (Convert.ToInt16(ds.Tables[0].Rows[0]["Designation_Id"]) > 0) { ddledesignation.SelectedValue = Convert.ToInt16(ds.Tables[0].Rows[0]["Designation_Id"]).ToString(); } else { ddledesignation.SelectedValue = "-1"; } txteaddress.Text = ds.Tables[0].Rows[0]["Address"].ToString(); txtemobileno.Text = ds.Tables[0].Rows[0]["Mobile"].ToString(); txtedob.Text = ds.Tables[0].Rows[0]["DOB"].ToString(); if (Convert.ToString(ds.Tables[0].Rows[0]["reporting_emp"]) != "") { ddlereporting.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["reporting_emp"]).ToString(); } else { ddlereporting.SelectedValue = "-1"; } if (Convert.ToInt16(ds.Tables[0].Rows[0]["IsActive"]) == 1) { chkeactive.Checked = true; } else { chkeactive.Checked = false; } } else { ClearControls(); } } }
protected void Button3_Click(object sender, EventArgs e) { string[] Param = new string[2]; Param[0] = "email"; Param[1] = TxtEmail.Value; // TxtEmail.Value = "Dsdsdsds"; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("User_Master_Password_Select", "1", "Forgot_Password", Param); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { str1 = ds.Tables[0].Rows[0]["email"].ToString(); str2 = ds.Tables[0].Rows[0]["pass"].ToString(); str3 = ds.Tables[0].Rows[0]["username"].ToString(); string mobile = ds.Tables[1].Rows[0]["mobile"].ToString(); string name = ds.Tables[1].Rows[0]["emp_name"].ToString(); // if (TxtEmail.Value == str1) // { string strPass = CommanDataLoad.Generate(6, 8); string str = "update usr_login set pass='******' where email='" + TxtEmail.Value + "' or empcode='" + TxtEmail.Value + "'"; CommanDataLoad.ExecuteNonQuery(str, "2", "Change Pass", ""); String strbody = ""; strbody = strbody + "<table><tr><td><img alt='RupeeBoss.com' width='120px' src='http://erp.rupeeboss.com/Common/Images/Logo.png' ' /></td>"; strbody = strbody + "<td style='font-weight: bold; font-family: Verdana; font-size: 12px;' valign='middle'>"; strbody = strbody + "Welcome to RupeeBoss-ERP</td></tr></table>"; strbody = strbody + "<br/>Dear " + str3 + ",<br/>"; strbody = strbody + "<br/>Your Password is : " + strPass; strbody = strbody + "<br/><br/>Thank You"; strbody = strbody + "<br /><br />RupeeBoss Software Team<br />"; strbody = strbody + "<br />+91.9920298619<br />"; strbody = strbody + "<br />[email protected]<br /></p>"; string stra = ""; try { stra = ClsSendMail.Send_Mail_Direct(str1, strbody, "Password detail", "*****@*****.**"); string smsbody = "Dear " + name + ", Your password for RB ERP and APP is " + strPass; CommanDataLoad.Send_SMS_Save_Data(mobile, smsbody, Request.UserHostAddress); GetMessage(); Clear(); } catch (Exception ex) { Response.Write(stra + "--" + ex.Message); // GetError(); } Response.Write(stra); // } } else { lblmsg.Text = "User not found"; } } else { lblmsg.Text = "User not found"; } }
protected void Button1_Click(object sender, EventArgs e) { string[] Param = new string[6]; Param[0] = "User"; Param[1] = txtuser.Value; Param[2] = "pass"; Param[3] = CommanDataLoad.EncryptPassword(txtpass.Value); Param[4] = "ip"; Param[5] = Request.UserHostAddress; if (chk.Checked) { if (txtpass.Value.ToString().ToUpper().Contains("ADMIN")) { Session["UserId"] = txtuser.Value; Session["UserName"] = txtuser.Value; Session["empcode"] = txtuser.Value; Session["UserGroupId"] = "4"; Response.Cookies["UserGroupId"].Value = "4"; Response.Cookies["empcode"].Value = txtuser.Value; Response.Cookies["UserName"].Value = txtuser.Value; Response.Cookies["Name"].Value = txtuser.Value; Response.Redirect("RBHome.aspx"); } RBERP.PBService.EmployeeRegistrationServiceContractClient client = new RBERP.PBService.EmployeeRegistrationServiceContractClient(); DataSet ds = client.AuthenticateEmployeeLogin(txtuser.Value, txtpass.Value); if (ds != null) { Session["UserId"] = ds.Tables[0].Rows[0]["employee_code"].ToString(); Session["UserName"] = ds.Tables[0].Rows[0]["employee_name"].ToString(); Session["empcode"] = ds.Tables[0].Rows[0]["employee_code"].ToString(); Session["UserGroupId"] = "4"; Response.Cookies["UserGroupId"].Value = "4"; Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["employee_code"].ToString(); Response.Cookies["UserName"].Value = txtuser.Value; Response.Cookies["Name"].Value = txtuser.Value; Response.Redirect("RBHome.aspx"); } else { lblmsg.Text = "Incorrect User Name Or Password"; } } else { DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Select_login", "1", "Login", Param); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { Session["UserId"] = ds.Tables[0].Rows[0]["userid"].ToString(); Session["UserName"] = txtuser.Value; Session["empcode"] = ds.Tables[0].Rows[0]["empcode"].ToString(); //Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["empcode"].ToString(); if (ds.Tables[0].Rows[0]["empcode"].ToString().Equals("RB40000155")) { Response.Cookies["empcode"].Value = "RB40000043"; } else { Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["empcode"].ToString(); } Response.Cookies["UserName"].Value = txtuser.Value; Response.Cookies["Name"].Value = txtuser.Value; Response.Cookies["UserId"].Value = ds.Tables[0].Rows[0]["userid"].ToString(); Response.Redirect("home.aspx"); } else { lblmsg.Text = "Incorrect User Name Or Password"; } } else { lblmsg.Text = "Incorrect User Name Or Password"; } } }
protected void btnsubmit_Click(object sender, EventArgs e) { string strPass = CommanDataLoad.Generate(6, 8); try { string[] param = new string[16]; param[0] = "Broker_Name"; param[1] = txtbroker.Text; param[2] = "Ip_address"; param[3] = ClsConnection.StrIP; param[4] = "UserId"; param[5] = ClsConnection.Userid; param[6] = "Contact_No"; param[7] = txtcontact.Text; param[8] = "PAN_No"; param[9] = txtPAN.Text; param[10] = "Emp_Code"; param[11] = ddlEmployee.SelectedValue; param[12] = "Email_Id"; param[13] = txtEmail.Text; param[14] = "UserPassword"; param[15] = CommanDataLoad.EncryptPassword(strPass); Send_mail(strPass); int rowaffect = 0; DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("Usp_Insert_BrokerDetail", "1", "Broker Master", param); if (ds != null) { string brokId = ds.Tables[0].Rows[0]["BrokerId"].ToString(); int i = 0; while (i < gvBrokerProd.Rows.Count) { CheckBox chk = (CheckBox)gvBrokerProd.Rows[i].FindControl("chk"); if (chk.Checked == true) { TextBox txtPayout = (TextBox)gvBrokerProd.Rows[i].FindControl("txtPayoutper"); string[] param1 = new string[6]; param1[0] = "Broker_Id"; param1[1] = brokId; param1[2] = "Product_Id"; param1[3] = gvBrokerProd.Rows[i].Cells[1].Text; param1[4] = "PayoutPer"; param1[5] = txtPayout.Text; rowaffect = CommanDataLoad.ExecuteNonQuery("USP_Insert_BrokerProductMapping", "1", "Broker Master", param1); } i = i + 1; } if (rowaffect > 0) { Response.Write("<script>alert('Record Saved Successfully.');</script>"); //BindGrid(); } } ClearControls(); BindGrid(); Load_Grid(); } catch (Exception ex) { lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void Load_Grid() { try { string[] param = new string[2]; param[0] = "Emp_Code"; param[1] = Request.Cookies["empcode"].Value.ToString(); DataSet ds = new DataSet(); ds = CommanDataLoad.ExecuteDataSet("USP_Load_VerticalWiseStatusRpt", "1", "Vertical Wise Status Report", param); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); int i = 0; dt.Columns.Add("Sr.No.", typeof(string)); dt.Columns.Add("Vertical Name", typeof(string)); while (i < ds.Tables[2].Rows.Count) { dt.Columns.Add(ds.Tables[2].Rows[i].ItemArray[1].ToString(), typeof(string));// GetType(String)); i = i + 1; } dt.Columns.Add("Total", typeof(int)); string str; i = 0; int j = 0; DataRow dr; int Total = 0; int[] StrTotal = new int[ds.Tables[2].Rows.Count]; while (i < ds.Tables[1].Rows.Count) { Total = 0; dr = dt.NewRow(); dr[0] = i + 1; dr[1] = ds.Tables[1].Rows[i].ItemArray[1] + "=" + ds.Tables[1].Rows[i].ItemArray[0]; j = 0; while (j < ds.Tables[2].Rows.Count) { var results = from myRow in ds.Tables[0].AsEnumerable() where ((myRow.Field <int>("Vertical_Id") == Convert.ToInt16(ds.Tables[1].Rows[i].ItemArray[0].ToString())) && (myRow.Field <int>("Lead_Status_Id") == Convert.ToInt16(ds.Tables[2].Rows[j].ItemArray[0]))) select myRow.Field <int>("leadcnt"); dr[j + 2] = results.SingleOrDefault(); Total = Total + Convert.ToInt16(results.SingleOrDefault()); StrTotal[j] = StrTotal[j] + Convert.ToInt16(results.SingleOrDefault()); j = j + 1; } // str = "<a target='_blank' href='SMN_FaultyStatus_Detail.aspx?region_id=" + ds.Tables[1].Rows[i].ItemArray[0].ToString() + "'>" + Total + "</a>"; dr[j + 2] = Total; dt.Rows.Add(dr); i = i + 1; } Total = 0; dr = dt.NewRow(); dr[0] = i + 1; dr[1] = "Grand Total"; j = 0; while (j < ds.Tables[2].Rows.Count) { dr[j + 2] = StrTotal[j]; Total = Total + Convert.ToInt16(dr[j + 2]); j = j + 1; } dr[j + 2] = Total; dt.Rows.Add(dr); i = i + 1; DataSet ds1 = new DataSet(); ds1.Tables.Add(dt); GridView1.DataSource = ds1; GridView1.DataBind(); i = 0; string[] StrRegion; while (i < GridView1.Rows.Count - 1) { j = 0; StrRegion = GridView1.Rows[i].Cells[1].Text.ToString().Split('='); GridView1.Rows[i].Cells[1].Text = StrRegion[0]; while (j < ds.Tables[2].Rows.Count) { if (GridView1.Rows[i].Cells[j + 2].Text == "0") { GridView1.Rows[i].Cells[j + 2].Text = "0"; } else { str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Vertical_Id=" + StrRegion[1] + "&Lead_Status_id=" + ds.Tables[2].Rows[j].ItemArray[0] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>"; GridView1.Rows[i].Cells[j + 2].Text = str; } j = j + 1; } str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Vertical_Id=" + StrRegion[1] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>"; GridView1.Rows[i].Cells[j + 2].Text = str; i = i + 1; } j = 0; while (j < ds.Tables[2].Rows.Count) { str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Lead_Status_id=" + ds.Tables[2].Rows[j].ItemArray[0] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>"; GridView1.Rows[i].Cells[j + 2].Text = str; j = j + 1; } GridView1.Rows[GridView1.Rows.Count - 1].Cells[GridView1.Rows[0].Cells.Count - 1].Text = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Lead_Status_id=0&Vertical_Id=0'>" + GridView1.Rows[GridView1.Rows.Count - 1].Cells[GridView1.Rows[0].Cells.Count - 1].Text + "</a>"; } } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
//[WebMethod(enableSession: true)] //public static Class.ClsManageLeads[] BindDatatable(String prefix) //{ // string empcode = HttpContext.Current.Request.Cookies["empcode"].Value.ToString(); // DataSet ds = new DataSet(); // string[] param1 = new string[12]; // param1[0] = "empcode"; // // param1[1] = "RB40000401"; // if (HttpContext.Current.Request.QueryString.Count > 0) // { // param1[1] = HttpContext.Current.Request.QueryString["emp_code"].ToString(); // } // else // { // param1[1] = empcode.ToString(); // } // param1[2] = "cityid"; // param1[3] = "0"; // param1[4] = "Lead_Status_id"; // param1[5] ="0"; // param1[6] = "Emp_Code"; // param1[7] = "0"; // param1[8] = "fdate"; // param1[9] = ""; // param1[10] = "tdate"; // param1[11] = ""; // ds = CommanDataLoad.ExecuteDataSet("SpDispManageLeadData", "1", "Manage Lead List", param1); // List<Class.ClsManageLeads> Data = new List<Class.ClsManageLeads>(); // if (ds != null) // { // if (ds.Tables[0].Rows.Count > 0) // { // Int32 i = 0; // for (i = 0; i < ds.Tables[0].Rows.Count; i++) // { // Class.ClsManageLeads cl = new Class.ClsManageLeads(); // cl.LeadId = ds.Tables[0].Rows[i]["leadid"].ToString(); // cl.name = ds.Tables[0].Rows[i]["name"].ToString(); // cl.lead_status = ds.Tables[0].Rows[i]["leadstatus"].ToString(); // cl.mobile = ds.Tables[0].Rows[i]["mobile"].ToString(); // cl.leaddate = ds.Tables[0].Rows[i]["leaddate"].ToString(); // cl.nextdate = ds.Tables[0].Rows[i]["next_date"].ToString(); // cl.remark = ds.Tables[0].Rows[i]["remark"].ToString(); // cl.companyname = ds.Tables[0].Rows[i]["companyname"].ToString(); // cl.designation = ds.Tables[0].Rows[i]["designation"].ToString(); // cl.phone = ds.Tables[0].Rows[i]["phone"].ToString(); // cl.cityname = ds.Tables[0].Rows[i]["city_name"].ToString(); // cl.empcode = ds.Tables[0].Rows[i]["emp_code"].ToString(); // cl.bankname = ds.Tables[0].Rows[i]["bank_name"].ToString(); // cl.empname = ds.Tables[0].Rows[i]["emp_name"].ToString(); // Data.Add(cl); // } // } // } // return Data.ToArray(); //} private void BindGrid() { ds = new DataSet(); string[] param1 = new string[12]; param1[0] = "empcode"; // param1[1] = "RB40000401"; if (Request.QueryString.Count > 0) { param1[1] = Request.QueryString["emp_code"].ToString(); } else { param1[1] = Request.Cookies["empcode"].Value.ToString(); } param1[2] = "cityid"; param1[3] = hfCityId.Value; param1[4] = "Lead_Status_id"; param1[5] = hfstatus.Value; param1[6] = "Emp_Code"; param1[7] = hfemp.Value; param1[8] = "fdate"; param1[9] = txtfromdt.Text; param1[10] = "tdate"; param1[11] = txttodt.Text; ds = CommanDataLoad.ExecuteDataSet("SpDispManageLeadData", "1", "Manage Lead List", param1); // tlist.InnerHtml = ""; //if (ds != null) //{ // if (ds.Tables[0].Rows.Count > 0) // { // String UnreadText = ""; // Int32 i = 0; // for (i = 0; i < ds.Tables[0].Rows.Count; i++) // { // UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >"; // UnreadText += " <td class=\"center\"><input class=\"checkbox\" id='chk' value=" + ds.Tables[0].Rows[i]["leadid"] +" name=\"check[]\" type =checkbox /> </td>"; // UnreadText += " <td class=\"center\">"; // UnreadText += " <a href=\"Manage_lead_data.aspx?leadid=" + ds.Tables[0].Rows[i]["leadid"] + "\">"; // UnreadText += " "+ ds.Tables[0].Rows[i]["leadid"] + ""; // UnreadText += " </a>"; // UnreadText += " </td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["name"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["emp_code"].ToString() + "</td>"; // UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["emp_name"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["City_Name"].ToString() + "</td>"; // UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["Mobile"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["leadstatus"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["next_date"].ToString() + "</td>"; // UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["remark"].ToString() + "</td>"; // UnreadText += " </tr>"; // tlist.InnerHtml = UnreadText; // //i++; // } // } //} }