/*
* 方法名称： 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
}
