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
{
}
}
