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