protected SalesorderTypeStatusInfoModel GetSalesOrderTypeStatusModelByIdFromDatabase(string usalsorder_status_id) { SalesorderTypeStatusInfoModel model = null; string sql = @" SELECT [salsorder_status_id] ,[salesorder_type_id] ,[payment_type] ,[salesorder_status_name] ,[status] ,[description] ,[sort_order] ,[created_by] ,[created_on] ,[modified_on] ,[modified_by] ,[status_code] FROM salesorder_type_status_info WHERE salsorder_status_id = $salsorder_status_id$ "; ParameterCollection pc = new ParameterCollection(); pc.Add("salsorder_status_id", usalsorder_status_id); DataTable dt = ExecuteDataTable(sql, pc); if (dt != null && dt.Rows.Count > 0) { model = new SalesorderTypeStatusInfoModel(); ModelConvertFrom(model, dt, 0); } return(model); }
/// <summary> /// 删除 /// </summary> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int DeleteMultiple(ParameterCollection pc) { int ret = 0; SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel(); ret = DbUtil.Current.DeleteMultiple(salesordertypestatusinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="salesordertypestatusinfo">实体</param> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int UpdateMultiple(SalesorderTypeStatusInfoModel salesordertypestatusinfo, ParameterCollection pc) { int ret = 0; salesordertypestatusinfo.ModifiedBy = SessionUtil.Current.UserId; salesordertypestatusinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.UpdateMultiple(salesordertypestatusinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="salesordertypestatusinfo">实体</param> /// <returns>影响的记录行数</returns> public int Update(SalesorderTypeStatusInfoModel salesordertypestatusinfo) { int ret = 0; salesordertypestatusinfo.ModifiedBy = SessionUtil.Current.UserId; salesordertypestatusinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.Update(salesordertypestatusinfo); return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="salsorderstatusid"></param> /// <returns>影响的记录行数</returns> public int Delete(string salsorderstatusid) { int ret = 0; SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel(); salesordertypestatusinfo.SalsorderStatusId = salsorderstatusid; ret = DbUtil.Current.Delete(salesordertypestatusinfo); return(ret); }
/// <summary> /// 编辑类型状态操作。 /// </summary> /// <param name="statusInfo"></param> /// <returns></returns> public bool EditSalesOrderTypeStatusInfo(SalesorderTypeStatusInfoModel model) { bool result = false; if (SalesorderTypeStatusInfoService.Instance.Update(model) > 0) { result = true; GetSalesOrderTypeStatusModelById(model.SalsorderStatusId, true); } return(result); }
/// <summary> /// 根据条件获取实体集合 /// </summary> /// <param name="pc">pc</param> /// <param name="obc">obc</param> /// <returns>实体</returns> public List <SalesorderTypeStatusInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc) { List <SalesorderTypeStatusInfoModel> salesordertypestatusinfos = new List <SalesorderTypeStatusInfoModel>(); SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel(); DataTable dt = DbUtil.Current.RetrieveMultiple(salesordertypestatusinfo, pc, obc); for (int i = 0; i < dt.Rows.Count; i++) { salesordertypestatusinfo = new SalesorderTypeStatusInfoModel(); salesordertypestatusinfo.ConvertFrom(dt, i); salesordertypestatusinfos.Add(salesordertypestatusinfo); } return(salesordertypestatusinfos); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="salsorderstatusid"></param> /// <returns>实体</returns> public SalesorderTypeStatusInfoModel Retrieve(string salsorderstatusid) { SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel(); salesordertypestatusinfo.SalsorderStatusId = salsorderstatusid; DataTable dt = DbUtil.Current.Retrieve(salesordertypestatusinfo); if (dt.Rows.Count < 1) { return(null); } salesordertypestatusinfo.ConvertFrom(dt); return(salesordertypestatusinfo); }
/// <summary> /// 新建订单类型状态值。 /// </summary> /// <param name="statusInfo"></param> /// <returns></returns> public bool CreateSalesOrderTypeStatusInfo(SalesorderTypeStatusInfoModel model, out string message) { bool result = false; message = "操作失败,请与管理员联系"; if (CheckExistSalesorderStatusName(model.SalesorderStatusName)) { message = string.Format("操作失败,已经存在名为【{0}】状态名称", model.SalesorderStatusName); return(false); } if (SalesorderTypeStatusInfoService.Instance.Create(model) > 0) { message = "添加成功"; result = true; GetSalesOrderTypeStatusModelById(model.SalsorderStatusId, true); } return(result); }
/// <summary> /// 根据ID获取用户领域模型。 /// </summary> /// <param name="userId"></param> /// <param name="clear"></param> /// <returns></returns> public SalesOrderTypeStatusDomainModel GetSalesOrderTypeStatusModelById(string salsorder_status_id, bool clear) { if (string.IsNullOrEmpty(salsorder_status_id)) { return(null); } string cacheKey = CacheKey.GetKeyDefine(CacheKey.SALESORDER_TYPE_STATUS_INFO, salsorder_status_id); SalesOrderTypeStatusDomainModel result = CacheUtil.Get <SalesOrderTypeStatusDomainModel>(cacheKey); if (result == null || clear) { SalesorderTypeStatusInfoModel basicInfo = GetSalesOrderTypeStatusModelByIdFromDatabase(salsorder_status_id); if (basicInfo != null) { result = new SalesOrderTypeStatusDomainModel(); result.BasicInfo = basicInfo; CacheUtil.Set(cacheKey, result); } } return(result); }