/// <summary>
/// Load options definition.
/// </summary>
/// <param name="options">Options configuration</param>
/// <param name="filterTable">Table for filter</param>
private void LoadOptionsDefinition(UniGridOptions options, Table filterTable)
{
// Create filter table according to the key value "DisplayFilter"
displayFilter = options.DisplayFilter;
if (displayFilter)
{
filter.Controls.Add(filterTable);
}
// Filter limit
if (options.FilterLimit > -1)
{
FilterLimit = options.FilterLimit;
}
// Display sort direction images
showSortDirection = options.ShowSortDirection;
// Display selection column with checkboxes
showSelection = options.ShowSelection;
if (showSelection)
{
TemplateField chkColumn = new TemplateField();
using (CheckBox headerBox = new CheckBox { ID = "headerBox" })
{
using (CheckBox itemBox = new CheckBox { ID = "itemBox" })
{
// Set selection argument
itemBox.Attributes["selectioncolumn"] = options.SelectionColumn;
chkColumn.HeaderTemplate = new GridViewTemplate(ListItemType.Header, this, headerBox);
chkColumn.ItemTemplate = new GridViewTemplate(ListItemType.Item, this, itemBox);
}
}
UniGridView.Columns.Add(chkColumn);
}
// Get pagesize options
if (!String.IsNullOrEmpty(options.PageSize))
{
Pager.PageSizeOptions = options.PageSize;
}
// Set pagging acording to the key value "DisplayPageSizeDropdown"
if (options.DisplayPageSizeDropdown != null)
{
Pager.ShowPageSize = options.DisplayPageSizeDropdown.Value;
}
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
// Initialize strings
btnAllTasks.Text = GetString("ImportExport.All");
btnNoneTasks.Text = GetString("export.none");
lblTasks.Text = GetString("Export.Tasks");
// Get object info
GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType);
if (info != null)
{
gvTasks.RowDataBound += gvTasks_RowDataBound;
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Task fields
TemplateField taskCheckBoxField = (TemplateField)gvTasks.Columns[0];
taskCheckBoxField.HeaderText = GetString("General.Export");
TemplateField titleField = (TemplateField)gvTasks.Columns[1];
titleField.HeaderText = GetString("Export.TaskTitle");
BoundField typeField = (BoundField)gvTasks.Columns[2];
typeField.HeaderText = GetString("general.type");
BoundField timeField = (BoundField)gvTasks.Columns[3];
timeField.HeaderText = GetString("Export.TaskTime");
// Load tasks
int siteId = (SiteObject ? Settings.SiteId : 0);
DataSet ds = ExportTaskInfoProvider.SelectTaskList(siteId, ObjectType, null, "TaskTime DESC", 0, null, CurrentOffset, CurrentPageSize, ref pagerForceNumberOfResults);
// Set correct ID for direct page contol
pagerElem.DirectPageControlID = ((float)pagerForceNumberOfResults / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
if (!DataHelper.DataSourceIsEmpty(ds) && (ValidationHelper.GetBoolean(Settings.GetSettings(ImportExportHelper.SETTINGS_TASKS), true)))
{
plcTasks.Visible = true;
gvTasks.DataSource = ds;
gvTasks.DataBind();
}
else
{
plcTasks.Visible = false;
}
}
else
{
plcGrid.Visible = false;
}
}
else
{
pnlGrid.Visible = false;
}
}
private bool InitInfoList(List<String[]> list)
{
//办理历史列表
DataTable dtHistory = ReadGridView();
DataTable dt = ReadGridView();
int dtI = 0;
int dtHistoryI = 0;
for (int i = 0; i < list.Count; ++i)
{
if (list[i][5] != "已办理")
{
DataRow row = dt.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dt.Rows.InsertAt(row, dtI++);
}
else
{
DataRow row = dtHistory.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dtHistory.Rows.InsertAt(row, dtHistoryI++);
}
}
dt.AcceptChanges();
carFinesInfoList.DataSource = dt;
carFinesInfoList.AllowPaging = true;
carFinesInfoList.PageSize = 5;
carFinesInfoList.EnableSortingAndPagingCallbacks = false;
carFinesInfoList.DataBind();
/*
HyperLinkField hyperLinkField = new HyperLinkField();
hyperLinkField.HeaderText = "处理情况";
carFinesInfoList.Columns.Add(hyperLinkField);
hyperLinkField.Text = "去处理";
hyperLinkField.NavigateUrl = "PayFinesWeb.aspx";
carFinesInfoList.DataBind();
*/
TemplateField tf = new TemplateField();
tf.ItemTemplate = new HandleFinesLinkHyTem();
tf.HeaderText = "处理情况";
carFinesInfoList.Columns.Add(tf);
carFinesInfoList.RowCommand += new GridViewCommandEventHandler(rowCommandEevnt);
carFinesInfoList.DataBind();
dtHistory.AcceptChanges();
historyFinesInfoList.DataSource = dtHistory;
historyFinesInfoList.DataBind();
return true;
}
private static HotspotInfo CreateVariableNameHotspot(
[NotNull] IDeclarationStatement current,
[NotNull] IInvocationExpression nextInvocation,
[NotNull] IList<string> nameSuggestions)
{
var name = current.VariableDeclarations[0].DeclaredName;
var templateField = new TemplateField(name, new NameSuggestionsExpression(nameSuggestions), 0);
var first = current.VariableDeclarations[0].GetNameDocumentRange();
var second = ((IReferenceExpression) nextInvocation.InvokedExpression).QualifierExpression.GetDocumentRange();
return new HotspotInfo(templateField, first, second);
}
protected override void AfterCompletion(
ITextControl textControl, ISolution solution, Suffix suffix,
TextRange resultRange, string targetText, int caretOffset)
{
var placeholders = new List<TextRange>();
for (var index = 0;; index++)
{
index = targetText.IndexOf(NamePlaceholder, index, StringComparison.Ordinal);
if (index == -1) break;
var range = new TextRange(resultRange.StartOffset + index);
placeholders.Add(range.ExtendRight(NamePlaceholder.Length));
}
if (placeholders.Count == 0)
{
base.AfterCompletion(textControl, solution, suffix, resultRange, targetText, caretOffset);
}
else
{
var nameField = new TemplateField("name", new NameSuggestionsExpression(myNames), 0);
var hotspotInfo = new HotspotInfo(nameField, placeholders);
var endRange = new TextRange(resultRange.StartOffset + caretOffset);
var session = LiveTemplatesManager.Instance.CreateHotspotSessionAtopExistingText(
mySolution, endRange, textControl, LiveTemplatesManager.EscapeAction.LeaveTextAndCaret, hotspotInfo);
if (!suffix.IsEmpty)
{
session.HotspotUpdated += delegate
{
if (session.IsFinished)
suffix.Playback(textControl);
};
}
session.Execute();
}
}
private void InitializeCustomControls()
{
InitToolBar();
btnOK = GetControltByMaster("btnOK") as Button;
btnOK.Click += new EventHandler(btnOK_Click);
btnOK.OnClientClick = "return confirm('请确认所有维修和质检任务都已发出！')";
//初始化维修保养表
this.spgvRepair = new SPGridView();
this.spgvRepair.AutoGenerateColumns = false;
this.spgvRepair.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
BoundField bfColumn;
foreach (var kvp in ShowRepairTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvRepair.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfChooseRepair = new TemplateField();
tfChooseRepair.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinRepairPlanID");
tfChooseRepair.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvRepair.Columns.Insert(0, tfChooseRepair);
SPMenuField colRepairMenu = new SPMenuField();
colRepairMenu.HeaderText = "维修保养计划表编号";
colRepairMenu.TextFields = "SrinRepairPlanCode";
colRepairMenu.MenuTemplateId = "mtRepair";
colRepairMenu.NavigateUrlFields = "SrinRepairPlanID"; //定义方式:"列名1,列名2..."
colRepairMenu.NavigateUrlFormat = "ManageRepairOrVerifyDetails.aspx?FormID={0}&Type=维修保养";
colRepairMenu.TokenNameAndValueFields = "curID=SrinRepairPlanID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate mtRepair = new MenuTemplate();
mtRepair.ID = "mtRepair";
MenuItemTemplate mitMaterial = new MenuItemTemplate("物资组长审核", "/_layouts/images/newitem.gif");
mitMaterial.ClientOnClickNavigateUrl = string.Format("SrinDispatchCenter.aspx?TaskType=维修保养物资组长审核&TaskID={0}&FormID=%curID%", _taskid);
mtRepair.Controls.Add(mitMaterial);
this.Controls.Add(mtRepair);
this.spgvRepair.Columns.Insert(1, colRepairMenu);
//初始化回收检验表
this.spgvVerify = new SPGridView();
this.spgvVerify.AutoGenerateColumns = false;
this.spgvVerify.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
foreach (var kvp in ShowVerifyTList)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvVerify.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfChooseVerify = new TemplateField();
tfChooseVerify.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinVerifyTransferID");
tfChooseVerify.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvVerify.Columns.Insert(0, tfChooseVerify);
SPMenuField colVerifyMenu = new SPMenuField();
colVerifyMenu.HeaderText = "回收检验传递表编号";
colVerifyMenu.TextFields = "SrinVerifyTransferCode";
colVerifyMenu.MenuTemplateId = "mtVerify";
colVerifyMenu.NavigateUrlFields = "SrinVerifyTransferID"; //定义方式:"列名1,列名2..."
colVerifyMenu.NavigateUrlFormat = "ManageRepairOrVerifyDetails.aspx?FormID={0}&Type=回收检验";
colVerifyMenu.TokenNameAndValueFields = "curID=SrinVerifyTransferID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate mtVerify = new MenuTemplate();
mtVerify.ID = "mtVerify";
MenuItemTemplate mitVerify = new MenuItemTemplate("提交生产组", "/_layouts/images/newitem.gif");
mitVerify.ClientOnClickNavigateUrl = string.Format("SrinDispatchCenter.aspx?TaskType=生产组安排质检&TaskID={0}&FormID=%curID%", _taskid);
mtVerify.Controls.Add(mitVerify);
this.Controls.Add(mtVerify);
this.spgvVerify.Columns.Insert(1, colVerifyMenu);
//添加任务详情列
HyperLinkField hlfVerifyTask = new HyperLinkField();
hlfVerifyTask.HeaderText = "任务详情";
this.spgvVerify.Columns.Insert(7, hlfVerifyTask);
this.spgvVerify.RowDataBound += new GridViewRowEventHandler(spgvVerify_RowDataBound);
}
private void BindGvList()
{
gvList.Columns.Clear();
string strwhere = "isshow=True and formID=" + dropTable.SelectedValue;
DataSet ds=BLL.DataBaseHelper.instance.GetList("FormParas", "*", 0, strwhere, "listpx,id");
string rows="";
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//添加自增列
if (chkAutoColumn.Checked)
{
TemplateField f = new TemplateField();
gvList.Columns.Add(new TemplateField());
}
tablename=ds.Tables[0].Rows[0]["tablename"].ToString();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var row = ds.Tables[0].Rows[i];
rows+=row["columnname"].ToString()+",";
BoundField filed = new BoundField();
filed.DataField = row["columnname"].ToString();
filed.HeaderText = row["cname"].ToString();
var listwidth = row["listwidth"].ToString();
int listw=0;
int.TryParse(listwidth,out listw);
if(listw>0)
{
filed.ItemStyle.Width = Unit.Pixel(listw);
}
gvList.Columns.Add(filed);
}
if(rows.Length>0)
rows=rows.Remove(rows.Length-1,1);
//string sql = string.Format("select {0} from {1}", rows, tablename);
int psize = 0;
int.TryParse(txtPageSize.Text.Trim(), out psize);
if (psize == 0)
gvList.AllowPaging = false;
else
{
gvList.AllowPaging = true;
gvList.PageSize = psize;
}
if(chkEdit.Checked || chkDelete.Checked)
{
CommandField colfiled = new CommandField();
colfiled.ItemStyle.Width = Unit.Pixel(100);
colfiled.ShowEditButton = chkEdit.Checked;
colfiled.ShowDeleteButton = chkDelete.Checked;
gvList.Columns.Add(colfiled);
}
gvList.DataSource = BLL.DataBaseHelper.instance.GetList(tablename, rows, 0, "", "");
gvList.DataBind();
//gvList.Columns[0].HeaderText = "我是你的";
//gvList.AutoGenerateColumns = false;
}
//gvList.DataSource =
//gvList.DataBind();
}
protected void DetailsView1_DataBinding(object sender, EventArgs e)
{
if (Request.QueryString["menu"] == "5")
{
TemplateField lbtn = DetailsView5.Fields[2] as TemplateField;
if (Session["acessos"].ToString().Substring(17, 1) == "0")
{
lbtn.InsertVisible = false;
}
else
{
lbtn.InsertVisible = true;
}
}
if (Request.QueryString["menu"] == "4")
{
TemplateField lbtn = DetailsView2.Fields[1] as TemplateField;
if (Session["acessos"].ToString().Substring(14, 1) == "0")
{
lbtn.InsertVisible = false;
}
else
{
lbtn.InsertVisible = true;
}
}
if (Request.QueryString["menu"] == "3")
{
TemplateField lbtn = DetailsView1.Fields[1] as TemplateField;
if (Session["acessos"].ToString().Substring(20, 1) == "0")
{
lbtn.InsertVisible = false;
}
else
{
lbtn.InsertVisible = true;
}
}
if (Request.QueryString["menu"] == "2")
{
TemplateField lbtn = DetailsView3.Fields[1] as TemplateField;
if (Session["acessos"].ToString().Substring(6, 1) == "0")
{
lbtn.InsertVisible = false;
}
else
{
lbtn.InsertVisible = true;
}
}
if (Request.QueryString["menu"] == "1")
{
TemplateField lbtn = DetailsView4.Fields[3] as TemplateField;
if (Session["acessos"].ToString().Substring(3, 1) == "0")
{
lbtn.InsertVisible = false;
}
else
{
lbtn.InsertVisible = true;
}
}
}
public void BuildDataGrid()
{
try
{
//int row, col;
//row = Convert.ToInt16(TextBox1.Text);
//col = Convert.ToInt16(TextBox2.Text);
Gv.Columns.Clear();
Hashtable Ht = new Hashtable();
Ht.Add(0, "Days");
Ht.Add(1, "Monday");
Ht.Add(2, "Tuesday");
Ht.Add(3, "Wensday");
Ht.Add(4, "Thursday");
Ht.Add(5, "Friday");
Ht.Add(6, "Saturday");
Ht.Add(7, "Sunday");
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");
//Gv.Columns.Clear();
DataTable dt = new DataTable();
for (int colCnt = 0; colCnt <= Convert.ToInt16(ViewState["cols"]); colCnt++)
{
DataColumn dc = new DataColumn();
if (colCnt == 0)
{
dc.ColumnName = Ht[0].ToString();
dt.Columns.Add(dc);
}
else
{
dc.ColumnName = Htp[0].ToString() + colCnt.ToString();
dt.Columns.Add(dc);
}
}
for (int rows = 1; rows <=Convert.ToInt16(ViewState["Rows"]); rows++)
{
DataRow dr = dt.NewRow();
dr["Days"] = Ht[rows];
for (int cols = 1; cols < dt.Columns.Count; cols++)
{
dr["Period" + cols] = Htp[cols].ToString();
}
dt.Rows.Add(dr);
}
//int k= dt.Rows.Count;
//DataRow dr1 in dt.Rows
// string str;
//foreach (DataRow dr4 in dt.Rows)
//{
//foreach(DataColumn dc4 in dt.Columns)
////for (int i = 1; i < dt.Columns.Count; i++)
//{
BoundField bfield = new BoundField();
bfield.DataField = "Days";
bfield.HeaderText = "Days";
Gv.Columns.Add(bfield);
for (int colCnt = 1; colCnt <= Convert.ToInt16(ViewState["cols"]); colCnt++)
{
// TemplateField Tfield = new TemplateField();
// Tfield.HeaderTemplate = new CheckBoxTemplate(ListItemType.Header, "Period" + colCnt.ToString());
//str= dr4[colCnt].ToString();
// Tfield.ItemTemplate = new CheckBoxTemplate(ListItemType.Item,str);
// Gv.Columns.Add(Tfield);
// Gv.DataSource = dt;
// Gv.DataBind();
// str= dr4[colCnt].ToString();
TemplateField tf = new TemplateField();
MyTemplate ta = new MyTemplate("Period" + colCnt.ToString());
tf.HeaderText = "Period" + colCnt.ToString();
tf.ItemTemplate = ta;
Gv.Columns.Add(tf);
Gv.DataSource = dt;
Gv.DataBind();
}
// }
// Gv.DataBind();
// }
//for (int j = 1; j <dt.Rows.Count; j++)
//{
//}
//foreach (DataColumn col1 in dt.Columns)
//{
// TemplateField bfield = new TemplateField();
// //Initalize the DataField value.
// // bfield.HeaderTemplate = new CheckBoxTemplate(ListItemType.Header, col1.ColumnName);
// //Initialize the HeaderText field value.
// bfield.ItemTemplate = new CheckBoxTemplate(ListItemType.Item, col1.ColumnName);
// Gv.Columns.Add(bfield);
// //Add the newly created bound field to the GridVie
// //// TemplateField tf = new TemplateField();
// ////Declare the bound field and allocate memory for the bound field.
// //BoundField bfield = new BoundField();
// ////Initalize the DataField value.
// //bfield.DataField = col1.ColumnName;
// ////Initialize the HeaderText field value.
// //bfield.HeaderText = col1.ColumnName;
// ////Add the newly created bound field to the GridView.
// //Gv.Columns.Add(bfield);
//}
//Gv.DataSource = dt;
//Gv.DataBind();
ViewState["Rows"] = ddlDays.SelectedValue.ToString() ;
ViewState["cols"] = ddlPeriods.SelectedValue.ToString();
}
catch (Exception)
{
throw;
}
}
protected void BtnGetAttendance_Click(object sender, EventArgs e)
{
sql = "SELECT * FROM Student WHERE SectionID = (SELECT SectionID FROM Section WHERE SectionName='" + DDLSection.SelectedItem.Text + "') AND Semester='" + int.Parse(DDLSemester.SelectedItem.Text) + "'";
Connect students = new Connect(sql);
GridView1.DataSource = students.ds;
GridView1.DataBind();
sql = "SELECT * FROM Subject WHERE Semester=" + int.Parse(DDLSemester.SelectedItem.Text) + " AND DepartmentID=" + int.Parse(Session["DepartmentID"].ToString()) + "";
Connect subjects = new Connect(sql);
for (int i = 0; i < subjects.ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < 3; j++)
{
string subscript;
if(j==0)
subscript = "Attd.";
else if(j==1)
subscript = "Held";
else
subscript = "%";
TemplateField field = new TemplateField();
field.HeaderText = subjects.ds.Tables[0].Rows[i]["SubjectCode"].ToString() + " " + subscript;
CreateItemTemplate.Page = 1;
field.ItemTemplate = new CreateItemTemplate(ListItemType.Item, subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString(), j.ToString());
Label l = new Label();
field.ItemTemplate.InstantiateIn(l);
GridView1.Columns.Add(field);
}
}
for (int j = 0; j < 3; j++)
{
string subscript;
if (j == 0)
subscript = "Attd.";
else if (j == 1)
subscript = "Held";
else
subscript = "%";
TemplateField temp = new TemplateField();
temp.HeaderText = "Total" + " " + subscript;
CreateItemTemplate.Page = 1;
temp.ItemTemplate = new CreateItemTemplate(ListItemType.Item, "total", j.ToString());
Label l1 = new Label();
temp.ItemTemplate.InstantiateIn(l1);
GridView1.Columns.Add(temp);
}
GridView1.DataBind();
foreach (GridViewRow row in GridView1.Rows)
{
for (int i = 0; i < subjects.ds.Tables[0].Rows.Count; i++)
{
string studentNo = row.Cells[1].Text + " ";
sql = "SELECT GroupID FROM Student WHERE StudentNo='" + studentNo + "'";
c = new Connect(sql);
sql = "SELECT * FROM Attendance WHERE SubjectID=" + int.Parse(subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString()) + " AND Date >= '" + TxtBxFromDate.Text + "' AND Date<='" + TxtBxToDate.Text + "' AND (SectionID=" + DDLSection.SelectedValue + " OR GroupID=" + int.Parse(c.ds.Tables[0].Rows[0]["GroupID"].ToString()) + ") AND Semester=" + DDLSemester.SelectedValue + " AND AttendanceTypeID=3";
c = new Connect(sql);
DataTable attendance = c.ds.Tables[0];
// Calculate total classes held for the selected subject using LINQ.
var totalClasses = (from k in attendance.AsEnumerable() select new { Date = k.Field<DateTime>("Date"), LectureID = k.Field<int>("LectureID") }).Distinct().Count();
int numberOfAbsent = 0;
for (int r = 0; r < c.ds.Tables[0].Rows.Count; r++)
{
if (c.ds.Tables[0].Rows[r]["StudentNo"].ToString().Equals(row.Cells[1].Text + " "))
{
numberOfAbsent = numberOfAbsent + 1;
}
}
Label totalPresent = (Label)row.FindControl("LblAttendanceType" + subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString() + "0");
totalPresent.Text = (totalClasses - numberOfAbsent).ToString();
Label held = (Label)row.FindControl("LblAttendanceType" + subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString() + "1");
held.Text = totalClasses.ToString();
Label percentageAttendance = (Label)row.FindControl("LblAttendanceType" + subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString() + "2");
percentageAttendance.Text = (float.Parse(totalPresent.Text) * 100 / totalClasses).ToString();
}
}
int totalAttended;
int totalHeld;
float totalPercentage;
foreach (GridViewRow row in GridView1.Rows)
{
totalAttended = 0;
totalHeld = 0;
totalPercentage = 0F;
for (int i = 0; i < subjects.ds.Tables[0].Rows.Count; i++)
{
string subjectID = subjects.ds.Tables[0].Rows[i]["SubjectID"].ToString();
Label lblAttended = (Label)row.FindControl("LblAttendanceType" + subjectID + "0");
totalAttended += int.Parse(lblAttended.Text);
Label lblHeld = (Label)row.FindControl("LblAttendanceType" + subjectID + "1");
totalHeld += int.Parse(lblHeld.Text);
Label lblPercentage = (Label)row.FindControl("LblAttendanceType" + subjectID + "2");
totalPercentage += float.Parse(lblPercentage.Text);
Label totAttd = (Label)row.FindControl("LblAttendanceType" + "total" + "0");
totAttd.Text = totalAttended.ToString();
Label totHeld = (Label)row.FindControl("LblAttendanceType" + "total" + "1");
totHeld.Text = totalHeld.ToString();
Label totPercentage = (Label)row.FindControl("LblAttendanceType" + "total" + "2");
totPercentage.Text = totalPercentage.ToString();
}
}
}
//动态生成GridView
protected void ShowGridView(object sender, EventArgs e)
{
GridPB.AutoGenerateColumns = false;
//GridPB.DataSource = CreateDataSource();//数据源是DataView
if (ViewState["dt"] == null)
{
GridPB.DataSource = GetGridViewData();//数据源是DataTable
ViewState["dt"] = GetGridViewData();
}
else
{
DataTable dt = (DataTable)ViewState["dt"];
GridPB.DataSource = dt;
}
ArrayList BClist = bz.BClist(out errMsg);
int[] bcid = (int[])BClist[0];
string[] bcms = (string[])BClist[1];
string[] st = (string[])BClist[2];
string[] et = (string[])BClist[3];
TemplateField rf = new TemplateField();
rf.HeaderTemplate = new GridViewTemplate("HeaderTemplate", "", "r");
rf.ItemTemplate = new GridViewTemplate("ItemTemplateRowNum", "行号", R.ToString());
this.GridPB.Columns.Add(rf);
TemplateField ttf = new TemplateField();
ttf.HeaderTemplate = new GridViewTemplate("HeaderTemplate", "日期", "t");
ttf.ItemTemplate = new GridViewTemplate("ItemTemplateTime", "日期", "time");
this.GridPB.Columns.Add(ttf);
if (bcms != null)
{
for (int i = 0; i < bcms.Length; i++)
{
if (bcms[i] == null)
{
break;
}
else
{
TemplateField tf = new TemplateField();
tf.HeaderTemplate = new GridViewTemplate("HeaderTemplate", bcms[i], "控件ID" + i.ToString());
tf.ItemTemplate = new GridViewTemplate("ItemTemplate", "班次", "BC" + i.ToString());
this.GridPB.Columns.Add(tf);
}
}
}
GridPB.DataBind();
}
private void ConstructGridViewTemplates()
{
var subLevels = from s in db.Schools
join slv in db.SchoolLevels on s.SchoolID equals slv.SchoolID
join ssl in db.SchoolSubLevels on slv.SchoolLevelID equals ssl.SchoolLevelID
join sl in db.SubLevels on ssl.SubLevelID equals sl.SubLevelID
where s.SchoolCode == Public.ToInt(this.txtSchoolCode.Text) && !sl.SubLevelName.Equals("Employees") && slv.LockOutDate == null
select
new
{
ssl.SchoolSubLevelID,
sl.SubLevelName,
StudentCount = ssl.BoysCount + ssl.GirlsCount
};
TemplateField goodsColumn = new TemplateField();
goodsColumn.HeaderTemplate = new GridViewTemplate(ListItemType.Header, "نام لوازم التحریر", "Sum", null);
goodsColumn.ItemTemplate = new GridViewTemplate(ListItemType.SelectedItem, null, "Sum", null);
this.grdPaperities.Columns.Add(goodsColumn);
byte index = 0;
foreach (var item in subLevels)
{
TemplateField column = new TemplateField();
column.HeaderTemplate = new GridViewTemplate(ListItemType.Header, item.SubLevelName, index.ToString(), item.SchoolSubLevelID.ToString());
column.ItemTemplate = new GridViewTemplate(ListItemType.Item, item.SubLevelName, index.ToString(), null);
column.FooterTemplate = new GridViewTemplate(ListItemType.Footer, "footer", index.ToString(), null);
this.grdPaperities.Columns.Add(column);
index++;
}
TemplateField sumColumn = new TemplateField();
sumColumn.HeaderTemplate = new GridViewTemplate(ListItemType.Header, "جمع", "Sum", null);
sumColumn.ItemTemplate = new GridViewTemplate(ListItemType.Item, null, "Sum", null);
sumColumn.FooterTemplate = new GridViewTemplate(ListItemType.Footer, null, "", null);
this.grdPaperities.Columns.Add(sumColumn);
this.grdPaperities.DataSource = index == 0 ? null : new byte[GetPaperteries().Count - 1];
this.grdPaperities.DataBind();
}
// Creates a mapping between what Sitecore labels a field as and which
// Property we're targetting on our Entity.
private String getFieldValue(TemplateField templateField, Product product)
{
switch (templateField.Name)
{
case "Description":
return product.Description;
case "Name":
return product.Name;
case "Database Id":
return product.Id.ToString();
}
return String.Empty;
}
public BulkItem AddField(TemplateField field, string value, Func <Stream> blob = null, bool isBlob = false,
string language = null, int?version = null,
Action <BulkField> postProcessor = null)
{
return(AddField(field.ID.Guid, value, blob, isBlob, language, version, field.Name, postProcessor));
}
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";
}
}
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (!string.IsNullOrEmpty(Request.QueryString["QCBatch"]))
{
QCbatch = Request.QueryString["QCBatch"];
}
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.gv.Columns.Add(bfColumn);
}
//添加选择列
TemplateField standardYON = new TemplateField();
standardYON.HeaderText = "计量单位";
standardYON.ItemTemplate = new MulDropDownListTemplate(DataControlRowType.DataRow, "ddlstandar");
this.gv.Columns.Insert(7, standardYON);
TemplateField unitprice = new TemplateField();
unitprice.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageInTestID", "txtunitprice");
unitprice.HeaderTemplate = new MulTextBoxTemplate("单价", DataControlRowType.Header);
unitprice.ItemStyle.Width = 150;
this.gv.Columns.Insert(8, unitprice);
TemplateField amount = new TemplateField();
amount.ItemTemplate = new TextBoxTemplate("unit", string.Empty, "", "自动计算", 80, false);
amount.HeaderTemplate = new MulTextBoxTemplate("金额", DataControlRowType.Header);
amount.ItemStyle.Width = 150;
this.gv.Columns.Insert(9, amount);
TemplateField reportNum = new TemplateField();
reportNum.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageInTestID", "txtreportNum");
reportNum.HeaderTemplate = new MulTextBoxTemplate("入库单据号", DataControlRowType.Header);
reportNum.ItemStyle.Width = 150;
this.gv.Columns.Insert(10, reportNum);
TemplateField materials = new TemplateField();
materials.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageInTestID", "txtmaterials");
materials.HeaderTemplate = new MulTextBoxTemplate("物资属性", DataControlRowType.Header);
materials.ItemStyle.Width = 150;
this.gv.Columns.Insert(11, materials);
this.gv.DataSource = from a in db.StorageInTest
join b in db.StorageInMain on a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID equals b.StorageInID
where a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == _storageInID && a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == (string.IsNullOrEmpty(QCbatch) ? a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex : QCbatch)
select new
{
a.StorageInTestID,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.MaterialName,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.SpecificationModel,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.FinanceCode,
b.StorageInCode,
a.TestGentaojian,
a.TestMetre,
a.TestTon,
a.StorageInMaterialsLeader.StorageInMaterials.StorageTime,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.ProjectInfo.ProjectName,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex,
a.Remark
};
this.gv.DataBind();
this.gv.Columns[this.gv.Columns.Count - 1].Visible = false;
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.gv);
}
}
private void createColumns(DataSet dsJobData, GridView grid, int tableIndex)
{
if (dsJobData != null)
{
grid.Columns.Clear();
foreach (DataColumn column in dsJobData.Tables[tableIndex].Columns)
{
if (column.ColumnName == "LastResult")
{
TemplateField tf = new TemplateField();
tf.HeaderText = column.ColumnName;
CustomGridViewTemplate t = new CustomGridViewTemplate(CustomGridViewTemplateTypes.LiteralText, column.ColumnName);
tf.ItemTemplate = t;
grid.Columns.Add(tf);
}
else
{
BoundField boundField = new BoundField();
boundField.DataField = column.ColumnName;
boundField.HeaderText = column.ColumnName;
grid.Columns.Add(boundField);
}
}
}
}
// void GridViewCreateTemplated(int BlankRow)
private void GridViewCreateTemplated()
{
// fill the table which is to bound to the GridView
string TableName = Session["SelectedTableName"].ToString();
//DataTable dtTable =
PopulateDataTable(TableName);
// add templated fields to the GridView
TemplateField BtnTmpField = new TemplateField();
//if (BlankRow == 0)
//{
if (dtTable != null && dtTable.Rows.Count == 0)
{
//if (Convert.ToInt16(Session["DeleteFlag"]) != 1)
//{
dtTable.Rows.Add(dtTable.NewRow());
BtnTmpField.HeaderTemplate =
new DynamicallyTemplatedGridView(ListItemType.Header, "...", "Command");
BtnTmpField.FooterTemplate =
new DynamicallyTemplatedGridView(ListItemType.Footer, "...", "Command");
grdMaster.Columns.Add(BtnTmpField);
for (int i = 0; i < dtTable.Columns.Count; i++)
{
TemplateField ItemTmpField = new TemplateField();
ItemTmpField.HeaderTemplate = new DynamicallyTemplatedGridView(ListItemType.Header,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
ItemTmpField.FooterTemplate = new DynamicallyTemplatedGridView(ListItemType.Footer,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
grdMaster.Columns.Add(ItemTmpField);
}
grdMaster.DataSource = dtTable;
grdMaster.DataBind();
grdMaster.Rows[0].Visible = false;
// BlankRow = 1;
}
//}
else
{
BtnTmpField.HeaderTemplate =
new DynamicallyTemplatedGridView(ListItemType.Header, "...", "Command");
BtnTmpField.ItemTemplate =
new DynamicallyTemplatedGridView(ListItemType.Item, "...", "Command");
BtnTmpField.EditItemTemplate =
new DynamicallyTemplatedGridView(ListItemType.EditItem, "...", "Command");
BtnTmpField.FooterTemplate =
new DynamicallyTemplatedGridView(ListItemType.Footer, "...", "Command");
grdMaster.Columns.Add(BtnTmpField);
for (int i = 0; i < dtTable.Columns.Count; i++)
{
TemplateField ItemTmpField = new TemplateField();
// create HeaderTemplate
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridView(ListItemType.Item,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
// create ItemTemplate
ItemTmpField.HeaderTemplate = new DynamicallyTemplatedGridView(ListItemType.Header,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
//create EditItemTemplate
ItemTmpField.EditItemTemplate = new DynamicallyTemplatedGridView(ListItemType.EditItem,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
//create footerTemplate
ItemTmpField.FooterTemplate = new DynamicallyTemplatedGridView(ListItemType.Footer,
dtTable.Columns[i].ColumnName,
dtTable.Columns[i].DataType.Name);
// then add to the GridView
grdMaster.Columns.Add(ItemTmpField);
}
// bind and display the data
grdMaster.DataSource = null;
grdMaster.DataSource = dtTable;
grdMaster.DataBind();
}
}
private HPMColumnDescription AddDefaultColumn(GridView gView, TabContainer multilineContainer, HPMUniqueID projectID, EHPMProjectDefaultColumn defaultColumn, string project)
{
HPMColumn column = new HPMColumn();
column.m_ColumnType = EHPMColumnType.DefaultColumn;
column.m_ColumnID = (uint)defaultColumn;
HPMColumnDescription columnDescription = m_VirtSession.UtilGetColumnDescription(column);
HPMUntranslatedString columnNameUntr = m_VirtSession.UtilGetColumnName(defaultColumn);
HPMString columnName = m_VirtSession.LocalizationTranslateString(m_VirtSession.LocalizationGetDefaultLanguage(), columnNameUntr);
bool isReadOnly = columnDescription.m_bReadOnly;
if (defaultColumn == EHPMProjectDefaultColumn.LinkedTo)
isReadOnly = true;
if ((defaultColumn == EHPMProjectDefaultColumn.DetailedDescription)
|| (defaultColumn == EHPMProjectDefaultColumn.StepsToReproduce))
{
AddMultilineTab(project, multilineContainer, columnName, Convert.ToString((uint)defaultColumn), isReadOnly);
return columnDescription;
}
if (defaultColumn == EHPMProjectDefaultColumn.Comments)
{
AddMultilineTabComments(project, multilineContainer, columnName, Convert.ToString((uint)defaultColumn), isReadOnly);
return columnDescription;
}
if (defaultColumn == EHPMProjectDefaultColumn.OriginallyCreatedBy)
columnDescription.m_CriteriaDataType = EHPMFindCriteriaDataType.Text;
if (defaultColumn == EHPMProjectDefaultColumn.MilestoneTag)
columnDescription.m_CriteriaDataType = EHPMFindCriteriaDataType.Droplist;
switch (columnDescription.m_CriteriaDataType)
{
case EHPMFindCriteriaDataType.Integer:
case EHPMFindCriteriaDataType.Float:
case EHPMFindCriteriaDataType.Date:
case EHPMFindCriteriaDataType.GeneralCondition:
case EHPMFindCriteriaDataType.Text:
{
BoundField textfield = new BoundField();
string id = Convert.ToString((uint)defaultColumn);
textfield.HeaderText = columnName;
textfield.AccessibleHeaderText = id;
textfield.SortExpression = id;
textfield.DataField = id;
textfield.ReadOnly = isReadOnly;
gView.Columns.Add(textfield);
}
break;
case EHPMFindCriteriaDataType.Droplist:
{
string id = Convert.ToString((uint)defaultColumn);
var values = new Dictionary<HPMUInt32, HPMString>();
HPMColumnData Data = m_VirtSession.UtilGetColumnData(projectID, defaultColumn);
// used to determine width of column
int longestString = 0;
foreach (HPMUInt32 DataItem in Data.m_DataItems)
{
HPMUntranslatedString DataItemTextUntranslated = m_VirtSession.UtilGetColumnDataItemFormatted(projectID, defaultColumn, DataItem);
HPMString DataItemText = m_VirtSession.LocalizationTranslateString(m_VirtSession.LocalizationGetDefaultLanguage(), DataItemTextUntranslated);
if (DataItemText.Length > longestString)
longestString = DataItemText.Length;
values.Add(DataItem, DataItemText);
}
// add some space to column width
longestString = longestString * 30;
TemplateField listfield = new TemplateField();
listfield.SortExpression = id;
listfield.HeaderText = columnName;
listfield.AccessibleHeaderText = id;
bool isNumeric = true;
if ((defaultColumn == EHPMProjectDefaultColumn.BugStatus) || (defaultColumn == EHPMProjectDefaultColumn.MilestoneTag) || (defaultColumn == EHPMProjectDefaultColumn.CommittedToSprint))
isNumeric = false;
listfield.ItemTemplate = new HPMGridViewTemplate(ListItemType.Item, HPMGridViewTemplateType.DropDownList, id, id, values, isReadOnly, isNumeric);
listfield.EditItemTemplate = new HPMGridViewTemplate(ListItemType.EditItem, HPMGridViewTemplateType.DropDownList, id, id, values, isReadOnly, isNumeric);
listfield.ItemStyle.Width = longestString;
listfield.ItemStyle.Wrap = false;
gView.Columns.Add(listfield);
}
break;
case EHPMFindCriteriaDataType.MultiSelectDroplist:
{
string id = Convert.ToString((uint)defaultColumn);
HPMUniqueID projectid = m_VirtSession.UtilGetRealProjectIDFromProjectID(projectID);
bool addResourceGroups = (defaultColumn == EHPMProjectDefaultColumn.AssignedTo) ? false : true;
var values = GetResources(projectid, addResourceGroups);
TemplateField listfield = new TemplateField();
listfield.SortExpression = id;
listfield.HeaderText = columnName;
listfield.AccessibleHeaderText = id;
listfield.ItemTemplate = new HPMGridViewTemplate(ListItemType.Item, HPMGridViewTemplateType.CheckBoxList, id, id, values, isReadOnly, false);
listfield.EditItemTemplate = new HPMGridViewTemplate(ListItemType.EditItem, HPMGridViewTemplateType.CheckBoxList, id, id, values, isReadOnly, false);
gView.Columns.Add(listfield);
}
break;
}
return columnDescription;
}
public static int GetColumnIndex(this GridView gv, string colName)
{
int ret = -1;
int i = 0;
i = 0;
while (i < gv.Columns.Count)
{
if (gv.Columns[i].GetType() == typeof(BoundField))
{
BoundField bfield = (BoundField)gv.Columns[i];
if (bfield.DataField.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(CheckBoxField))
{
CheckBoxField bfield = (CheckBoxField)gv.Columns[i];
if (bfield.DataField.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(HyperLinkField))
{
HyperLinkField bfield = (HyperLinkField)gv.Columns[i];
if (bfield.SortExpression.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(ImageField))
{
ImageField bfield = (ImageField)gv.Columns[i];
if (bfield.SortExpression.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(ButtonField))
{
ButtonField bfield = (ButtonField)gv.Columns[i];
if (bfield.SortExpression.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(CommandField))
{
CommandField bfield = (CommandField)gv.Columns[i];
if (bfield.SortExpression.ToUpper() == colName.ToUpper())
{
break;
}
}
if (gv.Columns[i].GetType() == typeof(TemplateField))
{
TemplateField bfield = (TemplateField)gv.Columns[i];
if (bfield.SortExpression.ToUpper() == colName.ToUpper())
{
break;
}
}
i++;
}
if (i < gv.Columns.Count)
{
ret = i;
}
return(ret);
}
private void AddCustomColumn(GridView gView, TabContainer multilineContainer, HPMUniqueID projectID, HPMProjectCustomColumnsColumn customColumn, string project)
{
string id = Convert.ToString(customColumn.m_Hash);
bool isReadOnly = true;
if (Convert.ToBoolean(customColumn.m_AccessRights & EHPMProjectCustomColumnsColumnAccessRights.AllProjectMembers))
{
isReadOnly = false;
}
else if (Convert.ToBoolean(customColumn.m_AccessRights & EHPMProjectCustomColumnsColumnAccessRights.MainProjectManagers))
{
HPMUniqueID realprojectID = m_VirtSession.UtilGetRealProjectIDFromProjectID(projectID);
HPMProjectResourceProperties userProperties = m_VirtSession.ProjectResourceGetProperties(realprojectID, m_ResourceID);
if (Convert.ToBoolean(userProperties.m_Flags & EHPMProjectResourceFlag.IsMainProjectManager))
isReadOnly = false;
}
else if (Convert.ToBoolean(customColumn.m_AccessRights & EHPMProjectCustomColumnsColumnAccessRights.ReadOnly))
{
isReadOnly = true;
}
switch (customColumn.m_Type)
{
case EHPMProjectCustomColumnsColumnType.IntegerNumber:
case EHPMProjectCustomColumnsColumnType.FloatNumber:
case EHPMProjectCustomColumnsColumnType.DateTime:
case EHPMProjectCustomColumnsColumnType.DateTimeWithTime:
case EHPMProjectCustomColumnsColumnType.Text:
case EHPMProjectCustomColumnsColumnType.Hyperlink:
{
BoundField textfield = new BoundField();
textfield.HeaderText = customColumn.m_Name;
textfield.SortExpression = id;
textfield.AccessibleHeaderText = id;
textfield.DataField = id;
textfield.ReadOnly = isReadOnly;
gView.Columns.Add(textfield);
}
break;
case EHPMProjectCustomColumnsColumnType.Resources:
{
HPMUniqueID projectid = m_VirtSession.UtilGetRealProjectIDFromProjectID(projectID);
var values = GetResources(projectid, true);
TemplateField listfield = new TemplateField();
listfield.SortExpression = id;
listfield.HeaderText = customColumn.m_Name;
listfield.AccessibleHeaderText = id;
listfield.ItemTemplate = new HPMGridViewTemplate(ListItemType.Item, HPMGridViewTemplateType.CheckBoxList, id, id, null, isReadOnly, false);
listfield.EditItemTemplate = new HPMGridViewTemplate(ListItemType.EditItem, HPMGridViewTemplateType.CheckBoxList, id, id, values, isReadOnly, false);
gView.Columns.Add(listfield);
}
break;
case EHPMProjectCustomColumnsColumnType.MultiSelectionDropList:
{
var values = new Dictionary<HPMUInt32, HPMString>();
string nothingSet = "(nothing set)";
values.Add(0, nothingSet);
foreach (HPMProjectCustomColumnsColumnDropListItem DataItem in customColumn.m_DropListItems)
{
values.Add(DataItem.m_Id, DataItem.m_Name);
}
TemplateField listfield = new TemplateField();
listfield.SortExpression = id;
listfield.HeaderText = customColumn.m_Name;
listfield.AccessibleHeaderText = id;
listfield.ItemTemplate = new HPMGridViewTemplate(ListItemType.Item, HPMGridViewTemplateType.CheckBoxList, id, id, null, isReadOnly, false);
listfield.EditItemTemplate = new HPMGridViewTemplate(ListItemType.EditItem, HPMGridViewTemplateType.CheckBoxList, id, id, values, isReadOnly, false);
gView.Columns.Add(listfield);
}
break;
case EHPMProjectCustomColumnsColumnType.DropList:
{
var values = new Dictionary<HPMUInt32, HPMString>();
string nothingSet = "(nothing set)";
// used to determine width of column
int longestString = nothingSet.Length;
values.Add(0, nothingSet);
foreach (HPMProjectCustomColumnsColumnDropListItem DataItem in customColumn.m_DropListItems)
{
if (DataItem.m_Name.Length > longestString)
longestString = DataItem.m_Name.Length;
values.Add(DataItem.m_Id, DataItem.m_Name);
}
// add some space to column width
longestString = longestString * 30;
TemplateField listfield = new TemplateField();
listfield.SortExpression = id;
listfield.HeaderText = customColumn.m_Name;
listfield.AccessibleHeaderText = id;
listfield.ItemTemplate = new HPMGridViewTemplate(ListItemType.Item, HPMGridViewTemplateType.DropDownList, id, id, values, isReadOnly, true);
listfield.EditItemTemplate = new HPMGridViewTemplate(ListItemType.EditItem, HPMGridViewTemplateType.DropDownList, id, id, values, isReadOnly, true);
listfield.ItemStyle.Width = longestString;
listfield.ItemStyle.Wrap = false;
gView.Columns.Add(listfield);
}
break;
case EHPMProjectCustomColumnsColumnType.MultiLineText:
{
AddMultilineTab(project, multilineContainer, customColumn.m_Name, Convert.ToString(customColumn.m_Hash), isReadOnly);
}
break;
}
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
selectionEnabled = ((ObjectType != LicenseObjectType.LICENSEKEY) || !Settings.IsOlderVersion);
if (selectionEnabled)
{
// Initilaize strings
btnAll.Text = GetString("ImportExport.All");
btnNone.Text = GetString("export.none");
btnDefault.Text = GetString("General.Default");
}
pnlLinks.Visible = selectionEnabled;
// Get object info
GeneralizedInfo info = CMSObjectHelper.GetReadOnlyObject(ObjectType);
if (info != null)
{
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Get data source
DataSet ds = DataSource;
DataTable table = null;
if (!DataHelper.DataSourceIsEmpty(ds))
{
// Get the table
string tableName = CMSObjectHelper.GetTableName(info);
table = ds.Tables[tableName];
// Set correct ID for direct page contol
pagerElem.DirectPageControlID = ((float)table.Rows.Count / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Sort data
if (!DataHelper.DataSourceIsEmpty(table))
{
string orderBy = GetOrderByExpression(info);
table.DefaultView.Sort = orderBy;
if (ValidationHelper.GetString(table.Rows[0][codeNameColumnName], null) == null)
{
codeNameColumnName = info.GUIDColumn;
}
}
}
// Prepare checkbox column
TemplateField checkBoxField = (TemplateField)gvObjects.Columns[0];
checkBoxField.HeaderText = GetString("General.Import");
// Prepare name field
TemplateField nameField = (TemplateField)gvObjects.Columns[1];
nameField.HeaderText = GetString("general.displayname");
if (!DataHelper.DataSourceIsEmpty(table))
{
plcObjects.Visible = true;
lblNoData.Visible = false;
gvObjects.DataSource = table;
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
PagedDataSource pagedDS = gvObjects.DataSource as PagedDataSource;
if (pagedDS != null)
{
if (pagedDS.PageSize <= 0)
{
gvObjects.DataSource = table;
}
}
gvObjects.DataBind();
}
else
{
plcObjects.Visible = false;
lblNoData.Visible = true;
lblNoData.Text = String.Format(GetString("ImportGridView.NoData"), GetString("objecttype." + ObjectType.Replace(".", "_").Replace("#", "_")));
}
}
else
{
plcGrid.Visible = false;
}
// Disable license selection
bool enable = !((ObjectType == LicenseObjectType.LICENSEKEY) && Settings.IsOlderVersion);
gvObjects.Enabled = enable;
pnlLinks.Enabled = enable;
lblInfo.Text = enable ? GetString("ImportGridView.Info") : GetString("ImportGridView.Disabled");
}
else
{
pnlGrid.Visible = false;
gvObjects.DataSource = null;
gvObjects.DataBind();
}
}
private IHotspotSession CreateFakeHotspotSession()
{
var hotspotSession = Substitute.For<IHotspotSession>();
var templateField = new TemplateField("", new MacroCallExpression(_quickParamterlessMacro), 0);
var hotspot = new Hotspot(new HotspotInfo(templateField), hotspotSession);
var rangeMarger = Substitute.For<IRangeMarker>();
hotspot.RangeMarkers.Add(rangeMarger);
var hotspots = new List<Hotspot>
{
new Hotspot(new HotspotInfo(new TemplateField("", 0)), hotspotSession),
hotspot
};
hotspotSession.Hotspots.Returns(hotspots);
return hotspotSession;
}
public void BindDataGrid(DataTable PartialDataset)
{
try
{
if (!PartialDataset.Columns.Contains("PRIMARY"))
{
PartialDataset.Columns.Add("PRIMARY");
PartialDataset.Columns["PRIMARY"].SetOrdinal(0);
}
for (int row = 0; row < PartialDataset.Rows.Count; row++)
{
PartialDataset.Rows[row]["PRIMARY"] = PartialDataset.Rows[row]["RELATIONID"].ToString();
}
for (int i = 0; i < PartialDataset.Columns.Count; i++)
{
if (i == 1)
{
BoundField bfcol1 = new BoundField();
bfcol1.DataField = PartialDataset.Columns["Date"].ColumnName;
bfcol1.HeaderText = "DATE";
bfcol1.ItemStyle.Width = Unit.Pixel(100);
UserControlGridVeiw.Columns.Add(bfcol1);
}
if (i == 9)
{
BoundField bfcol9 = new BoundField();
if (PartialDataset.Columns.Contains("BALANCE"))
{
bfcol9.DataField = PartialDataset.Columns["BALANCE"].ColumnName;
}
else if (PartialDataset.Columns.Contains("Credit"))
{
bfcol9.DataField = PartialDataset.Columns["Credit"].ColumnName;
}
bfcol9.HeaderText = "BALANCE";
bfcol9.ItemStyle.Width = Unit.Pixel(100);
UserControlGridVeiw.Columns.Add(bfcol9);
}
if (i == 3)
{
BoundField bfcol2 = new BoundField();
bfcol2.DataField = PartialDataset.Columns["NARRATION"].ColumnName;
bfcol2.HeaderText = "NARRATION";
bfcol2.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
bfcol2.ItemStyle.Width = Unit.Pixel(250);
UserControlGridVeiw.Columns.Add(bfcol2);
}
if (i == 5)
{
BoundField bfcol6 = new BoundField();
bfcol6.DataField = PartialDataset.Columns["LTRANTYPE"].ColumnName;
bfcol6.HeaderText = "TRANSACTION TYPE";
bfcol6.HeaderStyle.CssClass = "hideen";
bfcol6.ItemStyle.CssClass = "hideen";
bfcol6.HeaderStyle.Width = Unit.Pixel(5);
bfcol6.ItemStyle.Width = Unit.Pixel(5);
UserControlGridVeiw.Columns.Add(bfcol6);
}
if (i == 6)
{
BoundField bfcol3 = new BoundField();
bfcol3.DataField = PartialDataset.Columns["VOUCHERTYPE"].ColumnName;
bfcol3.HeaderText = "VOUCHER TYPE";
bfcol3.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
UserControlGridVeiw.Columns.Add(bfcol3);
}
if (i == 4)
{
BoundField bfcol4 = new BoundField();
bfcol4.DataField = PartialDataset.Columns["VchNo"].ColumnName;
bfcol4.HeaderText = "VOUCHER NO";
bfcol4.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
UserControlGridVeiw.Columns.Add(bfcol4);
}
if (i == 2)
{
Label lbl = new Label();
LinkButton linkbtn = new LinkButton();
TemplateField tempobj = new TemplateField();
/************************MAHENDRA*****************************/
//tempobj.HeaderTemplate = new ScrollDataGrid(lbl, PartialDataset.Columns["particular"].ColumnName, i, ListItemType.Header);
/**************Ashish******/
tempobj.ItemTemplate = new ScrollDataGrid(lbl, linkbtn, PartialDataset.Columns["particular"].ColumnName, i, ListItemType.Item);
tempobj.HeaderText = "PARTICULAR";
tempobj.ItemStyle.Width = Unit.Pixel(250);
tempobj.HeaderStyle.Width = Unit.Pixel(250);
tempobj.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
tempobj.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
UserControlGridVeiw.Columns.Add(tempobj);
}
if (i == 0)
{
Label lbl = new Label();
TemplateField tempobj = new TemplateField();
tempobj.ItemTemplate = new ScrollDataGrid(lbl, PartialDataset.Columns["PRIMARY"].ColumnName, i, ListItemType.Item);
UserControlGridVeiw.Columns.Add(tempobj);
}
if (i == 7)
{
Label lbl = new Label();
TemplateField tempobjcredit = new TemplateField();
tempobjcredit.HeaderTemplate = new ScrollDataGrid(lbl, PartialDataset.Columns["Credit"].ColumnName, i, ListItemType.Header);
tempobjcredit.ItemTemplate = new ScrollDataGrid(lbl, PartialDataset.Columns["Credit"].ColumnName, i, ListItemType.Item);
UserControlGridVeiw.Columns.Add(tempobjcredit);
}
if (i == 8)
{
Label lbl = new Label();
TemplateField tempobjcredit = new TemplateField();
tempobjcredit.HeaderTemplate = new ScrollDataGrid(lbl, "Debit", i, ListItemType.Header);
tempobjcredit.ItemTemplate = new ScrollDataGrid(lbl, PartialDataset.Columns["Credit"].ColumnName, i, ListItemType.Item);
UserControlGridVeiw.Columns.Add(tempobjcredit);
}
}
}
catch
{
throw;
}
}
private Action<ITextControl> MarkInsertedDescription(ISolution solution, ExceptionDocCommentModel insertedExceptionModel)
{
var exceptionCommentRange = insertedExceptionModel.GetMarkerRange();
if (exceptionCommentRange == DocumentRange.InvalidRange)
return null;
var copyExceptionDescription =
string.IsNullOrEmpty(insertedExceptionModel.ExceptionDescription) ||
insertedExceptionModel.ExceptionDescription.Contains("[MARKER]");
var exceptionDescription = copyExceptionDescription ? "Condition" : insertedExceptionModel.ExceptionDescription;
var nameSuggestionsExpression = new NameSuggestionsExpression(new[] {exceptionDescription});
var field = new TemplateField("name", nameSuggestionsExpression, 0);
var fieldInfo = new HotspotInfo(field, exceptionCommentRange);
return textControl =>
{
var hotspotSession = Shell.Instance.GetComponent<LiveTemplatesManager>()
.CreateHotspotSessionAtopExistingText(
solution, TextRange.InvalidRange, textControl, LiveTemplatesManager.EscapeAction.LeaveTextAndCaret,
new[] {fieldInfo});
hotspotSession.Execute();
};
}
/// <summary>
/// Load options definition.
/// </summary>
/// <param name="options">Options configuration</param>
/// <param name="filterWrapperControl">Wrapper control for filter</param>
private void LoadOptionsDefinition(UniGridOptions options, Control filterWrapperControl)
{
// Add custom filter or filter wrapper panel according to the key value "DisplayFilter"
displayFilter = options.DisplayFilter;
if (displayFilter)
{
// Add custom filter
if (!mCustomFilterAdded && !string.IsNullOrEmpty(options.FilterPath))
{
UniGridFilterField filterDefinition = new UniGridFilterField();
CMSAbstractBaseFilterControl filterControl = LoadFilterControl(options.FilterPath, CUSTOM_FILTER_SOURCE_NAME, null, filterDefinition);
FilterFields[CUSTOM_FILTER_SOURCE_NAME] = filterDefinition;
mCustomFilterAdded = true;
plcFilter.Controls.Add(filterControl);
RaiseOnFilterFieldCreated(null, filterDefinition);
}
// Add wrapper panel for default filter
else
{
plcFilter.Controls.Add(filterWrapperControl);
}
}
// Filter limit
if (options.FilterLimit > -1)
{
FilterLimit = options.FilterLimit;
}
// Display sort direction images
showSortDirection = options.ShowSortDirection;
// Display selection column with checkboxes
showSelection = options.ShowSelection;
if (showSelection)
{
TemplateField chkColumn = new TemplateField();
using (CMSCheckBox headerBox = new CMSCheckBox
{
ID = "headerBox"
})
{
using (CMSCheckBox itemBox = new CMSCheckBox
{
ID = "itemBox"
})
{
// Set selection argument
itemBox.Attributes["selectioncolumn"] = options.SelectionColumn;
chkColumn.HeaderTemplate = new GridViewTemplate(ListItemType.Header, this, headerBox);
chkColumn.ItemTemplate = new GridViewTemplate(ListItemType.Item, this, itemBox);
}
}
GridView.Columns.Add(chkColumn);
}
// PageSize and DisplayPageSizeDropdown properties are obsolete.
// This code ensures backward compatibility.
// #pragma statement disables warnings for using obsolete attribute.
#pragma warning disable 612, 618
if (!String.IsNullOrEmpty(options.PageSize))
{
Pager.PageSizeOptions = options.PageSize;
}
// Set paging according to the key value "DisplayPageSizeDropdown"
if (options.DisplayPageSizeDropdown != null)
{
Pager.ShowPageSize = options.DisplayPageSizeDropdown.Value;
}
#pragma warning restore 612, 618
}
public override bool ChangeFieldSharing(TemplateField fieldDefinition, TemplateFieldSharing sharing, CallContext context)
{
return base.ChangeFieldSharing(fieldDefinition, sharing, context);
}
private string GetFieldValue(TemplateField field, YTItemInfo itemInfo)
{
string val = string.Empty;
switch (field.Name)
{
case "Url":
val = itemInfo.YouTubeItem.Media.Content.Url;
break;
case "Width":
val = itemInfo.YouTubeItem.Media.Content.Width;
break;
case "Height":
val = itemInfo.YouTubeItem.Media.Content.Height;
break;
case "Title":
val = itemInfo.YouTubeItem.Media.Title.Value;
break;
case "Keywords":
val = itemInfo.YouTubeItem.Media.Keywords.Value;
break;
case "Description":
val = itemInfo.YouTubeItem.Media.Description.Value;
break;
case "Extension":
val = "flv";
break;
case "Mime Type":
val = itemInfo.YouTubeItem.Media.Content.Type;
break;
case "Size":
//val = itemInfo.YouTubeItem.Media.;
break;
case "Format":
break;
case "Dimensions":
break;
}
if (val == null) {val = string.Empty;}
return val;
}
private HotspotInfo CreateHostHotspotInfo()
{
var lambda = (ILambdaExpression)myOuterInvocation.NotNull().Arguments[0].Value;
var lambdaParameter = lambda.ParameterDeclarations[0];
var name = lambdaParameter.DeclaredName;
var templateField = new TemplateField(name, new MacroCallExpressionNew(new SuggestVariableNameMacroDef()), 0);
var documentRange = lambdaParameter.GetNameDocumentRange();
var documentRanges = new LocalList<DocumentRange>();
documentRanges.Add(documentRange);
CollectUsageRanges(lambdaParameter.DeclaredElement, lambda.BodyExpression, ref documentRanges);
return new HotspotInfo(templateField, documentRanges.ToArray());
}
protected void dvCompany_DataBound(object sender, EventArgs e)
{
//For IndustryDDL
DropDownList industryDropDownList = new DropDownList();
industryDropDownList = (DropDownList)dvCompany.FindControl("ddlIndustry");
if ((industryDropDownList != null))
{
ListItem selectItem = new ListItem("--Select Industry--", "0");
industryDropDownList.Items.Insert(0, selectItem);
}
//Sandler Rep Last Name - It should be Sales for Client
TemplateField repLastNameTempField = new TemplateField();
repLastNameTempField = dvCompany.Fields.OfType<TemplateField>().Where(f => f.HeaderText == "Sandler Rep Last Name :").FirstOrDefault();
if (repLastNameTempField != null)
{
//Get the User Info
if (CurrentUser.Role == SandlerRoles.Client)
{
repLastNameTempField.HeaderText = "Sales Rep Last Name :";
}
}
//For Sandler Rep First Name
TemplateField repFirstNameTempField = new TemplateField();
repFirstNameTempField = dvCompany.Fields.OfType<TemplateField>().Where(f => f.HeaderText == "Sandler Rep First Name :").FirstOrDefault();
if (repFirstNameTempField != null)
{
//Get the User Info
if (CurrentUser.Role == SandlerRoles.Client)
{
repFirstNameTempField.HeaderText = "Sales Rep First Name :";
}
}
//Find out Loggedin User's First and Last Name for Auto Polulatation
SandlerRepositories.CompaniesRepository companyRepository = new SandlerRepositories.CompaniesRepository();
System.Data.DataSet ds = companyRepository.GetFirstLastNameInfo(CurrentUser.UserId.ToString());
string FName = "";
string LName = "";
if (ds.Tables[0].Rows.Count > 0)
{
FName = ds.Tables[0].Rows[0].ItemArray[0].ToString();
LName = ds.Tables[0].Rows[0].ItemArray[1].ToString();
}
//For Next Contact Date - Calendar control
TextBox RepLastNameTextBox = new TextBox();
RepLastNameTextBox = (TextBox)dvCompany.FindControl("txtRepLastName");
if (RepLastNameTextBox != null)
{
RepLastNameTextBox.Text = LName;
}
//For Next Contact Date - Calendar control
TextBox RepFirstNameTextBox = new TextBox();
RepFirstNameTextBox = (TextBox)dvCompany.FindControl("txtRepFirstName");
if (RepFirstNameTextBox != null)
{
RepFirstNameTextBox.Text = FName;
}
}
private DataTable CreateTableItemColumn(MAS_TEMPLATECOLNAME colName)
{
/*********** For Create DataTable and Gridview Column ****************/
DataTable dtColName = null;
dtColName = new DataTable();
dtColName.Clear();
dtColName.Columns.Add("ProjectItemNo", typeof(string));
dtColName.Columns.Add("ProjectNo", typeof(string));
/**************** Set Gridview Property ***************/
gvItem.Columns.Clear();
gvItem.AllowSorting = false;
gvItem.AllowPaging = false;
gvItem.ShowFooter = true;
/******************************************************/
TemplateField tfield;
if (!string.IsNullOrWhiteSpace(colName.ColumnName1))
{
dtColName.Columns.Add("ItemColumn1", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName1;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName2))
{
dtColName.Columns.Add("ItemColumn2", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName2;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName3))
{
dtColName.Columns.Add("ItemColumn3", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName3;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName4))
{
dtColName.Columns.Add("ItemColumn4", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName4;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName5))
{
dtColName.Columns.Add("ItemColumn5", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName5;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName6))
{
dtColName.Columns.Add("ItemColumn6", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName6;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName7))
{
dtColName.Columns.Add("ItemColumn7", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName7;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
if (!string.IsNullOrWhiteSpace(colName.ColumnName8))
{
dtColName.Columns.Add("ItemColumn8", typeof(string));
tfield = new TemplateField();
tfield.HeaderText = colName.ColumnName8;
tfield.ItemStyle.HorizontalAlign.Equals("Center");
tfield.ItemStyle.VerticalAlign.Equals("Middle");
gvItem.Columns.Add(tfield);
}
return(dtColName);
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
selectionEnabled = ((ObjectType != LicenseKeyInfo.OBJECT_TYPE) || !Settings.IsOlderVersion);
pnlTaskLinks.Visible = selectionEnabled;
// Get object info
GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType);
if (info != null)
{
gvTasks.RowDataBound += gvTasks_RowDataBound;
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Task fields
TemplateField taskCheckBoxField = (TemplateField)gvTasks.Columns[0];
taskCheckBoxField.HeaderText = GetString("General.Process");
BoundField titleField = (BoundField)gvTasks.Columns[1];
titleField.HeaderText = GetString("Export.TaskTitle");
BoundField typeField = (BoundField)gvTasks.Columns[2];
typeField.HeaderText = GetString("general.type");
BoundField timeField = (BoundField)gvTasks.Columns[3];
timeField.HeaderText = GetString("Export.TaskTime");
// Load tasks
DataSet ds = DataSource;
if (!DataHelper.DataSourceIsEmpty(ds) && !DataHelper.DataSourceIsEmpty(ds.Tables["Export_Task"]) && (ValidationHelper.GetBoolean(Settings.GetSettings(ImportExportHelper.SETTINGS_TASKS), true)))
{
plcTasks.Visible = true;
gvTasks.DataSource = ds.Tables["Export_Task"];
// Set correct ID for direct page control
pagerElem.DirectPageControlID = ((float)ds.Tables["Export_Task"].Rows.Count / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
gvTasks.DataBind();
}
else
{
plcTasks.Visible = false;
}
}
else
{
plcGrid.Visible = false;
}
// Disable license selection
bool enable = !((ObjectType == LicenseKeyInfo.OBJECT_TYPE) && Settings.IsOlderVersion);
gvTasks.Enabled = enable;
pnlTaskLinks.Enabled = enable;
}
else
{
pnlGrid.Visible = false;
}
}
protected virtual void ProcessTemplateField([NotNull] FileCodeModel fileCodeModel, [NotNull] Template template, [NotNull] TemplateSection templateSection, [NotNull] CodeProperty2 property)
{
Debug.ArgumentNotNull(fileCodeModel, nameof(fileCodeModel));
Debug.ArgumentNotNull(template, nameof(template));
Debug.ArgumentNotNull(templateSection, nameof(templateSection));
Debug.ArgumentNotNull(property, nameof(property));
var type = property.Type.AsFullName;
var handler = FieldTypeHandlerManager.FieldTypes.FirstOrDefault(h => h.CanHandle(type));
if (handler == null)
{
return;
}
var field = new TemplateField(property);
templateSection.Fields.Add(field);
field.Name = property.Name;
field.TemplateFieldItemId = new ItemId(fileCodeModel.GetHash(property.Attributes, template.Name + @"/" + templateSection.Name + @"/" + field.Name));
field.Type = string.Empty;
field.Source = string.Empty;
field.Shared = false;
field.Unversioned = false;
field.Title = string.Empty;
field.ValidatorBar = string.Empty;
handler.Handle(type, field);
var sitecoreField = property.Attributes.OfType <CodeAttribute2>().FirstOrDefault(a => a.Name == "SitecoreField" || a.Name == "SitecoreFieldAttribute");
if (sitecoreField == null)
{
return;
}
var index = 0;
foreach (var argument in sitecoreField.Arguments.OfType <CodeAttributeArgument>())
{
var value = argument.Value;
if (value.StartsWith("\"") && value.EndsWith("\""))
{
value = value.Mid(1, value.Length - 2);
}
if (string.IsNullOrEmpty(argument.Name) && index == 0)
{
field.Name = value;
}
if (argument.Name == "FieldName")
{
field.Name = value;
}
if (argument.Name == "Type")
{
field.Type = value;
}
if (argument.Name == "Shared")
{
field.Shared = value == "true";
}
if (argument.Name == "Unversioned")
{
field.Shared = value == "true";
}
if (argument.Name == "Source")
{
field.Source = value;
}
index++;
}
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
pnlSearch.Visible = true;
// Get object info
GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType);
if (info != null)
{
gvObjects.RowDataBound += gvObjects_RowDataBound;
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Get data source
var where = Settings.GetObjectWhereCondition(ObjectType, SiteObject);
var orderBy = GetOrderByExpression(info);
// Set filter field
textFilter.Field = string.IsNullOrEmpty(displayNameColumnName) ? codeNameColumnName : displayNameColumnName;
// Hide filter if the object doesn't have needed columns
if (string.IsNullOrEmpty(textFilter.Field))
{
pnlSearch.Visible = false;
}
// Save previous filter where condition (needed for correct offset)
var filterPreviousWhereCondition = FilterCurrentWhereCondition;
// Reset filter if current node has changed
if (FilterCurrentObjectType != ObjectType)
{
ResetFilter();
}
else
{
var filterWhereCondition = "";
// Important, do not remove this check
if (!string.IsNullOrEmpty(textFilter.Text))
{
// Get filter condition
filterWhereCondition = textFilter.GetWhereCondition();
// Save filter condition to ViewState
FilterCurrentWhereCondition = filterWhereCondition;
}
if (!string.IsNullOrEmpty(filterWhereCondition))
{
// Apply filter condition
where = where.And(new WhereCondition(filterWhereCondition));
}
}
// Prepare the columns
string columns = null;
if (info.CodeNameColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN)
{
columns += info.CodeNameColumn;
}
if ((info.DisplayNameColumn.ToLowerCSafe() != info.CodeNameColumn.ToLowerCSafe()) && (info.DisplayNameColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN))
{
if (columns != null)
{
columns += ", ";
}
columns += info.DisplayNameColumn;
}
// Get the data query
var q = info.GetDataQuery(
true,
s => s
.Where(where)
.OrderBy(orderBy)
.Columns(columns),
false
);
q.IncludeBinaryData = false;
// No offset if filter condition has changed and not empty
if (!string.IsNullOrEmpty(FilterCurrentWhereCondition) && FilterCurrentWhereCondition != filterPreviousWhereCondition)
{
q.Offset = 0;
}
else
{
q.Offset = CurrentOffset;
}
q.MaxRecords = CurrentPageSize;
// Get the data
DataSet ds = q.Result;
pagerForceNumberOfResults = q.TotalRecords;
// Set correct ID for direct page control
pagerElem.DirectPageControlID = ((float)pagerForceNumberOfResults / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
// Prepare checkbox field
TemplateField checkBoxField = (TemplateField)gvObjects.Columns[0];
checkBoxField.HeaderText = GetString("General.Export");
// Prepare display name field
TemplateField nameField = (TemplateField)gvObjects.Columns[1];
nameField.HeaderText = GetString("general.displayname");
// Load data
if (!DataHelper.DataSourceIsEmpty(ds))
{
plcObjects.Visible = true;
lblNoData.Visible = false;
gvObjects.DataSource = ds;
gvObjects.DataBind();
}
else
{
plcObjects.Visible = false;
lblNoData.Visible = true;
lblNoData.Text = String.Format(GetString("ExportGridView.NoData"), GetString("objecttype." + ObjectType.Replace(".", "_").Replace("#", "_")));
}
}
else
{
plcGrid.Visible = false;
}
}
else
{
pnlGrid.Visible = false;
gvObjects.DataSource = null;
gvObjects.DataBind();
}
}
private void InitializeCustomControls()
{
InitBar();
//***初始化新建物资列表***//
this.spgvMaterial = new SPGridView();
this.spgvMaterial.AutoGenerateColumns = false;
this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.spgvMaterial);
//分页
this.spgvMaterial.AllowPaging = true;
this.spgvMaterial.PageSize = 10;
this.spgvMaterial.PageIndexChanging += new GridViewPageEventHandler(spgvMaterial_PageIndexChanging);
this.spgvMaterial.PagerTemplate = new PagerTemplate("{0} - {1}", spgvMaterial);
this.spgvMaterial.Columns.Clear();
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("选择", DataControlRowType.DataRow);
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("选择", DataControlRowType.Header);
this.spgvMaterial.Columns.Add(tfieldCheckbox);
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvMaterial.Columns.Add(bfColumn);
}
//加入调拨数量(根/台/套/件)列
TemplateField tfGentaojian = new TemplateField();
tfGentaojian.HeaderText = "调拨数量(根/台/套/件)";
tfGentaojian.ItemTemplate = new TextBoxTemplate("Gentaojian", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80);
this.spgvMaterial.Columns.Insert(5, tfGentaojian);
//加入调拨数量(米)列
TemplateField tfMetre = new TemplateField();
tfMetre.HeaderText = "调拨数量(米)";
tfMetre.ItemTemplate = new TextBoxTemplate("Metre", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80);
this.spgvMaterial.Columns.Insert(7, tfMetre);
//加入调拨数量(吨)列
TemplateField tfTon = new TemplateField();
tfTon.HeaderText = "调拨数量(吨)";
tfTon.ItemTemplate = new TextBoxTemplate("Ton", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80);
this.spgvMaterial.Columns.Insert(9, tfTon);
//加入备注
TemplateField tfRemark = new TemplateField();
tfRemark.HeaderText = "备注";
tfRemark.ItemTemplate = new TextBoxTemplate("Remark", DataControlRowType.DataRow);
this.spgvMaterial.Columns.Insert(10, tfRemark);
//***初始化已加入物资列表***//
this.spgvExistMaterial = new SPGridView();
this.spgvExistMaterial.AutoGenerateColumns = false;
this.spgvExistMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
foreach (var kvp in ExistTitlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvExistMaterial.Columns.Add(bfColumn);
}
btnOK = (Button)GetControltByMaster("btnOK");
btnOK.Click += new EventHandler(btnOK_Click);
btnSearch = (Button)GetControltByMaster("btnSearch");
btnSearch.Click += new EventHandler(btnSearch_Click);
chbShowAll = (CheckBox)GetControltByMaster("chbShowAll");
chbShowAll.CheckedChanged += new EventHandler(chbShowAll_CheckedChanged);
txtMaterialName = GetControltByMaster("txtMaterialName") as TextBox;
txtFinanceCode = GetControltByMaster("txtFinanceCode") as TextBox;
txtSpecificationModel = GetControltByMaster("txtSpecificationModel") as TextBox;
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
pnlSearch.Visible = true;
selectionEnabled = ((ObjectType != LicenseKeyInfo.OBJECT_TYPE) || !Settings.IsOlderVersion);
pnlLinks.Visible = selectionEnabled;
// Get object info
GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType);
if (info != null)
{
gvObjects.RowDataBound += gvObjects_RowDataBound;
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Set filter field
textFilter.Field = string.IsNullOrEmpty(displayNameColumnName) ? codeNameColumnName : displayNameColumnName;
// Hide filter if the object doesn't have needed columns
if (string.IsNullOrEmpty(textFilter.Field))
{
pnlSearch.Visible = false;
}
string filterWhereCondition = "";
// Reset filter if current node has changed
if (FilterCurrentObjectType != ObjectType)
{
ResetFilter();
}
else
{
// Important, do not remove this check
if (!string.IsNullOrEmpty(textFilter.Text))
{
// Get filter condition
filterWhereCondition = textFilter.GetWhereCondition();
}
}
// Get data source
DataSet ds = DataSource;
DataTable table = null;
if (!DataHelper.DataSourceIsEmpty(ds))
{
// Get the table
table = ObjectHelper.GetTable(ds, info);
// Set correct ID for direct page control
pagerElem.DirectPageControlID = ((float)table.Rows.Count / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Filter and sort data
if (!DataHelper.DataSourceIsEmpty(table))
{
if (!string.IsNullOrEmpty(filterWhereCondition))
{
// Make filter condition compatible with DataTables
var query = filterWhereCondition;
query = query.Replace("[", "");
query = query.Replace("]", "");
query = query.Replace("N'%", "'%");
query = query.Replace("N'", "'");
table.DefaultView.RowFilter = query;
//Save filter condition to ViewState
FilterCurrentWhereCondition = query;
}
string orderBy = GetOrderByExpression(info);
table.DefaultView.Sort = orderBy;
// Update correct ID for direct page control
pagerElem.DirectPageControlID = ((float)table.Rows.Count / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
if (ValidationHelper.GetString(table.Rows[0][codeNameColumnName], null) == null)
{
codeNameColumnName = info.TypeInfo.GUIDColumn;
}
}
}
// Prepare checkBox column
TemplateField checkBoxField = (TemplateField)gvObjects.Columns[0];
checkBoxField.HeaderText = GetString("General.Import");
// Prepare name field
TemplateField nameField = (TemplateField)gvObjects.Columns[1];
nameField.HeaderText = GetString("general.displayname");
if (!DataHelper.DataSourceIsEmpty(table) && table != null && table.DefaultView.Count > 0)
{
plcObjects.Visible = true;
lblNoData.Visible = false;
gvObjects.DataSource = table;
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
PagedDataSource pagedDS = gvObjects.DataSource as PagedDataSource;
if (pagedDS != null)
{
if (pagedDS.PageSize <= 0)
{
gvObjects.DataSource = table;
}
}
gvObjects.DataBind();
}
else
{
plcObjects.Visible = false;
lblNoData.Visible = true;
lblNoData.Text = String.Format(GetString("ImportGridView.NoData"), GetString("objecttype." + ObjectType.Replace(".", "_").Replace("#", "_")));
}
}
else
{
plcGrid.Visible = false;
}
// Disable license selection
bool enable = !((ObjectType == LicenseKeyInfo.OBJECT_TYPE) && Settings.IsOlderVersion);
gvObjects.Enabled = enable;
pnlLinks.Enabled = enable;
lblInfo.Text = enable ? GetString("ImportGridView.Info") : GetString("ImportGridView.Disabled");
}
else
{
pnlGrid.Visible = false;
gvObjects.DataSource = null;
gvObjects.DataBind();
}
}
private void GenerateColumns(GridView newGrid)
{
// the buttons column
TemplateField templ = new TemplateField();
GridViewTemplate btnTemplate = new GridViewTemplate(ListItemType.Item, GridViewTemplate.BUTTONS, FIELDS[0], BASE_CONTROL_NAME + 0);
btnTemplate.whatif = isWhatif;
btnTemplate.wantCopyButton = wantCopyButton;
templ.ItemTemplate = btnTemplate;
templ.EditItemTemplate = new GridViewTemplate(ListItemType.EditItem, GridViewTemplate.BUTTONS, FIELDS[0], null);
if (!isWhatif)
{
templ.FooterTemplate = new GridViewTemplate(ListItemType.Footer, GridViewTemplate.BUTTONS, FIELDS[0], null);
}
newGrid.Columns.Add(templ);
// data columns - standard and edit mode; footer
for (int i = 1; i < FIELDS.Length; i++)
{
TemplateField template = new TemplateField();
if (HEADER_TOOLTIPS != null)
{
template.HeaderTemplate = new GridViewTemplate(HEADERS[i], HEADER_TOOLTIPS[i], LABEL_IDS[i]);
}
else
{
template.HeaderText = HEADERS[i];
}
// standard mode
GridViewTemplate itemTemplate;
if (CHECKBOXES[i])
{
itemTemplate = new GridViewTemplate(ListItemType.Item, GridViewTemplate.CHECKBOX_DATA, FIELDS[i], LABEL_IDS[i]);
}
else
{
itemTemplate = new GridViewTemplate(ListItemType.Item, GridViewTemplate.DATA, FIELDS[i], LABEL_IDS[i]);
}
template.ItemTemplate = new CompiledBindableTemplateBuilder(delegate(Control container)
{
itemTemplate.InstantiateIn(container);
},
delegate(Control container)
{
OrderedDictionary dict = new OrderedDictionary();
for (int j = 1; j < FIELDS.Length; j++)
{
if (CHECKBOXES[j])
{
dict[FIELDS[j]] = ((CheckBox)container.FindControl(LABEL_IDS[j])).Checked;
}
else
{
dict[FIELDS[j]] = ((Label)container.FindControl(LABEL_IDS[j])).Text;
}
}
return(dict);
});
// edit mode
GridViewTemplate editTemplate;
if (COMBOS[i] && (!nonEdits || !fieldsNonEditable[i]))
{
editTemplate = new GridViewTemplate(ListItemType.EditItem, GridViewTemplate.COMBODATA, FIELDS[i], TEXT_BOX_IDS[i], GetDropList(FIELDS[i]));
}
else if (CHECKBOXES[i])
{
editTemplate = new GridViewTemplate(ListItemType.EditItem, GridViewTemplate.CHECKBOX_DATA, FIELDS[i], TEXT_BOX_IDS[i]);
}
else
{
if (nonEdits && fieldsNonEditable[i])
{
editTemplate = new GridViewTemplate(ListItemType.Item, GridViewTemplate.DATA, FIELDS[i], TEXT_BOX_IDS[i]);
}
else
{
editTemplate = new GridViewTemplate(ListItemType.EditItem, GridViewTemplate.DATA, FIELDS[i], TEXT_BOX_IDS[i]);
}
}
template.EditItemTemplate = new CompiledBindableTemplateBuilder(delegate(Control container)
{
editTemplate.InstantiateIn(container);
},
delegate(Control container)
{
OrderedDictionary dict = new OrderedDictionary();
for (int j = 1; j < FIELDS.Length; j++)
{
if (nonEdits && fieldsNonEditable[j])
{
dict[FIELDS[j]] = ((Label)container.FindControl(TEXT_BOX_IDS[j])).Text;
}
else if (COMBOS[j])
{
dict[FIELDS[j]] = ((AjaxControlToolkit.ComboBox)container.FindControl(TEXT_BOX_IDS[j])).Text;
}
else if (CHECKBOXES[j])
{
dict[FIELDS[j]] = ((CheckBox)container.FindControl(TEXT_BOX_IDS[j])).Checked;
}
else
{
dict[FIELDS[j]] = ((TextBox)container.FindControl(TEXT_BOX_IDS[j])).Text;
}
}
return(dict);
});
// footer
if (!isWhatif)
{
if (COMBOS[i])
{
template.FooterTemplate = new GridViewTemplate(ListItemType.Footer, GridViewTemplate.COMBODATA, FIELDS[i], TEXT_BOX_IDS[i], GetDropList(FIELDS[i]));
}
else if (CHECKBOXES[i])
{
template.FooterTemplate = new GridViewTemplate(ListItemType.Footer, GridViewTemplate.CHECKBOX_DATA, FIELDS[i], TEXT_BOX_IDS[i]);
}
else
{
template.FooterTemplate = new GridViewTemplate(ListItemType.Footer, GridViewTemplate.DATA, FIELDS[i], TEXT_BOX_IDS[i]);
}
}
// add new column
newGrid.Columns.Add(template);
}
}
protected override void CreateChildControls()
{
base.CreateChildControls();
// TODO: add custom rendering code here.
// Label label = new Label();
// label.Text = "Hello World";
// this.Controls.Add(label);
this._gviewTaskForOut = new SPGridView();
this._gviewTaskForOut.RowDataBound += new GridViewRowEventHandler(_gviewTaskForOut_RowDataBound);
//HyperLinkField hlf = new HyperLinkField();
////hlf.HeaderStyle.ForeColor = Color.Gray;
//hlf.HeaderStyle.Font.Bold = true;
//hlf.HeaderText = colNames[0].Split(':')[1];
//hlf.DataTextField = colNames[0].Split(':')[0];
//hlf.DataNavigateUrlFields = new string[] { "TaskStorageID", "StorageInID"};
//hlf.DataNavigateUrlFormatString = SPContext.Current.Web.Url + "/WorkPages/StorageIn/QualityControlManage.aspx?TaskStorageID={0}&StorageInID={1}";
TemplateField tfieldHyperLink = new TemplateField();
tfieldHyperLink.ItemTemplate = new HyperLinkTemplate("待办事项", DataControlRowType.DataRow, "TaskType", "TaskTitle");
tfieldHyperLink.HeaderTemplate = new HyperLinkTemplate("待办事项", DataControlRowType.Header);
this._gviewTaskForOut.Columns.Add(tfieldHyperLink);
for (int i = 1; i < colNames.Length; i++)
{
BoundField bf = new BoundField();
//bf.HeaderStyle.ForeColor = Color.Gray;
bf.HeaderStyle.Font.Bold = true;
bf.HeaderText = colNames[i].Split(':')[1];
bf.DataField = colNames[i].Split(':')[0];
if (i == 1)
{
bf.DataFormatString = "{0:yyyy-MM-dd HH:mm dddd}";
}
//if (i == 3)
//{
// TableItemStyle tis = new TableItemStyle();
// tis.ForeColor = System.Drawing.Color.Red;
// bf.DataFormatString = "";
//}
this._gviewTaskForOut.Columns.Add(bf);
}
this._gviewTaskForOut.AutoGenerateColumns = false;
this._gviewTaskForOut.GridLines = GridLines.None;
this._gviewTaskForOut.CssClass = "ms-vh2 padded headingfont";
//string curLoginName = SPContext.Current.Web.CurrentUser.LoginName;
using (WebPartMMSProDBDataContext dc = new WebPartMMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//this._gviewTaskForOut.DataSource = from t in dc.StorageOutTask
// join e1 in dc.EmpInfo on t equals e1.EmpID
this._gviewTaskForOut.DataSource = (from t in dc.StorageOutTask
join e1 in dc.EmpInfo on t.TaskTargetID equals e1.EmpID
join e2 in dc.EmpInfo on t.TaskCreaterID equals e2.EmpID
where e1.Account.ToLower() == SPContext.Current.Web.CurrentUser.LoginName.ToLower()
orderby t.TaskID descending
select new
{
t.TaskID,
t.TaskTitle,
t.CreateTime,
e2.EmpName,
t.TaskState,
t.NoticeID,
t.TaskType,
t.Process
}).Take(8);
this._gviewTaskForOut.DataBind();
}
int colLastIndex = this._gviewTaskForOut.Columns.Count - 2;
int rowLastIndex = this._gviewTaskForOut.Rows.Count - 1;
for (int i = 0; i <= rowLastIndex; i++)
{
if (this._gviewTaskForOut.Rows[i].Cells[colLastIndex].Text == "已完成")
{
this._gviewTaskForOut.Rows[i].Cells[colLastIndex].ForeColor = System.Drawing.Color.Green;
}
else
{
this._gviewTaskForOut.Rows[i].Cells[colLastIndex].ForeColor = System.Drawing.Color.Red;
}
}
Literal L1 = new Literal();
L1.Text = "<table style='width:100%; text-align:right'><tr><td><a href='WorkPages/DocAndIndexManager/MoreTaskOfStorageOut.aspx'>更多待办事项...</a></td></tr></table>";
this.Controls.Add(this._gviewTaskForOut);
this.Controls.Add(L1);
this.Title = "出库待办事项";
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
// Initialize strings
btnAll.Text = GetString("ImportExport.All");
btnNone.Text = GetString("export.none");
btnDefault.Text = GetString("General.Default");
// Get object info
GeneralizedInfo info = ModuleManager.GetReadOnlyObject(ObjectType);
if (info != null)
{
gvObjects.RowDataBound += gvObjects_RowDataBound;
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Get data source
var where = Settings.GetObjectWhereCondition(ObjectType, SiteObject);
var orderBy = GetOrderByExpression(info);
// Prepare the columns
string columns = null;
if (info.CodeNameColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN)
{
columns += info.CodeNameColumn;
}
if ((info.DisplayNameColumn.ToLowerCSafe() != info.CodeNameColumn.ToLowerCSafe()) && (info.DisplayNameColumn != ObjectTypeInfo.COLUMN_NAME_UNKNOWN))
{
if (columns != null)
{
columns += ", ";
}
columns += info.DisplayNameColumn;
}
// Get the data query
var q = info.GetDataQuery(
true,
s => s
.Where(where)
.OrderBy(orderBy)
.Columns(columns),
false
);
q.IncludeBinaryData = false;
q.Offset = CurrentOffset;
q.MaxRecords = CurrentPageSize;
// Get the data
DataSet ds = q.Result;
pagerForceNumberOfResults = q.TotalRecords;
// Set correct ID for direct page contol
pagerElem.DirectPageControlID = ((float)pagerForceNumberOfResults / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
// Prepare checkbox field
TemplateField checkBoxField = (TemplateField)gvObjects.Columns[0];
checkBoxField.HeaderText = GetString("General.Export");
// Prepare display name field
TemplateField nameField = (TemplateField)gvObjects.Columns[1];
nameField.HeaderText = GetString("general.displayname");
// Load data
if (!DataHelper.DataSourceIsEmpty(ds))
{
plcObjects.Visible = true;
lblNoData.Visible = false;
gvObjects.DataSource = ds;
gvObjects.DataBind();
}
else
{
plcObjects.Visible = false;
lblNoData.Visible = true;
lblNoData.Text = String.Format(GetString("ExportGridView.NoData"), GetString("objecttype." + ObjectType.Replace(".", "_").Replace("#", "_")));
}
}
else
{
plcGrid.Visible = false;
}
}
else
{
pnlGrid.Visible = false;
gvObjects.DataSource = null;
gvObjects.DataBind();
}
}
public bool MakeUnversioned([NotNull] TemplateField fieldDefinition)
{
Assert.ArgumentNotNull(fieldDefinition, nameof(fieldDefinition));
return(MakeUnversioned(fieldDefinition.ID, Owner.GetSharingType(fieldDefinition)));
}
/// <summary>
/// 初始化
/// </summary>
/// <param name="gv"></param>
/// <param name="columnSet"></param>
/// <param name="rowCreate"></param>
/// <param name="rowDataCollect"></param>
/// <param name="multiSelect">null: 不选择 true: 多选（checkbox）false: 单选</param>
public void Initialize(GridView gv,
Action <ColumnSetter> columnSet,
Action <RowCreator> rowCreate = null,
Action <RowCollector> rowDataCollect = null,
GridWrapper.SelectionMode mode = SelectionMode.None, bool showRowNumber = true, bool showFooter = true)
{
_Grid = gv;
_Mode = mode;
gv.CssClass = "grid";
gv.ShowFooter = showFooter;
gv.ShowHeaderWhenEmpty = true;
gv.ShowHeader = true;
gv.AutoGenerateColumns = false;
gv.RowStyle.CssClass = "gridRow";
if (gv.RowStyle.Height == Unit.Empty)
{
gv.RowStyle.Height = 20;
}
List <DataControlField> columns = new List <DataControlField>();
if (showRowNumber)
{
var c = new TemplateField()
{
HeaderTemplate = new TemplateItem.Label(l => l.Text = "#")
{
Id = "__lb_Header"
},
ItemTemplate = new TemplateItem.Label()
{
Id = "__lb"
}
};
c.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;
c.HeaderStyle.Width = 30;
c.ItemStyle.CssClass = "gridItem-bound-n";
c.ItemStyle.Width = 30;
c.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
if (!_RowButtonVisible)
{
c.ItemStyle.CssClass = "gridItem-bound-n-b";
}
columns.Add(c);
}
switch (_Mode)
{
case SelectionMode.Multiple:
var c = new TemplateField()
{
HeaderTemplate = new TemplateItem.CheckBox(cc =>
{
cc.Attributes["onclick"] = "ISEx.toggleCBs(this,'__cb')";
})
{
Id = "__cb_Header"
},
ItemTemplate = new TemplateItem.CheckBox()
{
Id = "__cb"
}
};
c.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
c.HeaderStyle.Width = 20;
c.ItemStyle.CssClass = "gridItem-template";
c.ItemStyle.Width = 20;
c.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
columns.Add(c);
break;
case SelectionMode.Single:
c = new TemplateField()
{
ItemTemplate = new TemplateItem.Button(b =>
{
b.ID = "__b";
b.Text = "选";
b.Height = 20;
if (!_RowButtonVisible)
{
b.Style.Add("display", "none");
}
})
};
c.ItemStyle.CssClass = "gridItem-hidden";
columns.Add(c);
break;
}
//if (gv.Columns.Count == 0)
//{
// columns.ForEach(c => gv.Columns.Add(c));
//}
//else
//{
// for (int i = 0; i < columns.Count; i++) gv.Columns.Insert(i, columns[i]);
//}
columns.ForEach(c => gv.Columns.Add(c));
if (columnSet != null)
{
columnSet(new ColumnSetter(gv));
}
gv.RowCreated += (s, e) =>
{
if (rowCreate != null)
{
rowCreate(new RowCreator(e.Row));
}
};
gv.RowDataBound += (s, e) =>
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
/// 处理具有特殊约定的控件
/// __lb：行序号
/// __cb：行选择控件
/// __b： 行按钮（用于单选一行）
e.Row.FindControl("__lb").If <Label>(l => l.Text = (e.Row.RowIndex + 1).ToString());
e.Row.FindControl("__cb").If <CheckBox>(cc =>
{
cc.Attributes["onclick"] =
string.Format("{0}.selection[{1}]=this.checked;ISEx.toggleCB(this);", ClientID, e.Row.RowIndex.ToString());
});
e.Row.FindControl("__b").If <Button>(b =>
{
b.CommandName = "S";
b.CommandArgument = e.Row.RowIndex.ToString();
b.OnClientClick = RowButtonClientClick;
if (!_RowButtonVisible)
{
if (_DblClickToSelect)
{
e.Row.Attributes["ondblclick"] =
Page.ClientScript.GetPostBackEventReference(b, string.Empty);
}
else
{
e.Row.Attributes["onclick"] =
Page.ClientScript.GetPostBackEventReference(b, string.Empty);
}
}
});
}
};
gv.RowCommand += (s, e) =>
{
switch (e.CommandName)
{
// 行选
case "S":
int index = _Util.Convert <int>(e.CommandArgument);
foreach (GridViewRow r in gv.Rows)
{
r.CssClass = "gridRow";
}
gv.Rows[index].CssClass = "gridRow-selected";
if (rowDataCollect != null)
{
Dictionary <string, object> data = new Dictionary <string, object>();
RowCollector rc = new RowCollector(gv.Rows[index], data);
rowDataCollect(rc);
}
break;
// 排序表头
case "O":
// 备份排序信息
List <KeyValuePair <string, bool> > sorts = new List <KeyValuePair <string, bool> >();
List <GridHeaderSorter> sorters = GetSorters();
for (int i = 0; i < sorters.Count; i++)
{
if (sorters[i].FieldName == e.CommandArgument.ToStringEx())
{
if (sorters[i].Sort.HasValue)
{
sorters[i].Sort = !sorters[i].Sort.Value;
}
else
{
sorters[i].Sort = true;
}
sorts.Add(new KeyValuePair <string, bool>(sorters[i].FieldName, sorters[i].Sort.Value));
}
}
// 发出事件
if (Sort != null)
{
Sort(this, EventArgs.Empty);
}
// 回写排序状态信息
sorters = GetSorters();
sorters.ForEach(ss => ss.Sort = null);
foreach (var ss in sorts)
{
sorters.ForEach(
sss =>
{
if (sss.FieldName == ss.Key)
{
sss.Sort = ss.Value;
}
sss.Caption = ss.Value.ToString();
});
}
break;
}
};
}
/// <summary>
/// Bind the data.
/// </summary>
public void Bind()
{
if (!string.IsNullOrEmpty(ObjectType))
{
pnlGrid.Visible = true;
// Initialize strings
btnAll.Text = GetString("ImportExport.All");
btnNone.Text = GetString("export.none");
btnDefault.Text = GetString("General.Default");
// Get object info
GeneralizedInfo info = CMSObjectHelper.GetReadOnlyObject(ObjectType);
if (info != null)
{
plcGrid.Visible = true;
codeNameColumnName = info.CodeNameColumn;
displayNameColumnName = info.DisplayNameColumn;
// Get data source
string where = GenerateWhereCondition();
string orderBy = GetOrderByExpression(info);
// Prepare the columns
string columns = null;
if (info.CodeNameColumn != TypeInfo.COLUMN_NAME_UNKNOWN)
{
columns += info.CodeNameColumn;
}
if ((info.DisplayNameColumn.ToLower() != info.CodeNameColumn.ToLower()) && (info.DisplayNameColumn != TypeInfo.COLUMN_NAME_UNKNOWN))
{
if (columns != null)
{
columns += ", ";
}
columns += info.DisplayNameColumn;
}
DataSet ds = info.GetData(null, where, orderBy, -1, columns, false, CurrentOffset, CurrentPageSize, ref pagerForceNumberOfResults);
// Set correct ID for direct page contol
pagerElem.DirectPageControlID = ((float)pagerForceNumberOfResults / pagerElem.CurrentPageSize > 20.0f) ? "txtPage" : "drpPage";
// Call page binding event
if (OnPageBinding != null)
{
OnPageBinding(this, null);
}
// Prepare checkbox field
TemplateField checkBoxField = (TemplateField)gvObjects.Columns[0];
checkBoxField.HeaderText = GetString("General.Export");
// Prepare display name field
TemplateField nameField = (TemplateField)gvObjects.Columns[1];
nameField.HeaderText = GetString("general.displayname");
// Load data
if (!DataHelper.DataSourceIsEmpty(ds))
{
plcObjects.Visible = true;
lblNoData.Visible = false;
gvObjects.DataSource = ds;
gvObjects.DataBind();
}
else
{
plcObjects.Visible = false;
lblNoData.Visible = true;
lblNoData.Text = String.Format(GetString("ExportGridView.NoData"), GetString("objecttype." + ObjectType.Replace(".", "_").Replace("#", "_")));
}
}
else
{
plcGrid.Visible = false;
}
}
else
{
pnlGrid.Visible = false;
gvObjects.DataSource = null;
gvObjects.DataBind();
}
}
}//Page_Load
/// <summary>PageBuild().</summary>
public void PageBuild()
{
int dataTableCount = -1;
int dataTableTotal = -1;
int theWordIdColumnIndex = 0;
DateTime dated = DateTime.Now;
System.Web.UI.WebControls.Label label = null;
String columnNameForeignKey = null;
String exceptionMessage = null;
String[] sourceName = null;
String[] sourceSQL = null;
String tableName = null;
System.Web.UI.WebControls.TextBox textBox = null;
XmlNodeList sourceXML = null;
TheWord.SourceSQLQuery
(
filenameConfigurationXml,
ref exceptionMessage,
ref sourceXML,
ref sourceSQL,
ref sourceName
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
if ( !Page.IsPostBack )
{
theWord.DataSetInitialize
(
databaseConnectionString,
ref exceptionMessage,
nodeRoot,
sourceSQL,
sourceName
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
}//if ( Page.IsPostBack )
UtilityXml.XmlDocumentNodeInnerText
(
filenameConfigurationXml,
ref exceptionMessage,
TheWord.XPathColumnForeign,
ref columnNameForeignKey
);
dataTableTotal = theWord.DataSetTheWord.Tables.Count;
GridViewTheWord = new System.Web.UI.WebControls.GridView[ dataTableTotal ];
linkButtonAdd = new System.Web.UI.WebControls.LinkButton[ dataTableTotal ];
for( dataTableCount = 0; dataTableCount < theWord.DataSetTheWord.Tables.Count; ++dataTableCount )
{
theWord.DataSetTheWord.Tables[dataTableCount].TableName = sourceName[dataTableCount];
}
dataTableCount = -1;
foreach( DataTable dataTable in theWord.DataSetTheWord.Tables )
{
++dataTableCount;
GridViewTheWord[dataTableCount] = new System.Web.UI.WebControls.GridView();
tableName = dataTable.TableName;
GridViewTheWord[dataTableCount].BorderWidth = 1;
GridViewTheWord[dataTableCount].CellPadding = 1;
GridViewTheWord[dataTableCount].DataSource = dataTable;
GridViewTheWord[dataTableCount].AllowPaging = true;
GridViewTheWord[dataTableCount].AllowSorting = true;
GridViewTheWord[dataTableCount].AutoGenerateColumns = false;
GridViewTheWord[dataTableCount].AutoGenerateDeleteButton = true;
GridViewTheWord[dataTableCount].AutoGenerateEditButton = true;
GridViewTheWord[dataTableCount].AutoGenerateSelectButton = true;
switch ( DataColumnFieldGridView )
{
case DataColumnField.Bound:
foreach( DataColumn dataColumn in dataTable.Columns )
{
BoundField boundField = null;
boundField = new BoundField();
boundField.DataField = dataColumn.ColumnName;
boundField.HeaderText = dataColumn.ColumnName;
boundField.SortExpression = dataColumn.ColumnName;
GridViewTheWord[dataTableCount].Columns.Add( boundField );
}
break;
case DataColumnField.Template:
foreach( DataColumn dataColumn in dataTable.Columns )
{
TemplateField templateField = null;
//System.Web.UI.WebControls.Label label = null;
templateField = new TemplateField();
templateField.HeaderText = dataColumn.ColumnName;
templateField.SortExpression = dataColumn.ColumnName;
//templateField.EditItemTemplate = new DataGridTemplate(ListItemType.EditItem, dataColumn.ColumnName);
//templateField.FooterTemplate = new DataGridTemplate(ListItemType.Footer, dataColumn.ColumnName);
//templateField.HeaderTemplate = new DataGridTemplate(ListItemType.Header, dataColumn.ColumnName);
templateField.ItemTemplate = new DataGridTemplate(ListItemType.Item, dataColumn.ColumnName);
GridViewTheWord[dataTableCount].Columns.Add( templateField );
}
break;
case DataColumnField.TextBox:
PlaceHolderGridView.Controls.Add
(
new LiteralControl
(
"<b>" + tableName + "</b><br />"
)
);
foreach( DataColumn dataColumn in dataTable.Columns )
{
label = new System.Web.UI.WebControls.Label();
//label.Id = dataColumn.ColumnName;
label.Text = dataColumn.ColumnName + ": ";
PlaceHolderGridView.Controls.Add( label );
textBox = new System.Web.UI.WebControls.TextBox();
//textBox.Name = dataColumn.ColumnName;
textBox.Text = dataColumn.ColumnName;
PlaceHolderGridView.Controls.Add( textBox );
label = new System.Web.UI.WebControls.Label();
label.Text = "<br />";
PlaceHolderGridView.Controls.Add( label );
}
break;
}
GridViewTheWord[dataTableCount].DataBind();
GridViewTheWord[dataTableCount].ID = tableName;
theWordIdColumnIndex = UtilityDatabase.DataTableColumnIndex
(
theWord.DataSetTheWord.Tables[tableName],
columnNameForeignKey
);
if ( DataColumnFieldGridView <= DataColumnField.Template )
{
if ( theWordIdColumnIndex >= 0 )
{
//UtilityDatabase.DataSetTableColumnVisible( GridViewTheWord[dataTableCount], theWordIdColumnIndex, false );
GridViewTheWord[dataTableCount].Columns[theWordIdColumnIndex].Visible = false;
}//if ( theWordIdColumnIndex >= 0 )
//GridViewTheWord[dataTableCount].UserDeletingRow += new GridViewRowCancelEventHandler( GridViewDeleteEventArgs );
PlaceHolderGridView.Controls.Add
(
new LiteralControl
(
"<b>" + GridViewTheWord[dataTableCount].ID + "</b>"
)
);
}
if ( dataTableCount != 0 )
{
linkButtonAdd[dataTableCount] = new System.Web.UI.WebControls.LinkButton();
linkButtonAdd[dataTableCount].ID = dataTableCount + "|" + tableName + "|" + "Add";
linkButtonAdd[dataTableCount].Text = "Add <br />";
// Register the event-handling method for the Click event.
linkButtonAdd[dataTableCount].Click += new EventHandler(this.LinkButtonAdd_Click);
PlaceHolderGridView.Controls.Add( linkButtonAdd[dataTableCount] );
}
if ( DataColumnFieldGridView <= DataColumnField.Template )
{
PlaceHolderGridView.Controls.Add(GridViewTheWord[dataTableCount]);
PlaceHolderGridView.Controls.Add(new LiteralControl("<br />"));
}
}//foreach( DataTable dataTable in theWord.DataSetTheWord.Tables )
}//public static void PageBuild()
public sealed override bool ChangeFieldSharing(TemplateField fieldDefinition, TemplateFieldSharing sharing, CallContext context)
{
throw new NotSupportedException(MustNotBeCalled);
}
private void InitializeCustomControls()
{
this.spgviewAuditControl = new SPGridView();
this.spgviewAuditControl.AutoGenerateColumns = false;
this.spgviewAuditControl.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
string[] ShowTlist =
{
"交货通知单编号:CommitInCode",
"入库单号:CommitInQualifiedNum",
"物料名称:MaterialName",
"物料编码:MaterialCode",
"规格型号:SpecificationModel",
"质检合格根/套/件数量:QuantityGentaojian",
"质检合格米数量:QuantityMetre",
"质检合格吨数量:QuantityTon",
"所选单位数量:Quantity",
"计量单位:CurUnit",
"质检时间:InspectionTime",
"检验报告号:InspectionReportNum",
"单价:UnitPrice",
"金额:Amount",
"所属仓库:StorageName",
"所属垛位:PileCode",
"财务编号:financeCode",
"到库时间:StorageTime",
"供应商:SupplierName",
"物资管理员:MaterialsManager",
"仓库员:WarehouseWorker",
"备注:Remark"
};
string[] HideTlist =
{
"SupplierIDCol:SupplierID",
"MaterialsManagerIDCol:MaterialsManagerID",
"WarehouseWorkerIDCol:WarehouseWorkerID",
};
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewAuditControl.Columns.Add(bfColumn);
}
//为SPGridView添加状态列
TemplateField tlfAudit = new TemplateField();
tlfAudit.HeaderText = "状态";
tlfAudit.ItemTemplate = new LabelTemplate("状态", DataControlRowType.DataRow);
this.spgviewAuditControl.Columns.Add(tlfAudit);
CommandField cdf = new CommandField();
cdf.HeaderText = "审核";
cdf.SelectText = "通过/未通过";
cdf.ShowSelectButton = true;
this.spgviewAuditControl.SelectedIndexChanging += new GridViewSelectEventHandler(spgviewAuditControl_SelectedIndexChanging);
this.spgviewAuditControl.Columns.Add(cdf);
//添加隐藏列
foreach (var kvp in HideTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgviewAuditControl.Columns.Add(bfColumn);
}
//添加控件到panel1
btnSend = new Button();
btnSend.Text = "生成审核清单";
btnSend.Enabled = false;
btnSend.Width = 100;
btnSend.Click += new EventHandler(btnSend_Click);
btnCancel = new Button();
btnCancel.Text = "返回";
btnCancel.Width = 100;
btnCancel.Click += new EventHandler(btnCancel_Click);
chbAuditAll = new CheckBox();
chbAuditAll.Checked = false;
chbAuditAll.AutoPostBack = true;
chbAuditAll.Text = "<font size = 2pt>全部通过审核</font>";
chbAuditAll.CheckedChanged += new EventHandler(chbAuditAll_CheckedChanged);
//验证任务是否已经完成
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"]));
if (tsi.TaskState == "已完成")
{
this.chbAuditAll.Enabled = false;
cdf.Visible = false;
}
}
}
protected void createGridView()
{
string query = createQuery(listSection1.SelectedValue);
hideQuery.Value = query;
if (query != "")
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
DataSet data = opt.CreateDataSetOra(query);
GridView1.Columns.Clear();
TemplateField customField = new TemplateField();
////增加当前选择列
customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new MSYS.GridViewTemplate(DataControlRowType.Header, "选择", "");
customField.ItemTemplate = new MSYS.GridViewTemplate(DataControlRowType.DataRow, "sel", "CheckBox");
ViewState["ck_sel"] = true;
GridView1.Columns.Add(customField);
/////增加路径名列
customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new MSYS.GridViewTemplate(DataControlRowType.Header, "路径名称", "");
customField.ItemTemplate = new MSYS.GridViewTemplate(DataControlRowType.DataRow, "Pathname", "TextBox");
ViewState["txt_Pathname"] = true;
GridView1.Columns.Add(customField);
/////增加路径编码
customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new MSYS.GridViewTemplate(DataControlRowType.Header, "路径编码", "");
customField.ItemTemplate = new MSYS.GridViewTemplate(DataControlRowType.DataRow, "Pathcode", "TextBox");
ViewState["txt_Pathcode"] = true;
GridView1.Columns.Add(customField);
//增加节点列
for (int j = 2; j < data.Tables[0].Columns.Count - 2; j++)
{
customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new MSYS.GridViewTemplate(DataControlRowType.Header, data.Tables[0].Columns[j].ColumnName, "");
customField.ItemTemplate = new MSYS.GridViewTemplate(DataControlRowType.DataRow, j.ToString(), "CheckBox");
ViewState["ck_" + j.ToString()] = true;
GridView1.Columns.Add(customField);
}
//增加保存按钮
MSYS.GridViewTemplate.SetButtonClickEvent((object sender, EventArgs e) => {
Button btn = (Button)sender;
GridView gv = (GridView)btn.NamingContainer.DataKeysContainer;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
int index = gvr.RowIndex;
string sectioncode = gv.DataKeys[index].Values[0].ToString();
string opathcode = gv.DataKeys[index].Values[1].ToString();
string[] seg = { "SECTION_CODE", "PATHCODE", "PATHNAME", "CREATE_TIME", "IS_DEL" };
string pathcode = "";
for (int i = 3; i < gv.Columns.Count - 1; i++)
{
pathcode += Convert.ToInt16(((CheckBox)gvr.FindControl("ck_" + (i - 1).ToString())).Checked).ToString();
}
((TextBox)gvr.FindControl("txt_Pathcode")).Text = pathcode;
string[] value = { sectioncode, pathcode, ((TextBox)gvr.FindControl("txt_Pathname")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "0" };
List <String> commandlist = new List <String>();
commandlist.Add("delete from HT_PUB_PATH_SECTION where SECTION_CODE = '" + sectioncode + "' and PATHCODE = '" + opathcode + "'");
commandlist.Add(opt.InsertDatastr(seg, value, "HT_PUB_PATH_SECTION"));
opt.TransactionCommand(commandlist);
});
customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new MSYS.GridViewTemplate(DataControlRowType.Header, "操作", "");
customField.ItemTemplate = new MSYS.GridViewTemplate(DataControlRowType.DataRow, "Grid1Save", "Button");
ViewState["btn_Grid1Save"] = true;
GridView1.Columns.Add(customField);
}
}
//private void FillSettingValue()
//{
// AdminBLL BLL = new AdminBLL();
// BLL.FilldefaultValues();
// if (HttpContext.Current.Items["Welcome_heading"] != null)
// {
// lblWelcom_Heading.Text = HttpContext.Current.Items["Welcome_heading"].ToString();
// }
//}
private void BindGuardSchedule()
{
DateTime temp;
//if (DateTime.TryParse(date, out temp))
if (Session["LCID"] != null)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@LocationID", Session["LCID"].ToString());
//para[1] = new SqlParameter("@CurrentTime", DateTime.Now.ToShortTimeString());
//para[1] = new SqlParameter("@MDate", date);
//DataTable dt = dal.executeprocedure1("usp_GetDailySchedule1", para, false);
//==========================Working Code Date:11/7/2012=====================//
//=================Purpose:Show Grid which Shows Current User With Current Time======//
/*
* DataTable dt = dal.executeprocedure("SP_DescriptionDashBoard",para, false);
* if (dt.Rows.Count > 0)
* {
* grdSchedule.DataSource = dt;
* grdSchedule.DataBind();
* }
* else
* {
* grdSchedule.DataSource = null;
* grdSchedule.DataBind();
* }*/
//=======================================================================//
//=========================Changes By:Sandeep Date:16/6/2012========================//
dt = dal.executeprocedure("usp_GetDailyScheduleLatestForDistinctGaurds", para, false);
//==================================================================================//
DataTable dt1 = SMSCommons.SMSCommon.ConvertRowsToColumns(dt, "Shift", "StaffName");
//DataTable dt1 = SMSCommons.smscom.ConvertRowsToColumns(dt, "Shift", "StaffName");
grdSchedule.AutoGenerateColumns = false;
for (int i = 0; i < grdSchedule.Columns.Count; i++)
{
try
{
grdSchedule.Columns.RemoveAt(0);
i--;
}
catch (Exception ex)
{
}
}
foreach (DataColumn dc in dt1.Columns)
{
TemplateField makeliveCol = new TemplateField();
// makeliveCol.ItemTemplate = new CreateItemTemplateLinkBtn(System.Guid.NewGuid().ToString().Split('-')[System.Guid.NewGuid().ToString().Split('-').Length - 1], dc.ColumnName, "MakeLive", "return confirm('Are you sure you want to publish this version?')");
// makeliveCol.ItemTemplate = new
makeliveCol.HeaderText = dc.ColumnName;
makeliveCol.HeaderStyle.Width = Unit.Pixel(180);
makeliveCol.ItemStyle.Height = Unit.Pixel(30);
makeliveCol.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
makeliveCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
makeliveCol.HeaderStyle.ForeColor = System.Drawing.Color.White;
grdSchedule.Columns.Add(makeliveCol);
//grdMy.Columns.Add(makeliveCol);
}
grdSchedule.DataSource = dt1;
grdSchedule.DataBind();
string script = "";
//=========================Changes By:Date:11/7/2012============================================//
// ==========Purpose:To show the same grid as in Login.aspx page for current assigned users=====//
//try
//{
// int grdcount = grdSchedule.Rows.Count;
// foreach (GridViewRow gvrSecurity in grdSchedule.Rows)
// {
// int gvrgrid = gvrSecurity.Cells.Count;
// foreach (TableCell tcSecurity in gvrSecurity.Cells)
// {
// LinkButton lnkUser = new LinkButton();
// lnkUser = ((LinkButton)tcSecurity.Controls[0]);
// //string xx = dt1.Rows[countTC][countGR].ToString();
// string xx = dt1.Rows[grdSchedule.Rows.Count - grdcount][gvrSecurity.Cells.Count - gvrgrid].ToString();
// gvrgrid = gvrgrid - 1;
// if (gvrgrid == 0) { grdcount = grdcount - 1; }
// if (xx != "")
// {
// string[] yy = xx.Split('|');
// lnkUser.Text = yy[0].ToString();
// lnkUser.ToolTip = yy[4].ToString();
// lnkUser.ForeColor = Color.Black;
// lnkUser.Font.Bold = true;
// lnkUser.Font.Underline = false;
// lnkUser.Click += ViewDetails;
// lnkUser.CommandArgument = lnkUser.ToolTip.ToString();
// }
// //=======Changes By:Sandeep Date:22/6/2012========//
// string StaffID = lnkUser.ToolTip.ToString();
// //=========================================================//
// // lnkUser.PostBackUrl = "~/ADMIN/ProfileUser.aspx?t1=" + StaffID.ToString();
// }
// }
//}
//catch(Exception ex)
//{
//}
//============================End Changes==============================//
}
}
private void InitializeCustomControls()
{
InitBar();
//***初始化新建物资列表***//
this.spgvMaterial = new SPGridView();
this.spgvMaterial.AutoGenerateColumns = false;
this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("选择", DataControlRowType.DataRow);
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("选择", DataControlRowType.Header);
this.spgvMaterial.Columns.Add(tfieldCheckbox);
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvMaterial.Columns.Add(bfColumn);
}
//加入回收数量--根套件列
TemplateField tfQuantityGtj = new TemplateField();
tfQuantityGtj.HeaderText = "根/台/套/件";
tfQuantityGtj.ItemTemplate = new TextBoxTemplate("TotleGentaojian", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(4, tfQuantityGtj);
//加入回收数量--米列
TemplateField tfQuantityMetre = new TemplateField();
tfQuantityMetre.HeaderText = "米";
tfQuantityMetre.ItemTemplate = new TextBoxTemplate("TotleMetre", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(5, tfQuantityMetre);
//加入回收数量--吨列
TemplateField tfQuantityTon = new TemplateField();
tfQuantityTon.HeaderText = "吨";
tfQuantityTon.ItemTemplate = new TextBoxTemplate("TotleTon", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(6, tfQuantityTon);
//加入回收单号列
TemplateField tfRetrieveCode = new TemplateField();
tfRetrieveCode.HeaderText = "回收单号";
tfRetrieveCode.ItemTemplate = new TextBoxTemplate("回收单号", DataControlRowType.DataRow);
this.spgvMaterial.Columns.Insert(7, tfRetrieveCode);
//加入备注列
TemplateField tfRemark = new TemplateField();
tfRemark.HeaderText = "备注";
tfRemark.ItemTemplate = new TextBoxTemplate("备注", DataControlRowType.DataRow);
this.spgvMaterial.Columns.Insert(8, tfRemark);
//***初始化已加入物资列表***//
this.spgvExistMaterial = new SPGridView();
this.spgvExistMaterial.AutoGenerateColumns = false;
this.spgvExistMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
foreach (var kvp in ExistTitlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvExistMaterial.Columns.Add(bfColumn);
}
btnOK = (Button)GetControltByMaster("btnOK");
btnOK.Click += new EventHandler(btnOK_Click);
btnSearch = (Button)GetControltByMaster("btnSearch");
btnSearch.Click += new EventHandler(btnSearch_Click);
chbShowAll = (CheckBox)GetControltByMaster("chbShowAll");
chbShowAll.CheckedChanged += new EventHandler(chbShowAll_CheckedChanged);
txtMaterialName = GetControltByMaster("txtMaterialName") as TextBox;
txtFinanceCode = GetControltByMaster("txtFinanceCode") as TextBox;
txtSpecificationModel = GetControltByMaster("txtSpecificationModel") as TextBox;
}
private void InitializeCustomControls()
{
InitToolBar();
btnOK = (Button)GetControltByMaster("btnOK");
btnOK.Click += new EventHandler(btnOK_Click);
//初始化spgvMaterial
this.spgvMaterial = new SPGridView();
this.spgvMaterial.AutoGenerateColumns = false;
this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
this.spgvMaterial.AllowGrouping = true;
this.spgvMaterial.AllowGroupCollapse = true;
this.spgvMaterial.GroupDescriptionField = "Description";
if (bWriteOff)
{
this.spgvMaterial.GroupField = "StorageType";
this.spgvMaterial.GroupFieldDisplayName = "待入库物资类型";
}
else
{
this.spgvMaterial.GroupField = "MaterialName";
this.spgvMaterial.GroupFieldDisplayName = "回收检验合格物资";
}
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvMaterial.Columns.Add(bfColumn);
}
if (bWriteOff)
{
bfColumn = new BoundField();
bfColumn.HeaderText = "物资名称";
bfColumn.DataField = "MaterialName";
this.spgvMaterial.Columns.Insert(0, bfColumn);
bfColumn = new BoundField();
bfColumn.HeaderText = "规格型号";
bfColumn.DataField = "SpecificationModel";
this.spgvMaterial.Columns.Insert(1, bfColumn);
bfColumn = new BoundField();
bfColumn.HeaderText = "财务编码";
bfColumn.DataField = "FinanceCode";
this.spgvMaterial.Columns.Insert(2, bfColumn);
bfColumn = new BoundField();
bfColumn.HeaderText = "物资编码";
bfColumn.DataField = "MaterialCode";
this.spgvMaterial.Columns.Insert(3, bfColumn);
}
//加入备注列
TemplateField tfRemark = new TemplateField();
tfRemark.HeaderText = "备注";
tfRemark.ItemTemplate = new TextBoxTemplate("备注", DataControlRowType.DataRow, "Remark");
if (bWriteOff)
{
this.spgvMaterial.Columns.Insert(14, tfRemark);
}
else
{
this.spgvMaterial.Columns.Insert(10, tfRemark);
}
}
private static HotspotInfo CreateVariableTypeHotspot([NotNull] IDeclarationStatement declaration)
{
var variableDeclaration = declaration.VariableDeclarations[0];
var variableType = variableDeclaration.TypeUsage;
var typeText = variableType.GetText();
var typeRange = variableType.GetDocumentRange();
var uniqueFieldName = typeRange.TextRange.StartOffset.ToString();
var templateField = new TemplateField(uniqueFieldName, new NameSuggestionsExpression(new[] {typeText, "var"}), 0);
return new HotspotInfo(templateField, typeRange);
}
private void CrearAtributo(string atributo)
{
try
{
string[] atributos = atributo.Split(',');
Panel pnl = new Panel();
pnl.ID = "pnl" + atributos[0];
pnl.CssClass = "pnl-atributo";
Label lblTitulo = new Label();
lblTitulo.Text = atributos[1];
lblTitulo.ID = "lblAtributo" + atributos[0];
pnl.Controls.Add(lblTitulo);
ImageButton ibtnCancel = new ImageButton();
ibtnCancel.ID = "ibtnCancel" + atributos[0];
ibtnCancel.ImageUrl = "../images/cancel.png";
ibtnCancel.Click += ibtnCancel_Click;
pnl.Controls.Add(ibtnCancel);
Elemento_AtributoBC objElemento_AtributoBC = new Elemento_AtributoBC();
List <Elemento_AtributoBE> lstElemento_AtributoBE = new List <Elemento_AtributoBE>();
lstElemento_AtributoBE = objElemento_AtributoBC.Get_Elemento_Atributo_Atributo(Convert.ToInt32(atributos[0]));
GridView gvElementoAtributo = new GridView();
gvElementoAtributo.ID = "gvElementoAtributo" + atributos[0];
gvElementoAtributo.CssClass = "gridview";
gvElementoAtributo.AlternatingRowStyle.CssClass = "alt";
gvElementoAtributo.PagerStyle.CssClass = "pgr";
gvElementoAtributo.AutoGenerateColumns = false;
TemplateField tfCheck = new TemplateField();
gvElementoAtributo.Columns.Add(tfCheck);
BoundField bfNombre = new BoundField();
bfNombre.DataField = "Nombre";
bfNombre.HeaderText = "Nombre";
gvElementoAtributo.Columns.Add(bfNombre);
BoundField bfIdElemento = new BoundField();
bfIdElemento.DataField = "Id_Elemento_Atributo";
bfIdElemento.HeaderText = "Id_Elemento_Atributo";
bfIdElemento.Visible = false;
gvElementoAtributo.Columns.Add(bfIdElemento);
gvElementoAtributo.RowDataBound += gvElementoAtributo_RowDataBound;
gvElementoAtributo.DataSource = lstElemento_AtributoBE;
gvElementoAtributo.DataBind();
pnl.Controls.Add(gvElementoAtributo);
pnlAtributos.Controls.Add(pnl);
}
catch (Exception)
{
throw;
}
}
protected void BtnGetAttendance_Click(object sender, EventArgs e)
{
if (RBLAttendanceViewType.SelectedItem.Text.Equals("Compiled"))
{
GridView1.Visible = true;
GridView2.Visible = false;
if (LblSectionGroup.Text.Equals("Section"))
{
sql = "SELECT * FROM Attendance WHERE AttendanceTypeID=3 AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + ") AND SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + " AND SectionID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Date >= '" + TxtBxFromDate.Text + "' AND Date <= '" + TxtBxToDate.Text + "'";
}
else
{
sql = "SELECT * FROM Attendance WHERE AttendanceTypeID=3 AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + ") AND SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + " AND GroupID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Date >= '" + TxtBxFromDate.Text + "' AND Date <= '" + TxtBxToDate.Text + "'";
}
c = new Connect(sql);
DataTable attendance = c.ds.Tables[0];
// Calculate total classes held for the selected subject using LINQ.
var totalClasses = (from i in attendance.AsEnumerable() select new { Date = i.Field<DateTime>("Date"), LectureID = i.Field<int>("LectureID") }).Distinct().Count();
// Fetch the list of the students
if (LblSectionGroup.Text.Equals("Section"))
{
sql = "SELECT StudentNo,Name FROM Student WHERE SectionID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
}
else
{
sql = "SELECT StudentNo,Name FROM Student WHERE GroupID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
}
students = new Connect(sql);
GridView1.DataSource = students.ds;
GridView1.DataBind();
Label l = (Label)GridView1.HeaderRow.FindControl("LblPresentHeader");
l.Text += " from " + totalClasses.ToString();
// Calculate the total attendance for each student
foreach (GridViewRow row in GridView1.Rows)
{
int numberOfAbsent = 0;
for (int k = 0; k < c.ds.Tables[0].Rows.Count; k++)
{
if (c.ds.Tables[0].Rows[k]["StudentNo"].ToString().Equals(row.Cells[1].Text + " "))
{
numberOfAbsent = numberOfAbsent + 1;
}
}
Label totalPresent = (Label)row.FindControl("LblPresent");
totalPresent.Text = (totalClasses - numberOfAbsent).ToString();
Label percentageAttendance = (Label)row.FindControl("LblPercentageAttendance");
percentageAttendance.Text = (float.Parse(totalPresent.Text) * 100 / totalClasses).ToString();
if (float.Parse(percentageAttendance.Text) < 75)
{
row.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF8D7C");
}
}
}
else
{
// Fetch the list of the students
if (LblSectionGroup.Text.Equals("Section"))
{
sql = "SELECT StudentNo,Name FROM Student WHERE SectionID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
}
else
{
sql = "SELECT StudentNo,Name FROM Student WHERE GroupID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
}
students = new Connect(sql);
GridView2.DataSource = students.ds;
//GridView2.DataBind();
//Fetch the attendance for that section
if (LblSectionGroup.Text.Equals("Section"))
{
sql = "SELECT * FROM Attendance WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + " AND SectionID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Date >= '" + TxtBxFromDate.Text + "' AND Date <= '" + TxtBxToDate.Text + "'";
}
else
{
sql = "SELECT * FROM Attendance WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue) + " AND GroupID=" + int.Parse(DDLSectionGroup.SelectedValue) + " AND Date >= '" + TxtBxFromDate.Text + "' AND Date <= '" + TxtBxToDate.Text + "'";
}
c = new Connect(sql);
DataTable attendance = c.ds.Tables[0];
// Get all the dates on which classes were held using LINQ.
var datesAndLectures = (from i in attendance.AsEnumerable() orderby i.Field<DateTime>("Date") select new { Date = i.Field<DateTime>("Date"), LectureID = i.Field<int>("LectureID") }).Distinct();
foreach (var date in datesAndLectures)
{
TemplateField temp = new TemplateField();
temp.HeaderText = date.Date.ToShortDateString();
CreateItemTemplate.Page = 2;
temp.ItemTemplate = new CreateItemTemplate(ListItemType.Item, date.LectureID.ToString(), date.Date.ToShortDateString(), abcd);
Label l = new Label();
temp.ItemTemplate.InstantiateIn(l);
GridView2.Columns.Add(temp);
}
GridView2.DataBind();
foreach (GridViewRow row in GridView2.Rows)
{
foreach (var date in datesAndLectures)
{
var att = from i in attendance.AsEnumerable() where i.Field<DateTime>("Date").Equals(date.Date) && i.Field<int>("LectureID").Equals(date.LectureID) orderby i.Field<DateTime>("Date") select new { StudentNo = i.Field<string>("StudentNo"), AttendanceTypeID = i.Field<int>("AttendanceTypeID") };
foreach (var record in att)
{
if ((row.Cells[1].Text + " ").Equals(record.StudentNo))
{
if (record.AttendanceTypeID == 2)
{
Label abc = (Label)row.FindControl("LblAttendanceType" + date.Date.ToShortDateString() + date.LectureID.ToString());
abc.Text = "PC";
abc.ForeColor = System.Drawing.Color.Green;
}
if (record.AttendanceTypeID == 3)
{
Label abc = (Label)row.FindControl("LblAttendanceType" + date.Date.ToShortDateString() + date.LectureID.ToString());
abc.Text = "A";
abc.ForeColor = System.Drawing.Color.Red;
}
break;
}
else
{
Label abc = (Label)row.FindControl("LblAttendanceType" + date.Date.ToShortDateString() + date.LectureID.ToString());
abc.Text = "P";
}
}
}
}
GridView1.Visible = false;
GridView2.Visible = true;
}
BtnDownloadAttendanceAsExcel.Visible = true;
}
private void InitializeCustomControls()
{
//初始化ToolBar
InitToolBar();
//初始化spgvMaterial
this.spgvMaterial = new SPGridView();
this.spgvMaterial.AutoGenerateColumns = false;
this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvMaterial.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfSelect = new TemplateField();
tfSelect.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinSubDetailsID");
tfSelect.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvMaterial.Columns.Insert(0, tfSelect);
//加入回收数量--根套件列
TemplateField tfQuantityGtj = new TemplateField();
tfQuantityGtj.HeaderText = "根/台/套/件";
tfQuantityGtj.ItemTemplate = new TextBoxTemplate("TotleGentaojian", "TotleGentaojian", "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(4, tfQuantityGtj);
//加入回收数量--米列
TemplateField tfQuantityMetre = new TemplateField();
tfQuantityMetre.HeaderText = "米";
tfQuantityMetre.ItemTemplate = new TextBoxTemplate("TotleMetre", "TotleMetre", "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(5, tfQuantityMetre);
//加入回收数量--吨列
TemplateField tfQuantityTon = new TemplateField();
tfQuantityTon.HeaderText = "吨";
tfQuantityTon.ItemTemplate = new TextBoxTemplate("TotleTon", "TotleTon", "^(-?\\d+)(\\.\\d+)?$", "0");
this.spgvMaterial.Columns.Insert(6, tfQuantityTon);
//加入回收单号列
TemplateField tfRetrieveCode = new TemplateField();
tfRetrieveCode.HeaderText = "回收单号";
tfRetrieveCode.ItemTemplate = new TextBoxTemplate("回收单号", DataControlRowType.DataRow, "RetrieveCode");
this.spgvMaterial.Columns.Insert(7, tfRetrieveCode);
//加入备注列
TemplateField tfRemark = new TemplateField();
tfRemark.HeaderText = "备注";
tfRemark.ItemTemplate = new TextBoxTemplate("备注", DataControlRowType.DataRow, "Remark");
this.spgvMaterial.Columns.Insert(8, tfRemark);
btnOK = (Button)GetControltByMaster("btnOK");
btnOK.Click += new EventHandler(btnOK_Click);
}
/// <summary>
/// Loads actions definition.
/// </summary>
/// <param name="actions">Configuration of the actions</param>
private void LoadActionsDefinition(UniGridActions actions)
{
// Custom template field of the grid view
TemplateField actionsColumn = new TemplateField();
// Ensure width of the column
if (!String.IsNullOrEmpty(actions.Width))
{
actionsColumn.ItemStyle.Width = new Unit(actions.Width);
}
// Add object menu if possible
if ((actions.Actions.Count > 0 && !(actions.Actions.FirstOrDefault() is EmptyAction)) && ShowObjectMenu && UniGridFunctions.ShowUniGridObjectContextMenu(CMSObjectHelper.GetReadOnlyObject(ObjectType)))
{
actions.Actions.RemoveAll(a => a is EmptyAction);
// Check if object menu already contained
var menus = from action in actions.Actions.OfType<Action>()
where (action.Name.ToLower() == "#objectmenu") || (!String.IsNullOrEmpty(action.ContextMenu))
select action;
// Add object menu of necessary
if ((menus.Count() == 0) && !IsLiveSite)
{
Action action = new Action("#objectmenu");
action.ExternalSourceName = "#objectmenu";
actions.Actions.Add(action);
}
}
// Show header?
if (actions.ShowHeader)
{
if (ShowActionsMenu && string.IsNullOrEmpty(actions.ContextMenu))
{
actions.ContextMenu = DEFAULT_ACTIONS_MENU;
actions.Caption = "General.OtherActions";
}
// Fill in the custom template field
GridViewTemplate headerTemplate = new GridViewTemplate(ListItemType.Header, this, actions, GetString("unigrid.actions"), ImageDirectoryPath, DefaultImageDirectoryPath, Page);
headerTemplate.ContextMenuParent = plcContextMenu;
headerTemplate.CheckRelative = CheckRelative;
actionsColumn.HeaderTemplate = headerTemplate;
if (ShowActionsMenu)
{
if (actions.Actions.FirstOrDefault() is EmptyAction)
{
actionsColumn.HeaderStyle.CssClass = "EmptyAC";
}
else
{
actionsColumn.HeaderStyle.CssClass = "AC";
}
}
}
GridViewTemplate actionsTemplate = new GridViewTemplate(ListItemType.Item, this, actions, null, ImageDirectoryPath, DefaultImageDirectoryPath, Page);
actionsTemplate.OnExternalDataBound += RaiseExternalDataBound;
actionsTemplate.ContextMenuParent = plcContextMenu;
actionsTemplate.CheckRelative = CheckRelative;
actionsColumn.ItemTemplate = actionsTemplate;
if (!IsLiveSite)
{
actionsColumn.ItemStyle.CssClass = "NW UniGridActions";
}
else
{
actionsColumn.ItemStyle.CssClass = "UniGridActions";
actionsColumn.ItemStyle.Wrap = false;
}
// CSS class name
string cssClass = actions.CssClass;
if (cssClass != null)
{
actionsColumn.HeaderStyle.CssClass += " " + cssClass;
actionsColumn.ItemStyle.CssClass += " " + cssClass;
actionsColumn.FooterStyle.CssClass += " " + cssClass;
}
// Add custom column to grid view
UniGridView.Columns.Add(actionsColumn);
}
private void InitGridView(DateTime begindate, DateTime enddate)
{
ViewState["FirstDateColumnIndex"] = gv_List.Columns.Count;
DateTime day = begindate;
while (day <= enddate)
{
#region 转换星期几的名称
string week = "";
switch (day.DayOfWeek)
{
case DayOfWeek.Monday:
week = "一";
break;
case DayOfWeek.Tuesday:
week = "二";
break;
case DayOfWeek.Wednesday:
week = "三";
break;
case DayOfWeek.Thursday:
week = "四";
break;
case DayOfWeek.Friday:
week = "五";
break;
case DayOfWeek.Saturday:
week = "<font color=red>六</font>";
break;
case DayOfWeek.Sunday:
week = "<font color=red>日</font>";
break;
default:
break;
}
#endregion
TemplateField customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new JournalPlanTemplate("<center>" + day.ToString("M.d") + "<br/>" + week + "</center>");
customField.HeaderStyle.Width = new Unit(35);
customField.ItemTemplate = new JournalPlanTemplate(day, new EventHandler(cbx_Journal_CheckedChanged));
customField.ItemStyle.Width = new Unit(35);
customField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gv_List.Columns.Add(customField);
day = day.AddDays(1);
}
if (620 + (enddate - begindate).Days * 40 > 1024)
{
gv_List.Width = new Unit(620 + (enddate - begindate).Days * 40);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="T:Sitecore.Shell.Applications.Templates.TemplateBuilder.TemplateBuilderForm.ScanResult" /> class.
/// </summary>
/// <param name="fieldDefinition">The field definition.</param>
/// <param name="displayName">Name of the display.</param>
/// <param name="shared">if set to <c>true</c> this instance is shared.</param>
/// <param name="unversioned">if set to <c>true</c> this instance is unversioned.</param>
public ScanResult(TemplateField fieldDefinition, string displayName, bool shared, bool unversioned)
{
Assert.ArgumentNotNull((object)fieldDefinition, "fieldDefinition");
Assert.ArgumentNotNull((object)displayName, "displayName");
this.fieldDefinition = fieldDefinition;
this.displayName = displayName;
this.shared = shared;
this.unversioned = unversioned;
}
private void InitGridView(DateTime begindate, DateTime enddate)
{
ViewState["FirstDateColumnIndex"] = gv_List.Columns.Count;
DateTime day = begindate;
while (day <= enddate)
{
#region 转换星期几的名称
string week = "";
switch (day.DayOfWeek)
{
case DayOfWeek.Monday:
week = "一";
break;
case DayOfWeek.Tuesday:
week = "二";
break;
case DayOfWeek.Wednesday:
week = "三";
break;
case DayOfWeek.Thursday:
week = "四";
break;
case DayOfWeek.Friday:
week = "五";
break;
case DayOfWeek.Saturday:
week = "<font color=red>六</font>";
break;
case DayOfWeek.Sunday:
week = "<font color=red>日</font>";
break;
default:
break;
}
#endregion
TemplateField customField = new TemplateField();
customField.ShowHeader = true;
customField.HeaderTemplate = new JournalPlanTemplate("<center>" + day.ToString("M.d") + "<br/>" + week + "</center>");
customField.HeaderStyle.Width = new Unit(35);
customField.ItemTemplate = new JournalPlanTemplate(day, new EventHandler(cbx_Journal_CheckedChanged));
customField.ItemStyle.Width = new Unit(35);
customField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
gv_List.Columns.Add(customField);
day = day.AddDays(1);
}
if (620 + (enddate - begindate).Days * 40 > 1024)
gv_List.Width = new Unit(620 + (enddate - begindate).Days * 40);
}
