private void Awake() { itemDataTable = this; itemImage = itemImageObj.GetComponent <Image>(); itemInfoText = itemInfo.GetComponent <Text>(); }
public override global::System.Data.DataTable Clone() { ItemDataTable cln = ((ItemDataTable)(base.Clone())); cln.InitVars(); return(cln); }
/// <summary> /// Builds the Min-Max DataTable. /// </summary> /// <returns>A DataTable representing all the QuickBooks Data to be written to the Min-Max Doc.</returns> public DataTable Analyze() { if (!excelDoc.excelObjSet) { excelDoc.SetExcelObjects(); } if (excelDoc.excelObjSet) { Log.WriteLine("...Analyzing Part Numbers..."); IQuickBooksData itemDataTable = new ItemDataTable(); IQuickBooksData salesOrderDataTable = new SODataTable(); excelDoc.InStreamData(); itemDataTable.BuildTable(); salesOrderDataTable.BuildTable(); minMaxDt = new DataTable().BuildTable(salesOrderDataTable, itemDataTable, excelDoc.partNumList); excelDoc.Write(minMaxDt); return(minMaxDt); } else { Log.WriteLine("Cannot Access Min-Max Document."); return(new DataTable()); } }
private void btnLocalizaPedido_Click(object sender, EventArgs e) { PedidoTableAdapter taPedido = new PedidoTableAdapter(); DataSet_Dados_do_Banco.PedidoDataTable dt = new DataSet_Dados_do_Banco.PedidoDataTable(); dt = taPedido.PesquisaPedido(int.Parse(txtNumPedidoPesq.Text)); if (dt.Rows.Count == 0) { MessageBox.Show("Pedido inexistente"); txtNumPedidoPesq.Focus(); txtNumPedidoPesq.SelectAll(); } else { lblNumeroPedido.Text = dt.Rows[0]["ped_id"].ToString(); cmbCliente.SelectedValue = dt.Rows[0]["cli_id"]; dtpDataVenda.Value = DateTime.Parse(dt.Rows[0]["ped_dtEncomenda"].ToString()); lblTotalPedido.Text = String.Format(dt.Rows[0]["ped_valor"].ToString(), "###,##0.00"); txtObservacao.Text = dt.Rows[0]["Ped_observacao"].ToString(); //if (dt.Rows[0]["ped_id"].ToString() == "") //TODO lblStatus ItemTableAdapter taItem = new ItemTableAdapter(); ItemDataTable dtItem = new ItemDataTable(); dtItem = taItem.Pesquisa_Itens_Pedido(int.Parse(txtNumPedidoPesq.Text)); dgvItem.DataSource = dtItem; dgvItem.Columns["Codigo"].DisplayIndex = 0; dgvItem.Columns["Descricao"].DisplayIndex = 1; dgvItem.Columns["Quantidade"].DisplayIndex = 2; dgvItem.Columns["Valor_Unit"].DisplayIndex = 3; dgvItem.Columns["TotalItem"].DisplayIndex = 4; } }
public void PolyItemTest() { QuickBooksDataTable itemTable = new ItemDataTable(); itemTable.BuildTable(); itemTable.Write(@"\\msw-fp1\user$\wchan\Documents\Visual Studio 2015\Projects\InventoryManagementApp\InventoryManagementApp\bin\Debug\Test\PolyItem.csv"); }
private void InitClass() { this.DataSetName = "dataset_pricelist"; this.Prefix = ""; this.Namespace = "http://tempuri.org/DataSet1.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableItem = new ItemDataTable(); base.Tables.Add(this.tableItem); }
public ReservationDAO() { _userDao = new UserDao(); _reservationAdapter = new ReservationTableAdapter(); _reservationTable = new ReservationDataTable(); _reservationAdapter.Fill(_reservationTable); _itemAdapter = new ItemTableAdapter(); _itemTable = new ItemDataTable(); _itemAdapter.Fill(_itemTable); }
internal void InitVars(bool initTable) { this.tableItem = ((ItemDataTable)(base.Tables["Item"])); if ((initTable == true)) { if ((this.tableItem != null)) { this.tableItem.InitVars(); } } }
public override void BuildItemDrawData(List <JDStruc> jdStruc) { ItemWorkDataTableRead itemWorkDataTableRead = new ItemWorkDataTableRead(this.ID); ItemDataTable = (DataTable)itemWorkDataTableRead.ReturnItemInstance(DrawItemStyle.TextItem); ItemDataTable.TableName = "g437"; ItemDataTable.WriteXml("ceshi", XmlWriteMode.WriteSchema, true); DataTable dt = new DataTable(); dt.TableName = "g437"; // dt.ReadXmlSchema("ceshi"); dt.ReadXml("ceshi"); }
public void PolyMinMaxTest() { QuickBooksDataTable itemTable = new ItemDataTable(); QuickBooksDataTable soTable = new SODataTable(); itemTable.BuildTable(); soTable.BuildTable(); using (excelDoc = new ExcelDoc()) { excelDoc.Open(); excelDoc.InStreamData(); excelDoc.Close(); DataTable minMaxDt = new DataTable().BuildTable(soTable, itemTable, excelDoc.partNumList); minMaxDt.Write(@"\\msw-fp1\user$\wchan\Documents\Visual Studio 2015\Projects\InventoryManagementApp\InventoryManagementApp\bin\Debug\Test\PolyMinMax.csv"); } }
private void InitClass() { this.DataSetName = "Content"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Content.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableItem = new ItemDataTable(); base.Tables.Add(this.tableItem); this.tableItemInstance = new ItemInstanceDataTable(); base.Tables.Add(this.tableItemInstance); this.tablePicture = new PictureDataTable(); base.Tables.Add(this.tablePicture); global::System.Data.ForeignKeyConstraint fkc; fkc = new global::System.Data.ForeignKeyConstraint("FK_Item_ItemInstance", new global::System.Data.DataColumn[] { this.tableItem.ContentIdColumn}, new global::System.Data.DataColumn[] { this.tableItemInstance.ContentIdColumn}); this.tableItemInstance.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.Cascade; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; fkc = new global::System.Data.ForeignKeyConstraint("FK_Item_Picture", new global::System.Data.DataColumn[] { this.tableItem.ContentIdColumn}, new global::System.Data.DataColumn[] { this.tablePicture.ContentIdColumn}); this.tablePicture.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; this.relationFK_Item_ItemInstance = new global::System.Data.DataRelation("FK_Item_ItemInstance", new global::System.Data.DataColumn[] { this.tableItem.ContentIdColumn}, new global::System.Data.DataColumn[] { this.tableItemInstance.ContentIdColumn}, false); this.Relations.Add(this.relationFK_Item_ItemInstance); this.relationFK_Item_Picture = new global::System.Data.DataRelation("FK_Item_Picture", new global::System.Data.DataColumn[] { this.tableItem.ContentIdColumn}, new global::System.Data.DataColumn[] { this.tablePicture.ContentIdColumn}, false); this.Relations.Add(this.relationFK_Item_Picture); }
internal void InitVars(bool initTable) { this.tableItem = ((ItemDataTable)(base.Tables["Item"])); if ((initTable == true)) { if ((this.tableItem != null)) { this.tableItem.InitVars(); } } this.tableItemInstance = ((ItemInstanceDataTable)(base.Tables["ItemInstance"])); if ((initTable == true)) { if ((this.tableItemInstance != null)) { this.tableItemInstance.InitVars(); } } this.tablePicture = ((PictureDataTable)(base.Tables["Picture"])); if ((initTable == true)) { if ((this.tablePicture != null)) { this.tablePicture.InitVars(); } } this.relationFK_Item_ItemInstance = this.Relations["FK_Item_ItemInstance"]; this.relationFK_Item_Picture = this.Relations["FK_Item_Picture"]; }
internal ItemRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableItem = ((ItemDataTable)(this.Table)); }
/// <summary> /// 方法:返回一个文本结构体的泛型 /// </summary> /// <param name="jdTop">参数:井顶</param> /// <param name="jdBottom">参数:井底</param> /// <returns></returns> private List <TextItemDrawStruc> GetJoinAdjustTextItemDrawStrucList(double jdTop, double jdBottom) { List <TextItemDrawStruc> relist = new List <TextItemDrawStruc>();//将用于返回值 double depthtop, depthbottom = jdBottom; string sqlTxt = GetJoinAdjustTxtItemSqlTxt(jdTop.ToString(), jdBottom.ToString());//通过井顶和井底参数返回一个sql语句用于查询 string tmpstr = ""; if (sqlTxt == "") { return(relist); } //查询获取所需的内容,此时已经将数据提取出来 DataRow[] drs = ItemDataTable.Select(sqlTxt, textItemStruct.TxtJDTop + " ASC"); string[] tifieldarr = textItemStruct.FromFieldName.Split(';');//拆解字段形成一个数组,该数组内的第0个内容非常特殊,保存的是所用数据的内容 string fieldname = ""; if (drs.Length < 1)//如果没有取到数据,退出 { return(relist); } //该部分算法说明:通过循环将上一个记录的井顶做为井底,然后将一个井段按照小段做成一个泛型 //该部分获取的是一个井段内以某个高度段为基准进行的分段 foreach (DataRow dr in drs) { depthtop = StrUtil.StrToDouble(dr[textItemStruct.TxtJDTop].ToString(), "绘图数据缺少顶部数据", "顶部数据为非数值型"); if (depthtop < jdTop) { depthtop = jdTop; } //对于depthtop的处理 if (textItemStruct.Depthstyle == DepthFieldStyle.TopAndBottom)//顶底型处理 { depthbottom = StrUtil.StrToDouble(dr[textItemStruct.TxtJDBottom].ToString(), "绘图数据缺少底部数据", "底数据为非数值型"); } else if (textItemStruct.Depthstyle == DepthFieldStyle.TopAndHeigh)//顶深型处理 { depthbottom = depthtop + StrUtil.StrToDouble(dr[textItemStruct.TxtJDHeigh].ToString(), "绘图数据缺少厚度数据", "厚度数据为非数值型"); } else if (textItemStruct.Depthstyle == DepthFieldStyle.Top)//仅头型,直接赋值 { depthbottom = depthtop; } //当depthbottom超界进行赋值处理 if (depthbottom > jdBottom) { depthbottom = jdBottom; } if (tifieldarr.Length > 0)//字段集合长度大于0,也就是存在字段,则取出首字段赋值 { tmpstr = ""; fieldname = tifieldarr[0].Trim(); if (fieldname != "") { tmpstr = dr[fieldname].ToString().Trim();//该段内容的值 } } if (tmpstr != "00") { relist.Add(new TextItemDrawStruc(depthtop, depthbottom, tmpstr));//添加新结构体 LegendManage.UpdateTxtLegendLst(fieldname, textItemStruct.FromFieldName, tmpstr); } } return(relist); }