private ClaimSparePartBillClass SetPara()
{
#region
ClaimSparePartBillClass CSPBClass = new ClaimSparePartBillClass();
try
{
CSPBClass.Fno = cbxFileNo.Text.Trim();
CSPBClass.ClaimDate = DateTime.Parse(dtpDrawDate.Text.Trim());
CSPBClass.ClaimMan = txtDrawMan.Text.Trim();
CSPBClass.DId = int.Parse(cbxDrawDepartment.SelectedValue.ToString());
CSPBClass.EiId = int.Parse(cbxENo.SelectedValue.ToString());
CSPBClass.InputDate = DateTime.Now;
CSPBClass.InputMan = this.UserName;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(CSPBClass);
#endregion
}
private void SaveAll()
{
try
{
List <ClaimSparePartBillDetailClass> list = GetTPDetail();
ClaimSparePartBillClass CSPBClass = SetPara();
id = Convert.ToInt32(equipmentLogic.SaveClaimSparePartAdd(CSPBClass, list).ToString());
if (id != 0)
{
txtDrawNo.Text = id.ToString();
equipmentLogic.SumAllDetail(id);
// 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
{
}
}
/*
* 方法名称：SaveClaimSparePartAdd
* 方法功能描述：同时将领料单主表和明细表保存到数据库中的方法 插入到两个表中
*
* 创建人：夏阳明
* 创建时间：20090324
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public int SaveClaimSparePartAdd(ClaimSparePartBillClass CSPBClass, List <ClaimSparePartBillDetailClass> list)
{
int id;
ArrayList sqllist = new ArrayList();
sqllist.Add(equipmentDb.GetInsertSqlps(CSPBClass));
foreach (ClaimSparePartBillDetailClass CSPBDClass in list)
{
sqllist.Add(equipmentDb.GetInsertSqlpsd(CSPBDClass));
}
ds = sqlHelperObj.QueryForDateSet(sqllist);
id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
return(id);
}
