protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//Add filter by user, type, room
//Add columns: Check date, uvuinvid, otherid, MakeModel
TechInventoryDataContext db = new TechInventoryDataContext();
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = GridView1.Rows[index];
string uvuInvID = Convert.ToString(row.Cells[1].Text);
ButtonField b = new ButtonField();
DateTime now = DateTime.Now;
string date = now.ToShortDateString();
var query = (from equip in db.Equipments
where equip.UVUInvID == uvuInvID
select equip).Single();
query.InvCheck = now;
string test = "test";
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (InRowChangingEventException)
{
// Resolve conflicts.
//db.ChangeConflicts.ResolveAll();
}
GridView1.DataBind();
}
private void BindGrid()
{
BoundField theCol0 = new BoundField();
theCol0.HeaderText = "Priority";
theCol0.ItemStyle.CssClass = "textstyle";
theCol0.DataField = "ID";
theCol0.SortExpression = "ID";
theCol0.ReadOnly = true;
BoundField theCol1 = new BoundField();
theCol1.HeaderText = "LPTF Patient Transfer";
theCol1.ItemStyle.CssClass = "textstyle";
theCol1.DataField = "Name";
theCol1.SortExpression = "Name";
theCol1.ReadOnly = true;
BoundField theCol2 = new BoundField();
theCol2.HeaderText = "AIDSRelief Site";
theCol2.ItemStyle.CssClass = "textstyle";
theCol2.DataField = "ARFunded";
theCol2.SortExpression = "ARFunded";
theCol2.ReadOnly = true;
BoundField theCol3 = new BoundField();
theCol3.HeaderText = "Status";
theCol3.DataField = "Status";
theCol3.ItemStyle.CssClass = "textstyle";
theCol3.SortExpression = "Status";
theCol3.ReadOnly = true;
ButtonField theBtn = new ButtonField();
theBtn.ButtonType = ButtonType.Link;
theBtn.CommandName = "Select";
theBtn.HeaderStyle.CssClass = "textstylehidden";
theBtn.ItemStyle.CssClass = "textstylehidden";
grdMasterLPTFPatientTransfer.Columns.Add(theCol0);
grdMasterLPTFPatientTransfer.Columns.Add(theCol1);
grdMasterLPTFPatientTransfer.Columns.Add(theCol2);
grdMasterLPTFPatientTransfer.Columns.Add(theCol3);
grdMasterLPTFPatientTransfer.Columns.Add(theBtn);
grdMasterLPTFPatientTransfer.DataBind();
grdMasterLPTFPatientTransfer.Columns[0].Visible = false;
}
/////////////////////////////////////////////////////////////////////
// Code Written By : Pankaj Kumar
// Written Date : 25th July 2006
// Modification Date :
// Description : Disease List
//
/// <summary>
/// Binds the grid.
/// </summary>
//
#region User functions
private void BindGrid()
{
BoundField theCol0 = new BoundField();
theCol0.HeaderText = "Disease_pk";
theCol0.DataField = "Disease_pk";
theCol0.ItemStyle.CssClass = "textstyle";
theCol0.ReadOnly = true;
BoundField theCol1 = new BoundField();
theCol1.HeaderText = "DiseaseName";
theCol1.ItemStyle.CssClass = "textstyle";
theCol1.DataField = "DiseaseName";
theCol1.SortExpression = "DiseaseName";
theCol1.ItemStyle.Font.Underline = true;
theCol1.ReadOnly = true;
BoundField theCol2 = new BoundField();
theCol2.HeaderText = "Status";
theCol2.DataField = "Status";
theCol2.SortExpression = "Status";
theCol2.ItemStyle.CssClass = "textstyle";
theCol2.ReadOnly = true;
BoundField theCol7 = new BoundField();
theCol7.HeaderText = "Priority";
theCol7.DataField = "Sequence";
theCol7.ItemStyle.CssClass = "textstyle";
theCol7.SortExpression = "Sequence";
theCol7.ReadOnly = true;
ButtonField theBtn = new ButtonField();
theBtn.ButtonType = ButtonType.Link;
theBtn.CommandName = "Select";
theBtn.HeaderStyle.CssClass = "textstylehidden";
theBtn.ItemStyle.CssClass = "textstylehidden";
grdDisease.Columns.Add(theCol0);
grdDisease.Columns.Add(theCol7);
grdDisease.Columns.Add(theCol1);
grdDisease.Columns.Add(theCol2);
grdDisease.Columns.Add(theBtn);
grdDisease.DataBind();
grdDisease.Columns[0].Visible = false;
}
protected void BindGrid()
{
BoundField theCol0 = new BoundField();
theCol0.HeaderText = "EducationID";
theCol0.DataField = "ID";
theCol0.ItemStyle.CssClass = "textStyle";
theCol0.ReadOnly = true;
BoundField theCol1 = new BoundField();
theCol1.HeaderText = "EducationName";
theCol1.DataField = "Name";
theCol1.ItemStyle.CssClass = "textstyle";
theCol1.SortExpression = "Name";
theCol1.ItemStyle.Font.Underline = true;
theCol1.ReadOnly = true;
BoundField theCol2 = new BoundField();
theCol2.HeaderText = "Status";
theCol2.DataField = "Status";
theCol2.SortExpression = "Status";
theCol2.ItemStyle.CssClass = "textstyle";
theCol2.ReadOnly = true;
BoundField theCol3 = new BoundField();
theCol3.HeaderText = "Sequence";
theCol3.DataField = "SRNO";
theCol3.ItemStyle.CssClass = "textstyle";
theCol3.SortExpression = "SRNO";
theCol3.ReadOnly = true;
ButtonField theBtn = new ButtonField();
theBtn.ButtonType = ButtonType.Link;
theBtn.CommandName = "Select";
theBtn.HeaderStyle.CssClass = "textstylehidden";
theBtn.ItemStyle.CssClass = "textstylehidden";
grdEducation.Columns.Add(theCol0);
grdEducation.Columns.Add(theCol1);
grdEducation.Columns.Add(theCol2);
grdEducation.Columns.Add(theCol3);
grdEducation.Columns.Add(theBtn);
grdEducation.DataBind();
grdEducation.Columns[0].Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
datacontract();
refresh();
refreEmpty();
add.Visible = false;
new Warehouse.Tools.AddSysLog().addlog("1", "数据备份", "查询");
}
ButtonField bf88 = GridView1.Columns[8] as ButtonField; bf88.ControlStyle.BorderStyle = BorderStyle.None; bf88.ControlStyle.BackColor = System.Drawing.Color.White;
ButtonField bf99 = GridView1.Columns[9] as ButtonField; bf99.ControlStyle.BorderStyle = BorderStyle.None; bf99.ControlStyle.BackColor = System.Drawing.Color.White;
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
// Por cada idioma definido en el web.config, cargo una nueva columna al Grid
foreach (string language in GetListOfSupportedLanguages())
{
ButtonField button = new ButtonField();
button.CommandName = "language_" + language;
button.ButtonType = ButtonType.Link;
button.HeaderText = language;
button.HeaderStyle.CssClass = "text-center";
grdData.Columns.Add(button);
}
}
protected void build()
{
//设置主键
GridView1.DataKeyNames = new string[] { Convert.ToString(config.Rows[0]["mainKey"]) };
//设置数据列
for (int i = 0; i < listconfig.Rows.Count; i++)
{
BoundField bf = new BoundField();
bf.DataField = Convert.ToString(listconfig.Rows[i]["fieldName"]);
bf.SortExpression = Convert.ToString(listconfig.Rows[i]["fieldName"]);
bf.HeaderText = Convert.ToString(listconfig.Rows[i]["fieldCN"]);
bf.HeaderStyle.Width = new Unit((string)listconfig.Rows[i]["onListHeaderWidth"]);
bf.ReadOnly = (double)listconfig.Rows[i]["readOnly"] > 0;
GridView1.Columns.Add(bf);
}
//设置按钮
ButtonField btnf3 = new ButtonField();
btnf3.CommandName = "hz"; btnf3.Text = "河长"; btnf3.ButtonType = ButtonType.Button;
btnf3.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
btnf3.ItemStyle.VerticalAlign = VerticalAlign.Middle;
GridView1.Columns.Add(btnf3);
CommandField cf = new CommandField();
cf.ShowEditButton = true; cf.ButtonType = ButtonType.Button;
cf.EditText = "修改"; cf.UpdateText = "确认";
cf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
cf.ItemStyle.VerticalAlign = VerticalAlign.Middle;
GridView1.Columns.Add(cf);
ButtonField btnf1 = new ButtonField();
btnf1.CommandName = "detail"; btnf1.Text = "详情"; btnf1.ButtonType = ButtonType.Button;
btnf1.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
btnf1.ItemStyle.VerticalAlign = VerticalAlign.Middle;
GridView1.Columns.Add(btnf1);
ButtonField btnf2 = new ButtonField();
btnf2.CommandName = "map"; btnf2.Text = "定位"; btnf2.ButtonType = ButtonType.Button;
btnf2.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
btnf2.ItemStyle.VerticalAlign = VerticalAlign.Middle;
GridView1.Columns.Add(btnf2);
ButtonField btnf4 = new ButtonField();
btnf4.CommandName = "flashback"; btnf4.Text = "还原"; btnf4.ButtonType = ButtonType.Button;
btnf4.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
btnf4.ItemStyle.VerticalAlign = VerticalAlign.Middle;
GridView1.Columns.Add(btnf4);
}
private void atualizarGrid()
{
Emprestimo emprestimo = new Emprestimo();
gvEmprestimos.Columns.Clear();
gvEmprestimos.DataSource = null;
gvEmprestimos.DataBind();
DataTable dados;
if (cbEmprestimos.Checked)
{
dados = emprestimo.listaTodosEmprestimosPorConcluirComNomes();
}
else
{
dados = emprestimo.listaTodosEmprestimosComNomes();
}
if (dados == null || dados.Rows.Count == 0)
{
return;
}
//botões de comando
//alterar o estado do empréstimo
ButtonField btEstado = new ButtonField();
btEstado.HeaderText = "Receber livro";
btEstado.Text = "Receber";
btEstado.ButtonType = ButtonType.Button;
btEstado.ControlStyle.CssClass = "btn btn-info";
btEstado.CommandName = "alterar";
gvEmprestimos.Columns.Add(btEstado);
//enviar o email
/* ButtonField btEmail = new ButtonField();
* btEmail.HeaderText = "Notificar";
* btEmail.Text = "Email";
* btEmail.ButtonType = ButtonType.Button;
* btEmail.ControlStyle.CssClass= "btn btn-danger";
* btEmail.CommandName = "email";
* gvEmprestimos.Columns.Add(btEmail);*/
gvEmprestimos.DataSource = dados;
gvEmprestimos.AutoGenerateColumns = true;
gvEmprestimos.DataBind();
}
protected override void CreateChildControls()
{
//Configure Search Button
var searchMachineModelButton = new Button {
Text = "Go", CausesValidation = true
};
searchMachineModelButton.Click += new EventHandler(SearchMachineModelButton_Click);
//Configure Button Field
ButtonField selectButton = new ButtonField();
selectButton.Text = "select";
selectButton.CommandName = "Select";
selectButton.CausesValidation = false;
//Configure Machine GridView
machineGridView.Columns.Add(selectButton);
machineGridView.DataKeyNames = new string[] { "ID" };
machineGridView.SelectedIndexChanged += machineGridView_SelectedIndexChanged;
machineGridView.RowStyle.Wrap = false;
//Configure Parts GridView
partGridView.RowStyle.Wrap = false;
//Add Controls
Controls.Add(new Label {
Text = "Search by Machine Model: "
});
searchMachineModelTextBox.ID = "SearchMachineTextBox";
Controls.Add(searchMachineModelTextBox);
Controls.Add(validationLabel);
Controls.Add(searchMachineModelButton);
Controls.Add(ResponseLabel);
Controls.Add(new Literal()
{
Text = "<br/><br/>"
});
Controls.Add(machineGridView);
Controls.Add(new Literal()
{
Text = "<br/><br/>"
});
Controls.Add(partGridView);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var test = new ButtonField();
test.Text = "Details";
test.ButtonType = ButtonType.Button;
test.CommandName = "test";
GridView1.Columns.Add(test);
GridView1.DataSource = new[] {
new { Id = 1, Text = "Text 1" },
new { Id = 2, Text = "Text 2" },
};
GridView1.DataBind();
}
}
public void ButtonField_CopyProperties()
{
PokerButtonField button = new PokerButtonField();
ButtonField copy = new ButtonField();
button.CommandName = "CommandName";
button.DataTextField = "DataTextField";
button.DataTextFormatString = "DataTextFormatString";
button.ImageUrl = "ImageUrl";
button.Text = "Text";
button.DoCopyProperties(copy);
Assert.AreEqual("CommandName", copy.CommandName, "CommandName");
Assert.AreEqual("DataTextField", copy.DataTextField, "DataTextField");
Assert.AreEqual("DataTextFormatString", copy.DataTextFormatString, "DataTextFormatString");
Assert.AreEqual("ImageUrl", copy.ImageUrl, "ImageUrl");
Assert.AreEqual("Text", copy.Text, "Text");
}
public void Bind1(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf2 = new BoundField(); bf2.DataField = "departId"; bf2.HeaderText = "部门Id"; bf2.ReadOnly = true; bf2.SortExpression = "departId"; bf2.HeaderStyle.Height = Unit.Parse("40px");
BoundField bf3 = new BoundField(); bf3.DataField = "departName"; bf3.HeaderText = "部门名称"; bf3.SortExpression = "departName";
BoundField bf4 = new BoundField(); bf4.DataField = "parentdepartName"; bf4.HeaderText = "上级部门"; bf4.SortExpression = "parentdepartName";
BoundField bf5 = new BoundField(); bf5.DataField = "staffNum"; bf5.HeaderText = "负责人"; bf5.SortExpression = "staffNum";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "编辑"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = "";
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = "";
G1.Columns.Add(bf1);
G1.Columns.Add(bf2);
G1.Columns.Add(bf3);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
//private SqlDataSource _sqlDataSource;
private void _SetupGridView()
{
var idBoundField = new ButtonField
{
DataTextField = "ID",
ButtonType = ButtonType.Link,
CommandName = "Select",
HeaderText = "Select"
};
var firstNameField = new BoundField
{
DataField = "FirstName",
HeaderText = "First Name",
SortExpression = "FirstName, LastName"
};
var lastNameField = new BoundField
{
DataField = "LastName",
HeaderText = "Last Name",
SortExpression = "LastName, FirstName"
};
var phoneField = new BoundField
{
DataField = "Phone",
HeaderText = "Phone",
SortExpression = "Phone"
};
var emailField = new BoundField
{
DataField = "EmailAddress",
HeaderText = "Email Address",
SortExpression = "EmailAddress"
};
_gridView.Columns.Add(idBoundField);
_gridView.Columns.Add(firstNameField);
_gridView.Columns.Add(lastNameField);
_gridView.Columns.Add(phoneField);
_gridView.Columns.Add(emailField);
_gridView.DataSourceID = "_sqlDataSource";
_gridView.DataKeyNames = new[] {"Id"};
_gridView.RowCommand += GridCommand;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号";
BoundField bf2 = new BoundField(); bf2.DataField = "userId"; bf2.HeaderText = "id"; bf2.Visible = false;
BoundField bf3 = new BoundField(); bf3.DataField = "staffNum"; bf3.HeaderText = "用户编号";
BoundField bf4 = new BoundField(); bf4.DataField = "staff.staffname"; bf4.HeaderText = "用户名称";
BoundField bf5 = new BoundField(); bf5.DataField = "staff.idCard"; bf5.HeaderText = "身份证号";
BoundField bf6 = new BoundField(); bf6.DataField = "staff.phoneNumber"; bf6.HeaderText = "联系方式";
BoundField bf7 = new BoundField(); bf7.DataField = "job"; bf7.HeaderText = "身份";
BoundField bf8 = new BoundField(); bf8.DataField = "staff.gender"; bf8.HeaderText = "性别";
BoundField bf9 = new BoundField(); bf9.DataField = "staff.hometown"; bf9.HeaderText = "地址";
BoundField bf10 = new BoundField(); bf10.DataField = "staff.department.departName"; bf10.HeaderText = "隶属部门";
GridView1.Columns.Add(bf1);
GridView1.Columns.Add(bf2);
GridView1.Columns.Add(bf3);
GridView1.Columns.Add(bf4);
GridView1.Columns.Add(bf5);
GridView1.Columns.Add(bf6);
GridView1.Columns.Add(bf7);
GridView1.Columns.Add(bf8);
GridView1.Columns.Add(bf9);
GridView1.Columns.Add(bf10);
ButtonField bf11 = new ButtonField(); bf11.CommandName = "editt"; bf11.Text = "编辑"; bf11.ControlStyle.BorderStyle = BorderStyle.None; bf11.ControlStyle.BackColor = System.Drawing.Color.White; bf11.ButtonType = ButtonType.Button; bf11.HeaderText = "";
ButtonField bf12 = new ButtonField(); bf12.CommandName = "deletee"; bf12.Text = "删除"; bf12.ControlStyle.BorderStyle = BorderStyle.None; bf12.ControlStyle.BackColor = System.Drawing.Color.White; bf12.ButtonType = ButtonType.Button; bf12.HeaderText = "";
GridView1.Columns.Add(bf11);
GridView1.Columns.Add(bf12);
refresh();
add.Visible = false;
update.Visible = false;
databind();
new Warehouse.Tools.AddSysLog().addlog("1", "用户管理", "查询");
}
ButtonField bf88 = GridView1.Columns[10] as ButtonField; bf88.ControlStyle.BorderStyle = BorderStyle.None; bf88.ControlStyle.BackColor = System.Drawing.Color.White;
ButtonField bf99 = GridView1.Columns[11] as ButtonField; bf99.ControlStyle.BorderStyle = BorderStyle.None; bf99.ControlStyle.BackColor = System.Drawing.Color.White;
}
public static bool in_out = true; //记录当前的是操作出库还是入库，true是入库，false是出库
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
databindOut();
databindIn();
refreAllIn();
refreAllOut();
GridView1.Visible = false;
addIn.Visible = false;
addOut.Visible = false;
}
ButtonField bfG1 = GridView1.Columns[9] as ButtonField; bfG1.ControlStyle.BorderStyle = BorderStyle.None; bfG1.ControlStyle.BackColor = System.Drawing.Color.White;
ButtonField bfG2 = GridView1.Columns[10] as ButtonField; bfG2.ControlStyle.BorderStyle = BorderStyle.None; bfG2.ControlStyle.BackColor = System.Drawing.Color.White;
ButtonField bfG3 = GridView2.Columns[8] as ButtonField; bfG3.ControlStyle.BorderStyle = BorderStyle.None; bfG3.ControlStyle.BackColor = System.Drawing.Color.White;
ButtonField bfG4 = GridView2.Columns[9] as ButtonField; bfG4.ControlStyle.BorderStyle = BorderStyle.None; bfG4.ControlStyle.BackColor = System.Drawing.Color.White;
}
protected void LoadHeader()
{
grvList.Columns.Clear();
ButtonField b = new ButtonField();
b.Text = " " + "<img border=0 align=absmiddle src=../img/unselected.gif>" + " ";
b.HeaderText = GetGlobalResourceObject("WebGlobalResource", "Select").ToString(); //选择
b.CommandName = "Select";
b.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
b.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
b.ItemStyle.Width = new Unit("30px");
grvList.Columns.Add(b);
string _sql = "select NAME,DESCR,OTHER_LANGUAGE_DESCR,CONTROL_LIST_WIDTH,CONTROL_LIST_DISPLAY_FORMAT,CONTROL_LIST_DISPLAY_ALIGN,TYPE from DMIS_SYS_COLUMNS where TABLE_ID=" + Session["MainTableId"].ToString() + " and ISDISPLAY=1 order by ORDER_ID";
DataTable _dt = DBOpt.dbHelper.GetDataTable(_sql);
for (int i = 0; i < _dt.Rows.Count; i++)
{
BoundField bf = new BoundField();
if (Session["Culture"] == null || Session["Culture"].ToString() == "zh-CN")
bf.HeaderText = _dt.Rows[i]["DESCR"] == Convert.DBNull ? "" : _dt.Rows[i]["DESCR"].ToString();
else
bf.HeaderText = _dt.Rows[i]["OTHER_LANGUAGE_DESCR"] == Convert.DBNull ? "" : _dt.Rows[i]["OTHER_LANGUAGE_DESCR"].ToString();
bf.DataField = _dt.Rows[i]["NAME"].ToString();
if (_dt.Rows[i]["CONTROL_LIST_WIDTH"] != Convert.DBNull)
bf.ItemStyle.Width = new Unit(_dt.Rows[i]["CONTROL_LIST_WIDTH"].ToString() + "px");
if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"] != Convert.DBNull && _dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"].ToString().Trim().Length > 0)
{
bf.DataFormatString = _dt.Rows[i]["CONTROL_LIST_DISPLAY_FORMAT"].ToString();
if (_dt.Rows[i]["TYPE"].ToString() == "Datetime") bf.HtmlEncode = false;
}
if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"] != Convert.DBNull)
{
if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "1")
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "0")
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "2")
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
else if (_dt.Rows[i]["CONTROL_LIST_DISPLAY_ALIGN"].ToString() == "3")
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Justify;
}
grvList.Columns.Add(bf);
}
}
private void atualizaGrelhaEmprestimos()
{
gvEmprestimos.Columns.Clear();
gvEmprestimos.DataSource = null;
gvEmprestimos.DataBind();
gvEmprestimos.PageSize = 5;
gvEmprestimos.AllowPaging = true;
DataTable dados;
if (cbEmprestimos.Checked)
{
dados = BaseDados.Instance.listaTodosEmprestimosPorConcluirComNomes();
}
else
{
dados = BaseDados.Instance.listaTodosEmprestimosComNomes();
}
if (dados == null || dados.Rows.Count == 0)
{
return;
}
//receber livro
ButtonField btReceberLivro = new ButtonField();
btReceberLivro.HeaderText = "Receber Livro";
btReceberLivro.Text = "Receber";
btReceberLivro.ButtonType = ButtonType.Button;
btReceberLivro.CommandName = "receber";
gvEmprestimos.Columns.Add(btReceberLivro);
//enviar email
ButtonField btEnviarEmail = new ButtonField();
btEnviarEmail.HeaderText = "Enviar email";
btEnviarEmail.Text = "Enviar";
btEnviarEmail.ButtonType = ButtonType.Button;
btEnviarEmail.CommandName = "enviar";
gvEmprestimos.Columns.Add(btEnviarEmail);
gvEmprestimos.DataSource = dados;
gvEmprestimos.DataBind();
}
public TranslatedButtonComponentSolver(TwitchModule module) :
base(module)
{
var component = module.BombComponent.GetComponent(ComponentType);
_button = (KMSelectable)ButtonField.GetValue(component);
ModInfo = ComponentSolverFactory.GetModuleInfo(GetModuleType(), "!{0} tap [tap the button] | !{0} hold [hold the button] | !{0} release 7 [release when the digit shows 7]").Clone();
Selectable selectable = module.BombComponent.GetComponent <Selectable>();
selectable.OnCancel += () => { SelectedField.SetValue(component, false); return(true); };
LanguageCode = TranslatedModuleHelper.GetLanguageCode(component, ComponentType);
ModInfo.moduleDisplayName = $"Big Button Translated{TranslatedModuleHelper.GetModuleDisplayNameAddon(component, ComponentType)}";
Module.HeaderText = ModInfo.moduleDisplayName;
var mat = (Material)StripMaterialField.GetValue(component);
StripMaterialField.SetValue(component, Object.Instantiate(mat));
}
public void Bind1(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf2 = new BoundField(); bf2.DataField = "roomNum"; bf2.HeaderText = "房间编号"; bf2.ReadOnly = true; bf2.SortExpression = "roomNum"; bf2.HeaderStyle.Height = Unit.Parse("40px");
BoundField bf3 = new BoundField(); bf3.DataField = "roomName"; bf3.HeaderText = "房间名称"; bf3.SortExpression = "roomName";
BoundField bf4 = new BoundField(); bf4.DataField = "M"; bf4.HeaderText = "可放面积"; bf4.SortExpression = "M";
BoundField bf5 = new BoundField(); bf5.DataField = "remark"; bf5.HeaderText = "备注"; bf5.SortExpression = "remark";
BoundField bf6 = new BoundField(); bf6.DataField = "createTime"; bf6.HeaderText = "创建时间"; bf6.SortExpression = "createTime"; bf6.DataFormatString = "{0:d}";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "编辑"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = "";
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = "";
G1.Columns.Add(bf1);
G1.Columns.Add(bf2);
G1.Columns.Add(bf3);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf6);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
public void Bind1(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf4 = new BoundField(); bf4.DataField = "goodsNum"; bf4.HeaderText = "物品编号"; bf4.SortExpression = "goodsNum";
BoundField bf5 = new BoundField(); bf5.DataField = "positionNum"; bf5.HeaderText = "库位编号"; bf5.SortExpression = "positionNum";
BoundField bf6 = new BoundField(); bf6.DataField = "amount"; bf6.HeaderText = "存量"; bf6.SortExpression = "amount";
BoundField bf7 = new BoundField(); bf7.DataField = "per"; bf7.HeaderText = "单位"; bf7.SortExpression = "per";
BoundField bf77 = new BoundField(); bf77.DataField = "V"; bf77.HeaderText = "体积"; bf77.SortExpression = "V";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "出库"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = "";
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = "";
G1.Columns.Add(bf1);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf6);
G1.Columns.Add(bf7);
G1.Columns.Add(bf77);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
private void AddExtraCommandColumns()
{
if (!string.IsNullOrEmpty(PermissionUrl))
{
HyperLinkField permissionfield = new HyperLinkField();
permissionfield.Text = Resources.GlobalResource.ButtonPermisstionText;
permissionfield.DataNavigateUrlFormatString = PermissionUrl;
permissionfield.DataNavigateUrlFields = new string[] { _idColumn };
permissionfield.ItemStyle.Width = 80;
this.Columns.Add(permissionfield);
}
else
{
ButtonField field = new ButtonField();
field.HeaderText = Resources.GlobalResource.ButtonPermisstionText;
field.Text = Resources.GlobalResource.ButtonPermisstionText;
field.ButtonType = ButtonType.Link;
this.Columns.Add(field);
}
}
public void CreateUI()
{
firstNameField = manager.CreateInputField("FirstName", new CursorPosition(2, 2), 10, InputType.StringNoNumbersNoSpecialCharacters, false);
ageField = manager.CreateInputField("Age", new CursorPosition(20, 2), 3, InputType.Integer, false);
firstNameField.Label = "First name";
ageField.Label = "Age";
ElementDecorators decors = new ElementDecorators(null, null, '[', ']');
manager.AddDecors(decors, firstNameField, ageField);
ButtonField sendButton = manager.CreateButtonField("sendButton", new CursorPosition(13, 5), "Send");
manager.CreateNavigationStateTransition(firstNameField, ConsoleKey.RightArrow, ageField, true);
manager.CreateNavigationStateTransition(firstNameField, ConsoleKey.DownArrow, sendButton, true);
manager.CreateNavigationStateTransition(ageField, ConsoleKey.DownArrow, sendButton, false);
manager.CreateActionStateTransition(sendButton, ConsoleKey.Enter, SendMessage);
manager.SetCursorToUIElement(firstNameField);
manager.Init();
}
private void atualizaGrelhaDevolve()
{
gvDevolver.Columns.Clear();
gvDevolver.DataSource = null;
gvDevolver.DataBind();
int idUtilizador = int.Parse(Session["id"].ToString());
gvDevolver.DataSource = BaseDados.Instance.listaTodosEmprestimosPorConcluirComNomes(idUtilizador);
//botão devolver
ButtonField btDevolver = new ButtonField();
btDevolver.HeaderText = "Devolver";
btDevolver.Text = "Devolver";
btDevolver.CommandName = "devolver";
btDevolver.ButtonType = ButtonType.Button;
gvDevolver.Columns.Add(btDevolver);
gvDevolver.DataBind();
}
private void SetDataGridColumn()
{
GridView1.Columns.Clear();
ButtonField lnkField = new ButtonField();
lnkField.ButtonType = ButtonType.Link;
lnkField.HeaderText = "标题";
lnkField.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
lnkField.HeaderStyle.Font.Bold = false;
lnkField.DataTextField = "Title";
lnkField.ItemStyle.Wrap = true;
lnkField.CommandName = "ShowDetails";
GridView1.Columns.Add(lnkField);
BoundField bindCol = new BoundField();
if (ShowAdditionFields.Length > 0)
{
string[] addFields = showAdditionFields.Split(';');
foreach (string showName in addFields)
{
string[] interNames = GetInterNameByShowName(showName);
if (interNames.Length > 1)
{
bindCol = new BoundField();
bindCol.ReadOnly = true;
bindCol.HeaderText = interNames[1];
bindCol.DataField = interNames[0];
bindCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
bindCol.HeaderStyle.Font.Bold = false;
if (showName == "创建时间")
{
bindCol.DataFormatString = "{0:yyyy-MM-dd HH:mm}";
}
GridView1.Columns.Add(bindCol);
}
}
}
GridView1.DataKeyNames = new string[] { "ID" };
}
private void AtualizarGrid()
{
gvLivros.Columns.Clear();
gvLivros.DataSource = null;
gvLivros.DataBind();
Livro livro = new Livro();
gvLivros.DataSource = livro.listaLivrosDisponiveis();
//botão reservar
ButtonField btReservar = new ButtonField();
btReservar.HeaderText = "Reservar livro";
btReservar.Text = "Reservar";
btReservar.ButtonType = ButtonType.Button;
btReservar.CommandName = "reservar";
btReservar.ControlStyle.CssClass = "btn btn-danger";
gvLivros.Columns.Add(btReservar);
gvLivros.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Panel1.Visible = false;
Panel2.Visible = false;
if (!IsPostBack)
{
ButtonField bf1 = new ButtonField();
bf1.Text = "Select";
bf1.CommandName = "Select_Data";
ButtonField bf2 = new ButtonField();
bf2.Text = "Update";
bf2.CommandName = "Update_Data";
ButtonField bf3 = new ButtonField();
bf3.Text = "Delete";
bf3.CommandName = "Delete_Data";
GridView1.Columns.Add(bf1);
GridView1.Columns.Add(bf2);
GridView1.Columns.Add(bf3);
}
Show_Data();
}
public void Bind1(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf2 = new BoundField(); bf2.DataField = "positionTypeId"; bf2.HeaderText = "库位类型编号"; bf2.ReadOnly = true; bf2.SortExpression = "positionTypeId"; bf2.HeaderStyle.Height = Unit.Parse("40px");
BoundField bf3 = new BoundField(); bf3.DataField = "positionTypeName"; bf3.HeaderText = "库柜类型名称"; bf3.SortExpression = "positionTypeName";
BoundField bf4 = new BoundField(); bf4.DataField = "length"; bf4.HeaderText = "长度/cm"; bf4.SortExpression = "length";
BoundField bf5 = new BoundField(); bf5.DataField = "width"; bf5.HeaderText = "宽度/cm"; bf5.SortExpression = "width";
BoundField bf6 = new BoundField(); bf6.DataField = "height"; bf6.HeaderText = "高度/cm"; bf6.SortExpression = "height";
BoundField bf7 = new BoundField(); bf7.DataField = "remark"; bf7.HeaderText = "备注"; bf7.SortExpression = "remark";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "编辑"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = ""; bf8.ControlStyle.Width = Unit.Parse("60px"); bf8.ControlStyle.Font.Size = FontUnit.Parse("17px");
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = ""; bf9.ControlStyle.Width = Unit.Parse("60px"); bf9.ControlStyle.Font.Size = FontUnit.Parse("17px");
G1.Columns.Add(bf1);
G1.Columns.Add(bf2);
G1.Columns.Add(bf3);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf6);
G1.Columns.Add(bf7);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
public void Bind3(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf44 = new BoundField(); bf44.DataField = "goodsTypeNum"; bf44.HeaderText = "物品类别编号"; bf44.SortExpression = "goodsTypeNum";
BoundField bf4 = new BoundField(); bf4.DataField = "goodsTypeName"; bf4.HeaderText = "物品类别名称"; bf4.SortExpression = "goodsTypeName";
BoundField bf5 = new BoundField(); bf5.DataField = "amount"; bf5.HeaderText = "物品数量"; bf5.SortExpression = "amount";
BoundField bf55 = new BoundField(); bf55.DataField = "per"; bf55.HeaderText = "物品单位"; bf55.SortExpression = "per";
BoundField bf10 = new BoundField(); bf10.DataField = "max"; bf10.HeaderText = "库存上限"; bf10.SortExpression = "max";
BoundField bf6 = new BoundField(); bf6.DataField = "rest"; bf6.HeaderText = "库存差额"; bf6.SortExpression = "rest";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "编辑"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = "";
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = "";
G1.Columns.Add(bf1);
G1.Columns.Add(bf44);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf10);
G1.Columns.Add(bf6);
G1.Columns.Add(bf55);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
protected void build()
{
//**设置主键
GridView1.DataKeyNames = new string[] { Convert.ToString("mainKey") };
//**设置数据列
BoundField bf = new BoundField();
bf.DataField = "fieldName";
bf.SortExpression = "fieldName";
bf.HeaderText = "fieldCN";
bf.HeaderStyle.Width = new Unit("100%");
bf.ReadOnly = true;
GridView1.Columns.Add(bf);
//设置按钮
ButtonField btnf = new ButtonField();
btnf.CommandName = "download"; btnf.Text = "下载"; btnf.ButtonType = ButtonType.Button;
btnf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
btnf.ItemStyle.VerticalAlign = VerticalAlign.Middle;
btnf.ItemStyle.Width = new Unit("40px");
GridView1.Columns.Add(btnf);
}
private void AtualizaGrelhaUtilizadores()
{
gvUtilizadores.Columns.Clear();
gvUtilizadores.DataSource = null;
gvUtilizadores.DataBind();
DataTable dados = BaseDados.Instance.ListaUtilizadoresDisponiveis();
if (dados == null || dados.Rows.Count == 0)
{
return;
}
gvUtilizadores.DataSource = dados;
gvUtilizadores.AutoGenerateColumns = true;
gvUtilizadores.AutoGenerateEditButton = true;
gvUtilizadores.AutoGenerateDeleteButton = true;
//coluna para ativar/desativar
ButtonField btEstado = new ButtonField();
btEstado.HeaderText = "Ativar/Desativar";
btEstado.Text = "Ativar/Desativar";
btEstado.ButtonType = ButtonType.Button;
btEstado.CommandName = "estado";
gvUtilizadores.Columns.Add(btEstado);
//coluna para ver histórico
ButtonField btHistorico = new ButtonField();
btHistorico.HeaderText = "Histórico";
btHistorico.Text = "Histórico";
btHistorico.ButtonType = ButtonType.Button;
btHistorico.CommandName = "histórico";
gvUtilizadores.Columns.Add(btHistorico);
gvUtilizadores.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Debugger.Break();
}
else
{
Debugger.Break();
}
DataTable oDataTable = new DataTable();
oDataTable.Columns.Add("animal");
DataRow oDataRow = oDataTable.NewRow();
oDataRow["animal"] = "cat";
oDataTable.Rows.Add(oDataRow);
GridView1.Columns.Clear();
ButtonField cf = new ButtonField();
cf.HeaderStyle.CssClass = "comGridHeadCell";
cf.HeaderText = "some text";
cf.HeaderImageUrl = "images/something.png";
cf.Text = "action";
cf.CommandName = "action";
cf.ImageUrl = "images/something.png";
cf.ButtonType = ButtonType.Image;
cf.ItemStyle.CssClass = "comGridLink";
GridView1.Columns.Add(cf);
GridView1.DataSource = oDataTable;
GridView1.DataBind();
}
public void Bind1(GridView G1)
{
BoundField bf1 = new BoundField(); bf1.HeaderText = "序号"; bf1.DataField = "num";
BoundField bf2 = new BoundField(); bf2.DataField = "goodsNum"; bf2.HeaderText = "物品编号"; bf2.ReadOnly = true; bf2.SortExpression = "goodsNum"; bf2.HeaderStyle.Height = Unit.Parse("40px");
BoundField bf3 = new BoundField(); bf3.DataField = "goodsName"; bf3.HeaderText = "物品名称"; bf3.SortExpression = "goodsName";
BoundField bf4 = new BoundField(); bf4.DataField = "per"; bf4.HeaderText = "称重单位"; bf4.SortExpression = "per";
BoundField bf5 = new BoundField(); bf5.DataField = "goodsStyle"; bf5.HeaderText = "物品规格"; bf5.SortExpression = "goodsStyle";
BoundField bf10 = new BoundField(); bf10.DataField = "goodsColor"; bf10.HeaderText = "物品颜色"; bf10.SortExpression = "goodsColor";
BoundField bf6 = new BoundField(); bf6.DataField = "condition"; bf6.HeaderText = "物品状态"; bf6.SortExpression = "condition";
ButtonField bf8 = new ButtonField(); bf8.CommandName = "editt"; bf8.Text = "编辑"; bf8.ControlStyle.BorderStyle = BorderStyle.None; bf8.ControlStyle.BackColor = System.Drawing.Color.White; bf8.ButtonType = ButtonType.Button; bf8.HeaderText = "";
ButtonField bf9 = new ButtonField(); bf9.CommandName = "deletee"; bf9.Text = "删除"; bf9.ControlStyle.BorderStyle = BorderStyle.None; bf9.ControlStyle.BackColor = System.Drawing.Color.White; bf9.ButtonType = ButtonType.Button; bf9.HeaderText = "";
BoundField bf77 = new BoundField(); bf77.DataField = "max"; bf77.HeaderText = "最大存量"; bf77.SortExpression = "max";
G1.Columns.Add(bf1);
G1.Columns.Add(bf2);
G1.Columns.Add(bf3);
G1.Columns.Add(bf4);
G1.Columns.Add(bf5);
G1.Columns.Add(bf10);
G1.Columns.Add(bf6);
G1.Columns.Add(bf77);
G1.Columns.Add(bf8);
G1.Columns.Add(bf9);
}
public void ShowData(string str)
{
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
UserModel model = (UserModel)this.Session["User"];
DataSet ds = this.pagesize.pagesize("*", "v_pd_project_publicExcel_list", " where (所属单位 like '" + model.Company.pk_corp.Trim() + "%' and 所属部门 like '" + model.Branch.BH.Trim() + "%') or (所属单位 like '" + model.Company.pk_corp.Trim() + "%' and 所属部门 is null) or (所属单位 is null and 所属部门 is null)", "AUTO_ID", " order by AUTO_ID desc ", this.Master.PageIndex, this.Master.PageSize, out this.count);
this.Master.RecordCount = Convert.ToInt32(this.count);
if (this.gvResult.Columns.Count == 0)
{
PublicDal.setGViewColumns(ds, this.gvResult);
ButtonField field = new ButtonField
{
HeaderText = "操作",
Text = "导出模板"
};
field.HeaderStyle.Width = Unit.Parse("80");
this.gvResult.Columns.Add(field);
field = new ButtonField
{
HeaderText = "操作",
Text = "导入数据"
};
field.HeaderStyle.Width = Unit.Parse("80");
this.gvResult.Columns.Add(field);
}
if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
{
DataView defaultView = ds.Tables[0].DefaultView;
if ((this.ViewState["SortOrder"] != null) && (this.ViewState["OrderDire"] != null))
{
string str2 = ((string)this.ViewState["SortOrder"]) + " " + ((string)this.ViewState["OrderDire"]);
defaultView.Sort = str2;
}
this.gvResult.DataSource = defaultView;
this.gvResult.DataBind();
}
else
{
DataTable table = new DataTable();
table = ds.Tables[0];
DataRow row = table.NewRow();
table.Rows.Add(row);
this.gvResult.DataSource = table.DefaultView;
this.gvResult.DataBind();
}
}
catch (Exception exception)
{
this.el = new ExceptionLog.ExceptionLog();
this.el.ErrClassName = base.GetType().ToString();
this.el.ErrMessage = exception.Message.ToString();
this.el.ErrMethod = "ShowData()";
this.el.WriteExceptionLog(true);
Const.OpenErrorPage("获取数据失败，请联系系统管理员！", this.Page);
}
finally
{
if (this.dbo != null)
{
this.dbo.Close();
}
}
}
//Method for handling the button click event on the row.
//Gets the UVUInvID from the selected row and uses that as the filter for the SQL update query
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string eventString = e.CommandName.ToString();
if (e.CommandName == "InventoryCheck")
{
//Instantiate new instance of SQL database connection
TechInventoryDataContext db = new TechInventoryDataContext();
//Convert command argument from button to string
string uvuInvID = Convert.ToString(e.CommandArgument);
ButtonField b = new ButtonField();
//Get current datetime value and convert to string
DateTime now = DateTime.Now;
string date = now.ToShortDateString();
//Linq query for a single UVUInventory record
var query = (from equip in db.Equipments
where equip.UVUInvID == uvuInvID
select equip).Single();
//Set the InvCheck value for the queried record to current datetime
query.InvCheck = now;
//Try/Catch to submit changes to the database
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (InRowChangingEventException)
{
// Resolve conflicts.
//db.ChangeConflicts.ResolveAll();
}
//Rebind data in gridview. Updated datetime value should be visible in grid.
GridView1.DataBind();
ViewState.Clear();
}
}
protected void DataBind1()
{
int ClassId = Convert.ToInt16(ddlClass.SelectedValue);
int SectionId = Convert.ToInt16(ddlSection.SelectedValue);
int YearId = Convert.ToInt16(ddlYear.SelectedValue);
Hashtable Htp = new Hashtable();
Htp.Add(0, "Period");
Htp.Add(1, "I");
Htp.Add(2, "II");
Htp.Add(3, "III");
Htp.Add(4, "IV");
Htp.Add(5, "V");
Htp.Add(6, "VI");
Htp.Add(7, "VII");
Htp.Add(8, "VIII");
Htp.Add(9, "IX");
Htp.Add(10, "X");
Htp.Add(11, "XI");
Htp.Add(12, "XII");
if ((ClassId != 0) && (SectionId != 0) && (YearId!=0))
{
DataSet ds1 = new DataSet();
ds1 = ObjStaff.GetTimetableClasswise(Convert.ToInt16(ddlClass.SelectedValue.ToString()), Convert.ToInt16(ddlSection.SelectedValue.ToString()),Convert.ToInt16(ddlYear.SelectedValue) );
if (ds1.Tables.Count > 0)
{
GvPanel.Visible = true;
//lblText.Visible = false;
DataView dv1 = new DataView(ds1.Tables[0]);
DataTable dt = new DataTable();
for (int colCnt = 0; colCnt <=Convert.ToInt16( ViewState["Cols"]); colCnt++)
{
DataColumn dc = new DataColumn();
if (colCnt == 0)
{
dc.ColumnName = "Days";
dt.Columns.Add(dc);
}
else
{
dc.ColumnName = "Period" + colCnt.ToString();
dt.Columns.Add(dc);
}
}
int k = 1;
for (int j = 1; j <= Convert.ToInt16(ViewState["Rows"]); j++)
{
dv1.RowFilter = "DayId =" + j.ToString();
DataRow dr = dt.NewRow();
if (dv1.Count > 0)
{
dr["Days"] = dv1[0][2];
for (int i = 0; i < dv1.Count; i++)
{
k = i + 1;
for (int b = 1; b < Htp.Count; b++)
{
if (Htp[b].ToString() == dv1[i]["Period"].ToString())
{
dr["Period" + b] = dv1[i]["TeacherId"].ToString();
}
}
//dr["Period" + k] = dv1[i][4].ToString();
}
dt.Rows.Add(dr);
}
}
GridView1.Columns.Clear();
BoundField bfield = new BoundField();
bfield.DataField = "Days";
bfield.HeaderText = "Days";
bfield.ControlStyle.CssClass = "gridviewheader";
GridView1.Columns.Add(bfield);
for (int colCnt = 1; colCnt <= Convert.ToInt16(ViewState["Cols"]); colCnt++)
{
TemplateField tf = new TemplateField();
MyTemplate ta = new MyTemplate("Period" + colCnt.ToString());
tf.HeaderText = "Period" + colCnt.ToString();
tf.ItemTemplate = ta;
GridView1.Columns.Add(tf);
GridView1.DataSource = dt;
GridView1.DataBind();
}
ButtonField btfiled = new ButtonField();
btfiled.ButtonType = ButtonType.Button;
btfiled.Text = "Edit";
btfiled.HeaderText = "Edit";
btfiled.CommandName = "Editing";
GridView1.Columns.Add(btfiled);
GridView1.DataSource = dt;
GridView1.DataBind();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
for (int j = 1; j <= Convert.ToInt16(ViewState["Cols"]); j++)
{
DropDownList ddl = (DropDownList)GridView1.Rows[i].Cells[j].FindControl("ddlPeriod" + j); ;
ddl.Items.Insert(0, new ListItem("---Select---", "0"));
ddl.SelectedValue = dt.Rows[i][j].ToString();
//ddl.Enabled = false;
}
}
datafiled();
//GridView1.DataSource = dt;
//GridView1.DataBind();
//string str = "<center><div><table border='2'><tr><td></td><td>I</td><td>II</td><td>III</td><td>IV</td><td>V</td><td>VI</td><td>VII</td><td>VIII</td></tr>";
//for (int j = 1; j <= 6; j++)
//{
// dv1.RowFilter = "DayId =" + j.ToString();
// if (dv1.Count > 0)
// {
// str += "<tr><td>" + dv1[0][2].ToString() + "</td>";
// for (int i = 0; i < dv1.Count; i++)
// {
// str += "<td>" + dv1[i][5].ToString() + "</td>";
// }
// str += "</tr>";
// }
//}
//str += "</table></div></center>";
//Divtag.InnerHtml = str;
// liTabl.Text = str;
}
else
{
GvPanel.Visible = false;
lblText.Visible = true;
lblText.Text = "Data is not aviable";
lblText.Font.Bold = true;
//Divtag.InnerHtml = "Data is not aviable";
}
}
}
protected void cmdStartSearch_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DBconnector.Connector.EmployeeType empType = Connector.EmployeeType.All;
Connector.RecordType recType = Connector.RecordType.All;
if (ddlEmployeeType.SelectedIndex == 1)
{
empType = Connector.EmployeeType.Contract;
}
else if (ddlEmployeeType.SelectedIndex == 2)
{
empType = Connector.EmployeeType.FullTime;
}
else if (ddlEmployeeType.SelectedIndex == 3)
{
empType = Connector.EmployeeType.PartTime;
}
else if (ddlEmployeeType.SelectedIndex == 4)
{
empType = Connector.EmployeeType.Seasonal;
}
else if (ddlEmployeeType.SelectedIndex == 0)
{
empType = Connector.EmployeeType.All;
}
if (DropDownListRecordType.SelectedIndex == 1)
{
recType = Connector.RecordType.Active;
}
else if (DropDownListRecordType.SelectedIndex == 2)
{
recType = Connector.RecordType.Incomplete;
}
else if (DropDownListRecordType.SelectedIndex == 3)
{
recType = Connector.RecordType.Inactive;
}
else if (DropDownListRecordType.SelectedIndex == 0)
{
recType = Connector.RecordType.All;
}
if (empType == Connector.EmployeeType.All)
{
this.conn.GetEmployeesAll(recType, TextBoxSIN.Text, TextBoxFirst.Text, TextBoxLast.Text, dt);
}
else
{
this.conn.GetEmployees(empType, recType, TextBoxSIN.Text, TextBoxFirst.Text, TextBoxLast.Text, dt);
}
GridViewData.Columns.Clear();
GridViewData.DataSource = dt;
if (recType == Connector.RecordType.Incomplete || recType == Connector.RecordType.Active)
{
ButtonField button = new ButtonField();
button.Text = "Modify";
button.ButtonType = ButtonType.Button;
button.CommandName = "clicked";
GridViewData.Columns.Add(button);
}
GridViewData.DataBind();
Session["data"] = dt;
}
private void RefreshGridView()
{
itemGridView.AutoGenerateColumns = false;
itemGridView.Columns.Clear();
fieldMaxLength.Clear();
SetItemFields(); // 调用子类的方法
itemGridView.DataSource = GetItemSource(page * pageSize+1, (page + 1) * pageSize);
//获取是否要显示删除按钮
if (HasDeleteField())
{
ButtonField deleteField = new ButtonField();
deleteField.HeaderText = "删除";
deleteField.Text = "删除";
deleteField.CommandName = "Delete";
deleteField.ButtonType = ButtonType.Link;
itemGridView.Columns.Add(deleteField);
deleteFieldIndex = itemGridView.Columns.IndexOf(deleteField);
}
itemGridView.DataBind();
}
