public int CheckRecord(int Id) { SqlParameter[] prams = { SqlParameterHelper.MakeInParam("@Id", SqlDbType.Int, 0, Id) }; DataSet ds; Database.RunProc("statdba.DataMySubscribe_check", prams, out ds); DataTable tb = ds.Tables[0]; int recCount = Convert.ToInt32(tb.Rows[0][0]); return(recCount); }
/// <summary> /// 添加统计信息 /// </summary> /// <param name="p"></param> /// <param name="dataMySubscribe"></param> private bool AddDataStat(XBase.Model.Decision.DataStat entity) { SqlParameter[] prams = { SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD), SqlParameterHelper.MakeInParam("@DataID", SqlDbType.Int, 4, entity.DataID), SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 100, entity.DataName), SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 100, entity.DataVarValue), SqlParameterHelper.MakeInParam("@DateNum", SqlDbType.Decimal, 9, entity.DataNum), SqlParameterHelper.MakeInParam("@StatType", SqlDbType.Char, 1, entity.StatType), SqlParameterHelper.MakeInParam("@DateDateim", SqlDbType.DateTime, 8, DateTime.Now) }; bool ret; Database.RunProc("[statdba].[DataStat_Add]", prams, out ret); return(ret); }
/// <summary> /// 根据Id获取部门信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public DataTable GetDeptById(int Id) { SqlParameter[] prams = { SqlParameterHelper.MakeInParam("@Id", SqlDbType.Int, 0, Id) }; DataSet ds = Database.RunSql("select * from officedba.DeptInfo where [id]=@Id", prams); if (ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } }
/// <summary> /// 条件查询 /// </summary> /// <param name="cond">查询条件,多个条件应该以And连接</param> /// <param name="orderExp">展现顺序</param> /// <returns>List</returns> public IList <XBase.Model.Decision.DataKeyPrepare> GetDataKeyPrepareListbyCond(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.DataKeyPrepare entity = null; List <XBase.Model.Decision.DataKeyPrepare> lst = new List <XBase.Model.Decision.DataKeyPrepare>(); SqlDataReader dr; Database.RunProc("[statdba].DataKeyPrepare_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); }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool ModDataMySubscrible(XBase.Model.Decision.DataMySubscribe entity) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 4, entity.ID), SqlParameterHelper.MakeInParam("@DataId", SqlDbType.VarChar, 100, entity.DataID), SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName), SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue), SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions), SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile), SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote), SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency), SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format) }; bool ret; Database.RunProc("statdba.DataMySubscribe_Modify", parameters, out ret); return(ret); }
/// <summary> /// 添加一条记录 /// </summary> /// <param name="val"></param> /// <returns></returns> public bool AddDataMySubscribe(XBase.Model.Decision.DataMySubscribe entity, out int Id) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD), SqlParameterHelper.MakeInParam("@DataID", SqlDbType.VarChar, 100, entity.DataID), SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName), SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue), SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions), SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile), SqlParameterHelper.MakeInParam("@Creator", SqlDbType.VarChar, 20, entity.Creator), SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 8, entity.CreateDate), SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote), SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency), SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format), SqlParameterHelper.MakeOutParam("@ID", SqlDbType.Int, 6) }; bool ret; Database.RunProc("statdba.DataMySubscribe_Create", parameters, out ret); Id = Convert.ToInt32(parameters[11].Value); 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 { } }