private void writeBillDetailsInfoFromBillNumber(string billNumber)
{
// DataGridView 赋值
SortedDictionary <int, SaleOrderDetailsTable> saleOrderDetails =
SaleOrderDetails.getInctance().getSaleInfoFromBillNumber(billNumber);
foreach (KeyValuePair <int, SaleOrderDetailsTable> index in saleOrderDetails)
{
SaleOrderDetailsTable record = new SaleOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID);
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = materielInfo.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitSale;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.transportationCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney;
}
}
private void FormMaterielStorageInfo_Load(object sender, EventArgs e)
{
// 树控件初始化
refreshTreeView();
// DataGridView控件初始化
m_dataGridViewExtend.addDataGridViewColumn("ID", 30);
m_dataGridViewExtend.addDataGridViewColumn("物料名称", 170);
m_dataGridViewExtend.addDataGridViewColumn("型号", 60);
m_dataGridViewExtend.addDataGridViewColumn("实际库存", 78);
if (m_isDisplayJG)
{
m_dataGridViewExtend.addDataGridViewColumn("加权单价", 78);
m_dataGridViewExtend.addDataGridViewColumn("合计", 60);
}
// 2016-11-11++ 增加库存预占信息显示
m_dataGridViewExtend.addDataGridViewColumn("预占数量", 78);
m_dataGridViewExtend.addDataGridViewColumn("预占人", 78);
m_dataGridViewExtend.addDataGridViewColumn("可用数量参考", 110);
// ++2016-11-11
m_dataGridViewExtend.addDataGridViewColumn("单位", 60);
m_dataGridViewExtend.addDataGridViewColumn("存货上限", 78);
m_dataGridViewExtend.addDataGridViewColumn("存货下限", 78);
m_dataGridViewExtend.addDataGridViewColumn("保质期", 78);
m_dataGridViewExtend.addDataGridViewColumn("收料仓库", 78);
m_dataGridViewExtend.initDataGridViewColumn(this.dataGridViewMaterielList);
getMaterielProOccupiedList();
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
private void updateStatusLable(int ID)
{
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(ID);
string countInfoToStatusLable = "当前数据过滤条件： ";
string materielName = "物料名称：" + record.name;
string startDate = " 开始日期: ";
string endDate = " 结束日期: ";
string isReview = " 是否审核: ";
startDate += m_countStartDate.Substring(0, 4) + "年";
startDate += m_countStartDate.Substring(4, 2) + "月";
startDate += m_countStartDate.Substring(6) + "日";
endDate += m_countEndDate.Substring(0, 4) + "年";
endDate += m_countEndDate.Substring(4, 2) + "月";
endDate += m_countEndDate.Substring(6) + "日";
isReview += "已审核单据";
countInfoToStatusLable += materielName;
countInfoToStatusLable += startDate;
countInfoToStatusLable += endDate;
countInfoToStatusLable += isReview;
this.toolStripStatusLabelCountInfo.Text = countInfoToStatusLable;
}
private void setMatetielInfoToDataGridView(string id)
{
double pkey = Convert.ToDouble(id.ToString());
//使用这个输入的值，匹配物料编号
MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id));
if (id != record.num || record.pkey == 0)
{
//使用这个输入的值，匹配物料key
record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey);
if (pkey != record.pkey || record.pkey == 0)
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex);
return;
}
}
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.pkey;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = "0";
}
private void writeBillDetailsInfoFromBillNumber(string billNumber)
{
// DataGridView 赋值
SortedDictionary <int, MaterielInOtherOrderDetailsTable> orderDetails =
MaterielInOtherOrderDetails.getInctance().getMaterielInOtherInfoFromBillNumber(billNumber);
foreach (KeyValuePair <int, MaterielInOtherOrderDetailsTable> index in orderDetails)
{
MaterielInOtherOrderDetailsTable record = new MaterielInOtherOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID);
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Parameter].Value = materielInfo.materielParameter;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = materielInfo.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materielInfo.unitSale);
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.CZ].Value = materielInfo.CZ;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Note].Value = record.note;
}
}
private bool modifyMateriel()
{
MaterielTable materiel = getPageMaterielActiveData();
if (materiel.name.Length == 0)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 物料名称不能为空，请重新输入");
return(false);
}
if (materiel.num.Length == 0)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 物料编号不能为空，请重新输入");
return(false);
}
if (materiel.mnemonicCode.Length > 10)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 助记码长度应小于10，请重新输入");
return(false);
}
Materiel.getInctance().update(m_materielPkey, materiel);
return(true);
}
private void FormMaterielEdit_Load(object sender, EventArgs e)
{
// 初始化下拉框值
ComboBoxExtend.initComboBox(this.comboBoxMaterielAttribut, MATERIEL_ATTRIBUTE_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxValuationType, VALUATION_TYPE_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnit, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnitPurchase, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnitSale, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxStorage, STORAGE_LIST_TABLE_NAME, true);
if (!m_isAdd)
{
this.buttonAdd.Enabled = false;
this.buttonMaterielGroup.Enabled = false;
if (m_isEditMateriel)
{
m_materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
}
else
{
m_materielType = MaterielType.getInctance().getMaterielTypeInfoFromPkey(m_materielGroupPkey);
m_isMaterielGroup = true;
}
setPageActiveState();
setPageActiveValue();
}
m_isInit = true;
}
private void buttonSelect_Click(object sender, EventArgs e)
{
if (m_selectedTextboxIndex <= 0 || m_selectedTextboxIndex > 3)
{
MessageBoxExtend.messageWarning("请将光标移动到指定输入框中后再重新选择物料");
this.buttonSelect.Enabled = false;
return;
}
FormBaseMateriel fbs = new FormBaseMateriel(true);
fbs.ShowDialog();
m_materielPkey = fbs.getSelectRecordPkey();
if (m_materielPkey != 0)
{
if (m_selectedTextboxIndex == 1)
{
this.textBoxStartID.Text = Convert.ToString(m_materielPkey);
}
else if (m_selectedTextboxIndex == 2)
{
this.textBoxEndID.Text = Convert.ToString(m_materielPkey);
}
else
{
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = materiel.name;
}
}
this.buttonSelect.Enabled = false;
m_selectedTextboxIndex = 0;
}
private void FormInitMaterielEdit_Load(object sender, EventArgs e)
{
if (m_isEditMaterielData)
{
this.buttonEdit.Enabled = true;
this.buttonSelect.Enabled = false;
this.textBoxPrice.Enabled = false;
this.textBoxValue.Enabled = false;
this.buttonEnter.Enabled = false;
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = Convert.ToString(materiel.pkey) + "-" + materiel.name;
m_materielName = materiel.name;
if (InitMateriel.getInctance().checkMaterielIsExist(m_materielPkey))
{
InitMaterielTable materielStock = InitMateriel.getInctance().getMaterielInfoFromMaterielID(m_materielPkey);
this.textBoxValue.Text = Convert.ToString(materielStock.value);
this.textBoxPrice.Text = Convert.ToString(materielStock.price);
}
else
{
this.textBoxValue.Text = "0";
this.textBoxPrice.Text = "0";
}
}
}
private void FormBaseMateriel_Load(object sender, EventArgs e)
{
// 树控件初始化
refreshTreeView();
// DataGridView控件初始化
m_dataGridViewExtend.addDataGridViewColumn("ID", 30);
m_dataGridViewExtend.addDataGridViewColumn("物料组", 200, false);
m_dataGridViewExtend.addDataGridViewColumn("物料名称", 200);
m_dataGridViewExtend.addDataGridViewColumn("物料简称", 100);
m_dataGridViewExtend.addDataGridViewColumn("助记码", 100);
m_dataGridViewExtend.addDataGridViewColumn("规格型号", 100);
m_dataGridViewExtend.addDataGridViewColumn("收料仓库", 100);
m_dataGridViewExtend.addDataGridViewColumn("物料属性", 100);
m_dataGridViewExtend.addDataGridViewColumn("计价方式", 100);
m_dataGridViewExtend.addDataGridViewColumn("基本单位", 100);
m_dataGridViewExtend.addDataGridViewColumn("采购单位", 100);
m_dataGridViewExtend.addDataGridViewColumn("销售单位", 100);
m_dataGridViewExtend.addDataGridViewColumn("库存单位", 100, false);
m_dataGridViewExtend.addDataGridViewColumn("存货上限", 100);
m_dataGridViewExtend.addDataGridViewColumn("存货下限", 100);
m_dataGridViewExtend.addDataGridViewColumn("保质期", 100);
m_dataGridViewExtend.addDataGridViewColumn("备注", 100);
m_dataGridViewExtend.initDataGridViewColumn(this.dataGridViewMaterielList);
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
setPageActionEnable();
ToolStripMenuItemAddMateriel.Enabled = this.add.Enabled;
ToolStripMenuItemModifyMateriel.Enabled = this.modify.Enabled;
ToolStripMenuItemDeleteMateriel.Enabled = this.delete.Enabled;
ToolStripMenuItemForbidMateriel.Enabled = this.forbid.Enabled;
ToolStripMenuItemNoForbidMateriel.Enabled = this.noForbid.Enabled;
}
private void buttonNoForbid_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.listViewNoForbidList.Items.Count; i++)
{
if (this.listViewNoForbidList.Items[i].Checked)
{
int pkey = Convert.ToInt32(listViewNoForbidList.Items[i].SubItems[1].Text.ToString());
if (m_forbidDataType == ForbidDataType.Supplier)
{
Supplier.getInctance().noForbidSupplier(pkey);
}
else if (m_forbidDataType == ForbidDataType.Customer)
{
Customer.getInctance().noForbidCustomer(pkey);
}
else if (m_forbidDataType == ForbidDataType.Materiel)
{
Materiel.getInctance().noForbidMateriel(pkey);
}
else if (m_forbidDataType == ForbidDataType.Staff)
{
Staff.getInctance().noForbidStaff(pkey);
}
else
{
// 咱不支持的数据类型
}
this.listViewNoForbidList.Items[i].Remove();
i--;
}
}
}
public FormStorageStockDetails()
{
InitializeComponent();
// 默认查询得本月第一天开始到本月最后一天的数据
DateTime nowDate = DateTime.Now;
DateTime currentMonthFirstDay = new DateTime(nowDate.Year, nowDate.Month, 1);
DateTime currentMonthLastDay = currentMonthFirstDay.AddMonths(1).AddDays(-1);
m_countStartDate = currentMonthFirstDay.ToString("yyyyMMdd");
m_countEndDate = currentMonthLastDay.ToString("yyyyMMdd");
m_materielList = Materiel.getInctance().getAllMaterielInfo();
if (m_materielList.Count > 0)
{
m_currentRecordIndex = 0;
}
// 判断下是否有查看单价的权限
SortedDictionary <int, ActionTable> list = MainProgram.model.Action.getInctance().getActionInfoFromModuleID(m_moduleID);
foreach (KeyValuePair <int, ActionTable> index in list)
{
if (index.Value.uiActionName == "dispaly")
{
m_isDisplayJG = AccessAuthorization.getInctance().isAccessAuthorization(index.Value.pkey,
Convert.ToString(DbPublic.getInctance().getCurrentLoginUserID()));
}
}
}
private void setMatetielInfoToDataGridView(double pkey)
{
/* 如果是物料编码列，需要判断该物料编码是否存在
* 如果存在读取相应的值填充DataGridView中对应的其他列，如果不存在该物料编码，则清空该行
* */
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey);
if (pkey != record.pkey || record.pkey == 0)
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex);
}
else
{
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID((int)pkey);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = Convert.ToString(MaterielCountdata.price);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0";
}
}
private void modify_Click(object sender, EventArgs e)
{
FormInitMaterielEdit fime = new FormInitMaterielEdit("编辑物料初始资料", true, m_currentDataGridViedRecordPkey);
fime.ShowDialog();
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
private void FormMaterielDetailed_Load(object sender, EventArgs e)
{
// 物料基本信息
this.labelMaterielID.Text = Convert.ToString(m_materielID);
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(m_materielID);
this.labelMaterielName.Text = record.name;
// 实际库存+预占
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID(m_materielID);
this.labelCount.Text = Convert.ToString(MaterielCountdata.value);
this.labelProCount.Text = Convert.ToString(MaterielProOccupiedOrderDetails.getInctance().getMaterielProCountInfoFromProject(m_materielID));
// 材料表情况
if (m_xxMaterielTablebillNubmber.Length > 0)
{
this.labelxxMaterielTableNum.Text = m_xxMaterielTablebillNubmber;
FormProjectMaterielTable projectInfo = FormProject.getInctance().getProjectInfoFromBillNumber(m_xxMaterielTablebillNubmber);
this.labelProjectNum.Text = projectInfo.projectNum;
this.labelProName.Text = projectInfo.projectName;
this.labelDevMode.Text = projectInfo.deviceMode;
SortedDictionary <int, ProjectManagerDetailsTable> list =
ProjectManagerDetails.getInctance().getPurchaseInfoFromBillNumber(m_xxMaterielTablebillNubmber);
foreach (KeyValuePair <int, ProjectManagerDetailsTable> index in list)
{
if (index.Value.materielID == m_materielID)
{
this.labelSub.Text = index.Value.deviceName;
this.labelNum.Text = index.Value.no;
this.labelSquence.Text = index.Value.sequence;
this.label1Value.Text = Convert.ToString(index.Value.value);
this.labelUseDate.Text = index.Value.useDate;
break;
}
}
}
else
{
this.labelxxMaterielTableNum.Text = " ";
this.labelProjectNum.Text = " ";
this.labelProName.Text = " ";
this.labelDevMode.Text = " ";
this.labelSub.Text = " ";
this.label1Value.Text = " ";
this.labelUseDate.Text = " ";
this.labelNum.Text = " ";
this.labelSquence.Text = " ";
this.labelUseDate.Text = " ";
}
}
private void dateTimePickerHistoryDate_CloseUp(object sender, EventArgs e)
{
string lastDate = this.dateTimePickerHistoryDate.Value.ToString("yyyy-MM-dd");
m_materielListHistoryInfo.Clear();
m_materielListHistoryInfo = StorageStockDetail.getInctance().getMaterielStorageStockDetailHistoryInfo(lastDate);
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
private void filter_Click(object sender, EventArgs e)
{
FormNewFilterValue fnfv = new FormNewFilterValue(m_filterValue);
fnfv.ShowDialog();
m_filterValue = fnfv.getNewFilterValue();
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
private void toolStripButtonRefresh_Click(object sender, EventArgs e)
{
MaterielProOccupiedOrder.getInctance().refrensRecord();
MaterielProOccupiedOrderDetails.getInctance().refrensRecord();
getMaterielProOccupiedList();
refreshTreeView();
Materiel.getInctance().refrensRecord();
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
private void textBoxSerach_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
updateDataGridView(Materiel.getInctance().getMaterielInfoFromSerachTerm(this.textBoxSerach.Text));
this.textBoxSerach.ForeColor = System.Drawing.SystemColors.ScrollBar;
this.textBoxSerach.Text = "输入物料名称，按回车键实现快速查找";
}
}
private void textBoxSerach_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
updateDataGridView(Materiel.getInctance().getMaterielInfoFromSerachTerm(this.textBoxSerach.Text));
this.labelMaterielGroupName.Text = "[" + this.textBoxSerach.Text + "]物料共计[" + Convert.ToString(m_materielRecordCount) + "]条记录";
this.textBoxSerach.ForeColor = System.Drawing.SystemColors.ScrollBar;
this.textBoxSerach.Text = "输入物料名称，按回车键实现快速查找";
}
}
private void forbid_Click(object sender, EventArgs e)
{
if (m_currentDataGridViedRecordPkey != 0)
{
if (MessageBoxExtend.messageQuestion("确定禁用[" + m_currentDataGridViedRecordCompanyName + "]吗?"))
{
Materiel.getInctance().forbidMateriel(m_currentDataGridViedRecordPkey);
updateDataGridView(getCurrentNodeAllChildNodesMateriel());
}
}
}
private void buttonSelect_Click(object sender, EventArgs e)
{
FormBaseMateriel fbs = new FormBaseMateriel(true);
fbs.ShowDialog();
m_materielPkey = fbs.getSelectRecordPkey();
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = materiel.name;
}
private void setMatetielInfoToDataGridView(string id)
{
/* 如果是物料编码列，需要判断该物料编码是否存在
* 如果存在读取相应的值填充DataGridView中对应的其他列，如果不存在该物料编码，则清空该行
* */
//使用这个输入的值，匹配物料编号
double pkey = 0;
MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id));
if (record == null || id.ToLower() != record.num.ToLower() || record.pkey == 0)
{
try
{
//使用这个输入的值，匹配物料key
pkey = Convert.ToDouble(id.ToString());
record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey);
if (pkey != record.pkey || record.pkey == 0)
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex);
return;
}
}
catch
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex);
return;
}
}
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID((int)pkey);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.pkey;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Parameter].Value = record.materielParameter;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Brand].Value = record.brand;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.CZ].Value = record.CZ;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = Convert.ToString(MaterielCountdata.price);
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0";
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0";
}
private void buttonNoForbid_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.listViewNoForbidList.Items.Count; i++)
{
if (this.listViewNoForbidList.Items[i].Checked)
{
Materiel.getInctance().noForbidMateriel(Convert.ToInt32(listViewNoForbidList.Items[i].SubItems[1].Text.ToString()));
this.listViewNoForbidList.Items[i].Remove();
i--;
}
}
}
private void addMateriel()
{
MaterielTable materiel = getPageMaterielActiveData();
if (materiel.name.Length == 0)
{
MessageBoxExtend.messageWarning("物料名称不能为空，请重新输入");
return;
}
Materiel.getInctance().insert(materiel);
}
private void FormInitMateriel_Load(object sender, EventArgs e)
{
m_dateGridViewExtend.addDataGridViewColumn("ID", 30);
m_dateGridViewExtend.addDataGridViewColumn("物料编号", 80);
m_dateGridViewExtend.addDataGridViewColumn("物料名称", 300);
m_dateGridViewExtend.addDataGridViewColumn("收料仓库", 150);
m_dateGridViewExtend.addDataGridViewColumn("单价", 100);
m_dateGridViewExtend.addDataGridViewColumn("数量", 100);
m_dateGridViewExtend.initDataGridViewColumn(this.dataGridViewMaterielList);
//updateDataGridView(InitMateriel.getInctance().getAllInitMaterielInfo());
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
setPageActionEnable();
}
private void import_Click(object sender, EventArgs e)
{
if (MessageBoxExtend.messageQuestion("批量导入数据会清空数据库所有已存在库存记录，是否继续？"))
{
// 指定OpenFileDialog控件打开的文件格式
openFileDialog1.Filter = "导入文件(*.xls)|*.xls";
openFileDialog1.FileName = "";
if (openFileDialog1.ShowDialog(this) == DialogResult.OK)
{
InitMateriel.getInctance().fileImport(openFileDialog1.FileName);
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
}
}
private void add_Click(object sender, EventArgs e)
{
// shengguang++ 2016-11-05 当业务启动后，增加功能：不能再直接增加物料库存信息
if (InitSubSystemSign.getInctance().isBusinessSystemInit())
{
MessageBoxExtend.messageWarning("业务系统已启用，不能再直接添加物料库存信息，请通过物料入库方式完成此操作");
return;
}
// ++shengguang
FormInitMaterielEdit fime = new FormInitMaterielEdit("添加物料初始资料", false);
fime.ShowDialog();
updateDataGridView(Materiel.getInctance().getAllMaterielInfo());
}
public FormMaterielPriceSheet(int materielID, bool isQuerySupplierPrice = true)
{
InitializeComponent();
m_materielID = materielID;
m_isQuerySupplierPrice = isQuerySupplierPrice;
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(materielID);
if (m_isQuerySupplierPrice)
{
this.Text = "物料 [" + record.name + "] 供应商报价信息";
}
else
{
this.Text = "商品 [" + record.name + "] 销售指导价格";
}
}
private void exportEarningsOrderData()
{
int startRowIndex = 6;
// 采购入库单数据导出
MaterielInEarningsOrderTable table = new MaterielInEarningsOrderTable();
table = MaterielInEarningsOrder.getInctance().getMaterielInEarningsOrderInfoFromBillNumber(m_billNubmber);
stringReplace(table.billNumber, "[1]");
if (table.isRedBill == 1)
{
stringReplace("(红字单据)", "[2]");
}
else
{
stringReplace("", "[2]");
}
stringReplace(table.makeOrderStaffName, "[3]");
double sum = 0.0;
for (int row = 0; row < m_dataGridView.RowCount; row++)
{
if (m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0)
{
break;
}
int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielNumber].Value.ToString().Trim());
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(materielID);
m_excelApp.Cells[row + startRowIndex, 2] = materielID;
m_excelApp.Cells[row + startRowIndex, 3] = record.brand;
m_excelApp.Cells[row + startRowIndex, 4] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielName].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 5] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Model].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 6] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Unit].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 7] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Value].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 8] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Note].Value.ToString().Trim();
sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Value].Value.ToString().Trim());
}
stringReplace(Convert.ToString(sum), "[4]");
}
