/* * 方法名称: SetPara() * 方法功能描述:插入、更新时提取文本框、下拉列表框内容; * * 创建人:冯雪 * 创建时间:2009-02-23 * * 修改人: * 修改时间: * 修改内容: * */ private void SetPara() { int mnId = 0, mmId = 0; if (!cbxMName.Text.Trim().Equals("")) { mnId = Convert.ToInt32(cbxMName.SelectedValue.ToString()); if (!cbxMModel.Text.Trim().Equals("")) { mmId = Convert.ToInt32(cbxMModel.SelectedValue.ToString()); if (!mLogic.MaterialSearch(mnId, mmId).Equals(null)) { GMclass.MaterialId = mLogic.MaterialSearch(mnId, mmId); } else { GMclass.MaterialId = 0; } } } GMclass.ProviderId = providerId; if (!cbxPname.Text.Trim().Equals("")) { GMclass.ProducerId = Convert.ToInt32(cbxPname.SelectedValue.ToString()); } else { GMclass.ProducerId = 0; } if (!txtDistance.Text.Trim().Equals("")) { GMclass.Distance = Convert.ToDouble(txtDistance.Text.Trim()); } else { GMclass.Distance = 0; } if (!txtPCapability.Text.Trim().Equals("")) { GMclass.ProvideCapability = txtPCapability.Text.Trim(); } else { GMclass.ProvideCapability = ""; } if (!txtRemark.Text.Trim().Equals("")) { GMclass.Remark = txtRemark.Text.Trim(); } else { GMclass.Remark = ""; } GMclass.InputMan = this.userName; }
/* * 方法名称: Get_MID() * 方法功能描述:取出该材料ID; * * 创建人:冯雪 * 创建时间:2009-04-11 * * 修改人: * 修改时间: * 修改内容: * */ private long Get_MID() { long mid = 0; if (!string.IsNullOrEmpty(cbxMName.Text.Trim())) { int mnid = Convert.ToInt32(this.cbxMName.SelectedValue.ToString()); if (!string.IsNullOrEmpty(cbxMModel.Text.Trim())) { int mmid = Convert.ToInt32(this.cbxMModel.SelectedValue.ToString()); // 提取材料ID; mid = Convert.ToInt64(mLogic.MaterialSearch(mnid, mmid)); } } return(mid); }
/* * 方法名称: getPara() * 方法功能描述:取出材料出库台帐查询条件; * * 创建人:冯雪 * 创建时间:2009-03-11 * * 修改人: * 修改时间: * 修改内容: * */ private void getPara() { // 取出材料ID; if (!cbxmKind.Text.Trim().Equals("")) { mkId = Convert.ToInt32(this.cbxmKind.SelectedValue.ToString()); } else { mkId = 0; } if (!cbxmName.Text.Trim().Equals("")) { mnId = Convert.ToInt32(this.cbxmName.SelectedValue.ToString()); if (!cbxmModel.Text.Trim().Equals("")) { mmId = Convert.ToInt32(this.cbxmModel.SelectedValue.ToString()); stockOutMclass.Mid = mLogic.MaterialSearch(mnId, mmId); } else { mmId = 0; stockOutMclass.Mid = 0; } } else { mnId = 0; stockOutMclass.Mid = 0; } // 取出时间; if (checkBegin.Checked) { stockOutMclass.BeginTime = Convert.ToDateTime(dtpBegionO.Text).ToString("yyyy-MM-dd"); } else { stockOutMclass.BeginTime = ""; } if (checkEnd.Checked) { stockOutMclass.EndTime = Convert.ToDateTime(dtpEndO.Text).ToString("yyyy-MM-dd"); } else { stockOutMclass.EndTime = ""; } // 取出设备编号; if (!cbxEquipment.Text.Trim().Equals("")) { stockOutMclass.Equipmentid = Convert.ToInt32(this.cbxEquipment.SelectedValue.ToString()); } else { stockOutMclass.Equipmentid = 0; } // 取出审核、审批查询条件; if (!string.IsNullOrEmpty(cbxState.Text.Trim())) { stockOutMclass.State = cbxState.Text.Trim(); } else { stockOutMclass.State = ""; } }
private void setM_DataGridView() { int mnId, mmId, pnId, pmId; string begin_data = (dtp_being.Value.Date).ToString("yyyy-MM-dd") + " 00:00:00"; string end_data = (dtp_end.Value.Date).ToString("yyyy-MM-dd") + " 23:59:59"; string guide_line = ""; int mid = 0, pid = 0; if (!string.IsNullOrEmpty(cbx_test.Text.Trim())) { guide_line = cbx_test.Text.Trim(); } if (rbtn_material.Checked) { #region 查出材料ID; { if (!string.IsNullOrEmpty(cbx_name.Text.Trim())) { mnId = Convert.ToInt32(this.cbx_name.SelectedValue.ToString()); if (!string.IsNullOrEmpty(cbx_model.Text.Trim())) { mmId = Convert.ToInt32(this.cbx_model.SelectedValue.ToString()); } else { mmId = 0; } } else { mnId = 0; mmId = 0; } if ((mnId != 0) && (mmId != 0)) { mid = mLogic.MaterialSearch(mnId, mmId); } } #endregion string str_sql = monitorL.Test_where(begin_data, end_data, guide_line, mid, 0); dataGridView1.DataSource = monitorL.Search_materialTest(str_sql); dataGridView1.Columns["mId"].Visible = false; } if (rbtn_product.Checked) { #region 查出产品ID; { if (!string.IsNullOrEmpty(cbx_name.Text.Trim())) { pnId = Convert.ToInt32(this.cbx_name.SelectedValue.ToString()); if (!string.IsNullOrEmpty(cbx_model.Text.Trim())) { pmId = Convert.ToInt32(this.cbx_model.SelectedValue.ToString()); } else { pmId = 0; } } else { pnId = 0; pmId = 0; } if ((pnId != 0) && (pmId != 0)) { pid = pLogic.PSearchID(pnId, pmId); } } #endregion string str_sql = monitorL.Test_where(begin_data, end_data, guide_line, pid, 1); dataGridView1.DataSource = monitorL.Search_productTest(str_sql); dataGridView1.Columns["pId"].Visible = false; } }
private void SetPara() { int mnId, mmId, pnId, pmId; eclass.No = No; eclass.Id = Id; eclass.InputMan = this.userName; if (!string.IsNullOrEmpty(txtHeight.Text.Trim())) { eclass.Height = decimal.Parse(txtHeight.Text.Trim()); } else { eclass.Height = null; } if (!string.IsNullOrEmpty(txtDiameter.Text.Trim())) { eclass.Diameter = decimal.Parse(txtDiameter.Text.Trim()); } else { eclass.Diameter = null; } if (rbtnMaterial.Checked) #region 查出材料ID; { if (!string.IsNullOrEmpty(cbxName.Text.Trim())) { mnId = Convert.ToInt32(this.cbxName.SelectedValue.ToString()); if (!string.IsNullOrEmpty(cbxModel.Text.Trim())) { mmId = Convert.ToInt32(this.cbxModel.SelectedValue.ToString()); } else { mmId = 0; } } else { mnId = 0; mmId = 0; } if ((mnId != 0) && (mmId != 0)) { eclass.MId = mLogic.MaterialSearch(mnId, mmId); } else { eclass.MId = null; } } #endregion if (rbtnProduct.Checked) #region 查出产品ID; { if (!string.IsNullOrEmpty(cbxName.Text.Trim())) { pnId = Convert.ToInt32(this.cbxName.SelectedValue.ToString()); if (!string.IsNullOrEmpty(cbxModel.Text.Trim())) { pmId = Convert.ToInt32(this.cbxModel.SelectedValue.ToString()); } else { pmId = 0; } } else { pnId = 0; pmId = 0; } if ((pnId != 0) && (pmId != 0)) { eclass.PId = pLogic.PSearchID(pnId, pmId); } else { eclass.PId = null; } } #endregion if (!string.IsNullOrEmpty(txtHeight.Text.Trim())) { eclass.Height = decimal.Parse(txtHeight.Text.Trim()); } else { eclass.Height = 0; } if (!string.IsNullOrEmpty(txtDiameter.Text.Trim())) { eclass.Diameter = decimal.Parse(txtDiameter.Text.Trim()); } else { eclass.Diameter = 0; } if (!string.IsNullOrEmpty(cbxType.Text.Trim())) { eclass.PotKind = cbxType.Text.Trim(); } else { eclass.PotKind = " "; } if (!string.IsNullOrEmpty(txtRemark.Text.Trim())) { eclass.Remark = txtRemark.Text.Trim(); } else { eclass.Remark = " "; } if (!string.IsNullOrEmpty(cbx_yno.Text.Trim())) { eclass.LpnId = Convert.ToInt64(this.cbx_yno.SelectedValue.ToString()); } else { eclass.LpnId = 0; } }
private void cbxPModel_Leave(object sender, EventArgs e) { // 如果选择材料,则取材料名称、规格在材料库存表中查询该记录的帐面库存量; #region 询该材料的库存量 if (rbtnPMaterial.Checked) { int mnid, mmid; if (!cbxPName.Text.Trim().Equals("")) { mnid = Convert.ToInt32(this.cbxPName.SelectedValue.ToString()); } else { mnid = 0; } if (!cbxPModel.Text.Trim().Equals("")) { mmid = Convert.ToInt32(this.cbxPModel.SelectedValue.ToString()); } else { mmid = 0; } if ((mnid != 0) && (mmid != 0)) { mId = mLogic.MaterialSearch(mnid, mmid); if (stockCLogic.SearchPMQuantity(mId).Rows.Count != 0) { txtTheory.Text = stockCLogic.SearchPMQuantity(mId).Rows[0][1].ToString(); } } } #endregion // 如果选择产品、则取产品名称、规格在产品库存表中查询该记录的帐面库存量; #region 询该产品的库存量 if (rbtnPProduct.Checked) { int pnid, pmid; if (!cbxPName.Text.Trim().Equals("")) { pnid = Convert.ToInt32(this.cbxPName.SelectedValue.ToString()); } else { pnid = 0; } if (!cbxPModel.Text.Trim().Equals("")) { pmid = Convert.ToInt32(this.cbxPModel.SelectedValue.ToString()); } else { pmid = 0; } if ((pnid != 0) && (pmid != 0)) { pid = pLogic.PSearchID(pnid, pmid); if (stockCLogic.SearchPPSuttle(pid).Rows.Count != 0) { txtTheory.Text = stockCLogic.SearchPPSuttle(pid).Rows[0][1].ToString(); } } } #endregion }