private ProportionClass SetPara()
{
#region
ProportionClass PClass = new ProportionClass();
try
{
PClass.PId = qualityLogic.FrmGYMixtureRatioSearchPId(Convert.ToInt32(cbxPName.SelectedValue.ToString()),
Convert.ToInt32(cbxPModel.SelectedValue.ToString()));
if (this.Text == "乳化沥青配合比")
{
PClass.Mark2 = 1;
}
else
{
PClass.Mark2 = 0;
}
PClass.Producer = cbxProducer.Text;
PClass.Remark = txtRemark.Text;
PClass.InputDate = DateTime.Now;
PClass.InputMan = this.userName;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(PClass);
#endregion
}
//批量保存配合比的方法
private void SaveAll()
{
try
{
int id;
List <ProportionDetailClass> list = GetTPDetail();
ProportionClass PClass = SetPara();
id = Convert.ToInt32(qualityLogic.SaveProportionAdd(PClass, list).ToString());
if (id != 0)
{
txtPId.Text = id.ToString();
// this.DialogResult = DialogResult.OK;
MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//this.Close();
}
else
{
MessageBox.Show("保存失败，请重新操作！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
}
/*
* 方法名称：SaveProportionAdd
* 方法功能描述：同时将配合比主表和明细表保存到数据库中的方法 插入到两个表中
*
* 创建人：夏阳明
* 创建时间：20090306
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public int SaveProportionAdd(ProportionClass PClass, List <ProportionDetailClass> list)
{
int id;
ArrayList sqllist = new ArrayList();
sqllist.Add(qualityDb.GetPInsertSqlps(PClass));
foreach (ProportionDetailClass PDClass in list)
{
sqllist.Add(qualityDb.GetPInsertSqlpsd(PDClass));
}
ds = sqlHelperObj.QueryForDateSet(sqllist);
id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
return(id);
}
