//批量保存目标配合比的方法
private void SaveAll()
{
try
{
int id;
List <TargetProportionDetailClass> list = GetTPDetail();
TargetProportionClass TPClass = SetPara();
id = Convert.ToInt32(qualityLogic.SaveTargetProportionAdd(TPClass, 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
{
}
}
/*
* 方法名称：SaveTargetProportionAdd
* 方法功能描述：同时将目标配合比主表和明细表保存到数据库中的方法 插入到两个表中
*
* 创建人：夏阳明
* 创建时间：20090304
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public int SaveTargetProportionAdd(TargetProportionClass TPClass, List <TargetProportionDetailClass> list)
{
int id;
ArrayList sqllist = new ArrayList();
sqllist.Add(qualityDb.GetInsertSqlps(TPClass));
foreach (TargetProportionDetailClass TPDClass in list)
{
sqllist.Add(qualityDb.GetInsertSqlpsd(TPDClass));
}
ds = sqlHelperObj.QueryForDateSet(sqllist);
id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
return(id);
}
private TargetProportionClass SetPara()
{
#region
TargetProportionClass TPClass = new TargetProportionClass();
try
{
TPClass.PmId = qualityLogic.FrmMixtureRatioAddSearchPId(Convert.ToInt32(cbxPName.SelectedValue.ToString()),
Convert.ToInt32(cbxPModel.SelectedValue.ToString()));
TPClass.Producer = cbxProducer.Text;
TPClass.Remark = txtRemark.Text;
TPClass.InputDate = DateTime.Now;
TPClass.InputMan = this.userName;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(TPClass);
#endregion
}
/*
* 方法名称：FrmMixtureRatioAddNewTargetProportion
* 方法功能描述：保存目标配合比概要信息记录
*
* 创建人：夏阳明
* 创建时间：20090303
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public bool FrmMixtureRatioAddNewTargetProportion(TargetProportionClass TPClass, int id, string userName)
{
status = qualityDb.FrmMixtureRatioAddNewTargetProportion(TPClass, id, userName);
return(status);
}