protected void btnExcel_Click(object sender, EventArgs e)
{
//Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = BindGridView();
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=" + DateTime.Now.Year + "-Newly_Hired" + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
//Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void AddRepairsNewEmptyFix(GridView grdView)
{
if (grdRepairs.Rows.Count == 0)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
PointRepairsTDS.RepairDetailsDataTable dt = new PointRepairsTDS.RepairDetailsDataTable();
dt.AddRepairDetailsRow(-1, "PL-A", "Temp", "", DateTime.Now, "", "", 0, "", "", "", "", DateTime.Now, "", "", DateTime.Now, "", false, false, "", false, companyId, false, "", "", "", DateTime.Now);
Session["pointRepairsRepairsTempDummy"] = dt;
SetFilter("Type='Temp' AND Deleted = 0");
grdRepairs.DataBind();
}
// normally executes at all postbacks
if (grdRepairs.Rows.Count == 1)
{
PointRepairsTDS.RepairDetailsDataTable dt = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTempDummy"];
if (dt != null)
{
grdRepairs.Rows[0].Visible = false;
grdRepairs.Rows[0].Controls.Clear();
Session.Remove("pointRepairsRepairsTempDummy");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
GridView grid = new GridView();
DataTable dt = new DataTable();
List<Usuario> lista = new List<Usuario>();
UsuarioBL uBL = new UsuarioBL();
lista = uBL.buscaUsuariosEmpresa(Convert.ToInt16(Session["empresa"].ToString()));
DataColumn c1 = new DataColumn("Email", Type.GetType("System.String"));
DataColumn c2 = new DataColumn("Nome", Type.GetType("System.String"));
DataColumn c3 = new DataColumn("Empresa", Type.GetType("System.String"));
DataColumn c4 = new DataColumn("Licença", Type.GetType("System.String"));
DataColumn c5 = new DataColumn("editar", Type.GetType("System.String"));
dt.Columns.Add(c1);
dt.Columns.Add(c2);
dt.Columns.Add(c3);
dt.Columns.Add(c4);
dt.Columns.Add(c5);
foreach (Usuario u in lista)
{
DataRow dr = dt.NewRow();
dr["Email"] = u.email.ToString();
dr["Nome"] = u.nome.ToString();
dr["Empresa"] = u.idEmpresa.ToString();
dr["Licença"] = u.dataFimLicenca.ToShortDateString();
dr["editar"] = "~/EditarUsuario.aspx?user_mail=" + u.email.ToString();
dt.Rows.Add(dr);
}
gridUsuarios.DataSource = dt.Copy();
gridUsuarios.DataBind();
}
public static long Add(string book, DateTime valueDate, string partyCode, int priceTypeId, GridView grid, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long nonGlStockMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.PriceTypeId = priceTypeId;
if(grid != null)
{
if(grid.Rows.Count > 0)
{
foreach(GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
nonGlStockMasterId = MixERP.Net.DatabaseLayer.Transactions.NonGLStockTransaction.Add(book, valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), referenceNumber, statementReference, stockMaster, details);
return nonGlStockMasterId;
}
/// <summary>
/// gridview显示title的方法
/// </summary>
/// Copyright (c)
/// 创 建 人：王好([email protected])
/// 创建日期：2012年2月1日
/// 修 改 人：王好
/// 修改日期：
/// 版 本:
/// <param name="gv"></param>
/// <param name="flag"></param>
/// <returns></returns>
public static string CreateTitle(GridView gv, bool flag = false)
{
if (!flag)
{
return "没有找到相关的信息";
}
else
{
StringBuilder strHtmlStream = new StringBuilder("");
//根据gv创建title
string tb = string.Format(@"<table class='{0}' cellspacing='{1}' border='0' style='border-collapse:collapse;'>"
, "gridviewEmptyTableStyle", gv.CellSpacing);
strHtmlStream.Append(tb + "<tr class='" + gv.HeaderStyle.CssClass + "'>");
for (int index = 0; index < gv.Columns.Count; index++)
{
strHtmlStream.Append("<td >");
strHtmlStream.Append(gv.Columns[index].HeaderText.ToString());//文字
strHtmlStream.Append("</td>");
}
//结尾
strHtmlStream.Append(string.Format("</tr><tr><td colspan='{0}'>没有找到相关的信息</td></tr></table>", gv.Columns.Count));
// 返回字符串脚本
return strHtmlStream.ToString();
}
}
public static long Add(DateTime valueDate, string referenceNumber, int costCenterId, GridView grid)
{
Collection<MixERP.Net.Common.Models.Transactions.TransactionDetailModel> details = new Collection<MixERP.Net.Common.Models.Transactions.TransactionDetailModel>();
long transactionMasterId = 0;
if(grid != null)
{
if(grid.Rows.Count > 0)
{
foreach(GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.TransactionDetailModel detail = new MixERP.Net.Common.Models.Transactions.TransactionDetailModel();
detail.AccountCode = row.Cells[0].Text;
detail.CashRepositoryName = row.Cells[2].Text;
detail.StatementReference = row.Cells[3].Text.Replace(" ", " ").Trim();
detail.Debit = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Credit = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[5].Text);
details.Add(detail);
}
}
}
transactionMasterId = MixERP.Net.DatabaseLayer.Transactions.Transaction.Add(valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.GetOfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.GetUserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.GetLogOnId(), costCenterId, referenceNumber, details);
MixERP.Net.DatabaseLayer.Transactions.Verification.CallAutoVerification(transactionMasterId);
return transactionMasterId;
}
/// <summary>
/// GridView合并行，
/// </summary>
/// <param name="gv">GridView</param>
/// <param name="startCol">开始列</param>
/// <param name="endCol">结束列</param>
public void MergeRow(GridView gv, int startCol, int endCol)
{
RowArg init = new RowArg()
{
StartRowIndex = 0,
EndRowIndex = gv.Rows.Count - 2
};
for (int i = startCol; i < endCol + 1; i++)
{
if (i > 0)
{
List<RowArg> list = new List<RowArg>();
//从第二列开始就要遍历前一列
TraversesPrevCol(gv, i - 1, list);
foreach (var item in list)
{
MergeRowCol(gv, i, item.StartRowIndex, item.EndRowIndex);
}
}
//合并开始列的行
else
{
MergeRowCol(gv, i, init.StartRowIndex, init.EndRowIndex);
}
}
}
protected void ChecklistRulesInformationEmptyFix(GridView grdChecklistRulesInformation)
{
if (grdChecklistRulesInformation.Rows.Count == 0)
{
DateTime lastService = new DateTime();
DateTime nextDue = new DateTime();
UnitInformationTDS.ChecklistDetailsDataTable dt = new UnitInformationTDS.ChecklistDetailsDataTable();
dt.AddChecklistDetailsRow(0, "", "", lastService, nextDue, false, "Unknown", false);
Session["unitsChecklistRulesEditDummy"] = dt;
grdChecklistRulesInformation.DataBind();
}
// normally executes at all postbacks
if (grdChecklistRulesInformation.Rows.Count == 1)
{
UnitInformationTDS.ChecklistDetailsDataTable dt = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesEditDummy"];
if (dt != null)
{
// hide row
grdChecklistRulesInformation.Rows[0].Visible = false;
grdChecklistRulesInformation.Rows[0].Controls.Clear();
}
}
}
public static void UpdateAdminRoomGrid(GridView gv)
{
if (superRoomList.Count == 0)
{
return;
}
if (gv.Rows.Count != superRoomList.Count)
{
return;
}
for (var i = 0; i < superRoomList.Count; i++)
{
var r = superRoomList[i];
gv.Rows[i].Cells[0].Text = r.Name;
gv.Rows[i].Cells[1].Text = r.MaxParticipants.ToString();
var s = string.Empty;
int j;
for (j = 0; j < r.Inventories.Count() - 1; j++)
{
s += r.Inventories[j].ProductName + ", ";
}
if (r.Inventories.Count() != 0)
{
s += r.Inventories[j].ProductName;
}
gv.Rows[i].Cells[2].Text = s;
}
}
/// <summary>
/// 合并GridView中某列相同信息的行（单元格）
/// </summary>
/// <param name="GridView1">GridView</param>
/// <param name="cellNum">第几列</param>
public static void GroupRows(GridView GridView1, int cellNum)
{
int i = 0, rowSpanNum = 1;
while (i < GridView1.Rows.Count - 1)
{
GridViewRow gvr = GridView1.Rows[i];
for (++i; i < GridView1.Rows.Count; i++)
{
GridViewRow gvrNext = GridView1.Rows[i];
if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text)
{
gvrNext.Cells[cellNum].Visible = false;
rowSpanNum++;
}
else
{
gvr.Cells[cellNum].RowSpan = rowSpanNum;
rowSpanNum = 1;
break;
}
if (i == GridView1.Rows.Count - 1)
{
gvr.Cells[cellNum].RowSpan = rowSpanNum;
}
}
}
}
public List<int> SyncDepartmentIDs(GridView gv, List<int> DepartmentIDs)
{
for (int i = 0; i < gv.Rows.Count; i++)
{
bool isChecked = ((CheckBox)gv.Rows[i].FindControl("CheckOne")).Checked;
if (isChecked) // Add to filter list
{
//int DepartmentID = (int)gv.DataKeys[i].Value;
int DepartmentID = int.Parse(gv.Rows[i].Cells[1].Text);
DepartmentIDs.Add(DepartmentID);
}
else // Remove from filter list
{
//int DepartmentID = (int)gv.DataKeys[i].Value;
int DepartmentID = int.Parse(gv.Rows[i].Cells[1].Text);
for (int k = 0; k < DepartmentIDs.Count; k++)
{
if (DepartmentIDs[k] == DepartmentID)
{
DepartmentIDs.RemoveAt(k);
}
}
}
}
return DepartmentIDs;
}
internal static void Show(GridView ListTests, string UserName)
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
string str = "select d.Discipline_name, c.categories_name, t.name, ct.points, ct.dateComplite " +
" from Complite_test as ct inner join test as t on ct.test_id = t.test_id " +
" inner join Categories as c on c.cat_id = t.cat_id " +
" inner join discipline as d on d.discipline_id = c.discipline_id " +
" inner join users as u on u.user_id = ct.user_id where u.login = @login";
SqlCommand cmd = new SqlCommand(str, con);
cmd.Parameters.AddWithValue("login", UserName);
try
{
con.Open();
SqlDataSource ds = new SqlDataSource(con.ConnectionString, str);
Parameter p = new Parameter("login", System.Data.DbType.String, UserName);
ds.SelectParameters.Add(p);
ListTests.DataSource = ds;
ListTests.DataBind();
}
catch (Exception)
{
throw new ApplicationException("Не удается отобразить список завершенных тестов");
}
finally {
con.Close();
}
}
/// <summary>
/// Sets the sort image states.
/// </summary>
/// <param name="gridView">The grid view.</param>
/// <param name="row">The row.</param>
/// <param name="columnStartIndex"> </param>
/// <param name="sortField">The sort field.</param>
/// <param name="sortAscending">if set to <c>true</c> [sort ascending].</param>
public static void SetSortImageStates(GridView gridView, GridViewRow row,int columnStartIndex, string sortField, bool sortAscending)
{
for (var i = columnStartIndex; i < row.Cells.Count; i++)
{
var tc = row.Cells[i];
if (!tc.HasControls()) continue;
// search for the header link
var lnk = tc.Controls[0] as LinkButton;
if (lnk == null) continue;
// initialize a new image
var img = new Image
{
ImageUrl = string.Format("~/images/{0}.png", (sortAscending ? "bullet_arrow_up" : "bullet_arrow_down")),
CssClass = "icon"
};
// setting the dynamically URL of the image
// checking if the header link is the user's choice
if (sortField == lnk.CommandArgument)
{
// adding a space and the image to the header link
//tc.Controls.Add(new LiteralControl(" "));
tc.Controls.Add(img);
}
}
}
public void ExportClientsListToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
string[] ClientsList={"mike","jonh","vladimit"};
grid.DataSource = /*from d in dbContext.diners
where d.user_diners.All(m => m.user_id == userID) && d.active == true */
from d in ClientsList
select new
{
FirstName = d
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected override void CreateChildControls()
{
//create new gridview object
_gridView = new GridView
{
ID = string.Format("{0}_gridView", base.ID),
AutoGenerateColumns = false
};
//Create Custom Field
var customField = new TemplateField
{
HeaderTemplate = new SetTemplate(DataControlRowType.Header, "Name"),
ItemTemplate = new SetTemplate(DataControlRowType.DataRow)
};
//Add custom field to gridview column
_gridView.Columns.Add(customField);
//Set test data list to datasource
_gridView.DataSource = _list;
//Bind gridview
_gridView.DataBind();
//Add gridview to composite control
Controls.Add(_gridView);
}
public ActionResult ViewCards(CardInput cardInput)
{
if (ModelState.IsValid)
{
CardGenerator cardGenerator = new CardGenerator(cardInput.GeneratingDate, cardInput.NumberOfCards);
List<Card> CardList = cardGenerator.GetCardsList();
CardDAO cardDAO = new CardDAO();
if (!cardDAO.ISExsistCardDate(CardList[0].CardNumber))
{
GridView gridView = new GridView();
gridView.DataSource = CardList;
gridView.DataBind();
Session["CardsListEXCEL"] = gridView;
Session["CardsList"] = CardList;
return View(CardList);
}
else
{
ModelState.AddModelError("", "You have already generated cards on this date, so choose aonther date. ");
return View("ShowCards");
}
}
else
{
ModelState.AddModelError("", "Card List is not available");
return View("ShowCards");
}
}
/// <summary>
/// 合并GridView中某列相同信息的行（单元格）
/// </summary>
/// <param name="GridView1"></param>
/// <param name="cellNum"></param>
public static void GroupCol(GridView gridView, int cols)
{
if (gridView.Rows.Count < 1 || cols > gridView.Rows[0].Cells.Count - 1)
{
return;
}
TableCell oldTc = gridView.Rows[0].Cells[cols];
for (int i = 1; i < gridView.Rows.Count; i++)
{
TableCell tc = gridView.Rows[i].Cells[cols];
if (oldTc.Text == tc.Text)
{
tc.Visible = false;
if (oldTc.RowSpan == 0)
{
oldTc.RowSpan = 1;
}
oldTc.RowSpan++;
oldTc.VerticalAlign = VerticalAlign.Middle;
}
else
{
oldTc = tc;
}
}
}
/// <summary>
/// Sets the sort image states.
/// </summary>
/// <param name="gridView">The grid view.</param>
/// <param name="row">The row.</param>
/// <param name="sortField">The sort field.</param>
/// <param name="sortAscending">if set to <c>true</c> [sort ascending].</param>
public static void SetSortImageStates(GridView gridView, GridViewRow row,int columnStartIndex, string sortField, bool sortAscending)
{
for (int i = columnStartIndex; i < row.Cells.Count; i++)
{
TableCell tc = row.Cells[i];
if (tc.HasControls())
{
// search for the header link
LinkButton lnk = (LinkButton)tc.Controls[0];
if (lnk != null)
{
// initialize a new image
System.Web.UI.WebControls.Image img = new System.Web.UI.WebControls.Image();
// setting the dynamically URL of the image
img.ImageUrl = "~/images/" + (sortAscending ? "bullet_arrow_up" : "bullet_arrow_down") + ".png";
img.CssClass = "icon";
// checking if the header link is the user's choice
if (sortField == lnk.CommandArgument)
{
// adding a space and the image to the header link
//tc.Controls.Add(new LiteralControl(" "));
tc.Controls.Add(img);
}
}
}
}
}
/// <summary>
/// Sets the pager button states.
/// </summary>
/// <param name="gridView">The grid view.</param>
/// <param name="gvPagerRow">The gv pager row.</param>
/// <param name="page">The page.</param>
public static void SetPagerButtonStates(GridView gridView, GridViewRow gvPagerRow, Page page)
{
int pageIndex = gridView.PageIndex;
int pageCount = gridView.PageCount;
ImageButton btnFirst = (ImageButton)gvPagerRow.FindControl("btnFirst");
ImageButton btnPrevious = (ImageButton)gvPagerRow.FindControl("btnPrevious");
ImageButton btnNext = (ImageButton)gvPagerRow.FindControl("btnNext");
ImageButton btnLast = (ImageButton)gvPagerRow.FindControl("btnLast");
btnFirst.Enabled = btnPrevious.Enabled = (pageIndex != 0);
btnNext.Enabled = btnLast.Enabled = (pageIndex < (pageCount - 1));
DropDownList ddlPageSelector = (DropDownList)gvPagerRow.FindControl("ddlPages");
ddlPageSelector.Items.Clear();
for (int i = 1; i <= gridView.PageCount; i++)
{
ddlPageSelector.Items.Add(i.ToString());
}
ddlPageSelector.SelectedIndex = pageIndex;
Label lblPageCount = (Label)gvPagerRow.FindControl("lblPageCount");
lblPageCount.Text = pageCount.ToString();
//ddlPageSelector.SelectedIndexChanged += delegate
//{
// gridView.PageIndex = ddlPageSelector.SelectedIndex;
// gridView.DataBind();
//};
}
public ActionResult ViewBalanceSheet(BalanceSheetInput balanceSheet)
{
if (ModelState.IsValid)
{
TimeSpan timeSpan = (balanceSheet.MonthEnd - balanceSheet.MonthStart);
if (timeSpan.Days >= 0)
{
BalanceSheetDAO BalanceSheetDAO = new BalanceSheetDAO();
List<BalanceSheet> BalanceSheetList = BalanceSheetDAO.GetMonthlyBaanceSheet(balanceSheet.MonthStart, balanceSheet.MonthEnd, balanceSheet.UnitPrice).ToList();
GridView gridView = new GridView();
gridView.DataSource = BalanceSheetList;
gridView.DataBind();
Session["BalanceSheet"] = gridView;
return View(BalanceSheetList);
}
else
{
ModelState.AddModelError("", "Please Select a valid range with correct dates");
return View("ShowBalanceSheet");
}
}
else
{
ModelState.AddModelError("", "Balance Sheet is not available");
return View("ShowBalanceSheet");
}
}
/// <summary>
/// Sorts the records in the specified <see cref="GridView"/>.
/// </summary>
/// <param name="action">The 'Sorting' <see cref="GridAction"/> to perform.</param>
/// <param name="view">The <see cref="GridView"/> to sort.</param>
/// <param name="p">The parameters used for sorting.</param>
public void HandleService(GridAction action, GridView view, params object[] p)
{
if (view == null) return;
if (!view.AllowSorting) return;
if (action != GridAction.Sorting) return;
// Handle sorting
GridViewSortEventArgs args = p[0] as GridViewSortEventArgs;
if (args == null) return;
if (args.SortExpression == LastExpression)
{
SortAscending = !SortAscending;
}
else
{
SortAscending = true;
LastExpression = args.SortExpression;
}
args.SortDirection = SortDirection;
if (view.DataSource is IDomainCollection)
{
IDomainCollection col = (IDomainCollection)view.DataSource;
col.Sort(args.SortExpression, (args.SortDirection == SortDirection.Ascending) ? SortOrder.Ascending : SortOrder.Descending);
view.DataSource = col;
}
view.DataBind();
}
public void BuscarPublicacion(GridView GridView1, string SearchWord, int id_usr)
{
String strConnString = ConfigurationManager.ConnectionStrings["ConexionRedSocial"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "BuscarPublicacion";
cmd.Parameters.Add("@id_usr", SqlDbType.Int).Value = id_usr;
cmd.Parameters.Add("@SearchWord", SqlDbType.Text).Value = SearchWord.Trim();
cmd.Connection = con;
try
{
con.Open();
GridView1.EmptyDataText = "No hay productos publicados que se ajusten a tu busqueda. Intentá de nuevo.";
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
Grid = Parent.Parent.Parent.Parent as GridView;
Row = Parent.Parent as GridViewRow;
Grid.DataBound += new EventHandler(Grid_DataBound);
}
public static void UpdateRoomInventoryGrid(GridView gv)
{
if (roomInventoryList.Count + editRoom.Inventories.Count() == 0 || roomInventoryList.Count + editRoom.Inventories.Count() != gv.Rows.Count)
{
return;
}
int i;
for (i = 0; i < editRoom.Inventories.Count(); i++)
{
var row = gv.Rows[i];
var inventory = editRoom.Inventories[i];
row.BackColor = Color.LightGray;
row.Cells[0].Text = inventory.ProductName;
row.Cells[1].Text = inventory.InventoryType.Type;
row.Cells[2].Text = inventory.Status;
}
if (i > 0)
{
gv.Rows[i - 1].CssClass = "BorderRow";
}
for (var j = i; j - i < roomInventoryList.Count; j++)
{
var row = gv.Rows[j];
var inventory = roomInventoryList[j - i];
row.Cells[0].Text = inventory.ProductName;
row.Cells[1].Text = inventory.InventoryType.Type;
row.Cells[2].Text = inventory.Status;
}
}
private void BindItemData(GridView itemsview, int TopicID)
{
DataTable table = (DataTable) this.ViewState["dtcount"];
DataRow[] rowArray = table.Select("TopicID=" + TopicID);
object obj2 = table.Compute("sum(SubmitNum)", "TopicID=" + TopicID);
int num = 0;
if (obj2.ToString() != "")
{
num = int.Parse(obj2.ToString());
}
ArrayList list = new ArrayList();
for (int i = 0; i < rowArray.Length; i++)
{
string str = rowArray[i]["Name"].ToString();
int num3 = int.Parse(rowArray[i]["SubmitNum"].ToString());
OptionList list2 = new OptionList {
name = str,
count = num3.ToString(),
totalcount = num.ToString()
};
list.Add(list2);
}
itemsview.DataSource = list;
itemsview.DataBind();
}
public void ExportToExcel(DataTable dataTable, HttpResponse response)
{
// Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = dataTable;
GridView1.DataBind();
response.Clear();
response.Buffer = true;
response.AddHeader("content-disposition", "attachment;filename=DataTable.xls");
response.Charset = "";
response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; (i
<= (GridView1.Rows.Count - 1)); i++)
{
// Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.RenderControl(hw);
// style to format numbers to string
string style = "<style> .textmode{mso-number-format:\\@;}</style>";
response.Write(style);
response.Output.Write(sw.ToString());
response.Flush();
response.End();
}
protected void btnDownload_Click(object sender, ImageClickEventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Baogia.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
DataSet dts = new DataSet();
SqlDataAdapter adt = new SqlDataAdapter();
SqlCommand comm = new SqlCommand("Export_to_Excel", objConn.SqlConn());
comm.CommandType = CommandType.StoredProcedure;
comm.Connection.Open();
adt.SelectCommand = comm;
adt.Fill(dts);
GridView g = new GridView();
g.DataSource = dts;
g.DataBind();
g.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
public static void GroupCol(GridView gridView, int cols, int sRow, int eRow)
{
checked
{
bool flag = gridView.Rows.Count < 1 || cols > gridView.Columns.Count - 1;
if (!flag)
{
TableCell tableCell = gridView.Rows[sRow].Cells[cols];
int arg_50_0 = 1;
int num = eRow - sRow - 1;
int num2 = arg_50_0;
while (true)
{
int arg_B4_0 = num2;
int num3 = num;
if (arg_B4_0 > num3)
{
break;
}
TableCell tableCell2 = gridView.Rows[sRow + num2].Cells[cols];
tableCell2.Visible = false;
flag = (tableCell.RowSpan == 0);
if (flag)
{
tableCell.RowSpan = 1;
}
TableCell tableCell3 = tableCell;
tableCell3.RowSpan++;
tableCell.VerticalAlign = VerticalAlign.Middle;
num2++;
}
}
}
}
public static void SetGridViewCheckState(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
return;
switch (filterName)
{
case "Department":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DepartmentFilter);
break;
case "Section":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.SectionFilter);
break;
case "Company":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CompanyFilter);
break;
case "Location":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.LocationFilter);
break;
case "Shift":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ShiftFilter);
break;
case "Division":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DivisionFilter);
break;
case "Employee":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.EmployeeFilter);
break;
case "Crew":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CrewFilter);
break;
case "Type":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.TypeFilter);
break;
}
}
public virtual void Init (PortalModuleBase module, GridView gridView, HyperLink addButton, int pageSize)
{
Grid = gridView;
Grid.PageSize = pageSize;
AddButton = addButton;
AddButton.NavigateUrl = Utils.EditUrl (module, EditKey);
}
public GridViewHelper(System.Web.UI.WebControls.GridView grd, bool useFooterForGeneralSummaries, SortDirection groupSortDirection)
{
this.mGrid = grd;
this.useFooter = useFooterForGeneralSummaries;
this.groupSortDir = groupSortDirection;
this.mGeneralSummaries = new List <GridViewSummary>();
this.mGroups = new List <GridViewGroup>();
this.mGrid.RowDataBound += new GridViewRowEventHandler(RowDataBoundHandler);
}
private void lkbtncancleCheck_Click(object sender, System.EventArgs e)
{
int num = 0;
bool flag = true;
System.Collections.Generic.Dictionary <string, int> dictionary = new System.Collections.Generic.Dictionary <string, int>();
foreach (System.Web.UI.WebControls.GridViewRow gridViewRow in this.grdAuthorizeProducts.Rows)
{
System.Web.UI.WebControls.GridView gridView = gridViewRow.FindControl("grdSkus") as System.Web.UI.WebControls.GridView;
foreach (System.Web.UI.WebControls.GridViewRow gridViewRow2 in gridView.Rows)
{
System.Web.UI.WebControls.CheckBox checkBox = (System.Web.UI.WebControls.CheckBox)gridViewRow2.FindControl("checkboxCol");
System.Web.UI.WebControls.TextBox textBox = gridViewRow2.FindControl("txtNum") as System.Web.UI.WebControls.TextBox;
if (checkBox != null && checkBox.Checked)
{
num++;
int value;
if (!int.TryParse(textBox.Text.Trim(), out value) || int.Parse(textBox.Text.Trim()) <= 0 || textBox.Text.Trim().Contains("."))
{
flag = false;
break;
}
dictionary.Add((string)gridView.DataKeys[gridViewRow2.RowIndex].Value, value);
}
}
if (!flag)
{
break;
}
}
if (num == 0)
{
this.ShowMsg("请先选择要添加的商品", false);
return;
}
if (!flag)
{
this.ShowMsg("数量不能为空,必需为大于零的正整数", false);
return;
}
int num2 = 0;
foreach (System.Collections.Generic.KeyValuePair <string, int> current in dictionary)
{
if (SubsiteSalesHelper.DeletePurchaseShoppingCartItem(current.Key))
{
num2++;
}
}
if (num2 > 0)
{
this.ShowMsg(string.Format("成功取消了{0}件商品", num2), true);
this.BindData();
return;
}
this.ShowMsg("取消商品失败", false);
}
protected void GridView2_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
System.Web.UI.WebControls.GridView sn = new System.Web.UI.WebControls.GridView();
DataTable dT = (DataTable)Session["header_01"];
tabela.makeHeader(sn, dT, GridView2);
}
}
protected void grvMergeHeader_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
System.Web.UI.WebControls.GridView sn = new System.Web.UI.WebControls.GridView();
DataTable dT = (DataTable)Session["header_01"];
makeHeader2(sn, dT);
}
} //end of grvMergeHeader_RowCreated
protected void naglowekTabeli_gwTabela3(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
System.Web.UI.WebControls.GridView sn = new System.Web.UI.WebControls.GridView();
DataTable dT = (DataTable)Session["header_03"];//tb.naglowek(path, 2);
tb.makeHeader(sn, dT, gwTabela3);
}
}
public ColHeaderWithAutoCompleteTbx(System.Web.UI.WebControls.GridView grd, SessionStateFilterAndSortEntities <TEntity> sessVar, string ServiceMethod)
{
_sessVar = sessVar;
grd.DataBinding += new EventHandler(grd_DataBinding);
_serviceMethod = ServiceMethod;
CompletionSetCount = 5;
CompletionInterval = 500;
MinimumPrelfixLength = 1;
}
public ColHeaderWithTimeIntervalFilter(System.Web.UI.WebControls.GridView grd, SessionStateFilterAndSortEntities <TEntity> sessVar)
{
_sessVar = sessVar;
grd.DataBinding += new EventHandler(grd_DataBinding);
BeginningOfTime = new DateTime(1945, 5, 8);
EndOfTime = new DateTime(3000, 1, 1);
}
public GridViewDecorator(System.Web.UI.WebControls.GridView grd, TState state, HttpResponse response, mko.Log.LogServer log)
{
Debug.Assert(grd != null && state != null && response != null && log != null, "GridViewDecorator: Konstruktorparameter unvollständig");
this.grd = grd;
this.log = log;
this.state = state;
grd.Sorting += new System.Web.UI.WebControls.GridViewSortEventHandler(grd_Sorting);
grd.EmptyDataTemplate = new mkoIt.Asp.GridView.EmptyDataTemplate <TEntity>(state, response);
}
protected void naglowekTabeli_gwTabela3(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
System.Web.UI.WebControls.GridView sn = new System.Web.UI.WebControls.GridView();
string path = Server.MapPath("\\Template\\obbk.xlsx");
DataTable dT = tb.naglowek(path, 3);
tb.makeHeader(sn, dT, gwTabela3);
}
}
public static void Format(System.Web.UI.WebControls.GridView obj)
{
obj.EmptyDataText = "Không có dữ liệu";
obj.CssClass = "mGrid";
obj.PagerStyle.CssClass = "pgr";
obj.AlternatingRowStyle.CssClass = "alt";
obj.AutoGenerateColumns = false;
obj.BorderWidth = 1;
obj.BorderColor = System.Drawing.Color.Black;
}
protected void naglowekTabeli_gwTabela2(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
System.Web.UI.WebControls.GridView sn = new System.Web.UI.WebControls.GridView();
string path = Server.MapPath("~\\Template\\" + tenPlikNazwa + ".xlsx");
DataTable dT = (DataTable)Session["header_02"];//tb.naglowek(path, 2);
tb.makeHeader(sn, dT, gwTabela2);
}
}
/// <summary>
/// 描述：把DataTable内容导出excel并返回客户端
/// 时间：2012-10-18
/// </summary>
/// <param name="dtData"></param>
/// <param name="header"></param>
/// <param name="fileName"></param>
/// <param name="mergeCellNums">要合并的列索引字典 格式：列索引-合并模式(合并模式 1 合并相同项、2 合并空项、3 合并相同项及空项)</param>
/// <param name="mergeKey">作为合并项的标记列索引</param>
public static void DataTable2Excel(System.Data.DataTable dtData, TableCell[] header, string fileName, Dictionary <int, int> mergeCellNums, int?mergeKey)
{
System.Web.UI.WebControls.GridView gvExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "gb2312";
if (!string.IsNullOrEmpty(fileName))
{
//处理中文名乱码问题
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
curContext.Response.AppendHeader("Content-Disposition", ("attachment;filename=" + (fileName.ToLower().EndsWith(".xls") ? fileName : fileName + ".xls")));
}
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 重新定义一个无分页的GridView
gvExport = new System.Web.UI.WebControls.GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
//优化导出数据显示，如身份证、12-1等显示异常问题
gvExport.RowDataBound += new System.Web.UI.WebControls.GridViewRowEventHandler(dgExport_RowDataBound);
gvExport.DataBind();
//处理表头
if (header != null && header.Length > 0)
{
gvExport.HeaderRow.Cells.Clear();
gvExport.HeaderRow.Cells.AddRange(header);
}
//合并单元格
if (mergeCellNums != null && mergeCellNums.Count > 0)
{
foreach (int cellNum in mergeCellNums.Keys)
{
MergeRows(gvExport, cellNum, mergeCellNums[cellNum], mergeKey);
}
}
// 返回客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Clear();
curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.End();
}
}
/// <summary>
/// In una gridview ricava l'indice di una colonna boundfield di nome dato
/// </summary>
public int GridIndexOfByName(System.Web.UI.WebControls.GridView myGridView, string colName)
{
int index = -1;
foreach (DataControlField field in myGridView.Columns)
{
//BoundField
if (field.GetType().ToString() == "System.Web.UI.WebControls.BoundField")
{
BoundField bf = (BoundField)field;
if (bf.DataField == colName)
{
index = myGridView.Columns.IndexOf(field);
break;
}
}
//TemplateField
else if (field.GetType().ToString() == "System.Web.UI.WebControls.TemplateField")
{
TemplateField tf = (TemplateField)field;
if (tf.ItemTemplate.GetType().ToString() == "System.Web.UI.WebControls.DropDownList")
{
System.Web.UI.WebControls.DropDownList dropdownField = (System.Web.UI.WebControls.DropDownList)tf.ItemTemplate;
if (dropdownField.ID.ToString() == colName)
{
index = myGridView.Columns.IndexOf(field);
break;
}
}
else if (tf.ItemTemplate.GetType().ToString() == "System.Web.UI.CompiledBindableTemplateBuilder")
{
//Questo ramo non funziona ...!!!
System.Web.UI.CompiledBindableTemplateBuilder compiledBindableTemplateBuilder = (System.Web.UI.CompiledBindableTemplateBuilder)tf.ItemTemplate;
if (compiledBindableTemplateBuilder.GetType().ToString() == "System.Web.UI.WebControls.TextBox")
{
//System.Web.UI.WebControls.TextBox textBox = (System.Web.UI.WebControls.TextBox)compiledBindableTemplateBuilder.tf.ItemTemplate;
//if (dropdownField.ID.ToString() == colName)
//{
// index = myGridView.Columns.IndexOf(field);
// break;
//}
}
if (compiledBindableTemplateBuilder.GetType().ToString() == colName)
{
index = myGridView.Columns.IndexOf(field);
break;
}
}
}
}
return(index);
}
/**/
/// <summary>
/// Add the confirm message to button
/// Created : GuangMing Chu, 1 1,2007
/// Modified: GuangMing Chu, 1 1,2007
/// Modified:
/// 代码调用:
/// UIHelper.AddConfirm(this.Button1, "真的要删了？？");
/// 点确定按钮就会执行事件中的代码，点取消不会
///
/// </summary>
/// <param name="button">The control, must be a button</param>
/// <param name="strMsg">The popup message</param>
public static void AddConfirm(System.Web.UI.WebControls.ImageButton button, string strMsg)
{
strMsg = strMsg.Replace("\n", "file://n/");
strMsg = strMsg.Replace("\r", "file://r/");
strMsg = strMsg.Replace("\"", "\\\"");
strMsg = strMsg.Replace("\'", "\\\'");
button.Attributes.Add("onClick", "return confirm('" + strMsg + "')");
}
/**/
/// <summary>
/// Add the confirm message to one column of gridview
/// 代码调用：
/// UIHelper myHelp = new UIHelper();
/// myHelp.AddConfirm(this.GridView1,1, "ok");
/// 请使用时注意，此方法的调用必须实例化，调用
/// </summary>
/// <param name="grid">The control, must be a GridView</param>
/// <param name="intColIndex">The column index. It's usually the column which has the "delete" button.</param>
/// <param name="strMsg">The popup message</param>
public static void AddConfirm(System.Web.UI.WebControls.GridView grid, int intColIndex, string strMsg)
{
strMsg = strMsg.Replace("\n", "file://n/");
strMsg = strMsg.Replace("\r", "file://r/");
strMsg = strMsg.Replace("\"", "\\\"");
strMsg = strMsg.Replace("\'", "\\\'");
for (int i = 0; i < grid.Rows.Count; i++)
{
grid.Rows[i].Cells[intColIndex].Attributes.Add("onclick", "return confirm('" + strMsg + "')");
}
}
/// <summary>
/// 从GridView的数据生成DataTable
/// </summary>
/// <param name="gv">GridView对象</param>
public static DataTable GridView2DataTable(System.Web.UI.WebControls.GridView gv)
{
DataTable table = new DataTable();
int rowIndex = 0;
List <string> cols = new List <string>();
if (!gv.ShowHeader && gv.Columns.Count == 0)
{
return(table);
}
GridViewRow headerRow = gv.HeaderRow;
int columnCount = headerRow.Cells.Count;
for (int i = 0; i < columnCount; i++)
{
string text = GetCellText(headerRow.Cells[i]);
cols.Add(text);
}
foreach (GridViewRow r in gv.Rows)
{
if (r.RowType == DataControlRowType.DataRow)
{
DataRow row = table.NewRow();
int j = 0;
for (int i = 0; i < columnCount; i++)
{
string text = GetCellText(r.Cells[i]);
if (!string.IsNullOrEmpty(text))
{
if (rowIndex == 0)
{
string columnName = cols[i];
if (string.IsNullOrEmpty(columnName))
{
continue;
}
if (table.Columns.Contains(columnName))
{
continue;
}
DataColumn dc = table.Columns.Add();
dc.ColumnName = columnName;
dc.DataType = typeof(string);
}
row[j] = text;
j++;
}
}
rowIndex++;
table.Rows.Add(row);
}
}
return(table);
}
public static void LoadClientPaymentHistoryPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlClientProvider sqlClientProvider = new SqlClientProvider();
DataSet ds = sqlClientProvider.LoadClientPaymentHistoryPage(search_val, pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
LoadClientPaymentHistoryPage(rptPager, recordCount, pageIndex, PageSize);
}
public static void LoadStatesPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlStatesProvider sqlStatesProvider = new SqlStatesProvider();
DataSet ds = sqlStatesProvider.GetStatesPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
statessPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public ActionResult Export()
{
DataTable dt = ToDataTable(db.EmployeeMsts.ToList());
if (dt.Rows.Count > 0)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.Tables[0].Columns.Remove("EmployeeID");
ds.Tables[0].Columns.Remove("Image");
System.Web.UI.WebControls.GridView gv = new System.Web.UI.WebControls.GridView();
gv.DataSource = ds;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=outage_manager.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.HeaderRow.Style.Add("background-color", "#92D050");
Table table = new Table();
TableRow title = new TableRow();
title.BackColor = Color.Gray;
TableCell titlecell = new TableCell();
titlecell.ColumnSpan = 9;//Should span across all columns
titlecell.HorizontalAlign = HorizontalAlign.Left;
titlecell.RowSpan = 2;
Label lbl = new Label();
lbl.Text = "Employee Details";
lbl.Style.Add("font-size", "medium");
lbl.Style.Add("font-family", "Arial");
lbl.Style.Add("font-weight", "bold");
titlecell.Controls.Add(lbl);
title.Cells.Add(titlecell);
table.Rows.Add(title);
table.RenderControl(htw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
return(RedirectToAction("Index"));
}
public static void BindGridView(this System.Web.UI.WebControls.GridView gridView, object source, int pageSize, int pageIndex, IEnumerable <int> columnIndexesToHide)
{
gridView.DataSource = source;
gridView.PageSize = pageSize;
gridView.PageIndex = pageIndex;
gridView.DataBind();
foreach (var index in columnIndexesToHide)
{
gridView.Columns[index].Visible = false;
}
}
public GridFilterRemoveFilterButton(Page page, System.Web.UI.WebControls.GridView grdAll, string IdBtnRemoveFilter, SessionStateFilterAndSortEntities <TEntity> state)
{
_Page = page;
_grdAll = grdAll;
_state = state;
if (_grdAll.HeaderRow != null)
{
_btnRemoveFilter = _grdAll.HeaderRow.FindControl(IdBtnRemoveFilter) as Button;
_btnRemoveFilter.Click += new EventHandler(OnButtonClick);
}
}
public GridFilterSetFilterButton(Page page, System.Web.UI.WebControls.GridView grdAll, string IdBtnSetFilter)
{
_Page = page;
_grdAll = grdAll;
if (_grdAll.HeaderRow != null)
{
_btnSetFilter = _grdAll.HeaderRow.FindControl(IdBtnSetFilter) as Button;
Debug.Assert(_btnSetFilter != null);
_btnSetFilter.Click += new EventHandler(OnButtonClick);
}
}
public static int FindColumnIndex(System.Web.UI.WebControls.GridView gridView, string accessibleHeaderText)
{
for (int index = 0; index < gridView.Columns.Count; index++)
{
if (String.Compare(gridView.Columns[index].AccessibleHeaderText, accessibleHeaderText, true) == 0)
{
return(index);
}
}
return(-1);
}
protected void new_object_Click(object sender, EventArgs e)
{
Session["created_flag"] = true;
System.Web.UI.WebControls.ObjectDataSource ods = current_ods();
System.Web.UI.WebControls.GridView gv = current_grid();
ods.SelectMethod = "GetData";
ods.SelectParameters.Clear();
int i = ods.Insert();
gv.EditIndex = gv.Rows.Count;
this.DataBind();
}
protected override void CreateChildControls()
{
SiteViewer webPart = (SiteViewer)this.WebPartToEdit;
if (webPart == null)
{
return;
}
if (ViewState["FirstLoad"] == null || !bool.Parse(ViewState["FirstLoad"].ToString()))
{
ViewState["CommingUp"] = webPart.CommingUpLink;
}
ViewState["FirstLoad"] = true;
lblTitle = new System.Web.UI.WebControls.Label();
lblTitle.Text = "Comming up link : ";
Controls.Add(lblTitle);
txtCommingUpTitle = new TextBox();
txtCommingUpTitle.ID = "txtTitle";
Controls.Add(txtCommingUpTitle);
txtCommingUpLink = new TextBox();
txtCommingUpLink.ID = "txtLink";
Controls.Add(txtCommingUpLink);
literalSpace = new Literal();
literalSpace.Text = " ";
Controls.Add(literalSpace);
btnAdd = new Button();
btnAdd.ID = "btnAdd";
btnAdd.Text = "Add";
btnAdd.Click += new EventHandler(btnAdd_Click);
Controls.Add(btnAdd);
literalSpace = new Literal();
literalSpace.Text = "<br /><br />";
Controls.Add(literalSpace);
gridCommingUpLink = new GridView();
gridCommingUpLink.Style.Add("width", "100%");
gridCommingUpLink.RowDeleting += new GridViewDeleteEventHandler(gridCommingUpLink_RowDeleting);
gridCommingUpLink.AutoGenerateDeleteButton = true;
gridCommingUpLink.DataSource = ViewState["CommingUp"] as List <CommingUpLink>;
gridCommingUpLink.DataBind();
Controls.Add(gridCommingUpLink);
base.CreateChildControls();
}
public void fillgrid(System.Web.UI.WebControls.GridView gv, string sql)
{
SqlConnection con = new SqlConnection(DBUtil.ConnectionString);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
da.Fill(dt);
gv.DataSource = dt;
gv.DataBind();
}
public static void LoadClientPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlClientProvider sqlClientProvider = new SqlClientProvider();
DataSet ds = sqlClientProvider.GetClientPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID, FromDate, ToDate);
gv.DataSource = ds;
gv.DataBind();
lbltotalrecord.Text = "Total Record Found : " + recordCount;
clientsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
protected void SelectOrDeselectAllGridCheckBox(System.Web.UI.WebControls.GridView gridView, bool makeItSelect, string checkBoxName)
{
for (int i = 0; i < gridView.Rows.Count; i++)
{
GridViewRow row = gridView.Rows[i];
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox cbxGroupedDiscplines = FindControlById(row, checkBoxName) as CheckBox;
cbxGroupedDiscplines.Checked = makeItSelect;
}
}
}
protected void dgvInfo_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow) //如果是数据行
{
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#6699ff' ");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
GridView grid = sender as GridView; //取当前操作的GridView
string code = grid.DataKeys[e.Row.RowIndex].Value.ToString();
string name = e.Row.Cells[1].Text;
((LinkButton)(e.Row.Cells[grid.Columns.Count - 1].Controls[0])).Attributes.Add("onclick",
"btnSelect_onclick('" + code +
"','" + name + "')");
}
}
/// <summary>
/// Clears the child controls of a EntityGridView to make sure all controls are LiteralControls
/// </summary>
/// <param name="gridView">Datagrid to be cleared and verified</param>
protected void ClearChildControls(System.Web.UI.WebControls.GridView gridView)
{
for (int i = gridView.Columns.Count - 1; i >= 0; i--)
{
if (gridView.Columns[i].GetType().Name == "ButtonColumn" ||
gridView.Columns[i].GetType().Name == "CheckBoxField" ||
gridView.Columns[i].GetType().Name == "CommandField")
{
gridView.Columns[i].Visible = false;
}
}
this.RecursiveClear(gridView);
}
//GridView
public void GridView_Bind(System.Web.UI.WebControls.GridView gv, DataSet ds)
{
if (ds == null)
{
return;
}
if (ds.Tables.Count == 0)
{
return;
}
gv.DataSource = ds.Tables[0].DefaultView;
gv.DataBind();
}