/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Integer), * new SqlParameter("@PageIndex", SqlDbType.Integer), * new SqlParameter("@IsReCount", SqlDbType.Int), * new SqlParameter("@OrderType", SqlDbType.Int), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "EmailInfo"; * parameters[1].Value = "EmailID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 得到一个最早的待发送的邮件 /// </summary> public Panther.Email.Entity.Model.EmailInfo GetNextEmailModel() { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select EmailID,EmailTitle,EmailCreateTime,EmailLastTime,EmailFilePath,EmailIsDel,EmailState,EmailStartSendTime from EmailInfo where EmailState = 0 and EmailStartSendTime < getdate() and EmailIsDel = 0 and EmailID in (select EmailSendAccount.EmailID from EmailSendAccount where EmailSendAccount.EmailAccountID in (select EmailAccountID from EmailAccount where EmailAccount.EmailAccountRemainEmailCount>0 and EmailAccount.EmailAccountLastTime<getdate() and EmailAccount.SendState = 0 ) ) order by EmailStartSendTime "); Panther.Email.Entity.Model.EmailInfo model = new Panther.Email.Entity.Model.EmailInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Panther.Email.Entity.Model.EmailInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update EmailInfo set "); strSql.Append("EmailTitle=@EmailTitle,"); strSql.Append("EmailCreateTime=@EmailCreateTime,"); strSql.Append("EmailLastTime=@EmailLastTime,"); strSql.Append("EmailFilePath=@EmailFilePath,"); strSql.Append("EmailIsDel=@EmailIsDel,"); strSql.Append("EmailState=@EmailState,"); strSql.Append("EmailStartSendTime=@EmailStartSendTime"); strSql.Append(" where EmailID=@EmailID "); SqlParameter[] parameters = { new SqlParameter("@EmailTitle", SqlDbType.VarChar, 0), new SqlParameter("@EmailCreateTime", SqlDbType.DateTime), new SqlParameter("@EmailLastTime", SqlDbType.DateTime), new SqlParameter("@EmailFilePath", SqlDbType.VarChar, 0), new SqlParameter("@EmailIsDel", SqlDbType.Int, 1), new SqlParameter("@EmailState", SqlDbType.Int), new SqlParameter("@EmailStartSendTime", SqlDbType.DateTime), new SqlParameter("@EmailID", SqlDbType.VarChar, 40) }; parameters[0].Value = model.EmailTitle; parameters[1].Value = model.EmailCreateTime; parameters[2].Value = model.EmailLastTime; parameters[3].Value = model.EmailFilePath; parameters[4].Value = model.EmailIsDel; parameters[5].Value = model.EmailState; parameters[6].Value = model.EmailStartSendTime; parameters[7].Value = model.EmailID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Panther.Email.Entity.Model.EmailInfo DataRowToModel(DataRow row) { Panther.Email.Entity.Model.EmailInfo model = new Panther.Email.Entity.Model.EmailInfo(); if (row != null) { if (row["EmailID"] != null) { model.EmailID = row["EmailID"].ToString(); } if (row["EmailTitle"] != null) { model.EmailTitle = row["EmailTitle"].ToString(); } if (row["EmailCreateTime"] != null && row["EmailCreateTime"].ToString() != "") { model.EmailCreateTime = DateTime.Parse(row["EmailCreateTime"].ToString()); } if (row["EmailLastTime"] != null && row["EmailLastTime"].ToString() != "") { model.EmailLastTime = DateTime.Parse(row["EmailLastTime"].ToString()); } if (row["EmailFilePath"] != null) { model.EmailFilePath = row["EmailFilePath"].ToString(); } if (row["EmailIsDel"] != null && row["EmailIsDel"].ToString() != "") { if ((row["EmailIsDel"].ToString() == "1") || (row["EmailIsDel"].ToString().ToLower() == "true")) { model.EmailIsDel = true; } else { model.EmailIsDel = false; } } //model.EmailState=row["EmailState"].ToString(); if (row["EmailStartSendTime"] != null && row["EmailStartSendTime"].ToString() != "") { model.EmailStartSendTime = DateTime.Parse(row["EmailStartSendTime"].ToString()); } } return(model); }
/// <summary> /// 得到待发送的邮件列表 /// </summary> public List <EmailInfo> GetSendEmailListModel() { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select EmailID,EmailTitle,EmailCreateTime,EmailLastTime,EmailFilePath,EmailIsDel,EmailState,EmailStartSendTime from EmailInfo where EmailState = 0 and EmailStartSendTime < getdate() and EmailIsDel = 0 and EmailID in (select EmailSendAccount.EmailID from EmailSendAccount where EmailSendAccount.EmailAccountID in (select EmailAccountID from EmailAccount where EmailAccount.EmailAccountRemainEmailCount>0 and EmailAccount.EmailAccountLastTime<getdate() and EmailAccount.SendState = 0 ) ) order by EmailStartSendTime "); Panther.Email.Entity.Model.EmailInfo model = new Panther.Email.Entity.Model.EmailInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) { return(null); } List <EmailInfo> emailList = new List <EmailInfo>(); foreach (DataRow dr in ds.Tables[0].Rows) { emailList.Add(DataRowToModel(dr)); } return(emailList); }
/// <summary> /// 得到一个对象实体 /// </summary> public Panther.Email.Entity.Model.EmailInfo GetModel(string EmailID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select EmailID,EmailTitle,EmailCreateTime,EmailLastTime,EmailFilePath,EmailIsDel,EmailState,EmailStartSendTime from EmailInfo "); strSql.Append(" where EmailID=@EmailID "); SqlParameter[] parameters = { new SqlParameter("@EmailID", SqlDbType.VarChar, 40) }; parameters[0].Value = EmailID; Panther.Email.Entity.Model.EmailInfo model = new Panther.Email.Entity.Model.EmailInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Panther.Email.Entity.Model.EmailInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Panther.Email.Entity.Model.EmailInfo model) { return(dal.Add(model)); }