/// <summary>
/// 公司选择按钮事件
/// </summary>
private void btnCompany_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("COMPANY", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCompanyName.Text = frm.BaseMasterTable.Name;
txtCompanyCode.Text = frm.BaseMasterTable.Code;
}
}
frm.Dispose();
DataSet ds = bBank.GetBank(" COMPANY_CODE = '" + txtCompanyCode.Text + "'");
DataTable dt = new DataTable();
dt.Columns.Add("NAME", Type.GetType("System.String"));
foreach (DataRow dr in ds.Tables[0].Rows)
{
dt.Rows.Add(dr["BANK_NAME"].ToString());
}
cobBank.DataSource = dt;
cobBank.DisplayMember = "NAME";
txtBankEn.Text = ds.Tables[0].Rows[0]["FULL_NAME_EN"].ToString();
rtxtDetail.Text = ds.Tables[0].Rows[0]["DETAIL_EN"].ToString();
}
private void btnSupplier_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("SUPPLIER", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSupplierCode.Text = frm.BaseMasterTable.Code;
txtSupplierName.Text = frm.BaseMasterTable.Name;
BaseSupplierTable CurrenceCodeTable = GetSupplierCurrence(txtSupplierCode.Text.Trim());
if (CurrenceCodeTable != null)
{
//cboCurrency.SelectedValue = CurrenceCodeTable.CURRENCE_CODE;
if (CurrenceCodeTable.TYPE == CConstant.ERP_DOMESTIC_NUMBER)
{
cboTax.SelectedValue = "01";
}
else
{
cboTax.SelectedValue = "99";
}
}
txtWarehouseCode.Focus();
}
}
frm.Dispose();
}
private void btnProductionProcess_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCTION_PROCESS", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtProductionProcessCode.Text = frm.BaseMasterTable.Code;
txtProductionProcessName.Text = frm.BaseMasterTable.Name;
btnSave.Focus();
if (!string.IsNullOrEmpty(this.txtCompositionProductsCode.Text.Trim()) && !string.IsNullOrEmpty(this.txtProductionProcessCode.Text.Trim()))
{
BaseCompositionProductsProductionProcessTable compositionspecificationGroup = new BaseCompositionProductsProductionProcessTable();
compositionspecificationGroup = bCompositionProductsSpecification.GetModel(txtCompositionProductsCode.Text, txtProductionProcessCode.Text);
if (compositionspecificationGroup != null)
{
txtProductionProcessCode.Text = "";
txtProductionProcessName.Text = "";
txtOrder.Text = "";
txtCompositionProductsCode.Focus();
MessageBox.Show("主配件与工序的组合已存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;// false;
}
}
}
}
frm.Dispose();
}
private void btnAddProductionProcess_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCTION_PROCESS", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
string strWhere = " CODE = " + "'" + frm.BaseMasterTable.Code + "'";
DataSet ds = BProductionProcess.GetList(strWhere);
string departmentcode = ds.Tables[0].Rows[0]["DEPARTMENT_CODE"].ToString().Trim();
string departmentname = ds.Tables[0].Rows[0]["DEPARTMENT_NAME"].ToString().Trim();
decimal productioncycle = CConvert.ToDecimal(ds.Tables[0].Rows[0]["PRODUCTION_CYCLE"].ToString().Trim());
if (dgvData.Rows.Count > 0)
{
int dgvrow = dgvData.Rows.Count - 1;
DateTime StartDate = CConvert.ToDateTime(dgvData.Rows[dgvrow].Cells["END_DATE"].Value.ToString());
DateTime EndDate = StartDate.AddDays(CConvert.ToDouble(productioncycle) + 0D);
object[] rows = { "", frm.BaseMasterTable.Code, frm.BaseMasterTable.Name, departmentcode, departmentname, StartDate, EndDate, "", productioncycle };
dgvData.Rows.Add(rows);
}
else
{
DateTime EndDate = CConvert.ToDateTime(txtSlipDateFrom.Text).AddDays(CConvert.ToDouble(productioncycle) + 0D);
object[] rows = { "", frm.BaseMasterTable.Code, frm.BaseMasterTable.Name, departmentcode, departmentname, txtSlipDateFrom.Text, EndDate, "", productioncycle };
dgvData.Rows.Add(rows);
}
}
frm.Dispose();
}
private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == dgvData.Columns["BtnProduct"].Index)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
DataGridViewRow dr = dgvData.Rows[e.RowIndex];
string code = frm.BaseMasterTable.Code;
BaseProductTable productTable = bProduct.GetModel(code);
BaseStockTable stock = bStock.GetModel(txtWarehouseCode.Text.Trim(), productTable.CODE);
if (productTable != null)
{
dr.Cells["PRODUCT_CODE"].Value = productTable.CODE;
dr.Cells["PRODUCT_NAME"].Value = productTable.NAME;
dr.Cells["SPEC"].Value = productTable.SPEC + " " + productTable.MODEL_NUMBER;
if (stock != null)
{
dr.Cells["QUANTITY"].Value = CConvert.ToString(stock.QUANTITY);
}
else
{
dr.Cells["QUANTITY"].Value = 0;
}
if (!string.IsNullOrEmpty(productTable.BASIC_UNIT_CODE))
{
dr.Cells["UNIT_NAME"].Value = bCommon.GetBaseMaster("UNIT", productTable.BASIC_UNIT_CODE).Name;
dr.Cells["UNIT_CODE"].Value = productTable.BASIC_UNIT_CODE;
}
dr.Cells["SANCTION_NUMBER"].Value = "1";
//DataGridViewComboBoxColumn cbo = (DataGridViewComboBoxColumn)this.dgvData.Columns["REASON"];
//MessageBox.Show(cbo.Items[0]);
}
else
{
MessageBox.Show("商品不存在.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
dr.Cells["QUANTITY"].Value = "0";
dr.Cells["CODE"].Selected = true;
}
}
}
frm.Dispose();
}
}
catch (Exception ex)
{
}
}
private void btnProduct_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtProduct.Text = frm.BaseMasterTable.Code;
txtProductName.Text = frm.BaseMasterTable.Name;
}
}
}
private void btnCustomer_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("CUSTOMER", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCustomerCode.Text = frm.BaseMasterTable.Code;
txtCustomerName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
txtBalance.Text = CConvert.ToString(GetCustomerDepositBlanace(txtCustomerCode.Text.Trim()));
}
/// <summary>
/// 商品类别
/// </summary>
private void btnGroup_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT_GROUP", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtGroupCode.Text = frm.BaseMasterTable.Code;
txtGroupName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
private void btnWarehouse_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("WAREHOUSE", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtWarehouseCode.Text = frm.BaseMasterTable.Code;
txtWarehouseName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
private void btnCompany_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("Company", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCode.Text = frm.BaseMasterTable.Code;
txtName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
/// <summary>
/// 代理店选择按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCustomer_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("CUSTOMER", "TYPE = 1");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCustomerCode.Text = frm.BaseMasterTable.Code;
txtCustomerName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
private void btnSupplier_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("SUPPLIER", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSupplierCode.Text = frm.BaseMasterTable.Code;
txtSupplierName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
/// <summary>
/// 纳入先选择按钮事件
/// </summary>
private void btnDeliveryPoint_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("DELIVERY", "", txtEndCustomerCode.Text);
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtDeliveryPointCode.Text = frm.BaseMasterTable.Code;
txtDeliveryPointName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
private void btnSupplier_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("SUPPLIER", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSupplierCode.Text = frm.BaseMasterTable.Code;
txtSupplierName.Text = frm.BaseMasterTable.Name;
BaseSupplierTable supplier = new BSupplier().GetModel(frm.BaseMasterTable.Code);
if (supplier.TYPE == CConstant.ERP_FOREIGN_NUMBER)
{
txtInvoiceNoLocal.Enabled = false;
txtInvoiceAmountLocal.Enabled = false;
txtInvoiceNoLocal.BackColor = SystemColors.Info;
txtInvoiceAmountLocal.BackColor = SystemColors.Info;
txtInvoiceNoLocal.Text = "";
txtInvoiceAmountLocal.Text = "";
txtInvoiceNo.Enabled = true;
txtInvoiceAmount.Enabled = true;
txtInvoiceNo.BackColor = Color.FromArgb(255, 192, 192);
txtInvoiceAmount.BackColor = Color.FromArgb(255, 192, 192);
//txtPackAmount.Text = "";
//txtPackAmount.Enabled = true;
//btnDivPackAmount.Enabled = true;
txtInvoiceNo.Focus();
}
else if (supplier.TYPE == CConstant.ERP_DOMESTIC_NUMBER)
{
txtInvoiceNo.Enabled = false;
txtInvoiceAmount.Enabled = false;
txtInvoiceNo.BackColor = SystemColors.Info;
txtInvoiceAmount.BackColor = SystemColors.Info;
txtInvoiceNo.Text = "";
txtInvoiceAmount.Text = "";
txtInvoiceNoLocal.Enabled = true;
txtInvoiceAmountLocal.Enabled = true;
txtInvoiceNoLocal.BackColor = Color.FromArgb(255, 192, 192);
txtInvoiceAmountLocal.BackColor = Color.FromArgb(255, 192, 192);
//txtPackAmount.Text = "0";
//txtPackAmount.Enabled = false;
//btnDivPackAmount.Enabled = false;
txtInvoiceNoLocal.Focus();
}
}
}
frm.Dispose();
}
private void btnTechnology3_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("TECHNOLOGY", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtTechnology3.Text = frm.BaseMasterTable.Name;
txtTechnologyCode3.Text = frm.BaseMasterTable.Code;
btnSave.Focus();
}
}
frm.Dispose();
}
/// <summary>
/// 供应商To
/// </summary>
private void btnSupplierTo_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("Supplier", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSupplierCodeTo.Text = frm.BaseMasterTable.Code;
txtSupplierNameTo.Text = frm.BaseMasterTable.Name;
txtPOSlipDateFrom.Focus();
}
}
frm.Dispose();
}
private void btnParts_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", "(PRODUCT_FLAG = " + CConstant.PRODUCT_FLAG_PRODUCE + " OR PRODUCT_FLAG = " + CConstant.PRODUCT_FLAG_PURCHASE + ")");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtPartsCode.Text = frm.BaseMasterTable.Code;
txtPartsName.Text = frm.BaseMasterTable.Name;
txtQuantity.Focus();
}
}
frm.Dispose();
}
private void btnProduct_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", " PRODUCT_FLAG = " + CConstant.PRODUCT_FLAG_SPEC);
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtProductCode.Text = frm.BaseMasterTable.Code;
txtProductName.Text = frm.BaseMasterTable.Name;
txtPartsCode.Focus();
}
}
frm.Dispose();
}
private void btnUnit_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("Unit", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtBasic.Text = frm.BaseMasterTable.Code;
txtBasicName.Text = frm.BaseMasterTable.Name;
rAccout1.Focus();
}
}
frm.Dispose();
}
private void btnCurrencyCode_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("CURRENCY", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCurrencyCode.Text = frm.BaseMasterTable.Code;
txtCurrencyName.Text = frm.BaseMasterTable.Name;
btnSave.Focus();
}
}
frm.Dispose();
}
private void btnDrawingType6_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("DRAWING", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtDrawingType6.Text = frm.BaseMasterTable.Name;
txtDrawingTypeCode6.Text = frm.BaseMasterTable.Code;
btnSave.Focus();
}
}
frm.Dispose();
}
private void btnDepartment_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("DEPARTMENT", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtDepartmentCode.Text = frm.BaseMasterTable.Code;
txtDepartmentName.Text = frm.BaseMasterTable.Name;
txtCompanyCode.Focus();
}
}
frm.Dispose();
}
private void btnSlipType_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("SLIP_TYPE", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSlipType.Text = frm.BaseMasterTable.Code;
txtSlipTypeName.Text = frm.BaseMasterTable.Name;
}
}
frm.Dispose();
}
private void btnParentCode_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT_GROUP", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtParentCode.Text = frm.BaseMasterTable.Code;
txtParentName.Text = frm.BaseMasterTable.Name;
txtIndicatesOrder.Focus();
}
}
frm.Dispose();
}
private void btnRoles_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("ROLES", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtRolesCode.Text = frm.BaseMasterTable.Code;
txtRolesName.Text = frm.BaseMasterTable.Name;
btnSave.Focus();
}
}
frm.Dispose();
}
private void btnCompositionProducts_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("COMPOSITION_PRODUCTS", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtCompositionProductsCode.Text = frm.BaseMasterTable.Code;
txtCompositionProductsName.Text = frm.BaseMasterTable.Name;
txtProductionProcessCode.Focus();
}
}
frm.Dispose();
}
private void btnProduct_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("PRODUCT", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtProductCode.Text = frm.BaseMasterTable.Code;
txtProductName.Text = frm.BaseMasterTable.Name;
cboMaintenanceStations.Focus();
}
}
frm.Dispose();
}
private void btnDepartual_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("WAREHOUSE", "");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtDepartualCode.Text = frm.BaseMasterTable.Code;
txtDepartualName.Text = frm.BaseMasterTable.Name;
txtArrivalCode.Focus();
}
}
frm.Dispose();
}
private void btnSales_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("USER", " DEPARTMENT_CODE='D01'");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtSales.Text = frm.BaseMasterTable.Name;
txtSalesCode.Text = frm.BaseMasterTable.Code.Substring(2);
//txtWarehouseCode.Focus();
}
}
frm.Dispose();
}
private void btnReported_Click(object sender, EventArgs e)
{
FrmMasterSearch frm = new FrmMasterSearch("Customer", "TYPE = 2");
if (frm.ShowDialog(this) == DialogResult.OK)
{
if (frm.BaseMasterTable != null)
{
txtReported.Text = frm.BaseMasterTable.Code;
txtReportedName.Text = frm.BaseMasterTable.Name;
txtReported.Focus();
ReportedDate.Focus();
}
}
frm.Dispose();
}