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