/// <summary>
/// 增加一条主表数据
/// </summary>
public string GetAddSQL(MaterialBom materialbom)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [MaterialBom](");
strSql.Append("MaterialGuid,MaterialName,Remark");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + materialbom.MaterialGuid + "',");
strSql.Append("'" + materialbom.MaterialName + "',");
strSql.Append("'" + materialbom.Remark + "'");
strSql.Append(")");
return(strSql.ToString());
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveMaterialBom(MaterialBom materialbom, List <MaterialBomDetail> materialbomdetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//删除集合中的bom子件数据
string strDeleteSql = "";
strDeleteSql = "Delete from MaterialBomDetail where MaterialFatherGuid='" + materialbom.MaterialGuid + "'";
pComm.Execute(strDeleteSql);
//删除集合中的bom母件数据
strDeleteSql = "";
strDeleteSql = "Delete from MaterialBom where MaterialGuid='" + materialbom.MaterialGuid + "' ";
pComm.Execute(strDeleteSql);
//插入母件数据
string strInsertSql = "";
strInsertSql = GetAddSQL(materialbom);
pComm.Execute(strInsertSql);
//插入子件数据
strInsertSql = "";
for (int i = 0; i < materialbomdetail.Count; i++)
{
strInsertSql = GetAddDetailSQL(materialbomdetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
