private void BindGrid3(string SDATE, string EDATE) { string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString); string cmdTxt = @" SELECT [USER_NAME],[COMPANY_NAME],[OPPORTUNITY_NAME],[PRODUCT],REPLACE([NOTE_CONTENT],char(10),'<br/>') AS [NOTE_CONTENT] ,[tb_NOTE].[CREATE_DATETIME],Replace(Convert(Varchar(12),CONVERT(money,ISNULL([tb_OPPORTUNITY].[AMOUNT],0)),1),'.00','') AS AMOUNT,(CASE WHEN [USER_NAME]='公司' THEN '蔡顏鴻' ELSE [USER_NAME] END ) AS TEMP FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_OPPORTUNITY] LEFT JOIN [HJ_BM_DB].[dbo].[tb_USER] ON [USER_ID]=[OWNER_ID] LEFT JOIN [HJ_BM_DB].[dbo].[tb_COMPANY] ON [tb_OPPORTUNITY].[COMPANY_ID]=[tb_COMPANY].[COMPANY_ID] WHERE [tb_NOTE].[OPPORTUNITY_ID]=[tb_OPPORTUNITY].[OPPORTUNITY_ID] AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE ORDER BY TEMP,[USER_NAME],[COMPANY_NAME],[tb_NOTE].[CREATE_DATETIME] "; m_db.AddParameter("@SDATE", SDATE); m_db.AddParameter("@EDATE", EDATE); DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt)); Grid3.DataSource = dt; Grid3.DataBind(); }
protected override void Render(Graphics g) { for (int gi = 0; gi < grids.Count; gi++) { Grid3 grid = grids[gi]; Mesh mesh = meshes[gi]; Vector3 v0, v1, v2; PointF[] poly = new PointF[3]; for (int i = 2; i < mesh.Inds.Length; i += 3) { v0 = grid.RsltVerts[mesh.Inds[i - 0]]; v1 = grid.RsltVerts[mesh.Inds[i - 1]]; v2 = grid.RsltVerts[mesh.Inds[i - 2]]; /*деление - константа * прибавление - дистанция от вершины до камеры */ // Perspective projection if (v0.z != 0) { v0 *= (-v0.z / 100 + 2); } if (v1.z != 0) { v1 *= (-v1.z / 100 + 2); } if (v2.z != 0) { v2 *= (-v2.z / 100 + 2); } // wireframe //g.DrawLine(pen, v0.x, v0.y, v1.x, v1.y); //g.DrawLine(pen, v1.x, v1.y, v2.x, v2.y); //g.DrawLine(pen, v2.x, v2.y, v0.x, v0.y); // solid mode poly[0].X = v0.x; poly[0].Y = v0.y; poly[1].X = v1.x; poly[1].Y = v1.y; poly[2].X = v2.x; poly[2].Y = v2.y; int clr = (byte)(((float)i / mesh.Inds.Length) * 255); if (clr > 255) { clr = 255; } brush = new SolidBrush(Color.FromArgb(clr, clr, 255)); g.FillPolygon(brush, poly); } } }
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 查看流程状态.Text = keys[1].ToString(); 查看单据编号.Text = keys[2].ToString(); 查看事项名称.Text = keys[3].ToString(); 查看备注.Text = keys[4].ToString(); this.Label1.Text = "数量合计:" + keys[5].ToString() + "---金额合计:" + keys[6].ToString() + "元"; 查看申请人.Text = keys[7].ToString(); 查看制单日期.Text = keys[8].ToString(); 查看供应商.Text = keys[9].ToString(); 查看供应商联系方式.Text = keys[10].ToString(); 查看合同编号.Text = keys[11].ToString(); 查看发票号.Text = keys[12].ToString(); 查看验收人.Text = keys[13].ToString(); 查看记账人.Text = keys[14].ToString(); 查看取得方式.Text = keys[15].ToString(); 查看购置日期.Text = keys[16].ToString(); 查看验收日期.Text = keys[17].ToString(); DataSet ds = gzysbll.购置验收查询设备(ID); DataTable dt = ds.Tables[0].Copy(); //复制一份table DataTable source = dt; Grid3.DataSource = dt; //DataTable Grid3.DataBind(); //List<办公设备信息表> list = cbll.购置验收查询设备(XID); 处理资产.Hidden = false; Grid3.Hidden = false; } }
protected void Grid1_RowSelect(object sender, FineUI.GridRowSelectEventArgs e) { string str = GridViewHelper.GetSelectedKey(Grid1, true); string[] plan_id_shop_id = str.Split(','); string plan_id = plan_id_shop_id[1]; string shop_id = plan_id_shop_id[0]; DataTable dt_left = null; dt_left = PLAN00Bll.GetInstence().GET_PLAN_LEFT_LIST(plan_id);// Get_PLAN_Left_List(plan_id); Grid2.DataSource = dt_left; Grid2.DataBind(); Grid2.SelectedRowIndex = 0; string prod_id = GridViewHelper.GetSelectedKey(Grid2, true); DataTable dt_right = null; dt_right = PLAN00Bll.GetInstence().GET_PLAN_RIGHT_LIST(plan_id); Grid3.DataSource = dt_right; Grid3.DataBind(); }
private void BindGrid3(string SDAY, string EDAY) { string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString); this.Session["SDAY"] = SDAY; this.Session["EDAY"] = EDAY; string cmdTxt = @" SELECT [tb_USER].USER_ACCOUNT,[tb_USER].USER_NAME,[tb_USER].GROUP_NAME,[tb_COMPANY].COMPANY_NAME FROM [HJ_BM_DB].[dbo].[tb_USER],[HJ_BM_DB].[dbo].[tb_COMPANY] WHERE [tb_USER].USER_ID=[tb_COMPANY].OWNER_ID AND COMPANY_ID NOT IN ( SELECT COMPANY_ID FROM [HJ_BM_DB].[dbo].[tb_NOTE] WHERE CONVERT(NVARCHAR,[tb_NOTE].[UPDATE_DATETIME],111)>=@SDAY AND CONVERT(NVARCHAR,[tb_NOTE].[UPDATE_DATETIME],111)<=@EDAY ) GROUP BY [tb_USER].USER_ACCOUNT,[tb_USER].USER_NAME,[tb_USER].GROUP_NAME,[tb_COMPANY].COMPANY_NAME ORDER BY [tb_USER].USER_ACCOUNT,[tb_USER].USER_NAME,[tb_USER].GROUP_NAME,[tb_COMPANY].COMPANY_NAME "; m_db.AddParameter("@SDAY", SDAY); m_db.AddParameter("@EDAY", EDAY); DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt)); Grid3.DataSource = dt; Grid3.DataBind(); }
private void BindGrid3() { try { using (var appdb = new AppContext()) { var q = from a in appdb.allitems select a; // 在职务名称中搜索 string searchText = txtKeyword.Text;// ddlItemNo.Text; if (!String.IsNullOrEmpty(searchText)) { q = q.Where(t => t.ItemNo.Contains(searchText) || t.ItemName.Contains(searchText) || t.Material.Contains(searchText) || t.Sclass.Contains(searchText) || t.SurfaceDeal.Contains(searchText)); } q = q.Take(100); // 在查询添加之后,排序和分页之前获取总记录数 //Grid3.RecordCount = q.Count(); // 排列和分页 //q = SortAndPage<BomDetail>(q, Grid1); Grid3.DataSource = q; Grid3.DataBind(); } } catch (Exception ee) { Alert.Show(ee.ToString()); } }
private void BindGrid3() { 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())); Grid3.DataSource = dt; Grid3.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); }
//调整步骤的序号 private void updateStepSort(int curIndex) { DataTable dt = new DataTable(); dt = getDataTableGrid3(); //添加一个排序列 dt.Columns.Add("sort"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["sort"] = i + 1; } for (int i = 0; i < dt.Rows.Count; i++) { //上个节点的排序 + 1 if (i == curIndex - 1) { dt.Rows[i]["sort"] = curIndex + 1; } //当前节点的排序 - 1 if (i == curIndex) { dt.Rows[i]["sort"] = curIndex; } } dt.DefaultView.Sort = "sort";//根据sort重新排序 Grid3.DataSource = dt; Grid3.DataBind(); }
public void Grid_IngestsInputCorrectly() { var grid = new Grid3(Example1); grid.Cubes.Should().HaveCount(75); // because we initialize the neighbors now too grid.Count(x => x.IsActive).Should().Be(5); }
protected void Grid1_RowClick(object sender, FineUI.GridRowClickEventArgs e) { bindGrid2(Grid1.DataKeys[e.RowIndex][0].ToString()); //DataTable dt = null; Grid3.DataSource = null; Grid3.DataBind(); }
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Action1") { 流程状态待派单.Hidden = false; object[] keys = Grid1.DataKeys[e.RowIndex]; int ID = Convert.ToInt32(keys[0].ToString());//获取ID xx.Text = ID.ToString(); 查看报修人.Text = keys[3].ToString(); 查看报修时间.Text = keys[4].ToString(); 查看单号.Text = keys[2].ToString(); 查看报修地址.Text = keys[5].ToString(); 查看故障描述.Text = keys[6].ToString(); if (keys[10] == null) { Image2.ImageUrl = "/res/images/zwzp.png"; } else { Image2.ImageUrl = keys[10].ToString(); } DataSet ds = bll.资产报修查看详情(ID); DataTable dt = ds.Tables[0].Copy(); //复制一份table Grid3.DataSource = dt; //DataTable Grid3.DataBind(); } }
private void BindGrid3(string SDATE, string EDATE) { string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString); string cmdTxt = @" SELECT [USER_NAME],[COMPANY_NAME] ,[NOTE_CONTENT] ,CONVERT(NVARCHAR,[tb_NOTE].[CREATE_DATETIME],111) AS [CREATE_DATETIME],CASE WHEN ([tb_NOTE].[FILE_NAME] LIKE '%Jpg%' OR [tb_NOTE].[FILE_NAME] LIKE '%JPG%' OR [tb_NOTE].[FILE_NAME] LIKE '%jpg%' OR [tb_NOTE].[FILE_NAME] LIKE '%png%' OR [tb_NOTE].[FILE_NAME] LIKE '%PNG%' OR [tb_NOTE].[FILE_NAME] LIKE '%Pmg%') THEN [tb_NOTE].[FILE_NAME] ELSE NULL END AS [FILE_NAME] FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY] LEFT JOIN [HJ_BM_DB].[dbo].[tb_USER] ON [USER_ID]=[OWNER_ID] WHERE [tb_COMPANY].COMPANY_ID=[tb_NOTE].COMPANY_ID AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE ORDER BY [USER_NAME],[COMPANY_NAME], [tb_NOTE].[CREATE_DATETIME] "; m_db.AddParameter("@SDATE", SDATE); m_db.AddParameter("@EDATE", EDATE); //string cmdTxt = @" // SELECT CONVERT(NVARCHAR,DATES,111) DATES,[TB_EB_USER].[USER_GUID],[TB_EB_USER].[ACCOUNT],[TB_EB_USER].[NAME],[tb_USER].USER_ID,START_TIME,[SUBJECT],[DESCRIPTION],TEMP4.[CREATE_DATETIME],[COMPANY_NAME] ,[NOTE_CONTENT] // FROM ( // SELECT DATEADD(d,rows-1,@SDATE) DATES from // ( // SELECT // ID,row_number()over(ORDER BY id) rows // FROM // sysobjects // )TEMP // WHERE // TEMP.rows <= DATEDIFF(d,@SDATE, @EDATE) + 1 // ) AS TEMP2 // LEFT JOIN [UOF].[dbo].[TB_EB_USER] ON [TB_EB_USER].[NAME] IN ('洪櫻芬','王琇平','葉枋俐','何姍怡','林琪琪','林杏育','張釋予','蔡顏鴻','陳帟靜','黃鈺涵') // LEFT JOIN [HJ_BM_DB].[dbo].[tb_USER] ON [tb_USER].USER_GUID=[TB_EB_USER].USER_GUID // LEFT JOIN // ( // SELECT [EXECUTE_USER],CONVERT(NVARCHAR,[START_TIME],111) AS START_TIME,[SUBJECT],[DESCRIPTION] // FROM [UOF].dbo.[TB_EIP_SCH_WORK] // WHERE [SOURCE_TYPE]='Self' // ) AS TEMP3 ON TEMP3.[EXECUTE_USER]=[TB_EB_USER].USER_GUID AND START_TIME=CONVERT(NVARCHAR,DATES,111) // LEFT JOIN // ( // SELECT [OWNER_ID],[COMPANY_NAME] ,[NOTE_CONTENT],CONVERT(NVARCHAR,[tb_NOTE].[CREATE_DATETIME],111) CREATE_DATETIME // FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY] // WHERE [tb_COMPANY].COMPANY_ID=[tb_NOTE].COMPANY_ID // ) AS TEMP4 ON TEMP4.OWNER_ID=USER_ID AND TEMP4.CREATE_DATETIME=CONVERT(NVARCHAR,DATES,111) // WHERE (ISNULL([SUBJECT],'')<>'' OR ISNULL([NOTE_CONTENT],'')<>'') // ORDER BY [NAME],CONVERT(NVARCHAR,DATES,111) // "; DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt)); Grid3.DataSource = dt; Grid3.DataBind(); }
public void Puzzle1_3DCubeGrid_FindActiveCubesAfterBoot() { var grid = new Grid3(Input.Day17); grid.Boot(); grid.ActiveCubeCount.Should().Be(298); }
public void GridExample1_CountsActiveCubes_AfterBoot() { var grid = new Grid3(Example1); grid.Boot(); grid.ActiveCubeCount.Should().Be(112); }
public void Setup() { AltEntitySync.Init(1, 500, repository => new MockNetworkLayer(repository), () => new Grid(50_000, 50_000, 100, 10_000, 10_000), new IdProvider()); grid3 = new Grid3(50_000, 50_000, 100, 10_000, 10_000); }
////加载文档分类 //private void bindDocType() //{ // string sqlCmd = "select * from OA_DocMgmt_DocType where pid='0' and stat='1' order by type_name"; // DataTable dt = new DataTable(); // SqlSel.GetSqlSel(ref dt, sqlCmd); // ddl_docType.DataTextField = "type_name"; // ddl_docType.DataValueField = "id"; // ddl_docType.DataSource = dt; // ddl_docType.DataBind(); // this.ddl_docType.Items.Insert(0, new FineUI.ListItem("所有类型", "%")); //} //文档明细列表 private void bindDocList(string docType) { string sqlCmd = "select * from OA_DocMgmt_DocList where docTyp='" + docType + "' and docStat='1'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); Grid3.DataSource = dt; Grid3.DataBind(); }
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Action1") { OffSession(); string 职务 = Session["职务"].ToString(); if (职务 == "财务人员") { Button5.Text = "同意"; Button6.Text = "拒绝"; } else { Button5.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 == "完成") { Button5.Enabled = false; Button6.Text = "关闭"; } 查看单据编号.Text = keys[2].ToString(); 查看事项名称.Text = keys[3].ToString(); 查看备注.Text = keys[4].ToString(); this.Label1.Text = "数量合计:" + keys[5].ToString() + "---金额合计:" + keys[6].ToString() + "元"; 查看申请人.Text = keys[7].ToString(); 查看制单日期.Text = keys[8].ToString(); 查看供应商.Text = keys[9].ToString(); 查看供应商联系方式.Text = keys[10].ToString(); 查看合同编号.Text = keys[11].ToString(); 查看发票号.Text = keys[12].ToString(); //查看验收人.Text = keys[13].ToString(); if (keys[14] == null) { 查看记账人.Text = ""; } else { 查看记账人.Text = keys[14].ToString(); } 查看取得方式.Text = keys[15].ToString(); 查看购置日期.Text = keys[16].ToString(); //查看验收日期.Text = keys[17].ToString(); DataSet ds = gzysbll.购置验收查询设备(ID); DataTable dt = ds.Tables[0].Copy(); //复制一份table DataTable source = dt; Grid3.DataSource = dt; //DataTable Grid3.DataBind(); 处理资产.Hidden = false; } }
//查找班级 protected void btnSearch_Click(object sender, EventArgs e) { grade = SelectGrade.SelectedItem.Text; string sqlstr = "select Grade,Class from Class where Grade ='" + grade + "'"; DataTable dt = Common.datatable(sqlstr); Grid3.DataSource = dt; Grid3.DataBind(); }
private void BindGrid() { Grid1.DataSource = GetDataTable1(); Grid1.DataBind(); Grid2.DataSource = GetDataTable2(); Grid2.DataBind(); Grid3.DataSource = GetDataTable3(); Grid3.DataBind(); }
private Grid3 <MeshTileCell> CreateGrid() { var dimensions = gridDimensions.GetGridPoint(); var shape = ImplicitShape.Parallelepiped(dimensions); var storage = shape.ToExplicit(new GridBounds(GridPoint3.Zero, dimensions)); var grid = new Grid3 <MeshTileCell>(storage); return(grid); }
//班级表单数据绑定 public void BindGrid3() { grade = SelectGrade.SelectedItem.Text; string sqlstr = "select Class,Grade from Class where Grade = '" + grade + "'"; DataTable dt = Common.datatable(sqlstr); // DataSet ds = Common.dataSet(sqlstr); Grid3.DataSource = dt; Grid3.DataBind(); }
public void Setup() { AltEntitySync.Init(1, 500, _ => true, (threadCount, repository) => new MockNetworkLayer(threadCount, repository), (entity, threadCount) => (entity.Id % threadCount), (entityId, entityType, threadCount) => (entityId % threadCount), (id) => new Grid(50_000, 50_000, 100, 10_000, 10_000), new IdProvider()); grid3 = new Grid3(50_000, 50_000, 100, 10_000, 10_000); }
//// draw floor //transform.position = new Vector3(0, 1 / 10, 0); //transform.localScale = new Vector3(gridsize + 1, height, gridsize + 1); ////Cube cube = new Cube(); //Instantiate(cube, transform.position, transform.rotation); // Use this for initialization void Start() { g3 = (Grid3)gameObject.GetComponent(typeof(Grid3)); int gridsize = g3.ArraySize; Cell[,] mazeArray = g3.CellArray; //get the 2d array of nodes from mazegen //maze walls int centerVal = (gridsize - 1) / 2; for (int i = 0; i < gridsize; i++) { for (int j = 0; j < gridsize; j++) { if (!mazeArray[i, j].path) //if wall exists { GameObject mazeWall = GameObject.CreatePrimitive(PrimitiveType.Cube); mazeWall.transform.position = new Vector3(i - centerVal, height, j - centerVal); mazeWall.transform.localScale = new Vector3(wallThick, wallHeight, wallThick); } } } // top and bottom walls: borders for (int i = 0; i < gridsize + 2; i++) { if (i - 1 != g3.startRow) { GameObject wall = GameObject.CreatePrimitive(PrimitiveType.Cube); wall.transform.position = new Vector3(i - 1 - centerVal, height, -centerVal - 1); wall.transform.localScale = new Vector3(wallThick, wallHeight, wallThick); GameObject wall2 = GameObject.CreatePrimitive(PrimitiveType.Cube); wall2.transform.position = new Vector3(i - 1 - centerVal, height, centerVal + 1); wall2.transform.localScale = new Vector3(wallThick, wallHeight, wallThick); } } // left and right walls for (int i = 0; i < gridsize; i++) { GameObject wall = GameObject.CreatePrimitive(PrimitiveType.Cube); wall.transform.position = new Vector3(-centerVal - 1, height, i - centerVal); wall.transform.localScale = new Vector3(wallThick, wallHeight, wallThick); GameObject wall2 = GameObject.CreatePrimitive(PrimitiveType.Cube); wall2.transform.position = new Vector3(centerVal + 1, height, i - centerVal); wall2.transform.localScale = new Vector3(wallThick, wallHeight, wallThick); } //ground GameObject ground = GameObject.CreatePrimitive(PrimitiveType.Cube); ground.transform.localScale = new Vector3(gridsize + 1, (float)0.2, gridsize + 1); }
private void BindGrid3(string TradeId) { string sqlCmd = "select t1.recId,t3.GoodsNo,t3.GoodsName,t1.regCount,t1.dealwith,t1.regTime from ES_WH_SellBackRegister t1 " + "left join G_SellBack_GoodsList t2 on t1.recId=t2.recId " + "left join g_goods_goodsList t3 on cast(t2.goodsid as int)= t3.goodsid where billId = '" + TradeId + "' order by regTime"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); Grid3.DataSource = dt; Grid3.DataBind(); }
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Action1") { OffSession(); string username = Session["姓名"].ToString(); //ID,流程状态,单据编号,借用人,借出人,提交时间,借用时间,预计归还时间,备注信息,Sort,资产ID object[] keys = Grid1.DataKeys[e.RowIndex]; int Sort = Convert.ToInt32(keys[9].ToString()); int ID = Convert.ToInt32(keys[0].ToString());//获取ID FlowID.Text = ID.ToString(); 查看流程状态.Text = keys[1].ToString(); //if (查看流程状态.Text == "完成") //{ // btnok.Enabled = false; // btnon.Text = "关闭"; //} 查看单据编号.Text = keys[2].ToString(); 查看借用人.Text = keys[3].ToString(); 查看借出人.Text = keys[4].ToString(); if (username == 查看借出人.Text && Sort == 1) { btnok.Text = "同意借出"; btnon.Text = "拒绝借出"; } else if (Sort == 2 && 查看借用人.Text == username) { btnok.Text = "确认归还"; btnon.Text = "关闭"; } else if (Sort == 3 && 查看借出人.Text == username) { btnok.Text = "已归还"; btnon.Text = "未归还"; } else { btnok.Text = ""; btnon.Text = "关闭"; } 查看提交时间.Text = keys[5].ToString(); 查看借用时间.Text = keys[6].ToString(); 查看预计归还时间.Text = keys[7].ToString(); 查看备注信息.Text = keys[8].ToString(); string zcid = keys[10].ToString(); 资产ID.Text = zcid; School资产借还交接BLL bll = new School资产借还交接BLL(); Grid3.DataSource = bll.资产借还查看详情(zcid); Grid3.DataBind(); Window3.Hidden = false; } }
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.查询设备平均故障时间("车体喷砂系统"); } }
private void BindGrid3() { // 1.设置总项数 Grid3.RecordCount = GetTotalCount3(); // 2.获取当前分页数据 DataTable table = GetPagedDataTable3(Grid3.PageIndex, Grid3.PageSize); // 3.绑定到Grid Grid3.DataSource = table; Grid3.DataBind(); }
protected void Grid1_RowSelect(object sender, FineUI.GridRowSelectEventArgs e) { string str = GridViewHelper.GetSelectedKey(Grid1, true); string[] col_id_shop_id = str.Split(','); string shop_id = col_id_shop_id[1]; string col_id = col_id_shop_id[0]; DataTable dt_left = null; dt_left = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_LEFT_LIST(col_id); Grid2.DataSource = dt_left; Grid2.DataBind(); Grid2.SelectedRowIndex = 0; string prod_id = GridViewHelper.GetSelectedKey(Grid2, true); DataTable dt_right = null; dt_right = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_RIGHT_LIST(prod_id, col_id); Grid3.DataSource = dt_right; Grid3.DataBind(); var PurchasePLANColumn0 = Grid3.FindColumn("SUP_QUAN0") as FineUI.RenderField; // HeaderText="生产量/采购量" var PurchasePLANColumn1 = Grid3.FindColumn("SUP_QUAN1") as FineUI.RenderField; // HeaderText="生产量/采购量" var model_ARCHIVEORDERS = new Col_Order00(x => x.COL_ID == col_id); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string area_id = model_SHOP.SHOP_Area_ID.ToString(); // var model_SYS_PARAMATERS = new SYS_PARAMATERS(x => x.Area_Id == area_id); //根据参数表 显示信息 //if (model_SYS_PARAMATERS != null) //{ //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 0) //产品类型汇整 // { //if (model_ARCHIVEORDERS.PROD_TYPE == 0) { PurchasePLANColumn1.Hidden = true; PPhidId.Text = "0"; } //if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } //if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } // } //if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 1) //产品类型汇整 //{ // if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "0"; } // if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; } //} // } }
protected void btnIcon1_Click(object sender, EventArgs e) { Grid3.RecordCount = 700; //测试,去数据库获取总数 // 2.获取当前分页数据 DataTable table = GetPagedDataTableall(Grid3.PageIndex, Grid3.PageSize); //查询方法 // 3.绑定到Grid Grid3.DataSource = table;//DataTable Grid3.DataBind(); Window2.Hidden = false; }
public Grid3<int> CreateGrid() { Grid3<int> grid = new Grid3<int>(); foreach( RectTool rectTool in rectTools ) { switch( rectTool.toolType ) { case RectTool.eToolType.add: grid.AddCells( rectTool.toolBlockId, rectTool.toolStart, rectTool.toolSize ); break; case RectTool.eToolType.remove: grid.RemoveCells( rectTool.toolStart, rectTool.toolSize ); break; case RectTool.eToolType.writeover: grid.WriteoverCells( rectTool.toolBlockId, rectTool.toolStart, rectTool.toolSize ); break; case RectTool.eToolType.intersect: grid.IntersectCells( rectTool.toolBlockId, rectTool.toolStart, rectTool.toolSize ); break; } } return grid; }
public void GenerateMiniblocks() { MiniblockRectangleTool miniblockRectangleTool = gameObject.GetComponent<MiniblockRectangleTool>(); blockIdMap = ( miniblockRectangleTool != null ) ? miniblockRectangleTool.CreateGrid() : blockIdMap; GenerateMesh(); return; }