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;
}
