/// <summary> /// 删除货品条码 /// </summary> /// <param name="idcode"></param> public void DeleteMatIDCode(MatIDCode idcode) { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.Delete <MatIDCode>(idcode); } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(CheckStockBill info) { int count = 0; string sql = ""; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); count = session.Delete <CheckStockBill>(info); sql = "delete from T_WH_CheckStockDetail where BillID = @BillID"; session.ExecuteSql(sql, new DataParameter("BillID", info.ID)); session.CommitTs(); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(ProductInfo model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除基本信息 count = session.Delete <ProductInfo>(model); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除公告信息 /// </summary> /// <param name="user">公告信息</param> /// <returns>删除个数</returns> public int Delete(NoticeInfo notice) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除基本信息 count = session.Delete <NoticeInfo>(notice); } return(count); } catch (Exception ex) { throw; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHStockLimit info) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除基本信息 count = session.Delete <WHStockLimit>(info); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 逻辑删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHOutMode model) { StringBuilder sqlBuilder = new StringBuilder(); List <DataParameter> parameters = new List <DataParameter>(); int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { count = session.Delete <WHOutMode>(model); } return(count); } catch (Exception ex) { throw ex; } }
public void Delete(UseMatBill bill) { string sql = null; using (IDataSession session = AppDataFactory.CreateMainSession()) { session.OpenTs(); session.Delete <UseMatBill>(bill); sql = "delete from T_WH_UseMatAmount where USEID = @USEID"; session.ExecuteSql(sql, new DataParameter("USEID", bill.PID)); session.Insert <UseMatAmount>(bill.Amounts); sql = "delete from T_WH_UseMatDetail where USEID = @USEID"; session.ExecuteSql(sql, new DataParameter("USEID", bill.PID)); session.Insert <UseMatDetail>(bill.Details); session.CommitTs(); } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(WHQualityCheck model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除基本信息 count = session.Delete <WHQualityCheck>(model); //删除明细信息 string sql = "DELETE FROM T_WH_QualityCheckResult WHERE CheckID = @CheckID"; session.ExecuteSql(sql, new DataParameter("CheckID", model.ID)); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(ProduceBOM model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除BOM信息 count = session.Delete <ProduceBOM>(model); //删除BOM明细信息 string sql = "delete from T_FP_BOMDETAIL where BOMID = @BOMID"; session.ExecuteSql(sql, new DataParameter("BOMID", model.PID)); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(SupplyInfo model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除BOM信息 count = session.Delete <SupplyInfo>(model); //删除BOM明细信息 string sql = "delete from T_FP_SUPPLYMATERIALINFO where SUPPLYID = @SUPPLYID"; session.ExecuteSql(sql, new DataParameter("SUPPLYID", model.PID)); } return(count); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除信息 /// </summary> /// <param name=""></param> /// <returns>删除个数</returns> public int Delete(QualityCheckInfo model) { int count = 0; try { using (IDataSession session = AppDataFactory.CreateMainSession()) { //删除BOM信息 count = session.Delete <QualityCheckInfo>(model); //删除BOM明细信息 string sql = "DELETE FROM T_FP_QUALITYCHECKRESULT WHERE CheckID = @CheckID"; session.ExecuteSql(sql, new DataParameter("CheckID", model.ID)); } return(count); } catch (Exception ex) { throw ex; } }