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); }