private List <T_PropEntity> ConvertToSkuValue(SkuContract contract) { var result = new List <T_PropEntity>(); int displayIndex = 0; foreach (var i in contract.ValueList) { var dbEntity = new T_PropEntity { prop_id = i.SkuValueId, prop_code = i.SkuValueCode, prop_name = i.SkuValueName, prop_type = "3", parent_prop_id = contract.SkuId, prop_level = 2, prop_domain = "SKU", prop_input_flag = "select", prop_max_lenth = 1000, status = 1, display_index = ++displayIndex, create_time = i.CreateTime != null?contract.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss") : DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = i.ModifyTime != null?contract.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss") : DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), }; result.Add(dbEntity); } return(result); }
internal void Delete(T_PropEntity dbEntity) { using (var conn = new SqlConnection(ConnectionString.XgxInsert)) { conn.Open(); conn.Delete(dbEntity); } }
internal void Update(T_PropEntity dbEntity) { using (var conn = new SqlConnection(ConnectionString.XgxInsert)) { dbEntity.modify_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); //dbEntity.modify_user_id = "ERP"; conn.Open(); conn.Update(dbEntity); } }
private T_PropEntity ConvertToSkuName(SkuContract contract) { var dbEntity = new T_PropEntity { prop_id = contract.SkuId, prop_code = contract.SkuCode, prop_name = contract.SkuName, prop_type = "2", parent_prop_id = "-99", prop_level = 1, prop_domain = "SKU", prop_input_flag = "select", prop_max_lenth = 1000, status = 1, display_index = 0, create_time = contract.CreateTime != null?contract.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss") : DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = contract.ModifyTime != null?contract.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss") : DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), }; return(dbEntity); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Update(T_PropEntity pEntity, IDbTransaction pTran) { _currentDAO.Update(pEntity, pTran); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(T_PropEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <T_PropEntity> PagedQueryByEntity(T_PropEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public T_PropEntity[] QueryByEntity(T_PropEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Delete(T_PropEntity pEntity, IDbTransaction pTran) { _currentDAO.Delete(pEntity, pTran); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(T_PropEntity pEntity) { _currentDAO.Delete(pEntity); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(T_PropEntity pEntity) { _currentDAO.Update(pEntity); }
public void Create(T_PropEntity dbEntity) { _cmd.Create(dbEntity); }
public void Delete(T_PropEntity dbEntity) { _cmd.Delete(dbEntity); }
public void Update(T_PropEntity dbEntity) { _cmd.Update(dbEntity); }