private void BindGrid4()
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
StringBuilder cmdTxt = new StringBuilder();
StringBuilder QUERYS = new StringBuilder();
cmdTxt.AppendFormat(@"
SELECT
[ID]
,[KINDS]
,[NAMES]
,[MOQS]
,[INDAYS]
,[COMMENTS]
FROM [TKBUSINESS].[dbo].[TBPURMOQ]
WHERE [KINDS]=@KINDS
ORDER BY [ID]
");
m_db.AddParameter("@KINDS", "內袋");
//m_db.AddParameter("@EDATE", EDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt.ToString()));
Grid4.DataSource = dt;
Grid4.DataBind();
}
protected void Button4_Click(object sender, EventArgs e)
{
School查询办公设备条件表 model = new School查询办公设备条件表();
string str部门 = 部门.SelectedText;
if (str部门 != null)
{
model.归属部门 = Convert.ToInt32(部门.SelectedValue);
if (负责人.SelectedText != null)
{
model.负责人 = Convert.ToInt32(负责人.SelectedValue);
}
else
{
model.负责人 = 0;
Alert.ShowInTop("必须选择负责人！");
return;
}
}
else
{
Alert.ShowInTop("必须选择负责人！");
return;
}
model.关键字 = TwinTriggerBox1.Text;
School资产处置BLL bll = new School资产处置BLL();
DataSet ds = bll.查询全部资产信息(model);
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid4.DataSource = dt;//DataTable
Grid4.DataBind();
}
private void btnDesnaStrelica_Click(object sender, RoutedEventArgs e)
{
vrednost -= 750;
brojac++;
if (brojac == 3)
{
btnDesnaStrelica.Visibility = Visibility.Hidden;
}
else if (brojac == 0 || brojac == 1)
{
btnLevaStrelica.Visibility = Visibility.Visible;
btnDesnaStrelica.Visibility = Visibility.Visible;
}
DoubleAnimation doubleAnimation = new DoubleAnimation();
PowerEase powerEase = new PowerEase();
powerEase.EasingMode = EasingMode.EaseInOut;
powerEase.Power = 10;
doubleAnimation.To = vrednost;
doubleAnimation.Duration = new Duration(new TimeSpan(0, 0, 0, 0, 700));
// doubleAnimation.EasingFunction = powerEase;
Grid1.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid2.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid3.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid4.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid5.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid6.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid7.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
}
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
object[] keys = Grid1.DataKeys[e.RowIndex];
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
xx.Text = ID.ToString();
查看流程状态.Text = keys[1].ToString();
if (查看流程状态.Text != "待审核")
{
Button9.Enabled = false;
Button3.Enabled = false;
}
查看单据编号.Text = keys[2].ToString();
查看事项名称.Text = keys[3].ToString();
查看申请人.Text = keys[4].ToString();
查看申请日期.Text = keys[5].ToString();
查看联系方式.Text = keys[6].ToString();
DataSet ds = bll.资产转移查看详情(ID);
DataTable dt = ds.Tables[0].Copy(); //复制一份table
Grid4.DataSource = dt; //DataTable
Grid4.DataBind();
//查询现负责人等
SchoolX_资产转移改动信息表 model = bll.查询变更为(ID);
查看存放地点变更为.Text = model.现存放地点;
查看归属部门变更为.Text = model.现归属部门;
查看负责人变更为.Text = model.现负责人;
新增资产转移查看详情.Hidden = false;
}
}
public void Puzzle1_4DCubeGrid_FindActiveCubesAfterBoot()
{
var grid = new Grid4(Input.Day17);
grid.Boot();
grid.ActiveCubeCount.Should().Be(1792);
}
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
OffSession();
string 职务 = Session["职务"].ToString();
if (职务 == "财务人员")
{
//Button4.Text = "同意";
Button6.Text = "拒绝";
}
else
{
//Button4.Enabled = false;
Button6.Text = "关闭";
}
object[] keys = Grid1.DataKeys[e.RowIndex];
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
flowid.Text = ID.ToString();
查看流程状态.Text = keys[1].ToString();
if (查看流程状态.Text == "完成")
{
//Button4.Enabled = false;
Button6.Text = "关闭";
}
查看单据编号.Text = keys[2].ToString();
查看事项名称.Text = keys[3].ToString();
查看申请人.Text = keys[4].ToString();
查看申请日期.Text = keys[5].ToString();
查看记账人.Text = keys[6].ToString();
//赋值lable
this.Label5.Text = "数量合计:" + keys[7].ToString() + "---金额合计：" + keys[8].ToString() + "元";
查看变动方式.Text = keys[9].ToString();
查看变动原因.Text = keys[10].ToString();
查看记账人意见.Text = keys[11].ToString();
查看备注.Text = keys[12].ToString();
string 资产ID = keys[13].ToString();
string str变动金额 = keys[14].ToString();
if (keys[15] == null)
{
int Sort = 0;
}
else
{
int Sort = Convert.ToInt32(keys[15].ToString());
}
//通过ID查询资产数据
Grid4.DataSource = bll.原值变动查看详情(资产ID);
Grid4.DataBind();
Window3.Hidden = false;
}
}
/// <summary>
/// 点击任务单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid3_RowClick(object sender, GridRowClickEventArgs e)
{
//IEnumerable<string> selectIds = GetDispatchCenterIds();
try
{
if (Grid3.SelectedRowIndexArray.Length == 0)
{
Alert.Show("请至少选择一项！", MessageBoxIcon.Information);
}
else if (Grid3.SelectedRowIndexArray.Length > 1)
{
Alert.Show("只能选择一项！", MessageBoxIcon.Information);
}
else
{
string sid = Grid3.DataKeys[Grid3.SelectedRowIndexArray[0]][0].ToString();
//根据调度单号查询任务单
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@KeyId", sid);
parms.Add("@FCompanyId", CurrentUser.AccountComId);
var data = SqlService.ExecuteProcedureCommand("proc_DispatchDetails", parms).Tables[0];
var bottle = SqlService.ExecuteProcedureCommand("rpt_SalesBottles", parms).Tables[0];
if (data.Rows.Count > 0)
{
//绑定数据源
Grid1.DataSource = data;
Grid1.DataBind();
}
if (bottle.Rows.Count > 0)
{
//绑定数据源
Grid4.DataSource = bottle;
Grid4.DataBind();
var summary = new JObject
{
{ "FBottle", "合计" },
{ "FBottleQty", bottle.Compute("sum(FBottleQty)", "true").ToString() },
};
Grid4.SummaryData = summary;
}
}
}
catch (Exception ex)
{
Alert.Show("查看失败！", MessageBoxIcon.Warning);
}
}
protected void TabStrip1_TabIndexChanged(object sender, EventArgs e)
{
if (TabStrip1.ActiveTabIndex == 0)
{
}
else if (TabStrip1.ActiveTabIndex == 1)
{
//查询关联备件
string sbmc = "";
int 所属单位 = 0;
int[] selections = Grid1.SelectedRowIndexArray;
foreach (int rowIndex in selections)
{
sbmc = Grid1.DataKeys[rowIndex][4].ToString();
所属单位 = Convert.ToInt16(Grid1.DataKeys[rowIndex][10]);
}
Grid2.DataSource = bll.设备名称关联备件(sbmc, 所属单位);
Grid2.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 2)
{
//维修情况
//string sbbh = "";
//int[] selections = Grid1.SelectedRowIndexArray;
//foreach (int rowIndex in selections)
//{
// sbbh = Grid1.DataKeys[rowIndex][3].ToString();
//}
Grid3.DataSource = bll.设备编号关联维修情况(设备编号.Text);
Grid3.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 3)
{
//设备BOM
}
else if (TabStrip1.ActiveTabIndex == 4)
{
//备件消耗
Grid4.DataSource = bll.设备编号查询备件消耗(设备编号.Text);
Grid4.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 5)
{
//预防性维修
string sbbc = 设备名称.Text;
//text.Text = bll.查询单台设备平均故障时间("999-1252", "喷枪");
List <预防性维修> listmodel = bll.查询设备平均故障时间(sbbc);
Grid5.DataSource = listmodel;
Grid5.DataBind();
//List<预防性维修> listmodel = bll.查询设备平均故障时间("车体喷砂系统");
}
}
public void LoadOrderDep01(string ORDDER_ID)
{
if (String.IsNullOrEmpty(ORDDER_ID))
{
Grid4.DataSource = null;
Grid5.DataSource = null;
Grid4.DataBind();
Grid5.DataBind();
}
ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid4, 1, ORDDER_ID);
ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid5, 2, ORDDER_ID);
}
protected void btnIcon1_Click(object sender, EventArgs e)
{
School资产处置BLL bll = new School资产处置BLL();
DataSet ds = bll.查询全部资产信息();
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid4.DataSource = dt;//DataTable
Grid4.DataBind();
//绑定条件
School清查盘点BLL pdbll = new School清查盘点BLL();
List <School一级部门表> xxmc = pdbll.查询一级部门();
部门.DataTextField = "名称";
部门.DataValueField = "ID";
部门.DataSource = xxmc;
部门.DataBind();
List <School一级类别表> yjlb = pdbll.查询一级类别();
一级.DataTextField = "名称";
一级.DataValueField = "ID";
一级.DataSource = yjlb;
一级.DataBind();
List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
存放地点.DataTextField = "名称";
存放地点.DataValueField = "ID";
存放地点.DataSource = 查询建筑物;
存放地点.DataBind();
二级.Enabled = false;
级.Enabled = false;
负责人.Enabled = false;
房间.Enabled = false;
二级.EmptyText = "全部";
级.EmptyText = "全部";
负责人.EmptyText = "全部";
房间.EmptyText = "全部";
Window2.Hidden = false;
}
/// <summary>
///
/// </summary>
private void BindDataGrid()
{
var source = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesDetails WHERE keyId='{0}' and FCompanyId={1}", txtKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid1.DataSource = source.Tables[0];
Grid1.DataBind();
//----------------------------------------------------------
var dataStatus = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FActionName
,FMemo
FROM dbo.LHBillStatus a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", txtKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid2.DataSource = dataStatus;
Grid2.DataBind();
//----------------------------------------------------------
var dataFlow = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FMemo
FROM dbo.LHBillFlow a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", txtKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid3.DataSource = dataFlow;
Grid3.DataBind();
//----------------------------------------------------------
var log = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesDetailsLog a WHERE keyId='{0}' and a.FCompanyId={1}", txtKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid4.DataSource = log;
Grid4.DataBind();
}
protected void LoadREVGrid(string mode)
{
SQL_utils sql = new SQL_utils("backend");
GridView gv = new GridView();
DataTable dt_stack = new DataTable();
dt_stack = sql.DataTable_from_SQLstring("select * from fin.vwREV_FutureMo_with_TOTALS_by_budgetNbr where budgetNbr in ( '" + utilSelect2.getselected_CSVval(selBudgets, "','") + "') " +
" order by budgetnbr, mos_from_now");
if (dt_stack.Rows.Count >= 1)
{
DataTable dt_stack_pivot = utilsPivot.Pivot(dt_stack, new string[] { "budgetName", "budgetNbr", "EndDate" }, "mos_from_now", "calcREV");
string[] mos = new string[12];
for (int i = 0; i < 12; i++)
{
var myDate = DateTime.Now;
var startOfMonth = new DateTime(myDate.Year, myDate.Month, 1);
var endOfMonth = startOfMonth.AddMonths(1).AddDays(-1);
//That should give you what you need. int lastDay = DateTime.DaysInMonth (2014, 2); and the first day is always 1.
string prefix = (i < 9) ? "0" : "";
mos[i] = String.Format("{0:d}", startOfMonth.AddMonths(i));
// mos[i] = String.Format("{0:d}", dt_stack_pivot.Columns[i + 2].ColumnName);
dt_stack_pivot.Columns[i + num_cols_before_REV].ColumnName = "mo" + prefix + (i + 1).ToString();
}
Grid4.DataSource = dt_stack_pivot;
Grid4.DataBind();
//Set the HeaderText to the month
for (int m = 0; m < 12; m++)
{
Grid4.Columns[num_cols_before_REV + m].HeaderText = mos[m];
}
lblError.Text = "";
}
else
{
lblError.Text = "No records returned.";
Grid4.Visible = false;
}
}
/// <summary>
/// 列表按键绑定——修改列表控件属性
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid4_PreRowDataBound(object sender, FineUI.GridPreRowEventArgs e)
{
int rowc = Grid4.Rows.Count;
int id = ConvertHelper.Cint0(hidId.Text);//获取页面传值
Solution.DataAccess.Model.Position model = new DataAccess.Model.Position();
//获取指定ID的菜单内容，如果不存在，则创建一个菜单实体
model = PositionBll.GetInstence().GetModelForCache(x => x.Id == id);
GridRow gr1 = Grid3.Rows[Grid3.SelectedRowIndex];
menuInfoId_ = int.Parse(gr1.Values[0].ToString());
if (model == null)
{
return;
}
//绑定是否显示状态列
if (menuInfoId_ != 0)
{
int o = e.RowIndex;
DataRowView row = e.DataItem as DataRowView;
string _ControlPower = model.ControlPower;// PositionBll.GetInstence().GetFieldValue(id, "ControlPower", true).ToString();
// GridRow gr = Grid4.Rows[o];
string str = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][0].ToString();
string s = "," + menuInfoId_.ToString() + "|" + str + ",";
if (_ControlPower.IndexOf("," + menuInfoId_.ToString() + "|" + str + ",") >= 0)
{
var lbf = Grid4.FindColumn("IsOrNotLink") as LinkButtonField;
lbf.Icon = Icon.BulletTick;
lbf.CommandArgument = "0";
}
else
{
var lbf = Grid4.FindColumn("IsOrNotLink") as LinkButtonField;
lbf.Icon = Icon.BulletCross;
lbf.CommandArgument = "1";
}
}
}
public string Solve2()
{
var grid = new Grid4();
var lines = File.ReadAllLines(@"Day17\input.txt").ToArray();
for (int y = 0; y < lines.Length; y++)
{
for (int x = 0; x < lines[y].Length; x++)
{
if (lines[y][x] == '#')
{
grid.SetActive(x, y, 0, 0);
}
}
}
for (int step = 1; step <= 6; step++)
{
grid.Step();
//Console.WriteLine($"After {step} cycles");
//for (var z = grid.Coordinates.Select(o => o.Z).Min(); z <= grid.Coordinates.Select(o => o.Z).Max(); z++)
//{
// Console.WriteLine($"z={z}");
// for (var y = grid.Coordinates.Select(o => o.Y).Min(); y <= grid.Coordinates.Select(o => o.Y).Max(); y++)
// {
// for (var x = grid.Coordinates.Select(o => o.X).Min(); x <= grid.Coordinates.Select(o => o.X).Max(); x++)
// {
// Console.Write(grid.Coordinates.Contains(new Coordinate(x, y, z)) ? "#" : ".");
// }
// Console.WriteLine();
// }
// Console.WriteLine();
// Console.WriteLine();
//}
}
return(grid.ActiveCount.ToString());
}
private void BindGrid4()
{
using (var appdb = new AppContext())
{
var q = from a in appdb.orderdetail
join b in appdb.orderheader on a.FSN equals b.SN
select a;
string searchText = ddlOrderno.Text;
if (!String.IsNullOrEmpty(searchText))
{
q = q.Where(u => u.ItemName.Contains(searchText) || u.ItemNo.Contains(searchText) || u.ClinetNo.Contains(searchText) || u.OrderNo.Contains(searchText));;
}
// 在查询添加之后，排序和分页之前获取总记录数
Grid4.RecordCount = q.Count();
// 排列和分页
//q = SortAndPage<Provider>(q, Grid4);
Grid4.DataSource = q;
Grid4.DataBind();
}
}
/// <summary>
///
/// </summary>
private void BindDataGrid()
{
var source = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_LeaseReturnDetails a WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid1.DataSource = source;
Grid1.DataBind();
var table = source.Tables[0];
if (table != null && table.Rows.Count > 0)
{
decimal sumFQty = 0.00M;
decimal sumFAmount = 0.00M;
for (int i = 0; i < table.Rows.Count; i++)
{
sumFQty += Convert.ToDecimal(table.Rows[i]["FBottleQty"]);
sumFAmount += Convert.ToDecimal(table.Rows[i]["FDepositSecurity"]);
}
var summary = new JObject
{
{ "FBottle", "合计" },
{ "FBottleQty", sumFQty },
{ "FDepositSecurity", sumFAmount }
};
Grid1.SummaryData = summary;
}
//----------------------------------------------------------
var dataStatus = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FActionName
,FMemo
FROM dbo.LHBillStatus a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid2.DataSource = dataStatus;
Grid2.DataBind();
//----------------------------------------------------------
var dataFlow = SqlService.Where(string.Format(@"SELECT FId
,KeyId
,a.FCompanyId
,FDeptId
,b.org_name FDeptName
,FOperator
,FDate
,FMemo
FROM dbo.LHBillFlow a
LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid3.DataSource = dataFlow;
Grid3.DataBind();
//----------------------------------------------------------
var log = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_LeaseReturnDetailsLog a WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId));
//绑定数据源
Grid4.DataSource = log;
Grid4.DataBind();
}
protected void Button4_Click(object sender, EventArgs e)
{
School查询办公设备条件表 model = new School查询办公设备条件表();
string str一级 = 一级.SelectedText;
string str二级 = 二级.SelectedText;
string str三级 = 级.SelectedText;
if (str一级 == "全部" || str一级 == null)
{
str一级 = "";
}
if (str二级 == "全部" || str二级 == null)
{
str二级 = "";
}
if (str三级 == "全部" || str三级 == null)
{
str三级 = "";
}
model.一级分类 = str一级;
model.二级分类 = str二级;
model.级分类 = str三级;
string str部门 = 部门.SelectedText;
if (str部门 != "全部" && str部门 != null)
{
model.归属部门 = Convert.ToInt32(部门.SelectedValue);
if (负责人.SelectedText != null)
{
model.负责人 = Convert.ToInt32(负责人.SelectedValue);
}
else
{
model.负责人 = 0;
}
}
else
{
model.归属部门 = 0;
}
if (存放地点.SelectedText != null)
{
model.存放地点 = Convert.ToInt32(存放地点.SelectedValue);
if (房间.SelectedText != null)
{
model.房间 = Convert.ToInt32(房间.SelectedValue);
}
else
{
model.房间 = 0;
}
}
else
{
model.存放地点 = 0;
}
if (起始投入日期.Text != "")
{
model.起始投入日期 = Convert.ToDateTime(起始投入日期.Text).ToShortDateString();
}
else
{
model.起始投入日期 = "";
}
if (结束投入日期.Text != "")
{
model.结束投入日期 = Convert.ToDateTime(结束投入日期.Text).ToShortDateString();
}
else
{
model.结束投入日期 = "";
}
model.关键字 = TwinTriggerBox1.Text;
School资产处置BLL bll = new School资产处置BLL();
DataSet ds = bll.查询全部资产信息(model);
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid4.DataSource = dt;//DataTable
Grid4.DataBind();
//二级.Enabled = false;
//三级.Enabled = false;
//负责人.Enabled = false;
//房间.Enabled = false;
二级.EmptyText = "全部";
级.EmptyText = "全部";
负责人.EmptyText = "全部";
房间.EmptyText = "全部";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = bll.首页_X_资产报修流程表("全部");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid1.DataSource = dt;//DataTable
Grid1.DataBind();
DateTime dtime = DateTime.Now;
string sj = dtime.Year + "-" + dtime.Month + "-" + dtime.Day;
报修时间2.EmptyText = sj;
DatePicker1.EmptyText = sj;
完成时间.EmptyText = sj;
List <School房间信息表> cfdd = bll.cfdd();
报修地址.DataTextField = "名称";
报修地址.DataValueField = "ID";
报修地址.DataSource = cfdd;
报修地址.DataBind();
//DatePicker1.MinDate = DateTime.Now;
//DatePicker1.MaxDate = DateTime.Now.AddDays(10);
// 3.绑定到Grid
Grid4.DataSource = dt;//DataTable
Grid4.DataBind();
//绑定条件
School清查盘点BLL pdbll = new School清查盘点BLL();
List <School一级部门表> xxmc = pdbll.查询一级部门();
部门.DataTextField = "名称";
部门.DataValueField = "ID";
部门.DataSource = xxmc;
部门.DataBind();
List <School一级类别表> yjlb = pdbll.查询一级类别();
一级.DataTextField = "名称";
一级.DataValueField = "ID";
一级.DataSource = yjlb;
一级.DataBind();
List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表();
存放地点.DataTextField = "名称";
存放地点.DataValueField = "ID";
存放地点.DataSource = 查询建筑物;
存放地点.DataBind();
二级.Enabled = false;
级.Enabled = false;
负责人.Enabled = false;
房间.Enabled = false;
二级.EmptyText = "全部";
级.EmptyText = "全部";
负责人.EmptyText = "全部";
房间.EmptyText = "全部";
OffSession();
string 职务 = HttpContext.Current.Session["职务"].ToString();
联系电话.Text = HttpContext.Current.Session["电话号码"].ToString();
if (职务 == "资产管理员")
{
Button1.Hidden = false;
}
}
}
/// <summary>
/// 顯示時欄位初始值
/// </summary>
/// <param name="versionField">欄位集合</param>
public override void SetField(Fast.EB.WKF.Design.VersionField versionField)
{
FieldOptional fieldOptional = versionField as FieldOptional;
if (fieldOptional != null)
{
#region ==============屬性說明==============『』
//fieldOptional.IsRequiredField『是否為必填欄位,如果是必填(True),如果不是必填(False)』
//fieldOptional.DisplayOnly『是否為純顯示,如果是(True),如果不是(False),一般在觀看表單及列印表單時,屬性為True』
//fieldOptional.HasAuthority『是否有填寫權限,如果有填寫權限(True),如果沒有填寫權限(False)』
//fieldOptional.FieldValue『如果已有人填寫過欄位,則此屬性為記錄其內容』
//fieldOptional.FieldDefault『如果欄位有預設值,則此屬性為記錄其內容』
//fieldOptional.FieldModify『是否允許修改,如果允許(fieldOptional.FieldModify=FieldModifyType.yes),如果不允許(fieldOptional.FieldModify=FieldModifyType.no)』
//fieldOptional.Modifier『如果欄位有被修改過,則Modifier的內容為EBUser,如果沒有被修改過,則會等於Null』
#endregion
if (fieldOptional.FieldMode == FieldMode.View || fieldOptional.FieldMode == FieldMode.Print)
{
SqlConnection con = new SqlConnection();
DataTable dt = new DataTable("CURRENT");
try
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
SqlDataAdapter da = new SqlDataAdapter("select CURRENT_DOC,TASK_RESULT,DOC_NBR,BEGIN_TIME from [UOF].[dbo].[TB_WKF_TASK] where TASK_ID = @TASK_ID", con);
da.SelectCommand.Parameters.Add("TASK_ID", SqlDbType.NVarChar).Value = Request.QueryString["TASK_ID"].ToString();
da.Fill(dt);
}
finally
{
con.Close();
}
//string url = Request.Url.AbsoluteUri;
txtFieldValue.Text = dt.Rows[0][0].ToString();
result = dt.Rows[0]["TASK_RESULT"].ToString();
DOC_NBR = dt.Rows[0]["DOC_NBR"].ToString();
BEGIN_TIME = dt.Rows[0]["BEGIN_TIME"].ToString();
//Response.Write("<script>alert('" + dt.Rows[0][0].ToString() + "')</script>");
Grid4.DataSource = BindGrid4();
Grid4.DataBind();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(txtFieldValue.Text);
XmlNodeList last = xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem");
int lastcount = last.Count;
int xmllistcount = 1;
foreach (XmlNode nd in last)
{
if (xmllistcount == lastcount)
{
if (result == "0" && (nd.Attributes["ConditionValue"].Value == "" || nd.Attributes["ConditionValue"].Value == "0"))
{
XmlNodeList DELlast = xmlDoc.SelectNodes("/Form/FormFieldValue/FieldItem/FieldValue/Item/DEL"); //有此節點則是代表此表單作廢
if (DELlast.Count == 0)
{
resend.Enabled = btnDel.Enabled = true;
}
else
{
resend.Visible = btnDel.Visible = false;
}
}
}
xmllistcount++;
}
}
#region ==============如果有修改，要顯示修改者資訊==============
if (fieldOptional.Modifier != null)
{
lblModifier.Visible = true;
lblModifier.ForeColor = System.Drawing.Color.Red;
lblModifier.Text = String.Format("( {0}：{1} )", this.lblMsgSigner.Text, fieldOptional.Modifier.Name);
}
#endregion
}
}
protected void Grid4_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Grid4.DataSource = BindGrid4();
Grid4.DataBind();
}
private void bindEvaluateTableToGrid()
{
string exception = "";
EvaluateTable evaluateTable = new EvaluateTable();
string evaluatedID = Request.QueryString["id"];
if (EvaluationManagementCtrl.GetEvaluateTable(evaluatedID, ref evaluateTable, ref exception))
{
ViewState["KeyWeight"] = evaluateTable.KeyWeight;
ViewState["ResponseWeight"] = evaluateTable.KeyWeight;
ViewState["QualifyWeight"] = evaluateTable.QualifyWeitht;
ViewState["AttitudeWeight"] = evaluateTable.AttitudeWeight;
ViewState["RejectWeight"] = evaluateTable.RejectWeight;
Label_EvaluatedName.Text = evaluateTable.EvaluatedName;
Label_PostName.Text = evaluateTable.PostName;
Label_LaborDep.Text = evaluateTable.LaborDep;
Label_LaborUnit.Text = evaluateTable.LaborUnit;
RadioButtonList_Relation.SelectedValue = Request.QueryString["relation"];
Label_Period.Text = evaluateTable.StartTime + " ~ " + evaluateTable.StopTime;
//关键岗位职责指标
DataTable table1 = new DataTable();
table1.Columns.Add("Title");
table1.Columns.Add("Quota");
foreach (Quota item in evaluateTable.KeyResponse)
{
table1.Rows.Add(item.Title, item.Content[0]);
}
Grid1.DataSource = table1;
Grid1.DataBind();
//关键岗位胜任能力指标
DataTable table2 = new DataTable();
table2.Columns.Add("Title");
table2.Columns.Add("Quota1");
table2.Columns.Add("Quota2");
table2.Columns.Add("Quota3");
table2.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.KeyQualify)
{
table2.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid2.DataSource = table2;
Grid2.DataBind();
//关键岗位工作态度指标
DataTable table3 = new DataTable();
table3.Columns.Add("Title");
table3.Columns.Add("Quota1");
table3.Columns.Add("Quota2");
table3.Columns.Add("Quota3");
table3.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.KeyAttitude)
{
table3.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid3.DataSource = table3;
Grid3.DataBind();
//岗位职责指标
DataTable table4 = new DataTable();
table4.Columns.Add("Title");
table4.Columns.Add("Quota");
foreach (Quota item in evaluateTable.Response)
{
table4.Rows.Add(item.Title, item.Content[0]);
}
Grid4.DataSource = table4;
Grid4.DataBind();
//岗位胜任能力指标
DataTable table5 = new DataTable();
table5.Columns.Add("Title");
table5.Columns.Add("Quota1");
table5.Columns.Add("Quota2");
table5.Columns.Add("Quota3");
table5.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.Qualify)
{
table5.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid5.DataSource = table5;
Grid5.DataBind();
//岗位工作态度指标
DataTable table6 = new DataTable();
table6.Columns.Add("Title");
table6.Columns.Add("Quota1");
table6.Columns.Add("Quota2");
table6.Columns.Add("Quota3");
table6.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.Attitude)
{
table6.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid6.DataSource = table6;
Grid6.DataBind();
//否决指标
DataTable table7 = new DataTable();
table7.Columns.Add("Title");
table7.Columns.Add("Quota");
table7.Rows.Add("严重违反规章制度", "累计旷工3天以上的；\n严重失职，营私舞弊，给本单位造成3000元以上经济损失或者其它严重后果的；\n同时与其他用人单位建立劳动关系，对完成本单位工作任务造成严重影响，或者经本单位提出，拒不改正的；\n违背职业道德，行贿、受贿价值超过3000元以上的；\n被依法追究刑事责任的；");
table7.Rows.Add(evaluateTable.Reject[0].Title, evaluateTable.Reject[0].Content[0]);
Grid7.DataSource = table7;
Grid7.DataBind();
System.Web.UI.WebControls.DropDownList ddl = Grid7.Rows[1].FindControl("DropDownList_Reject") as System.Web.UI.WebControls.DropDownList;
ddl.Visible = false;
}
}
//确认申报
protected void Button1_Click(object sender, EventArgs e)
{
if (类别.SelectedValue.ToString() == "待报废")
{
if (类别.SelectedValue.ToString() == "待报废")
{
OffSession();
string 职务 = Session["职务"].ToString();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
Console.Write(selections.Length);
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window2.Hidden = false;
Console.Write(selections);
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
//int 总数 = 0;
//int 总价 = 0;
float 总数 = 0.0f;
float 总价 = 0.0f;
if (listdata != null)
{
foreach (School办公设备信息表 itemjj in listdata)
{
总数 += itemjj.数量;
总价 += Convert.ToInt32(itemjj.价格);
}
}
Grid3.DataSource = listdata;//DataTable
Grid3.DataBind();
Grid4.DataSource = listdata;//DataTable
Grid4.DataBind();
JObject summary = new JObject();
//summary.Add("major", "全部合计");
summary.Add("数量", 总数.ToString("F2"));
summary.Add("价格", 总价.ToString("F2"));
Grid3.SummaryData = summary;
Grid4.SummaryData = summary;
//Grid7.SummaryData = summary;
//Grid8.SummaryData = summary;
//待报废Grid3
报废流程状态.Text = "待审核";
报废流程状态.Enabled = false;
报废_申报单位.Text = Session["二级部门名称"].ToString();
报废_申报单位.Enabled = false;
报废_申报日期.Text = DateTime.Now.ToShortDateString();
报废单据编号.Text = SchoolUtility.strbumber("ZCCZBF");;
报废单据编号.Enabled = false;
报废_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
报废_申请人.Enabled = false;
报废_职务.Text = 职务;
报废_职务.Enabled = false;
}
}
}
else if (类别.SelectedValue.ToString() == "待调拨")
{
OffSession();
string 职务 = Session["职务"].ToString();
if (职务 == "资产管理员")
{
School清查盘点BLL pdbll = new School清查盘点BLL();
List <School一级部门表> xxmc = SchoolUtility.查询一级部门不带全部();;
调拨调入单位.DataTextField = "名称";
调拨调入单位.DataValueField = "ID";
调拨调入单位.DataSource = xxmc;
调拨调入单位.DataBind();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window3.Hidden = false;
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
Grid5.DataSource = listdata;//DataTable
Grid5.DataBind();
Grid6.DataSource = listdata;
Grid6.DataBind();
//当前用户部门是调出单位 调入单位操作人选填
调拨流程状态.Text = "待审核";
调拨流程状态.Enabled = false;
调拨调出单位.Text = Session["二级部门名称"].ToString();
调拨调出单位.Enabled = false;
调拨申报日期.Text = DateTime.Now.ToShortDateString();
调拨验收日期.Text = DateTime.Now.ToShortDateString();
DateTime dt = DateTime.Now;
string y = dt.Year.ToString();
string m = dt.Month.ToString();
string d = dt.Day.ToString();
string h = dt.Hour.ToString();
string mm = dt.Minute.ToString();
调拨单据编号.Text = SchoolUtility.strbumber("ZCCZDB");
调拨单据编号.Enabled = false;
调拨_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
调拨_申请人.Enabled = false;
调拨职务.Enabled = false;
调拨电话.Enabled = false;
调拨职务.Text = HttpContext.Current.Session["职务"].ToString();
try
{
调拨电话.Text = HttpContext.Current.Session["联系电话"].ToString();
}
catch (Exception)
{
调拨电话.Text = "";
}
}
}
else
{
Alert.Show("您没有资产处置-调拨处理的权限，请联系资产管理员", MessageBoxIcon.Warning);
}
}
}
private void BindGrid(int n)
{
if (n == 0)
{
EducationLevelBLL objBLL = new EducationLevelBLL();
IList <EducationLevel> objList = objBLL.GetAllEducationLevel();
Grid1.DataSource = objList;
Grid1.DataBind();
Grid1.Visible = true;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 1)
{
PoliticalStatusBLL objBLL = new PoliticalStatusBLL();
IList <PoliticalStatus> objList = objBLL.GetAllPoliticalStatus();
Grid2.DataSource = objList;
Grid2.DataBind();
Grid1.Visible = false;
Grid2.Visible = true;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 2)
{
WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL();
IList <WorkGroupLeaderLevel> objList = objBLL.GetAllWorkGroupLeaderLevel();
Grid3.DataSource = objList;
Grid3.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = true;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 3)
{
TechnicianTypeBLL objBLL = new TechnicianTypeBLL();
IList <TechnicianType> objList = objBLL.GetAllTechnicianType();
Grid4.DataSource = objList;
Grid4.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = true;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 4)
{
TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL();
IList <TechnicianTitleType> objList = objBLL.GetAllTechnicianTitleType();
Grid5.DataSource = objList;
Grid5.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = true;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 5)
{
EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL();
IList <EducationEmployeeType> objList = objBLL.GetAllEducationEmployeeType();
Grid6.DataSource = objList;
Grid6.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = true;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 6)
{
CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL();
IList <CommitteeHeadShip> objList = objBLL.GetAllCommitteeHeadShip();
Grid7.DataSource = objList;
Grid7.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = true;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 7)
{
RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL();
IList <RandomExamModularType> objList = objBLL.GetAllRandomExamModularType();
Grid8.DataSource = objList;
Grid8.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = true;
Grid9.Visible = false;
}
if (n == 8)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_trainplan_type order by trainplan_type_id").Tables[0];
Grid9.DataSource = dt;
Grid9.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = true;
}
if (n == 9)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_safe_level order by order_index").Tables[0];
Grid10.DataSource = dt;
Grid10.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = true;
}
if (n == 10)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
Grid11.DataSource = dt;
Grid11.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = true;
}
if (n == 11)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(@"select a.*,b.certificate_name from zj_certificate_level a
left join zj_certificate b on a.certificate_id=b.certificate_id order by a.order_index").Tables[0];
Grid12.DataSource = dt;
Grid12.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = true;
}
if (n == 12)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_certificate_unit order by order_index").Tables[0];
Grid13.DataSource = dt;
Grid13.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = true;
}
if (n == 13)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_train_unit order by order_index").Tables[0];
Grid14.DataSource = dt;
Grid14.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = false;
Grid14.Visible = true;
}
}
protected void gridCallBack_Callback(object sender, CallBackEventArgs e)
{
hfMessage.Value = "";
int n = OrgList.SelectedIndex;
try
{
if (e.Parameters[0] != "")
{
if (e.Parameters[1] == "Up")
{
UpData(e.Parameters[0]);
}
else if (e.Parameters[1] == "Down")
{
DownData(e.Parameters[0]);
}
else
{
DeleteData(e.Parameters[0]);
}
}
else if (e.Parameters[0] == "")
{
BindGrid(n);
}
if (n == 0)
{
Grid1.RenderControl(e.Output);
}
else if (n == 1)
{
Grid2.RenderControl(e.Output);
}
else if (n == 2)
{
Grid3.RenderControl(e.Output);
}
else if (n == 3)
{
Grid4.RenderControl(e.Output);
}
else if (n == 4)
{
Grid5.RenderControl(e.Output);
}
else if (n == 5)
{
Grid6.RenderControl(e.Output);
}
else if (n == 6)
{
Grid7.RenderControl(e.Output);
}
else if (n == 7)
{
Grid8.RenderControl(e.Output);
}
else if (n == 8)
{
Grid9.RenderControl(e.Output);
}
else if (n == 9)
{
Grid10.RenderControl(e.Output);
}
else if (n == 10)
{
Grid11.RenderControl(e.Output);
}
else if (n == 11)
{
Grid12.RenderControl(e.Output);
}
else if (n == 12)
{
Grid13.RenderControl(e.Output);
}
else if (n == 13)
{
Grid14.RenderControl(e.Output);
}
}
catch
{
BindGrid(n);
}
hfMessage.RenderControl(e.Output);
}
private void LoadDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[0];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Business Unit/Dept", "", "Count", "Division/Dept");
FCLiteral1.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "DivisionDeptChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral1.Visible = false;
}
if (_DataList.Tables[1].Rows.Count > 0) // Employee Location PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[1];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Country", "", "Country", "Count");
FCLiteral2.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "CountryChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral2.Visible = false;
}
if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile PieChart
{
DataTable _DataTable = _DataList.Tables[2];
CreateBarGraph1(_DataTable);
}
else
{
FCLiteral3.Visible = false;
}
if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[3];
PieXML = CreatePieGraph1(_DataTable, "Employee Service Year Profile", "", "Count", "Division/Dept");
FCLiteral4.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "ServiceChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral4.Visible = false;
}
if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[4];
Grid3.DataSource = _DataTable;
Grid3.DataBind();
}
else
{
Grid3.DataSource = null;
Grid3.DataBind();
}
if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[5];
Grid4.DataSource = _DataTable;
Grid4.DataBind();
}
else
{
Grid4.DataSource = null;
Grid4.DataBind();
}
if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[6];
Grid5.DataSource = _DataTable;
Grid5.DataBind();
}
else
{
Grid5.DataSource = null;
Grid5.DataBind();
}
if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
{
DataTable _DataTable = _DataList.Tables[7];
Grid1.DataSource = _DataTable;
Grid1.DataBind();
}
else
{
Grid1.DataSource = null;
Grid1.DataBind();
}
if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
{
DataTable _DataTable = _DataList.Tables[8];
Grid2.DataSource = _DataTable;
Grid2.DataBind();
}
else
{
Grid2.DataSource = null;
Grid2.DataBind();
}
if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
{
DataTable _DataTable = _DataList.Tables[10];
Grid7.DataSource = _DataTable;
Grid7.DataBind();
}
else
{
Grid7.DataSource = null;
Grid7.DataBind();
}
if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
{
DataTable _DataTable = _DataList.Tables[11];
Grid10.DataSource = _DataTable;
Grid10.DataBind();
}
else
{
Grid10.DataSource = null;
Grid10.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
protected void TabStrip2_TabIndexChanged(object sender, EventArgs e)
{
if (TabStrip2.ActiveTabIndex == 0)
{
}
else if (TabStrip2.ActiveTabIndex == 1)
{
//查询 拍照补录
// 1.获取数据总数
// Grid3.RecordCount = 700;//测试，去数据库获取总数
// 2.获取当前分页数据
DataSet ds = bll.拍照补录查询("");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid3.DataSource = source;//DataTable
Grid3.DataBind();
}
else if (TabStrip2.ActiveTabIndex == 2)
{
DataSet dspk = bll.盘亏处理查询("");
DataTable dtpk = dspk.Tables[0].Copy(); //复制一份table
Grid4.DataSource = dtpk; //DataTable
Grid4.DataBind();
}
else if (TabStrip2.ActiveTabIndex == 3)
{
//Grid5
Grid5.DataSource = bll.查询盘点报告();//DataTable
Grid5.DataBind();
//绑定条件数据
List <School学校名称表> xxmc = bll.查询学校名称();
单位.DataTextField = "学校名称";
单位.DataValueField = "ID";
单位.DataSource = xxmc;
单位.DataBind();
School资产转移BLL bllzy = new School资产转移BLL();
List <School一级部门表> gsbm = bllzy.byzc();
部门.DataTextField = "名称";
部门.DataValueField = "ID";
部门.DataSource = gsbm;
部门.DataBind();
List <School一级类别表> yjlb = bll.查询一级类别();
一级.DataTextField = "名称";
一级.DataValueField = "ID";
一级.DataSource = yjlb;
一级.DataBind();
List <School建筑物信息表> 查询建筑物 = bll.查询建筑物信息表();
存放地点.DataTextField = "名称";
存放地点.DataValueField = "ID";
存放地点.DataSource = 查询建筑物;
存放地点.DataBind();
}
}
private void LoadDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional Chart
{
DataTable _DataTable = _DataList.Tables[0];
Division_EmpListChart(_DataTable);
}
else
{
EmpListChart1.Items.Clear();
}
if (_DataList.Tables[1].Rows.Count > 0) // Employee Location Chart
{
DataTable _DataTable = _DataList.Tables[1];
Location_EmpListChart(_DataTable);
}
else
{
EmpListChart2.Items.Clear();
}
if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile Chart
{
DataTable _DataTable = _DataList.Tables[2];
AgeProfile_EmpListChart(_DataTable);
}
else
{
EmpListChart3.Items.Clear();
}
if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile Chart
{
DataTable _DataTable = _DataList.Tables[3];
ServiceProfile_EmpListChart(_DataTable);
}
else
{
EmpListChart4.Items.Clear();
}
if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[4];
Grid3.DataSource = _DataTable;
Grid3.DataBind();
}
else
{
Grid3.DataSource = null;
Grid3.DataBind();
}
if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[5];
Grid4.DataSource = _DataTable;
Grid4.DataBind();
}
else
{
Grid4.DataSource = null;
Grid4.DataBind();
}
if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[6];
Grid5.DataSource = _DataTable;
Grid5.DataBind();
}
else
{
Grid5.DataSource = null;
Grid5.DataBind();
}
if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
{
DataTable _DataTable = _DataList.Tables[7];
Grid1.DataSource = _DataTable;
Grid1.DataBind();
}
else
{
Grid1.DataSource = null;
Grid1.DataBind();
}
if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
{
DataTable _DataTable = _DataList.Tables[8];
Grid2.DataSource = _DataTable;
Grid2.DataBind();
}
else
{
Grid2.DataSource = null;
Grid2.DataBind();
}
if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
{
DataTable _DataTable = _DataList.Tables[10];
Grid7.DataSource = _DataTable;
Grid7.DataBind();
}
else
{
Grid7.DataSource = null;
Grid7.DataBind();
}
if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
{
DataTable _DataTable = _DataList.Tables[11];
Grid10.DataSource = _DataTable;
Grid10.DataBind();
}
else
{
Grid10.DataSource = null;
Grid10.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}