/// <summary> /// 更新 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool ModDataMyCollector(XBase.Model.Decision.DataMyCollector entity) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 4, entity.ID), SqlParameterHelper.MakeInParam("@Flag", SqlDbType.Char, 1, entity.Flag), SqlParameterHelper.MakeInParam("@ReadStatus", SqlDbType.Char, 1, entity.ReadStatus), SqlParameterHelper.MakeInParam("@ReadDate", SqlDbType.DateTime, 8, entity.ReadDate) }; bool ret; Database.RunProc("[statdba].DataMyCollector_Mod", parameters, out ret); return(ret); }
/// <summary> /// 添加一个实体类 /// </summary> /// <param name="dr"></param> /// <returns></returns> private XBase.Model.Decision.DataMyCollector GetList(SqlDataReader dr) { XBase.Model.Decision.DataMyCollector entity = new XBase.Model.Decision.DataMyCollector(); entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0); entity.KeyWordID = SqlClientUtility.GetInt32(dr, "KeyWordID", 0); entity.ActionID = SqlClientUtility.GetInt32(dr, "ActionID", 0); entity.ActionDetailID = SqlClientUtility.GetInt32(dr, "ActionDetailID", 0); entity.Frequency = SqlClientUtility.GetInt32(dr, "Frequency", 0); entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty); entity.Flag = SqlClientUtility.GetString(dr, "Flag", String.Empty); entity.Owner = SqlClientUtility.GetString(dr, "Owner", String.Empty); entity.ReportDate = SqlClientUtility.GetDateTime(dr, "ReportDate", DateTime.Now); entity.ReadStatus = SqlClientUtility.GetString(dr, "ReadStatus", String.Empty); entity.ReadDate = SqlClientUtility.GetDateTime(dr, "ReadDate", DateTime.Now); entity.ReportTxt = SqlClientUtility.GetString(dr, "ReportTxt", String.Empty); return entity; }
/// <summary> /// 添加一个实体类 /// </summary> /// <param name="dr"></param> /// <returns></returns> private XBase.Model.Decision.DataMyCollector GetList(SqlDataReader dr) { XBase.Model.Decision.DataMyCollector entity = new XBase.Model.Decision.DataMyCollector(); entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0); entity.KeyWordID = SqlClientUtility.GetInt32(dr, "KeyWordID", 0); entity.ActionID = SqlClientUtility.GetInt32(dr, "ActionID", 0); entity.ActionDetailID = SqlClientUtility.GetInt32(dr, "ActionDetailID", 0); entity.Frequency = SqlClientUtility.GetInt32(dr, "Frequency", 0); entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty); entity.Flag = SqlClientUtility.GetString(dr, "Flag", String.Empty); entity.Owner = SqlClientUtility.GetString(dr, "Owner", String.Empty); entity.ReportDate = SqlClientUtility.GetDateTime(dr, "ReportDate", DateTime.Now); entity.ReadStatus = SqlClientUtility.GetString(dr, "ReadStatus", String.Empty); entity.ReadDate = SqlClientUtility.GetDateTime(dr, "ReadDate", DateTime.Now); entity.ReportTxt = SqlClientUtility.GetString(dr, "ReportTxt", String.Empty); return(entity); }
/// <summary> /// 条件查询 /// </summary> /// <param name="cond">查询条件,多个条件应该以And连接</param> /// <param name="orderExp">展现顺序</param> /// <returns>List</returns> public IList <XBase.Model.Decision.DataMyCollector> GetDataMyCollectorListbyCond(string cond, string orderExp) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@Where", SqlDbType.VarChar, 100, cond), SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.VarChar, 50, orderExp) }; XBase.Model.Decision.DataMyCollector entity = null; List <XBase.Model.Decision.DataMyCollector> lst = new List <XBase.Model.Decision.DataMyCollector>(); SqlDataReader dr; Database.RunProc("statdba.DataMyCollector_SelectbyCond", parameters, out dr); while (dr.Read()) { entity = GetList(dr); lst.Add(entity); } return(lst); }
/// <summary> /// 添加一条记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool AddDataMyCollector(XBase.Model.Decision.DataMyCollector entity) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@KeyWordID", SqlDbType.Int, 4, entity.KeyWordID), SqlParameterHelper.MakeInParam("@ActionID", SqlDbType.Int, 4, entity.ActionID), SqlParameterHelper.MakeInParam("@ActionDetailID", SqlDbType.Int, 4, entity.ActionDetailID), SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.Int, 4, entity.Frequency), SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD), SqlParameterHelper.MakeInParam("@Flag", SqlDbType.Char, 1, entity.Flag), SqlParameterHelper.MakeInParam("@ReportDate", SqlDbType.DateTime, 8, entity.ReportDate), SqlParameterHelper.MakeInParam("@Owner", SqlDbType.VarChar, 20, entity.Owner), SqlParameterHelper.MakeInParam("@ReportTxt", SqlDbType.NVarChar, 200, entity.ReportTxt), SqlParameterHelper.MakeInParam("@ReadStatus", SqlDbType.Char, 1, entity.ReadStatus) }; bool ret; Database.RunProc("[statdba].DataMyCollector_Add", parameters, out ret); return(ret); }
public void DataStatSend(DateTime lastEndDate, string Frequency) { try { string strPro = String.Empty; string strSqlwhere = String.Empty; DataSet ds = null; XBase.Data.Decision.DataMySubscribe _dal = new DataMySubscribe(); _list = _dal.GetDataMySubscribleListbyCond("Frequency='" + Frequency + "'", "ID"); for (int i = 0; i < _list.Count; i++) { if (_list[i].DataVarValue != "" && _list[i].DataVarValue != null) { strSqlwhere = _list[i].DataVarValue; } if (strSqlwhere != "") { SqlParameter[] prams = { SqlParameterHelper.MakeInParam("@LastEndDate", SqlDbType.DateTime, 20, Convert.ToDateTime(lastEndDate)) }; try{ ds = Database.RunSql(strSqlwhere, prams); if (ds != null) { if (ds.Tables[0].Rows[0][0] != null) { if (ds.Tables[0].Rows[0][0].ToString() != "") { string[] MobileArr = _list[i].MyMobile.Split(','); string DataName1 = _list[i].DataName; string SetResult = Regex.Replace(DataName1, @"<(.[^>]*)>", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase).Replace(" ", ""); SetResult += _list[i].Format.ToString().Replace("[#统计数据#]", ds.Tables[0].Rows[0][0].ToString()); for (int n = 0; n < MobileArr.Length; n++) { XBase.Common.SMSender.InternalSend(MobileArr[n], SetResult + "(统计时间:" + lastEndDate + "---" + DateTime.Now.ToString() + ")"); } XBase.Model.Decision.DataMyCollector collmodel = new XBase.Model.Decision.DataMyCollector(); string[] IdArr = _list[i].DataID.Split('|'); collmodel.CompanyCD = _list[i].CompanyCD; collmodel.KeyWordID = Convert.ToInt32(IdArr[0]); collmodel.ActionID = Convert.ToInt32(IdArr[1]); collmodel.Frequency = int.Parse(Frequency); collmodel.ActionDetailID = Convert.ToInt32(IdArr[2]); collmodel.Flag = "1"; collmodel.ReportDate = DateTime.Now; collmodel.ReadStatus = "0"; collmodel.Owner = ""; collmodel.ReportTxt = SetResult; XBase.Data.Decision.DataMyCollector colldata = new XBase.Data.Decision.DataMyCollector(); colldata.AddDataMyCollector(collmodel); } } } } catch { } } } } catch { } }
public void DataStatSend(DateTime lastEndDate,string Frequency) { try { string strPro = String.Empty; string strSqlwhere = String.Empty; DataSet ds = null; XBase.Data.Decision.DataMySubscribe _dal = new DataMySubscribe(); _list = _dal.GetDataMySubscribleListbyCond("Frequency='" + Frequency + "'", "ID"); for (int i = 0; i < _list.Count; i++) { if (_list[i].DataVarValue != "" && _list[i].DataVarValue != null) strSqlwhere = _list[i].DataVarValue; if (strSqlwhere != "") { SqlParameter[] prams = { SqlParameterHelper.MakeInParam("@LastEndDate",SqlDbType.DateTime,20,Convert.ToDateTime(lastEndDate)) }; try{ ds= Database.RunSql(strSqlwhere,prams); if (ds!=null) { if (ds.Tables[0].Rows[0][0] != null) { if (ds.Tables[0].Rows[0][0].ToString()!="") { string[] MobileArr = _list[i].MyMobile.Split(','); string DataName1 = _list[i].DataName; string SetResult = Regex.Replace(DataName1, @"<(.[^>]*)>", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase).Replace(" ",""); SetResult+= _list[i].Format.ToString().Replace("[#统计数据#]", ds.Tables[0].Rows[0][0].ToString()); for (int n = 0; n < MobileArr.Length; n++) { XBase.Common.SMSender.InternalSend(MobileArr[n], SetResult + "(统计时间:" + lastEndDate+"---"+DateTime.Now.ToString()+")"); } XBase.Model.Decision.DataMyCollector collmodel = new XBase.Model.Decision.DataMyCollector(); string[] IdArr = _list[i].DataID.Split('|'); collmodel.CompanyCD = _list[i].CompanyCD; collmodel.KeyWordID = Convert.ToInt32(IdArr[0]); collmodel.ActionID = Convert.ToInt32(IdArr[1]); collmodel.Frequency = int.Parse(Frequency); collmodel.ActionDetailID = Convert.ToInt32(IdArr[2]); collmodel.Flag = "1"; collmodel.ReportDate = DateTime.Now; collmodel.ReadStatus = "0"; collmodel.Owner = ""; collmodel.ReportTxt = SetResult; XBase.Data.Decision.DataMyCollector colldata = new XBase.Data.Decision.DataMyCollector(); colldata.AddDataMyCollector(collmodel); } } } } catch { } } } } catch { } }
public bool ModDataMyCollector(XBase.Model.Decision.DataMyCollector entity) { return(_dal.ModDataMyCollector(entity)); }