public void SearchInvoiceItems() { this.dsInvoiceItems = InvoiceItem.GetInvoiceItems(this.cnConnection, this.iiSearch); this.dgvInvoiceItems.DataSource = this.dsInvoiceItems; this.dgvInvoiceItems.DataMember = "tabInvoiceItems"; for (int i = 0; i < this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows.Count; i++) { if ((int)this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["intRequestNumber"] == -1) { this.dgvInvoiceItems.Rows[i].Cells["intRequestNumberAsName"].Value = "بدون درخواست"; } else { this.dgvInvoiceItems.Rows[i].Cells["intRequestNumberAsName"].Value = this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["intRequestNumber"]; } this.dgvInvoiceItems.Rows[i].Cells["nvcStoreCodeAsName"].Value = StoreCode.GetMaterialTypeFromStoreCode(this.cnConnection, this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["nvcStoreCode"].ToString()); this.dobTotalCost += (double)this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["floAmount"] * (double)this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["floPrice"]; this.dgvInvoiceItems.Rows[i].Cells["floTotalCost"].Value = (double)this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["floAmount"] * (double)this.dsInvoiceItems.Tables["tabInvoiceItems"].Rows[i]["floPrice"]; } this.labTotalCost.Text = String.Format("{0:n0}", this.dobTotalCost); }
/// <summary> /// 获取所有仓库 /// </summary> /// <param name="tum"></param> /// <returns></returns> public List <StoreCode> QueryStore(t_ADMM_UsrMst tum) { try { var list = (from u in db.t_ADMM_UsrItem join g in db.t_ADMM_UsrDataRightMst on u.fGrpCode equals g.fUsrID join k in db.t_ADMM_UsrDataRightItem on g.fUsrID equals k.fUsrID where u.fUsrID == tum.fUsrID & k.fItemCode == "13" select new { fValue = k.fValue, fValueDesc = k.fValueDesc }).ToList().Distinct(); List <StoreCode> data = new List <StoreCode>(); foreach (var item in list) { StoreCode n = new StoreCode(); n.fValue = item.fValue; n.fValueDesc = item.fValueDesc; data.Add(n); } return(data); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void Materials_Load(object sender, EventArgs e) { this.dsTypes = StoreCode.GetTypesAsDataSet(this.cnConnection, this.tySearch); this.dgvTypes.DataSource = this.dsTypes; this.dgvTypes.DataMember = "tabStuffTypes"; }
private void Materials_Load(object sender, EventArgs e) { this.dsMaterials = StoreCode.GetMaterialsAsDataSet(this.cnConnection, this.maSearch); this.dgvMaterials.DataSource = this.dsMaterials; this.dgvMaterials.DataMember = "tabStuffMaterials"; }
private void DgvStoreGetOutItems_Sorted(object sender, EventArgs e) { for (int i = 0; i < this.dtStoreGetOutItems.Rows.Count; i++) { this.dgvStoreGetOutItems.Rows[i].Cells["nvcStuffStoreCodeAsName"].Value = StoreCode.GetNameByStoreCode(this.cnConnection, this.dgvStoreGetOutItems.Rows[i].Cells["nvcStuffStoreCode"].Value.ToString()); } }
private void StoreGetOutItemUpdate_Load(object sender, EventArgs e) { this.cbActionType.DataSource = Enum.GetValues(typeof(ActionType)); this.tbAmount.Text = this.sgoiUpdate.dobStuffAmount.ToString(); this.tbStoreGetOutNumber.Text = this.sgoiUpdate.intStoreGetOutNumber.ToString(); this.labStuff.Text = StoreCode.GetNameByStoreCode(this.cnConnection, this.sgoiUpdate.strStuffStoreCode); this.cbActionType.SelectedIndex = --this.sgoiUpdate.intTechnicalActionType; SetEnableBtmOk(); }
public void FillSections() { this.cbCategories.Items.Clear(); this.seSections = StoreCode.GetSections(this.cnConnection, this.stStores[this.cbStores.SelectedIndex].strCode); foreach (StoreCode.Section seSections in this.seSections) { this.cbCategories.Items.Add(seSections.strName); } this.cbName.Items.Clear(); this.cbBranch.Items.Clear(); this.labCode.Text = ""; this.labName.Text = ""; }
public void SearchRequestItems() { this.dtStoreGetOutItems = StoreGetOutItem.GetStoreGetOutItemsBySGONumber(this.cnConnection, this.sgoStoreGetOut.intNumber); this.dgvStoreGetOutItems.DataSource = this.dtStoreGetOutItems; for (int i = 0; i < this.dtStoreGetOutItems.Rows.Count; i++) { this.dgvStoreGetOutItems.Rows[i].Cells["nvcStuffStoreCodeAsName"].Value = StoreCode.GetNameByStoreCode(this.cnConnection, this.dgvStoreGetOutItems.Rows[i].Cells["nvcStuffStoreCode"].Value.ToString()); this.dgvStoreGetOutItems.Rows[i].Cells["intTechnicalActionTypeAsName"].Value = (ActionType)this.dgvStoreGetOutItems.Rows[i].Cells["intTechnicalActionType"].Value; } }
public void FillTypes() { this.cbBranch.Items.Clear(); this.tyTypes = StoreCode.GetTypes(this.cnConnection, this.stStores[this.cbStores.SelectedIndex].strCode, this.seSections[this.cbCategories.SelectedIndex].strCode, this.maMaterials[this.cbName.SelectedIndex].strCode); foreach (StoreCode.Type coCode in this.tyTypes) { this.cbBranch.Items.Add(coCode.strName); } this.labCode.Text = ""; this.labName.Text = ""; }
public void FillMaterials() { this.cbName.Items.Clear(); this.maMaterials = StoreCode.GetMaterials(this.cnConnection, this.stStores[this.cbStores.SelectedIndex].strCode, this.seSections[this.cbCategories.SelectedIndex].strCode); foreach (StoreCode.Material miMinorGroup in this.maMaterials) { this.cbName.Items.Add(miMinorGroup.strName); } this.cbBranch.Items.Clear(); this.labCode.Text = ""; this.labName.Text = ""; }
public void FillStores() { this.cbStores.Items.Clear(); this.stStores = StoreCode.GetStores(this.cnConnection); foreach (StoreCode.Store stStore in this.stStores) { this.cbStores.Items.Add(stStore.strName); } this.cbCategories.Items.Clear(); this.cbName.Items.Clear(); this.cbBranch.Items.Clear(); this.labCode.Text = ""; this.labName.Text = ""; }
private void BtmOK_Click(object sender, EventArgs e) { for (int i = 0; i < this.dsTypes.Tables["tabStuffTypes"].Rows.Count; i++) { if (this.dsTypes.Tables["tabStuffTypes"].Rows[i].RowState == DataRowState.Deleted) { StoreCode.TypeDelete(this.cnConnection, (int)this.dsTypes.Tables["tabStuffTypes"].Rows[i]["intID", DataRowVersion.Original]); } if (this.dsTypes.Tables["tabStuffTypes"].Rows[i].RowState == DataRowState.Added) { StoreCode.Type tyType = new StoreCode.Type(); tyType.strStore = this.tySearch.strStore; tyType.strSection = this.tySearch.strSection; tyType.strMaterial = this.tySearch.strMaterial; tyType.strName = this.dsTypes.Tables["tabStuffTypes"].Rows[i]["nvcName"].ToString(); StoreCode.TypeInsert(this.cnConnection, tyType); } if (this.dsTypes.Tables["tabStuffTypes"].Rows[i].RowState == DataRowState.Modified) { StoreCode.Type tyType = new StoreCode.Type(); tyType.intID = (int)this.dsTypes.Tables["tabStuffTypes"].Rows[i]["intID"]; tyType.strName = this.dsTypes.Tables["tabStuffTypes"].Rows[i]["nvcName"].ToString(); StoreCode.TypeUpdate(this.cnConnection, tyType); } } //if (this.Owner is StuffUpdate) //{ // StuffUpdate frmStuffUpdate = (StuffUpdate)this.Owner; // frmStuffUpdate.FillTypes(); //} //if (this.Owner is StuffInsert) //{ // StuffInsert frmStuffInsert = (StuffInsert)this.Owner; // frmStuffInsert.FillTypes(); //} this.Close(); }
private void BtmOK_Click(object sender, EventArgs e) { for (int i = 0; i < this.dsMaterials.Tables["tabStuffMaterials"].Rows.Count; i++) { if (this.dsMaterials.Tables["tabStuffMaterials"].Rows[i].RowState == DataRowState.Deleted) { StoreCode.MaterialDelete(this.cnConnection, (int)this.dsMaterials.Tables["tabStuffMaterials"].Rows[i]["intID", DataRowVersion.Original]); } if (this.dsMaterials.Tables["tabStuffMaterials"].Rows[i].RowState == DataRowState.Added) { StoreCode.Material maMaterial = new StoreCode.Material(); maMaterial.strStore = this.maSearch.strStore; maMaterial.strSection = this.maSearch.strSection; maMaterial.strName = this.dsMaterials.Tables["tabStuffMaterials"].Rows[i]["nvcName"].ToString(); StoreCode.MaterialInsert(this.cnConnection, maMaterial); } if (this.dsMaterials.Tables["tabStuffMaterials"].Rows[i].RowState == DataRowState.Modified) { StoreCode.Material maMaterial = new StoreCode.Material(); maMaterial.intID = (int)this.dsMaterials.Tables["tabStuffMaterials"].Rows[i]["intID"]; maMaterial.strName = this.dsMaterials.Tables["tabStuffMaterials"].Rows[i]["nvcName"].ToString(); StoreCode.MaterialUpdate(this.cnConnection, maMaterial); } } //if (this.Owner is StuffUpdate) //{ // StuffUpdate frmStuffUpdate = (StuffUpdate)this.Owner; // frmStuffUpdate.FillMaterials(); //} //if (this.Owner is StuffInsert) //{ // StuffInsert frmStuffInsert = (StuffInsert)this.Owner; // frmStuffInsert.FillMaterials(); //} this.Close(); }
/// <summary> /// Saves the current composition on the print platform if the "Crtl S" combination is pressed /// </summary> /// <param name="sender">event sender</param> /// <param name="e">event args</param> public void SaveAFile_KeyDown(object sender, KeyEventArgs e) { if (e.Modifiers == Keys.Control && e.KeyCode == Keys.S) { if (Main.main.current3Dview == Main.ThreeDViewOptions.gcode) { StoreCode.Execute(); } if (Main.main.current3Dview == Main.ThreeDViewOptions.STLeditor) { if (Main.main.saveSTL.ShowDialog() == DialogResult.OK) { this.SaveComposition(Main.main.saveSTL.FileName); } } e.Handled = true; } }