/*
* 方法名称：ProduceProportion
* 方法功能描述：同时将生产配合比主表和明细表保存到数据库中的方法 插入到两个表中
*
* 创建人：夏阳明
* 创建时间：20090305
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public int ProduceProportion(ProduceProportionClass PPClass, List <ProduceProportionDetailClass> list)
{
int id;
ArrayList sqllist = new ArrayList();
sqllist.Add(qualityDb.GetPPInsertSqlps(PPClass));
foreach (ProduceProportionDetailClass PPDClass in list)
{
sqllist.Add(qualityDb.GetPPInsertSqlpsd(PPDClass));
}
ds = sqlHelperObj.QueryForDateSet(sqllist);
id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
return(id);
}
private ProduceProportionClass SetPara()
{
ProduceProportionClass PPClass = new ProduceProportionClass();
try
{
PPClass.PId = qualityLogic.FrmMixtureRatioAddSearchPId(Convert.ToInt32(cbxPName.SelectedValue.ToString()),
Convert.ToInt32(cbxPModel.SelectedValue.ToString()));
PPClass.Producer = cbxProducer.Text;
PPClass.Remark = txtRemark.Text;
PPClass.InputDate = DateTime.Now;
PPClass.InputMan = this.userName;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(PPClass);
}
private void btnSave_Click(object sender, EventArgs e)
{
int id;
List <ProduceProportionDetailClass> list = new List <ProduceProportionDetailClass>();
ProduceProportionDetailClass PPDClass = null;
try
{
ProduceProportionClass PPClass = SetPara();
foreach (object obj in panelTable.Controls)
{
TextBox txtOjb = obj as TextBox;
if (txtOjb != null)
{
if (txtOjb.Text != "")
{
if (Check.CheckFloat((txtOjb.Text)))
{
PPDClass = new ProduceProportionDetailClass();
PPDClass.ProduceProportion = txtOjb.Tag.ToString();
PPDClass.ProduceProportionValue = Convert.ToDouble(txtOjb.Text);
PPDClass.Producer = cbxProducer.Text;
PPDClass.InputDate = DateTime.Now;
PPDClass.InputMan = this.userName;
list.Add(PPDClass);
}
else
{
MessageBox.Show("配合比详细信息只能是数字！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
if (PPDClass == null)
{
if (MessageBox.Show("还没有输入详细信息，确定退出吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) ==
DialogResult.OK)
{
this.Close();
}
else
{
return;
}
}
id = Convert.ToInt32(qualityLogic.ProduceProportion(PPClass, list).ToString());
if (id != 0)
{
txtId.Text = id.ToString();
MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
foreach (object obj in panelTable.Controls)
{
if (obj.GetType() == typeof(TextBox))
{
((TextBox)obj).Clear();
}
}
}
else
{
MessageBox.Show("保存失败，请重新操作！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}