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.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 static List <OnlineList> GetSaleHightItem(int num, int C2Sysno, List <int> ItemSysnolist)
{
List <OnlineList> onlineList = null;
if (num > 0)
{
if (ItemSysnolist != null && ItemSysnolist.Count > 0)
{
DataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("GetSaleHightItemForHomePage");
command.ReplaceParameterValue("@num", num.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@ItemSysnolist", ItemSysnolist.ToListString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
else
{
DataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("GetSaleHightItemForHomePageSingle");
command.ReplaceParameterValue("@num", num.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
onlineList = command.ExecuteEntityList <OnlineList>();
}
}
return(onlineList);
}
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>();
}
/// <summary>
/// 获取告警类型数据
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public DataTable GetAlarmListIndex(QueryAlarmNew alarmNew)
{
int intPazeSize = alarmNew.PageSize;
int intNext = intPazeSize * (alarmNew.PageIndex - 1);
DataTable dtAlarmType = new DataTable();
//string strSql = @" SELECT distinct TOP " + intPazeSize + " id, ALARMOBJID,ALARMTYPE,ALARMTYPENAME,ALARMLEVEL,ALARMOBJNAME,ALARMCONTENT,STATUS,ALARMTIME,location " +
// " from AlarmAreaDevice WHERE id not in " +
// " ( SELECT TOP " + intNext + " id from AlarmAreaDevice ) and 1=1 ";
string whereStr = "";
string orderStr = "ORDER BY id desc";
whereStr += " and ALARMTIME between '" + alarmNew.StartTime.ToString("yyyy-MM-dd 00:00:00") + "' and '" + alarmNew.EndTime.ToString("yyyy-MM-dd 23:59:59") + "'";
if (alarmNew.AlarmStatus != "")
{
whereStr += " and STATUS = " + alarmNew.AlarmStatus;
}
var cmd = new DataCommand("GetAlarmListIndex", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#PageSize#", intPazeSize.ToString());
cmd.ReplaceParameterValue("#Next#", intNext.ToString());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#orderStr#", orderStr);
return(cmd.ExecuteDataSet().Tables[0]);
}
public static List <OnlineList> GetNewItemForBrand(int diffnum, List <int> HasItemSysnolist, int BrandSysNo)
{
List <OnlineList> onlineList = null;
if (diffnum > 0)
{
if (HasItemSysnolist != null && HasItemSysnolist.Count > 0)
{
DataCommand command = DataCommandManager.GetDataCommand("GetNewItemForBrand");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@BrandSysNo", BrandSysNo.ToString());
command.ReplaceParameterValue("@HasItemSysnolist", HasItemSysnolist.ToListString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
if (onlineList == null || onlineList.Count == 0)
{
DataCommand command = DataCommandManager.GetDataCommand("GetNewItemForBrandSingle");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@BrandSysNo", BrandSysNo.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
}
return(onlineList);
}
public static List <OnlineList> GetPriceDownPercentItemForC2(int diffnum, List <int> HasItemSysnolist, int C2Sysno)
{
List <OnlineList> onlineList = null;
if (diffnum > 0)
{
if (HasItemSysnolist != null && HasItemSysnolist.Count > 0)
{
DataCommand command = DataCommandManager.GetDataCommand("GetPriceDownPercentItemForC2");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@HasItemSysnolist", HasItemSysnolist.ToListString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
else
{
DataCommand command = DataCommandManager.GetDataCommand("GetPriceDownPercentItemForC2Single");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
}
return(onlineList);
}
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 DataTable GetWaitingRegisters(int?soSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryWaitingRegisterForRefund");
if (soSysNo == null)
{
List <int> waitingSO = ObjectFactory <IRefundDA> .Instance.GetWaitingSOForRefund();
if (waitingSO != null && waitingSO.Count > 0)
{
string sql = "C.[SOSysNo] IN(";
waitingSO.ForEach(item => sql += item + ",");
sql = sql.TrimEnd(',');
sql += ")";
command.ReplaceParameterValue("#SOSysNo#", sql);
}
else
{
command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] IS NULL");
}
}
else
{
command.ReplaceParameterValue("#SOSysNo#", "C.[SOSysNo] = @SOSysNo");
}
command.SetParameterValue("@SOSysNo", soSysNo);
command.SetParameterValue("@RefundStatus", RMARefundStatus.Abandon);
return(command.ExecuteDataTable());
}
///// <summary>
///// 根据区域和项目代码获取是否含有数据
///// </summary>
///// <param name="itemcode"></param>
///// <param name="areaid"></param>
///// <returns></returns>
//public int GetCountItemCodeAreaId(string itemcode, string areaid)
//{
// string strSql = @"select count(distinct s1.areaid) from Becm_Device s1 "
// + " inner join ( select * from f_GetChildAreaId(" + areaid + " ) ) s2 on s1.areaid = s2.id "
// + " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber where s1.itemcodeid = '" + itemcode + "'";
// return int.Parse(SqlHelper.ExecuteScalar(strSql.ToString()).ToString());
//}
/// <summary>
/// 根据区域和项目代码获取是否含有数据
/// </summary>
/// <param name="itemcode"></param>
/// <param name="areaid"></param>
/// <returns></returns>
public int GetCountItemCodeAreaId(string itemcode, string areaid, int classid)
{
string strSql = "";
if (classid == 1)
{
//strSql = @" select count(distinct s1.areaid) from Becm_Device s1 "
// + "inner join ( select * from f_GetChildAreaId(" + areaid + ") ) s2 on s1.areaid = s2.id "
// + " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber "
// + " inner join ( select * from f_GetChildItemCode('" + itemcode + "') ) s4 on s1.itemcodeid=s4.code";
var cmd = new DataCommand("GetCountItemCodeAreaId1", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#Areaid#", areaid);
cmd.ReplaceParameterValue("#ItemCode#", itemcode);
return(int.Parse(cmd.ExecuteScalar().ToString()));
}
else
{
var cmd = new DataCommand("GetCountItemCodeAreaId2", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#Areaid#", areaid);
cmd.ReplaceParameterValue("#ItemCode#", itemcode);
return(int.Parse(cmd.ExecuteScalar().ToString()));
// strSql = @" select count(distinct s1.areaid) from Becm_Device s1 "
//+ "inner join ( select * from f_GetChildFuncAreaId(" + areaid + ") ) s2 on s1.areaid2 = s2.id "
//+ " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber "
//+ " inner join ( select * from f_GetChildItemCode('" + itemcode + "') ) s4 on s1.itemcodeid=s4.code";
}
//return int.Parse(SqlHelper.ExecuteScalar(strSql.ToString()).ToString());
}
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>();
}
internal static void ClearTableOnLinelist(string day)
{
DataCommand command = DataCommandManager.GetDataCommand("ClearTableOnLinelist");
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
command.ReplaceParameterValue("@Day", day);
command.ExecuteNonQuery();
}
public static void ClearTableOnLinelist(string day)
{
DataCommand command = DataCommandManager.GetDataCommand("ClearTableOnLinelist");
command.ReplaceParameterValue("@CompanyCode", CompanyCode);
command.ReplaceParameterValue("@Day", day);
command.ExecuteNonQuery();
}
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.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.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>());
}
internal static List <OnlineList> CheckC2ItemNumOnC1(int C1sysno)
{
DataCommand command = DataCommandManager.GetDataCommand("CheckC2ItemNumOnC1");
command.ReplaceParameterValue("@Category1Sysno", C1sysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
return(command.ExecuteEntityList <OnlineList>());
}
/// <summary>
/// 获取告警类型数据
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public DataTable GetAlarmList(QueryAlarmNew alarmNew, string groupId)
{
try
{
int intPazeSize = alarmNew.PageSize;
int intNext = intPazeSize * (alarmNew.PageIndex - 1);
string whereStr = "";
string orderStr = "ORDER BY id desc";
whereStr += " and ALARMTIME between '" + alarmNew.StartTime.ToString("yyyy-MM-dd 00:00:00") + "' and '" + alarmNew.EndTime.ToString("yyyy-MM-dd 23:59:59") + "'";
if (alarmNew.AlarmLevel != "")
{
whereStr += " and ALARMLEVEL = " + alarmNew.AlarmLevel;
}
if (alarmNew.AlarmStatus != "")
{
whereStr += " and STATUS = " + alarmNew.AlarmStatus;
}
if (alarmNew.AlarmType != "")
{
whereStr += " and alarmtype = " + alarmNew.AlarmType;
}
IList <string> lstAreaId = GetAlarmListAreaId(alarmNew.ObjectId, alarmNew.ObjType);
IList <string> lstDeviceId = GetAlarmListDeviceId(alarmNew.ObjectId, alarmNew.ObjType);
whereStr += " and (";
if (lstAreaId.Count > 0)
{
string strAreaId = string.Join(",", lstAreaId.ToArray());
whereStr += " ALARMOBJID in (" + strAreaId + ") and alarmObjType=32 ";
}
else
{
whereStr += "1=2";
}
whereStr += " or ";
if (lstDeviceId.Count > 0)
{
string strDeviceId = string.Join(",", lstDeviceId.ToArray());
whereStr += " ALARMOBJID in (" + strDeviceId + ") and alarmObjType=31 ";
}
else
{
whereStr += "1=2";
}
whereStr += ")";
var cmd = new DataCommand("GetAlarmList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#PageSize#", intPazeSize.ToString());
cmd.ReplaceParameterValue("#Next#", intNext.ToString());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
cmd.ReplaceParameterValue("#orderStr#", orderStr);
return(cmd.ExecuteDataSet().Tables[0]);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 删除作废已标记数据
/// </summary>
/// <param name="pagetype"></param>
/// <param name="positionid"></param>
/// <param name="pageID"></param>
public static void DeleteOnlineListItem(int pagetype, int positionid, int pageID)
{
DataCommand command = DataCommandManager.GetDataCommand("DeleteOnlineListSystem");
command.ReplaceParameterValue("@PageType", pagetype.ToString());
command.ReplaceParameterValue("@PageID", pageID.ToString());
command.ReplaceParameterValue("@PositionID", positionid.ToString());
command.ReplaceParameterValue("@CompanyCode", CompanyCode);
command.ExecuteNonQuery();
}
/// <summary>
/// 将该位置系统之前添加的数据标记为待删除
/// </summary>
/// <param name="pagetype"></param>
/// <param name="positionid"></param>
/// <param name="pageID"></param>
public static void UpdateInvalidData(int pagetype, int positionid, int pageID)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateInvalidData");
command.ReplaceParameterValue("@PageType", pagetype.ToString());
command.ReplaceParameterValue("@PageID", pageID.ToString());
command.ReplaceParameterValue("@PositionID", positionid.ToString());
command.ReplaceParameterValue("@CompanyCode", CompanyCode);
command.ExecuteNonQuery();
}
/// <summary>
/// 获取商品配送规则
/// </summary>
/// <param name="c3SysNoStr">商品3级分类编号序列（如：254,256）</param>
/// <param name="productSysNoStr">商品编号序列（如：157856,157896）</param>
/// <param name="provinceSysNo">省编号</param>
/// <param name="citySysNo">市编号</param>
/// <param name="areaSysno">区编号</param>
/// <param name="companyCode">公司编号</param>
/// <returns></returns>
public List <ItemShipRuleInfo> GetItemShipRuleList(string c3SysNoStr, string productSysNoStr, int?provinceSysNo, int?citySysNo, int?areaSysno, string companyCode)
{
DataCommand command = DataCommandManager.GetDataCommand("GetItemShipRuleList");
command.ReplaceParameterValue("#C3SysNoStr#", c3SysNoStr);
command.ReplaceParameterValue("#ProductSysNoStr#", productSysNoStr);
command.SetParameterValue("@ProvinceSysNo", provinceSysNo);
command.SetParameterValue("@CitySysNo", citySysNo);
command.SetParameterValue("@AreaSysNo", areaSysno);
command.SetParameterValue("@CompanyCode", companyCode);
return(command.ExecuteEntityList <ItemShipRuleInfo>());
}
/// <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.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 <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 static List <OnlineList> GetNewItem(int num, int C2Sysno)
{
List <OnlineList> onlineList = null;
if (num > 0)
{
DataCommand command = DataCommandManager.GetDataCommand("GetSaleHightItem");
command.ReplaceParameterValue("@num", num.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
return(onlineList);
}
public static List <OnlineList> GetSaleHightItemForC1Page(int diffnum, List <int> HasItemSysnolist, int C1Sysno, int C2Sysno)
{
List <OnlineList> onlineList = null;
if (diffnum > 0)
{
if (HasItemSysnolist != null && HasItemSysnolist.Count > 0)
{
if (C2Sysno != -1)
{
DataCommand command = DataCommandManager.GetDataCommand("GetSaleHightItemForC1PagebyC2sysno");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@ItemSysnolist", HasItemSysnolist.ToListString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
else
{
DataCommand command = DataCommandManager.GetDataCommand("GetSaleHightItemForC1Page");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C1SysNo", C1Sysno.ToString());
command.ReplaceParameterValue("@ItemSysnolist", HasItemSysnolist.ToListString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
}
else
{
if (C2Sysno != -1)
{
DataCommand command = DataCommandManager.GetDataCommand("GetSaleHightItemForC1PageByC2sysnoSingle");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C2SysNo", C2Sysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
else
{
DataCommand command = DataCommandManager.GetDataCommand("GetSaleHightItemForC1PageSingle");
command.ReplaceParameterValue("@num", diffnum.ToString());
command.ReplaceParameterValue("@C1SysNo", C1Sysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
onlineList = command.ExecuteEntityList <OnlineList>();
}
}
}
return(onlineList);
}
internal static int CheckBrandItemNum(int brandsysno)
{
DataCommand command = DataCommandManager.GetDataCommand("CheckBrandItemNum");
command.ReplaceParameterValue("@BrandSysNo", brandsysno.ToString());
command.ReplaceParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]);
try
{
return(command.ExecuteScalar <int>());
}
catch
{
return(0);
}
}
/// <summary>
/// 是否存在该审核
/// 当中文名或者英文名存在重的名称即认为存在品牌重复
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool IsExistsBrandRequest_New(BrandRequestInfo info)
{
string queryStr = "";
DataCommand cmd = DataCommandManager.GetDataCommand("IsExistsBrandRequest_New");
if ((!string.IsNullOrWhiteSpace(info.BrandNameLocal.Content)) && string.IsNullOrWhiteSpace(info.BrandNameGlobal))
{
queryStr = " AND BrandName_Ch=@BrandName_Ch";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && string.IsNullOrWhiteSpace(info.BrandNameLocal.Content))
{
queryStr = " AND BrandName_En=@BrandName_En";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && (!string.IsNullOrWhiteSpace(info.BrandNameLocal.Content)))
{
queryStr = " AND (BrandName_Ch=@BrandName_Ch or BrandName_En=@BrandName_En)";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && string.IsNullOrWhiteSpace(info.BrandNameLocal.Content))
{
queryStr = " AND BrandName_Ch='' AND BrandName_En='' ";
}
cmd.SetParameterValue("@BrandName_Ch", info.BrandNameLocal.Content);
cmd.SetParameterValue("@BrandName_En", info.BrandNameGlobal);
cmd.ReplaceParameterValue("#strWhere#", queryStr);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@flag") < 0);
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public DataTable GetList(string whereStr, string order)
{
// StringBuilder strSql = new StringBuilder();
// strSql.Append(@"select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from (select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from Becm_LayerObject union
// select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from Becm_FunctionObject)
// aa where 1=1");
// if (!whereStr.Equals(string.Empty))
// {
// strSql.AppendFormat(" and {0}", whereStr);
// }
// strSql.AppendFormat(" order by {0}", order);
// DataTable dt = SqlHelper.Query(strSql.ToString(), parameters).Tables[0];
// return dt;
try
{
var cmd = new DataCommand("GetList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
//cmd.ReplaceParameterValue("#Sort#", order);
return(cmd.ExecuteDataSet().Tables[0]);
}
catch (Exception ee)
{
throw ee;
}
}
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<Model.MonthSumData> GetMonthDataObjectList(string tableName,string date)
{
var cmd = new DataCommand("getMonthData", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#TableName#", tableName);
return cmd.ExecuteEntityList<Model.MonthSumData>();
}
/// <summary>
/// 获取告警类型
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public int GetAlarmIndexCount(QueryAlarmNew alarmNew)
{
int intPazeSize = alarmNew.PageSize;
int intNext = intPazeSize * (alarmNew.PageIndex - 1);
DataTable dtAlarmType = new DataTable();
string strSql = @" SELECT count(id) from AlarmAreaDevice where 1=1";
string whereStr = "";
whereStr += " and ALARMTIME between '" + alarmNew.StartTime.ToString("yyyy-MM-dd 00:00:00") + "' and '" + alarmNew.EndTime.ToString("yyyy-MM-dd 23:59:59") + "'";
if (alarmNew.AlarmStatus != "")
{
whereStr += " and STATUS = " + alarmNew.AlarmStatus;
}
if (!whereStr.Equals(string.Empty))
{
strSql = strSql + whereStr;
}
// Object obj = SqlHelper.GetSingle(strSql);
var cmd = new DataCommand("GetBaseDataItem", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#SQLSTR#", strSql);
return(int.Parse(cmd.ExecuteScalar().ToString()));
}
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<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 void DeleteSOInterceptInfo(SOInterceptInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("BatchDeleteSOIntercept");
command.ReplaceParameterValue("#SysNoString#", " SysNo IN (" + info.Sysnolist + ")");
command.ExecuteNonQuery();
}
public List <Model.TB_UserGroup> GetUserGroupList(string whereStr)
{
var cmd = new DataCommand("GetUserGroupList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return(cmd.ExecuteEntityList <Model.TB_UserGroup>());
}
/// <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>());
}
public static int InsertMPI(string PMSysNos)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryPMMPIEntityInfoByCategoryV2");
command.ReplaceParameterValue("#PMSysNos#", PMSysNos);
return(command.ExecuteNonQuery());
}
/// <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>();
}
/// <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 bool SaveAlloctionAndLog(string sql)
{
var cmd = new DataCommand("saveAlloctionAndLog", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#sql#", sql);
int result = cmd.ExecuteNonQuery();
if (result > 0)
return true;
else
return false;
}
/// <summary>
/// 获取表的基础数据集
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetBaseData(BaseDataModel model)
{
var dtold = new DataTable();
var tcount = new List<string>();
var cmdName = string.Empty;
tcount = GetTcountNames(model, tcount);
switch (model.Unit)
{
case ChartUnit.unit_hour:
cmdName = "getBaseDataByHour";
break;
case ChartUnit.unit_day:
cmdName = "getBaseDataByDate";
break;
case ChartUnit.unit_month:
cmdName = "getBaseDataByMonth";
break;
default:
cmdName = "getBaseDataByMonth";
break;
}
//var cmd = new DataCommand(cmdName, new SqlCustomDbCommand());
//cmd.SetParameterValue("@countid", model.ObjectId);
//cmd.SetParameterValue("@itemcode", model.ItemCode);
for (var i = 0; i < tcount.Count; i++)
{
var cmd = new DataCommand(cmdName, new SqlCustomDbCommand());
cmd.SetParameterValue("@countid", model.ObjectId);
cmd.SetParameterValue("@itemcode", model.ItemCode);
cmd.ReplaceParameterValue("#TableName#", tcount[i]);
//cmd.SetParameterValue("#TableName#", tcount[i]);
//object param = cmd.GetParameterValue("#TableName#");
//cmd.SetParameterValue("@tname", tcount[i]);
DataTable dts;
if (model.Unit == ChartUnit.unit_hour)
{
cmd.SetParameterValue("@cdate", model.Starttime.ToString("yyyy-MM-dd"));
}
try
{
dts = cmd.ExecuteDataSet().Tables[0];
dtold = i.Equals(0) ? dts.Clone() : dtold;
dtold = UniteDataTable(dtold, dts.Copy());
}
catch (Exception e)
{
//throw new Exception(e.Message);
}
}
return MakerData(dtold, model);
}
public bool HasMenuRight(string where)
{
try
{
var cmd = new DataCommand("HasMenuRight", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", where);
return int.Parse(cmd.ExecuteScalar().ToString()) == 0 ? false : true;
}
catch (Exception)
{
return false;
}
}
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<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;
}
}
/// <summary>
/// 获取告警数量
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public int GetAlarmCount(string whereStr)
{
//DataTable dtAlarmType = new DataTable();
//string strSql = "select count(id) from TE_ALARM where 1=1 ";
//if (!whereStr.Equals(string.Empty))
//{
// strSql = strSql + whereStr;
//}
//Object obj = SqlHelper.GetSingle(strSql);
//int Count = 0;
//if (obj != DBNull.Value)
//{
// Count = int.Parse(obj.ToString());
//}
//return Count;
var cmd = new DataCommand("GetAlarmCount", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return int.Parse(cmd.ExecuteScalar().ToString());
}
/// <summary>
/// 更新设备属性
/// </summary>
/// <param name="areaId"></param>
/// <param name="itemCodeId"></param>
/// <param name="areaType"></param>
/// <param name="deviceIds"></param>
/// <returns></returns>
public int UpdateDeviceProp(int areaId, int itemCodeId, int areaType, List<int> deviceIds)
{
string sql = string.Empty;
string columName = "areaid1";
if (areaType == 2)
{
columName = "areaid2";
}
// sql = string.Format("update tb_device_property set {0}=null where device_itemcode in (select ID from dbo.GetAllChildren({1})) or device_itemcode={2} ", columName, itemCodeId, itemCodeId);
foreach (var item in deviceIds)
{
sql += string.Format(" update tb_device_property set {0}={1} where id= {2} ", columName, areaId, item);
}
if (string.IsNullOrEmpty(sql))
{
return 0;
}
var cmd = new DataCommand("updateDeviceProp", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#sql#", sql);
int result = cmd.ExecuteNonQuery();
return result;
}
/// <summary>
/// 获取告警类型
/// </summary>
/// <param name="whereStr"></param>
/// <returns></returns>
public int GetAlarmIndexCount(QueryAlarmNew alarmNew)
{
int intPazeSize = alarmNew.PageSize;
int intNext = intPazeSize * (alarmNew.PageIndex - 1);
DataTable dtAlarmType = new DataTable();
string strSql = @" SELECT count(id) from AlarmAreaDevice where 1=1";
string whereStr = "";
whereStr += " and ALARMTIME between '" + alarmNew.StartTime.ToString("yyyy-MM-dd 00:00:00") + "' and '" + alarmNew.EndTime.ToString("yyyy-MM-dd 23:59:59") + "'";
if (alarmNew.AlarmStatus != "")
{
whereStr += " and STATUS = " + alarmNew.AlarmStatus;
}
if (!whereStr.Equals(string.Empty))
{
strSql = strSql + whereStr;
}
// Object obj = SqlHelper.GetSingle(strSql);
var cmd = new DataCommand("GetBaseDataItem", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#SQLSTR#", strSql);
return int.Parse(cmd.ExecuteScalar().ToString());
}
/// <summary>
/// 阶梯模式保存 （新增、修改）
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public bool SaveRatePrice(string sql)
{
var cmd = new DataCommand("addRatePrice", new SqlCustomDbCommand());
//cmd.SetParameterValue("@sql", sql);
cmd.ReplaceParameterValue("#sql#", sql);
int result = cmd.ExecuteNonQuery();
if (result > 0)
return true;
else
return false;
}
/// <summary>
/// 获取表的基础数据集
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetBaseDataItem(BaseDataModelNew model)
{
DataTable dtold = new DataTable();
try
{
List<string> Tcount = new List<string>();
Tcount = GetTcountNames(model, Tcount);
for (int i = 0; i < Tcount.Count; i++)
{
string basesql = "";
string sql = "";
switch (model.Unit)
{
case "1":
basesql = " select top 1 CountID,Value24 as value,ItemCode from \"{0}\" where CountID='{1}' and CONVERT(varchar(100), CDate, 23)='{2}' and ItemCode='{3}'";
break;
case "2":
basesql = " select top 1 CountID,Value365 as value,ItemCode from \"{0}\" where CountID={1} and ItemCode='{3}'";
sql = string.Format(basesql, new object[] { Tcount[i], model.ObjectId, model.Starttime.ToString("yyyy-MM-dd"), model.ItemCode });
break;
case "3":
basesql = " select top 1 CountID,Value30 as value,ItemCode from \"{0}\" where CountID={1} and ItemCode='{3}'";
break;
default:
basesql = " select top 1 CountID,Value24 as value,ItemCode from \"{0}\" where CountID='{1}' and CONVERT(varchar(100), CDate, 23)='{2}' and ItemCode='{3}'";
break;
}
// sql = string.Format(basesql, new object[] { Tcount[i], model.Starttime, model.Endtime, model.ItemCode });
sql = string.Format(basesql, new object[] { Tcount[i], model.ObjectId, model.Starttime.ToString("yyyy-MM-dd"), model.ItemCode });
var cmd = new DataCommand("GetBaseDataItem", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#SQLSTR#", sql);
//DataTable dts = SqlHelper.Query(sql).Tables[0];
DataTable dts = cmd.ExecuteDataSet().Tables[0];
DataTable dtNew = GetNewDataByDts(model, dts);
dtold = i.Equals(0) ? dtNew.Clone() : dtold;
dtold = UniteDataTable(dtold, dtNew.Copy());
}
return dtold;
}
catch (Exception ex)
{
if (ex.ToString().IndexOf("对象名") > -1)
{
throw new Exception("缺少对应的数据表！");
}
else if (ex.ToString().IndexOf("列名") > -1)
{
throw new Exception("缺少对应的数据列！");
}
else
{
throw new Exception("数据表发生异常！");
}
}
}
public List<Model.TB_UserGroup> GetUserGroupList(string whereStr)
{
var cmd = new DataCommand("GetUserGroupList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteEntityList<Model.TB_UserGroup>();
}
public List<Model.TB_ALLOCTION_CONFIG> GetAlloctionList(string whereStr)
{
var cmd = new DataCommand("getAlloctionList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteEntityList<Model.TB_ALLOCTION_CONFIG>();
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public DataSet GetItemCode(string whereStr)
{
//DataSet dsItemCode = new DataSet();
//string strSql = "select * from \"Becm_ItemCode\" where 1=1";
//if (!whereStr.Equals(string.Empty))
//{
// strSql = strSql + whereStr;
//}
//dsItemCode = SqlHelper.Query(strSql);
//return dsItemCode;
try
{
var cmd = new DataCommand("GetItemCode", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
//cmd.ReplaceParameterValue("#Sort#", order);
return cmd.ExecuteDataSet();
}
catch (Exception ee)
{
throw ee;
}
//return ds.Tables[0];
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public DataTable GetList(string whereStr, string order)
{
// StringBuilder strSql = new StringBuilder();
// strSql.Append(@"select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from (select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from Becm_LayerObject union
// select layerobjectid,layerobjectname,layerobjectpic,layerobjectcontent,layerobjectparentid,bgflag,areatype
// from Becm_FunctionObject)
// aa where 1=1");
// if (!whereStr.Equals(string.Empty))
// {
// strSql.AppendFormat(" and {0}", whereStr);
// }
// strSql.AppendFormat(" order by {0}", order);
// DataTable dt = SqlHelper.Query(strSql.ToString(), parameters).Tables[0];
// return dt;
try
{
var cmd = new DataCommand("GetList", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
//cmd.ReplaceParameterValue("#Sort#", order);
return cmd.ExecuteDataSet().Tables[0];
}
catch (Exception ee)
{
throw ee;
}
}
/// <summary>
/// 获取查询的列表
/// </summary>
/// <param name="whereStr">查询的条件</param>
/// <param name="order">排序的方式</param>
/// <param name="parameters">查询的参数</param>
/// <returns></returns>
public DataTable GetListItemCode(string whereStr, string order)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append("select * from \"Becm_ItemCode\" where 1=1");
//if (!whereStr.Equals(string.Empty))
//{
// strSql.AppendFormat(" and {0}", whereStr);
//}
//strSql.AppendFormat(" order by {0}", order);
//DataTable dt = SqlHelper.Query(strSql.ToString(), parameters).Tables[0];
//return dt;
try
{
var cmd = new DataCommand("GetListItemCode", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteDataSet().Tables[0];
}
catch (Exception ee)
{
throw ee;
}
}
///// <summary>
///// 根据区域和项目代码获取是否含有数据
///// </summary>
///// <param name="itemcode"></param>
///// <param name="areaid"></param>
///// <returns></returns>
//public int GetCountItemCodeAreaId(string itemcode, string areaid)
//{
// string strSql = @"select count(distinct s1.areaid) from Becm_Device s1 "
// + " inner join ( select * from f_GetChildAreaId(" + areaid + " ) ) s2 on s1.areaid = s2.id "
// + " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber where s1.itemcodeid = '" + itemcode + "'";
// return int.Parse(SqlHelper.ExecuteScalar(strSql.ToString()).ToString());
//}
/// <summary>
/// 根据区域和项目代码获取是否含有数据
/// </summary>
/// <param name="itemcode"></param>
/// <param name="areaid"></param>
/// <returns></returns>
public int GetCountItemCodeAreaId(string itemcode, string areaid, int classid)
{
string strSql = "";
if (classid == 1)
{
//strSql = @" select count(distinct s1.areaid) from Becm_Device s1 "
// + "inner join ( select * from f_GetChildAreaId(" + areaid + ") ) s2 on s1.areaid = s2.id "
// + " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber "
// + " inner join ( select * from f_GetChildItemCode('" + itemcode + "') ) s4 on s1.itemcodeid=s4.code";
var cmd = new DataCommand("GetCountItemCodeAreaId1", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#Areaid#", areaid);
cmd.ReplaceParameterValue("#ItemCode#", itemcode);
return int.Parse(cmd.ExecuteScalar().ToString());
}
else
{
var cmd = new DataCommand("GetCountItemCodeAreaId2", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#Areaid#", areaid);
cmd.ReplaceParameterValue("#ItemCode#", itemcode);
return int.Parse(cmd.ExecuteScalar().ToString());
// strSql = @" select count(distinct s1.areaid) from Becm_Device s1 "
//+ "inner join ( select * from f_GetChildFuncAreaId(" + areaid + ") ) s2 on s1.areaid2 = s2.id "
//+ " inner join Becm_ItemCode s3 on s1.itemcodeid = s3.itemcodenumber "
//+ " inner join ( select * from f_GetChildItemCode('" + itemcode + "') ) s4 on s1.itemcodeid=s4.code";
}
//return int.Parse(SqlHelper.ExecuteScalar(strSql.ToString()).ToString());
}
public List<Model.SysLog> GetSysLogList(string whereStr)
{
var cmd = new DataCommand("GetSysLog", new SqlCustomDbCommand());
cmd.ReplaceParameterValue("#whereStr#", whereStr);
return cmd.ExecuteEntityList<Model.SysLog>();
}
/// <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>();
}