public List<Model.Device> GetDeviceList(string whereStr, string sortStr)
{
var cmd = new DataCommand("getDevice", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#",whereStr);
cmd.ReplaceParameterValue("#Sort#", sortStr);
return cmd.ExecuteEntityList<Model.Device>();
}
public List<Model.TS_DataCenter_Area_Month> GetTsDataCenterAreaMonth(string whereStr, string Year)
{
var cmd = new DataCommand("GetTsDataCenterAreaMonth", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#Year#", Year);
return cmd.ExecuteEntityList<Model.TS_DataCenter_Area_Month>();
}
public List<Model.MonthSumData> GetMonthDataObjectList(string tableName,string date)
{
var cmd = new DataCommand("getMonthData", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#TableName#", tableName);
return cmd.ExecuteEntityList<Model.MonthSumData>();
}
public List<Model.TB_Menu> GetMenuList(string where, string order)
{
var cmd = new DataCommand("GetMenuList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", where);
cmd.ReplaceParameterValue("#orderby#", order);
return cmd.ExecuteEntityList<Model.TB_Menu>();
}
public List<Model.TB_ALLOCTION_CONFIG_History> GetConfigLogList(string whereStr, string orderBy)
{
var cmd = new DataCommand("getConfigLogList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#orderBy#", orderBy);
return cmd.ExecuteEntityList<Model.TB_ALLOCTION_CONFIG_History>();
}
public List<CostQueryModel> GetCostQuery(QueryCost query)
{
try
{
var cmd = new DataCommand("getCostQuery", new SqlCustomDbCommand());
string table = "";
switch (query.Particle)
{
case Particle.Month:
table = string.Format("TS_FEE_DAY_{0}", query.StartTime.Year);
break;
case Particle.Year:
table = string.Format("TS_FEE_MONTH_{0}", query.StartTime.Year);
break;
default:
table = string.Format("TS_FEE_DAY_{0}", query.StartTime.Year);
break;
}
cmd.ReplaceParameterValue("#TableName#", table);
cmd.SetParameterValue("@OBJECTID", query.ObjectId.ToString());
cmd.SetParameterValue("@ITEMCODE", query.ItemCode);
cmd.SetParameterValue("@StartTime", query.StartTime);
cmd.SetParameterValue("@EndTime", query.EndTime);
return cmd.ExecuteEntityList<CostQueryModel>();
}
catch (Exception ee)
{
throw ee;
}
}
public List<AlarmDiagnoseModel> GetAlarmDiagnose(QueryAlarm query)
{
try
{
var cmd = new DataCommand("getAlarmDiagnose", new SqlCustomDbCommand());
IList<string> objectIds = new AlarmAccess().GetAlarmListAreaId(query.ObjectId, query.ObjType);
StringBuilder sb = new StringBuilder();
foreach (string s in objectIds)
{
sb.Append(s);
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
cmd.ReplaceParameterValue("#ObjectId#", sb.ToString());
cmd.SetParameterValue("@StartTime", query.StartTime);
cmd.SetParameterValue("@EndTime", query.EndTime);
return cmd.ExecuteEntityList<AlarmDiagnoseModel>();
}
catch(Exception ee)
{
throw ee;
//return null;
}
}
public static List <ChannelProductAppointEntity> GetAllAppointList(int page, int pageSize)
{
DataCommand command = DataCommandManager.GetDataCommand("GetAllAppointList");
command.SetParameterValue("@Page", page);
command.SetParameterValue("@PageSize", pageSize);
return(command.ExecuteEntityList <ChannelProductAppointEntity>());
}
public static List <POSSBLogEntity> GetPOSSBLog(int poSysNo, string actionType)
{
DataCommand command = DataCommandManager.GetDataCommand("GetPOSSBLog");
command.SetParameterValue("@POSysNo", poSysNo);
command.SetParameterValue("@ActionType", actionType);
return(command.ExecuteEntityList <POSSBLogEntity>());
}
public List <PrivilegeEntity> GetPrivilegeList()
{
DataCommand dc =
DataCommandManager.GetDataCommand("External_Get_PrivilegeList");
List <PrivilegeEntity> result = dc.ExecuteEntityList <PrivilegeEntity>();
return(result);
}
/// <summary>
/// 加载UserRole信息
/// </summary>
public static List <User_Role> LoadUserRole(int UserSysNo)
{
DataCommand cmd = new DataCommand("LoadUserRole");
cmd.SetParameter("@UserSysNo", DbType.Int32, UserSysNo);
List <User_Role> list = cmd.ExecuteEntityList <User_Role>();
return(list);
}
public static List <PurchaseOrderSSBLogInfo> LoadPOSSBLog(int poSysNo, PurchaseOrderSSBMsgType msgType)
{
DataCommand command = DataCommandManager.GetDataCommand("GetPOSSBLog");
command.SetParameterValue("@POSysNo", poSysNo);
command.SetParameterValue("@ActionType", msgType.ToString());
return(command.ExecuteEntityList <PurchaseOrderSSBLogInfo>());
}
/// <summary>
/// 获取商品映射列表
/// </summary>
/// <param name="productSysNo"></param>
/// <returns></returns>
private IList <ProductMapping> GetProductMappingList(int productSysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetProductMappingList");
dc.SetParameterValue("@ProductSysNo", productSysNo);
var sourceEntity = dc.ExecuteEntityList <ProductMapping>();
return(sourceEntity);
}
/// <summary>
/// 获取商品时效性促销语
/// </summary>
/// <param name="productSysNo"></param>
/// <returns></returns>
private IList <ProductTimelyPromotionTitle> GetProductTimelyPromotionTitle(int productSysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetProductTimelyPromotionTitle");
dc.SetParameterValue("@ProductSysNo", productSysNo);
var sourceEntity = dc.ExecuteEntityList <ProductTimelyPromotionTitle>();
return(sourceEntity);
}
/// <summary>
/// 获取商品销售区域列表
/// </summary>
/// <param name="productSysNo"></param>
/// <returns></returns>
private IList <ProductSalesAreaInfo> GetProductSalesAreaInfoBySysNo(int productSysNo)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetProductSalesAreaInfoBySysNo");
dc.SetParameterValue("@ProductSysNo", productSysNo);
var sourceEntity = dc.ExecuteEntityList <ProductSalesAreaInfo>();
return(sourceEntity);
}
public List <SaleGiftInfo> GetGiftItemListByProductSysNo(int productSysNo, SaleGiftStatus status)
{
DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_GetGiftItemListByProductSysNo");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
cmd.SetParameterValue("@Status", status);
return(cmd.ExecuteEntityList <SaleGiftInfo>());
}
/// <summary>
/// 获取当前商品会员价格更改请求
/// </summary>
/// <param name="productSysNo"></param>
/// <returns></returns>
public List <ProductRankPriceInfo> GetProductRequestRankPriceBySysNo(int productSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductRequestRankPriceBySysNo");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
var sourceEntity = cmd.ExecuteEntityList <ProductRankPriceInfo>();
return(sourceEntity);
}
/// <summary>
/// 根据商品ID查询商品列表，用于查询返修品，ProductID类似 xxxxR（目前仅RMA调用）
/// </summary>
/// <returns></returns>
public List <ProductInfo> GetSimpleProductListByID(string productID)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetSimpleProductListByID");
dc.SetParameterValue("@ProductID", productID);
var sourceEntity = dc.ExecuteEntityList <ProductInfo>();
return(sourceEntity);
}
public static List <PurchaseOrderReceivedInfo> LoadPurchaseOrderReceivedInfo(int poSysNo)
{
List <PurchaseOrderReceivedInfo> result = new List <PurchaseOrderReceivedInfo>();
DataCommand command = DataCommandManager.GetDataCommand("GetPOReceivedInfoByPOSysNo");
command.SetParameterValue("@POSysNo", poSysNo);
result = command.ExecuteEntityList <PurchaseOrderReceivedInfo>();
return(result);
}
public static List<SecKillEntity> GetCountDownItem4SecKill()
{
List<SecKillEntity> result;
DataCommand command = DataCommandManager.GetDataCommand("GetCountDownItem4SecKill");
result = command.ExecuteEntityList<SecKillEntity>();
return result;
}
/// <summary>
/// 获取 超过10天 待审核(0)、待支付(2)、待主管审核(3)、待出库(1) 的订单信息；
/// </summary>
/// <returns>成功返回MoreThanTenDaysOrderInfoEntity 列表</returns>
public static List <MoreThanTenDaysOrderInfoEntity> GetMoreThanTenDaysUnauditedOrNotOutStockOrderInfoList(string CompanyCode)
{
List <MoreThanTenDaysOrderInfoEntity> result = new List <MoreThanTenDaysOrderInfoEntity>();
DataCommand command = DataCommandManager.GetDataCommand("GetUnauditedOrNotOutStockOrderList");
command.SetParameterValue("@CompanyCode", CompanyCode);
result = command.ExecuteEntityList <MoreThanTenDaysOrderInfoEntity>();
return(result);
}
public static List<InventoryStockEntity> GetInventoryStock(int ProductSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetInventoryStockByProductSysNo");
command.SetParameterValue("@ProductSysNo", ProductSysNo);
List<InventoryStockEntity> result = command.ExecuteEntityList<InventoryStockEntity>();
return result;
}
/// <summary>
/// 根据存储过程名称查询元数据
/// </summary>
/// <param name="argProceName"></param>
/// <returns></returns>
public List <ProceMetadata> GetMetadataList(string argProceName)
{
DataCommand command = DataCommandManager.GetDataCommand("Common.GetProceParam");
command.SetParameterValue("@SPECIFIC_NAME", argProceName);
List <ProceMetadata> list = command.ExecuteEntityList <ProceMetadata>();
return(list);
}
//查询三级别类别
public List <ProductBrandWarrantyInfo> GetC3SysNo(ProductBrandWarrantyInfo productBrandWarranty)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetBrandWarrantyC3SysNo");
cmd.SetParameterValue("@C1SysNo", productBrandWarranty.C1SysNo);
cmd.SetParameterValue("@C2SysNo", productBrandWarranty.C2SysNo);
cmd.SetParameterValue("@C3SysNo", productBrandWarranty.C3SysNo);
return(cmd.ExecuteEntityList <ProductBrandWarrantyInfo>());
}
public static List <UICustomerReviewInfo> GetGoodReview(int limitCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("Review_GetGoodReview");
SetCommandDefaultParameters(cmd);
cmd.SetParameterValue("@TopCount", limitCount);
return(cmd.ExecuteEntityList <UICustomerReviewInfo>());
}
public List <CarInfo> GetCarInfoBySupplierID(long supplierID)
{
List <CarInfo> result = new List <CarInfo>();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(CarStatement.GetCarInfoBySupplierID, "Text"));
command.AddInputParameter("@SupplierID", DbType.Int64, supplierID);
result = command.ExecuteEntityList <CarInfo>();
return(result);
}
public List <PrivilegeEntity> GetPrivilegeListByRoleSysNo(int roleSysNo)
{
DataCommand dc =
DataCommandManager.GetDataCommand("External_Get_PrivilegeListByRoleSysNo");
dc.SetParameterValue("@RoleSysNo", roleSysNo);
return(dc.ExecuteEntityList <PrivilegeEntity>());
}
public static List <CommissionSettlementItemEntity> CommissionSettlementItemBySysNo(int userSysNo, DateTime beginDate, DateTime endDate)
{
DataCommand command = DataCommandManager.GetDataCommand("Settled.CommissionSettlementItemBySysNo");
command.SetParameterValue("@UserSysNo", userSysNo);
command.SetParameterValue("@BeginDate", beginDate);
command.SetParameterValue("@EndDate", endDate);
return(command.ExecuteEntityList <CommissionSettlementItemEntity>());
}
public static List <POItem> GetPOItemBySys(int poSys, string companyCode)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetPOItemBySys");
cmd.SetParameterValue("@SysNo", poSys);
cmd.SetParameterValue("@Companycode", companyCode);
return(cmd.ExecuteEntityList <POItem>());
}
public static List <OnlineList> GetAllC1SysNolist()
{
List <OnlineList> onlineList = null;
DataCommand command = DataCommandManager.GetDataCommand("GetAllC1SysNolist");
command.SetParameterValue("@CompanyCode", CompanyCode);
onlineList = command.ExecuteEntityList <OnlineList>();
return(onlineList);
}
public static List <ChannelProductPercentEntity> GetAllPercentListByChannelSysNo(int page, int pageSize, int ChannelSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetAllPercentListByChannelSysNo");
command.SetParameterValue("@Page", page);
command.SetParameterValue("@PageSize", pageSize);
command.SetParameterValue("@ChannelSysNo", ChannelSysNo);
return(command.ExecuteEntityList <ChannelProductPercentEntity>());
}
public List <ProductDepartmentCategory> GetExistingProductCategories(List <int> c2SysNoLsit, int productDomainSysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("ProductDomain_GetExistingProductCategories");
cmd.SetParameterValue("@C2SysNoLsit", c2SysNoLsit.Join(","));
cmd.SetParameterValue("@ProductDomainSysNo", productDomainSysNo);
return(cmd.ExecuteEntityList <ProductDepartmentCategory>());
}
public static List <OnlineList> GetAllBrand()
{
List <OnlineList> result = null;
DataCommand command = DataCommandManager.GetDataCommand("GetAllBrand");
command.SetParameterValue("@CompanyCode", CompanyCode);
result = command.ExecuteEntityList <OnlineList>();
return(result);
}
public List <CommissionRule> GetCommissionRulesByMerchantSysNo(int merchantSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetCommissionRulesByMerchantSysNo");
command.SetParameterValue("@MerchantSysNo", merchantSysNo);
command.SetParameterValue("@CompanyCode", GlobalSettings.CompanyCode);
return(command.ExecuteEntityList <CommissionRule>());
}
/// <summary>
/// 获取经销商品结算单子项（附带着税金价款信息）
/// </summary>
/// <param name="SettleInfo"></param>
/// <returns></returns>
public List <SettleItemInfo> GetSettleItemInfoWithTaxAndCost(SettleInfo settleInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetSettleItemInfoWithTaxAndCost");
command.SetParameterValue("@SettleSysNo", settleInfo.SysNo);
var result = command.ExecuteEntityList <SettleItemInfo>();
return(result);
}
/// <summary>
/// 相同产品ID、相同批次号
/// </summary>
/// <param name="goodsid"></param>
/// <param name="storageID"></param>
/// <param name="batchNumber"></param>
/// <param name="DY0">是否查询大于0</param>
/// <returns></returns>
public List <InventoryInfo> GetInventoryByRule(int goodsid, int storageID, string batchNumber, int CustomerID, bool DY0, string keywords)
{
List <InventoryInfo> result = new List <InventoryInfo>();
string sqlText = InventoryStatement.GetAllInventoryByRule;
if (!string.IsNullOrEmpty(keywords))
{
sqlText += " and GoodsID in(select GoodsID from wms_GoodsInfo where GoodsName like '%" + keywords + "%')";
}
if (goodsid > 0)
{
sqlText += " AND GoodsID=@GoodSID";
}
if (storageID > 0)
{
sqlText += " AND StorageID=@StorageID";
}
if (!string.IsNullOrEmpty(batchNumber))
{
sqlText += " AND BatchNumber=@BatchNumber";
}
if (CustomerID > 0)
{
sqlText += " AND CustomerID=@CustomerID";
}
// 只查询大于0的库存数据
if (DY0)
{
sqlText += " AND Quantity>0";
}
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sqlText, "Text"));
if (goodsid > 0)
{
command.AddInputParameter("@GoodSID", DbType.String, goodsid);
}
if (storageID > 0)
{
command.AddInputParameter("@StorageID", DbType.String, storageID);
}
if (!string.IsNullOrEmpty(batchNumber))
{
command.AddInputParameter("@BatchNumber", DbType.String, batchNumber);
}
if (CustomerID > 0)
{
command.AddInputParameter("@CustomerID", DbType.String, CustomerID);
}
result = command.ExecuteEntityList <InventoryInfo>();
return(result);
}
/// <summary>
/// 获取热门关键信息
/// </summary>
public static List <HotSearchKeyword> GetHotSearchKeyword(int pageType, int pageID)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("Content_GetHotSearchKeyword");
dataCommand.SetParameterValue("@PageType", pageType);
dataCommand.SetParameterValue("@PageID", pageID);
List <HotSearchKeyword> entitys = dataCommand.ExecuteEntityList <HotSearchKeyword>();
return(entitys);
}
public List<StepSettingModel> GetStepSetting(string itemcode)
{
try
{
var cmd = new DataCommand("getStepSetting", new SqlCustomDbCommand());
cmd.SetParameterValue("@ITEMCODE", itemcode);
return cmd.ExecuteEntityList<StepSettingModel>();
}
catch (Exception ee)
{
throw ee;
}
}
// public DataTable GetMenuTree(string username)
// {
// try
// {
// string SQL = string.Format(@"select A.ID MenuID,A.MenuName,A.LinkName,A.IconClass,A.ParentID from dbo.TB_MENU A
//JOIN TB_USERGROUPMENURIGHT B ON A.ID=B.MENUID
//JOIN TB_USER C ON B.USERGROUPID=C.GROUPS
//WHERE C.CNAME='{0}'
//order by A.ID", username);
// return SqlHelper.Query(SQL).Tables[0];
// }
// catch (Exception ex)
// {
// throw new Exception(ex.Message);
// }
// }
public List<MenuModel> GetMenus(string username)
{
try
{
var cmd = new DataCommand("getMenus", new SqlCustomDbCommand());
cmd.SetParameterValue("@CNAME", username);
return cmd.ExecuteEntityList<MenuModel>();
}
catch (Exception ee)
{
throw ee;
}
}
public List<Model.Itemcode> GetItemcodeList(string whereStr, string sortStr)
{
try
{
var cmd = new DataCommand("getItemCode", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#Sort#", sortStr);
return cmd.ExecuteEntityList<Model.Itemcode>();
}
catch(Exception ee)
{
return null;
}
}
public List<TB_AreaInfo> GetAreaList(List<int> areaId )
{
try
{
string strArea = listToString(areaId);
var cmd = new DataCommand("GetAreaList", new SqlCustomDbCommand());
cmd.SetParameterValue("@AREAID", strArea);
return cmd.ExecuteEntityList<TB_AreaInfo>();
}
catch (Exception ee)
{
throw ee;
}
}
public List<Model.TS_FEE_DAY> GetFeeDayList(int year, string whereStr)
{
try
{
var cmd = new DataCommand("getFeeDay", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#TableName#", "TS_FEE_DAY_" + year);
cmd.ReplaceParameterValue("#whereStr#", whereStr);
List<Model.TS_FEE_DAY> list = cmd.ExecuteEntityList<Model.TS_FEE_DAY>();
return list;
}
catch (Exception ex)
{
string message = ex.Message;
}
return null;
}
public List<TB_Alloction_Config> GetAlloctionConfig(Queryfeeapportion feeApport)
{
try
{
var cmd = new DataCommand("GetAlloctionConfig", new SqlCustomDbCommand());
cmd.SetParameterValue("@OBJECTID", feeApport.ObjectId);
cmd.SetParameterValue("@ITEMCODE", feeApport.ItemCode);
cmd.SetParameterValue("@YEAR", feeApport.StartTime.Year);
cmd.SetParameterValue("@MONTH", feeApport.StartTime.Month);
return cmd.ExecuteEntityList<TB_Alloction_Config>();
}
catch (Exception ee)
{
throw ee;
}
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public List<Model.BaseLayerObject> GetBaseFuncLayerObjectList(string whereStr, string sortStr, string username = "")
{
string viewname = "";
if (!string.IsNullOrEmpty(username))
{
viewname = "Becm_FunctionObjectByUser";
whereStr += string.Format(" and username='******'", username);
}
else
{
viewname = "getBaseFuncLayerObject";
}
var cmd = new DataCommand(viewname, new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#Sort#", sortStr);
return cmd.ExecuteEntityList<Model.BaseLayerObject>();
}
public HistoryImport GetResultImportList(HistoryQuery import, int action)
{
var result = new HistoryImport { HistoryItem = new List<ResultImport>(), PageInfo = new PageInfo() };
var cmd = new DataCommand("SearchImportData", new SqlCustomDbCommand());
var whereStr = new StringBuilder();
if (import.DeviceId == null || import.DeviceId==0)
{
if (!string.IsNullOrEmpty(import.ObjectId.ToString()))
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.ObjectId));
}
}
else
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.DeviceId));
}
if (!string.IsNullOrEmpty(import.Starttime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime>='{0}'", import.Starttime));
}
if (!string.IsNullOrEmpty(import.Endtime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime<='{0}'", import.Endtime));
}
if (!string.IsNullOrEmpty(import.ItemCode))
{
whereStr.Append(string.Format(" and import.ItemCode='{0}'", import.ItemCode));
}
if (!string.IsNullOrEmpty(import.DateUnit.ToString(CultureInfo.InvariantCulture)))
{
whereStr.Append(string.Format(" and import.MonthType={0}", import.DateUnit));
}
cmd.SetParameterValue("@action", action);
cmd.ReplaceParameterValue("#whereStr#", whereStr.ToString());
cmd.ReplaceParameterValue("#pagesize#",import.PaddingInfo.PageSize.ToString(CultureInfo.InvariantCulture));
cmd.ReplaceParameterValue("#pagenums#", ((import.PaddingInfo.Page - 1) * import.PaddingInfo.PageSize).ToString(CultureInfo.InvariantCulture));
result.HistoryItem = cmd.ExecuteEntityList<ResultImport>();
foreach (var item in result.HistoryItem)
{
item.ObjectName = GetObjectName(item.IsArea, item.ObjectId);
}
result.PageInfo.Total = (int)cmd.GetParameterValue("@Count");
return result;
}
public List<CostQueryModel> GetCostQuery(Queryfeeapportion query, DateTime dtBegin, DateTime dtEnd)
{
try
{
var cmd = new DataCommand("getCostQuery2", new SqlCustomDbCommand());
string table = "TS_FEE_DAY_" + query.StartTime.Year;
cmd.ReplaceParameterValue("#TableName#", table);
cmd.SetParameterValue("@OBJECTID", query.ObjectId.ToString());
cmd.SetParameterValue("@ITEMCODE", query.ItemCode);
cmd.SetParameterValue("@StartTime", dtBegin);
cmd.SetParameterValue("@EndTime", dtEnd);
return cmd.ExecuteEntityList<CostQueryModel>();
}
catch (Exception ee)
{
throw ee;
}
}
public QuotaAnalyseModel GetQuotaAnalyse(string whereStr)
{
try
{
var cmd = new DataCommand("getQuotaValue", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
//return cmd.ExecuteEntity<QuotaAnalyseModel>();
var list = cmd.ExecuteEntityList<QuotaAnalyseModel>();
if (list.Count > 0)
{
return list[0];
}
}
catch(Exception ee)
{
}
return null;
}
public List<Model.SysLog> GetSysLogList(string whereStr)
{
var cmd = new DataCommand("GetSysLog", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteEntityList<Model.SysLog>();
}
public List<UserGroupModel> GetUserGroups()
{
var cmd = new DataCommand("getUserGroupList", new SqlCustomDbCommand());
return cmd.ExecuteEntityList<Model.UserGroupModel>();
}
// public void AddUserGroup(QueryUserGroup model)
// {
// try
// {
// string sql = " select max(id) + 1 from tb_usergroup ";
// int MaxID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql));
// List<String> sqlList = new List<string>();
// List<SqlParameter[]> parasList = new List<SqlParameter[]>();
// sql = @"insert into tb_usergroup
// (id,cname,description)
// values
// (@id,@cname,@description)";
// SqlParameter[] paras = new SqlParameter[] {
// new SqlParameter("@id",MaxID) ,
// new SqlParameter("@cname", model.UserGroupName),
// new SqlParameter("@description", model.Description)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPMENURIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",MaxID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPLIQUIDRIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",MaxID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPAREARIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",MaxID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// foreach (var menu in model.UserGroupMenuRights)
// {
// sql = @"insert into TB_USERGROUPMENURIGHT
// (usergroupid,menuid)
// values
// (@usergroupid,@menuid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", MaxID),
// new SqlParameter("@menuid", menu)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// foreach (var liquid in model.UserGroupLiquidRights)
// {
// sql = @"insert into TB_USERGROUPLIQUIDRIGHT
// (usergroupid,areaid)
// values
// (@usergroupid,@areaid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", MaxID),
// new SqlParameter("@areaid", liquid)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// foreach (var area in model.UserGroupAreaRights)
// {
// sql = @"insert into TB_USERGROUPAREARIGHT
// (usergroupid,areaid)
// values
// (@usergroupid,@areaid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", MaxID),
// new SqlParameter("@areaid", area)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// SqlHelper.ExecuteSql(sqlList, parasList);
// }
// catch (Exception ee)
// {
// throw ee;
// }
// }
// public void UpdateUserGroup(QueryUserGroup model)
// {
// try
// {
// List<String> sqlList = new List<string>();
// List<SqlParameter[]> parasList = new List<SqlParameter[]>();
// string sql = @"update tb_usergroup
// set
// cname=@cname,
// description=@description
// where id=@id";
// SqlParameter[] paras = new SqlParameter[] {
// new SqlParameter("@cname", model.UserGroupName),
// new SqlParameter("@description", model.Description),
// new SqlParameter("@id", model.UserGroupID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPMENURIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",model.UserGroupID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPLIQUIDRIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",model.UserGroupID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPAREARIGHT where usergroupid=@id";
// paras = new SqlParameter[] {
// new SqlParameter("@id",model.UserGroupID)
// };
// sqlList.Add(sql);
// parasList.Add(paras);
// foreach (var menu in model.UserGroupMenuRights)
// {
// sql = @"insert into TB_USERGROUPMENURIGHT
// (usergroupid,menuid)
// values
// (@usergroupid,@menuid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", model.UserGroupID),
// new SqlParameter("@menuid", menu)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// foreach (var liquid in model.UserGroupLiquidRights)
// {
// sql = @"insert into TB_USERGROUPLIQUIDRIGHT
// (usergroupid,areaid)
// values
// (@usergroupid,@areaid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", model.UserGroupID),
// new SqlParameter("@areaid", liquid)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// foreach (var area in model.UserGroupAreaRights)
// {
// sql = @"insert into TB_USERGROUPAREARIGHT
// (usergroupid,areaid)
// values
// (@usergroupid,@areaid)";
// paras = new SqlParameter[] {
// new SqlParameter("@usergroupid", model.UserGroupID),
// new SqlParameter("@areaid", area)};
// sqlList.Add(sql);
// parasList.Add(paras);
// }
// SqlHelper.ExecuteSql(sqlList, parasList);
// }
// catch (Exception ee)
// {
// throw ee;
// }
// }
// public void DeleteUserGroup(int id)
// {
// try
// {
// List<String> sqlList = new List<string>();
// List<SqlParameter[]> parasList = new List<SqlParameter[]>();
// string sql = @"delete from TB_USERGROUPMENURIGHT where usergroupid=@id";
// SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id",id)};
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPLIQUIDRIGHT where usergroupid=@id";
// paras = new SqlParameter[] { new SqlParameter("@id", id) };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from TB_USERGROUPAREARIGHT where usergroupid=@id";
// paras = new SqlParameter[] { new SqlParameter("@id", id) };
// sqlList.Add(sql);
// parasList.Add(paras);
// sql = @"delete from tb_usergroup where id=@id";
// paras = new SqlParameter[] { new SqlParameter("@id", id) };
// sqlList.Add(sql);
// parasList.Add(paras);
// SqlHelper.ExecuteSql(sqlList, parasList);
// }
// catch (Exception ee)
// {
// throw ee;
// }
// }
public QueryUserGroup GetSingleUserGroup(int usergroupid)
{
try
{
var cmd = new DataCommand("getSingleUserGroup", new SqlCustomDbCommand());
cmd.SetParameterValue("@id", usergroupid);
QueryUserGroup result = cmd.ExecuteEntity<QueryUserGroup>();
if (result!=null)
{
result.UserGroupMenuRights = new List<int>();
result.UserGroupLiquidRights = new List<int>();
result.UserGroupAreaRights = new List<int>();
cmd = new DataCommand("getMenuRightByUserGroupID", new SqlCustomDbCommand());
cmd.SetParameterValue("@id", usergroupid);
List<GroupRight> rightlist = cmd.ExecuteEntityList<GroupRight>();
foreach (var right in rightlist)
{
result.UserGroupMenuRights.Add(right.RightID);
}
cmd = new DataCommand("getLiquidRightByUserGroupID", new SqlCustomDbCommand());
cmd.SetParameterValue("@id", usergroupid);
rightlist = cmd.ExecuteEntityList<GroupRight>();
foreach (var right in rightlist)
{
result.UserGroupLiquidRights.Add(right.RightID);
}
cmd = new DataCommand("getAreaRightByUserGroupID", new SqlCustomDbCommand());
cmd.SetParameterValue("@id", usergroupid);
rightlist = cmd.ExecuteEntityList<GroupRight>();
foreach (var right in rightlist)
{
result.UserGroupAreaRights.Add(right.RightID);
}
}
return result;
}
catch (Exception ee)
{
return null;
}
}
public List<Model.TB_MULTI_STEP> GetMultiStepListByTypeID(string typeId)
{
var cmd = new DataCommand("getMultiStepListByTypeID", new SqlCustomDbCommand());
cmd.SetParameterValue("@TYPEID", typeId);
return cmd.ExecuteEntityList<Model.TB_MULTI_STEP>();
}
/// <summary>
/// 获取告警触发事件表数据
/// </summary>
/// <param name="alarmTypeId">告警类型表ID</param>
/// <returns>List<Model.TB_AlarmEvent></returns>
public List<Model.TB_AlarmEvent> GetAlarmEventByAlarmTypeId(int alarmTypeId)
{
var cmd = new DataCommand("getAlarmEventByAlarmTypeId", new SqlCustomDbCommand());
cmd.SetParameterValue("@alarmTypeId", alarmTypeId);
return cmd.ExecuteEntityList<Model.TB_AlarmEvent>();
}
public List<UserList> GetUsers()
{
var cmd = new DataCommand("getUserList", new SqlCustomDbCommand());
return cmd.ExecuteEntityList<UserList>();
}
public List<QueryUserMenu> GetSingleUserMenu(string username)
{
try
{
var cmd = new DataCommand("getSingleUserMenuList", new SqlCustomDbCommand());
cmd.SetParameterValue("@name", username);
return cmd.ExecuteEntityList<QueryUserMenu>();
}
catch (Exception ee)
{
return null;
}
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public List<Model.BaseLayerObject> GetBaseLayerObjectList(string whereStr, string sortStr, string username = "")
{
// var cmd = new DataCommand("getBaseLayerObject", new SqlCustomDbCommand());
//string username = "";
//try
//{
// //username = HttpContext.Current.Cache["username"].ToString();
// username = GetCookie("userid");
// username = HttpContext.Current.Session["userid"].ToString() ;
// username = NTS.WEB.Common.CacheHelper.GetCache("username").ToString();
//}
//catch(Exception ee)
//{
//}
string viewname = "";
if (!string.IsNullOrEmpty(username))
{
viewname = "Becm_LayerObjectByUser";
whereStr += string.Format(" and username='******'", username);
}
else
{
viewname = "getBaseLayerObject";
}
var cmd = new DataCommand(viewname, new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#Sort#", sortStr);
//username = HttpContext.Current.Cache["username"].ToString();
//username = GetCookie("username");
//if (HttpContext.Current.Session["username"] != null)
//{
// username = HttpContext.Current.Session["username"].ToString();
//}
//if (!string.IsNullOrEmpty(username))
//{
// cmd.SetParameterValue("@username", username);
//}
//else
//{
// cmd.SetParameterValue("@username", DBNull.Value);
//}
return cmd.ExecuteEntityList<Model.BaseLayerObject>();
}
public List<Model.TB_TIME_PERIOD_SET> GetTimePeroidListByTypeID(string typeId)
{
var cmd = new DataCommand("getTimePeroidListByTypeID", new SqlCustomDbCommand());
cmd.SetParameterValue("@TYPEID", typeId);
return cmd.ExecuteEntityList<Model.TB_TIME_PERIOD_SET>();
}
/// <summary>
/// 根据能源类型和计费方式类型，获取分时 价格 信息
/// </summary>
/// <param name="energyCode"></param>
/// <param name="typeId"></param>
/// <returns></returns>
public List<Model.TB_Price_TimeBillExend> GetTimePriceByEnergyCodeType(string energyCode, string typeId)
{
var cmd = new DataCommand("getTimePriceByEnergyCodeType", new SqlCustomDbCommand());
cmd.SetParameterValue("@EnergyCode", energyCode);
cmd.SetParameterValue("@TypeID", typeId);
return cmd.ExecuteEntityList<Model.TB_Price_TimeBillExend>();
}
public List<Model.TE_Alarm_Scale> GetAlarmScaleList()
{
var cmd = new DataCommand("getAlarmScaleList", new SqlCustomDbCommand());
return cmd.ExecuteEntityList<Model.TE_Alarm_Scale>();
}
/// <summary>
/// 获取告警类型表所有数据
/// </summary>
/// <returns>List<Model.TB_AlarmType></returns>
public List<Model.TB_AlarmType> GetAlarmTypeList(string whereStr)
{
var cmd = new DataCommand("getAlarmTypeList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteEntityList<Model.TB_AlarmType>();
}
/// <summary>
/// 设备关联的液态区域ID列表
/// </summary>
/// <param name="itemcode"></param>
/// <returns></returns>
public List<DeviceAreaID> GetDeviceAreaID2List(string itemcode)
{
string viewname = "";
viewname = "GetDeviceAreaID2List";
var cmd = new DataCommand(viewname, new SqlCustomDbCommand());
if (itemcode == "00000")
{
cmd.SetParameterValue("@itemcode", DBNull.Value);
}
else
{
cmd.SetParameterValue("@itemcode", itemcode);
}
return cmd.ExecuteEntityList<DeviceAreaID>();
}