/// <summary>
/// 获取月度签到榜
/// </summary>
/// <returns></returns>
public List <SignUserViewModel> GetSignUsersByMonth()
{
DateTime time = DateTime.Now;
DataTable dt = dal.GetSignUsersByMonth(time.AddDays(-time.Day + 1).Date, time);
return(ModelConvertHelper <SignUserViewModel> .ConvertToList(dt));
}
/// <summary>
/// 系统通知公告
/// </summary>
/// <returns></returns>
public ActionResult SystemNotice()
{
try
{
DataTable dt = News.GetNewsList(1, 1, "where newstypeid=3 and convert(varchar(10),addtime,120)=convert(varchar(10),getdate(),120)");
List <MD_NewsInfo> list = (List <MD_NewsInfo>) ModelConvertHelper <MD_NewsInfo> .ConvertToModel(dt);
if (list.Count > 0)
{
JsonSerializerSettings jsetting = new JsonSerializerSettings();
jsetting.DateFormatString = "yyyy-MM-dd HH:mm:ss";
jsetting.ContractResolver = new JsonLimitOutPut(new string[] { "Title", "Time", "Body" }, true);
string data = JsonConvert.SerializeObject(list[0], jsetting).ToLower();
return(APIResult("success", data, true));
}
else
{
return(APIResult("success", "暂无通知公告"));
}
}
catch (Exception ex)
{
return(APIResult("error", "获取失败"));
}
}
/// <summary>
/// 获取评论列表
/// </summary>
/// <param name="mainID"></param>
/// <param name="mainType">评论对象类型(1贴吧 2文章 3活动 4礼物 5招聘 6求职 7产品服务 8数据分析 9课程)</param>
/// <param name="priseType">点赞类型</param>
/// <param name="userID"></param>
/// <param name="page"></param>
/// <returns></returns>
public _Comments GetCommentCallBack(long mainID, int mainType, int priseType, long userID, Paging page, int sbiMainType = 0)
{
_Comments comments = new _Comments()
{
Comments = new List <_Comment>()
};
//获取问题对应评论
DataSet ds = CommentBLL.Instance.GetCommentsByType(mainID, userID, mainType, sbiMainType, priseType, page.StartIndex, page.EndIndex);
int recordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
if (recordCount > 0)
{
page.RecordCount = recordCount;
comments.Comments = ModelConvertHelper <_Comment> .ConvertToList(ds.Tables[1]);
//获取评论的回复
comments.Comments.ForEach(item =>
{
//(非回答作者)如果该回答需要付费并且没有付过费，则先不加载评论的回复
if (item.CommentUserID == userID || item.IsHideOrFeeToSee != 1 || item.IsFeeAnswer)
{
item.ReplyList = ModelConvertHelper <_ReplyComment> .ConvertToList(dal.GetReplyList(item.CommentId, userID, mainType, priseType));
}
});
}
comments.CommentPage = page;
return(comments);
}
public ProductViewModel SelectByCondition(Paging page, string search_cname, string search_pname, string search_price_min, string search_price_max, string search_endTime)
{
StringBuilder sb = new StringBuilder();
if (IsSafe(search_cname))
{
sb.Append(@" and a.CompanyName like '%{0}%' ".FormatWith(search_cname));
}
if (IsSafe(search_pname))
{
sb.Append(" and a.PTitle like '%{0}%' ".FormatWith(search_pname));
}
if (IsSafe(search_price_min) && IsSafe(search_price_max))
{
sb.Append(" and ISNULL(a.PPrice,0) between {0} and {1} ".FormatWith(search_price_min, search_price_max));
}
if (IsSafe(search_endTime))
{
sb.Append(" and a.CreateTime < {0} ".FormatWith(Convert.ToDateTime(search_endTime).AddDays(-30)));
}
var model = new ProductViewModel();
var ds = dal.SelectByCondition(page.StartIndex, page.EndIndex, sb.ToString());
int count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
page.RecordCount = count;
model.ProductList = ModelConvertHelper <_Product> .ConvertToList(ds.Tables[1]);
model.ProductPage = page;
return(model);
}
/// <summary>
/// 获取签到榜用户信息(今日签到用户)
/// </summary>
/// <returns></returns>
public List <SignUserViewModel> GetSignUsersByToday()
{
var time = DateTime.Now;
DataTable dt = dal.GetSignUsers(time.Date, time);
return(ModelConvertHelper <SignUserViewModel> .ConvertToList(dt));
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="mobile"></param>
/// <param name="password"></param>
/// <param name="ipAddress"></param>
/// <returns></returns>
public async Task <D_User> Login(string mobile, string password)
{
string salt = await GetSalt(mobile);
if (string.IsNullOrEmpty(salt))
{
return(null);
}
string pwd = Utils.PasswordHashing(password, salt);
var sql = "select * from [dbo].[EM_User] where Mobile = '" + mobile + "' and Pwd = '" + pwd + "' and IsDelete != 99";
var db = Repository.QueryByTablde(sql);
if (db == null || db.Rows.Count <= 0)
{
return(null);
}
var list = await Task.Run(() =>
ModelConvertHelper <D_User> .ConvertToModel(db)
);
return(list[0]);
}
/// <summary>
/// 获取新用户(30天内注册的)
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List <UserViewModel> GetNewUsers()
{
int days = Convert.ToInt32(ConfigHelper.AppSettings("NewUsersDays"));
DataTable dt = dal.GetNewUsers(days);
return(ModelConvertHelper <UserViewModel> .ConvertToList(dt));
}
/// <summary>
/// 通知公告
/// </summary>
/// <returns></returns>
public ActionResult Notice()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
if (parmas.Count == 0)
{
return(APIResult("error", "请求参数错误"));
}
int page = int.Parse(parmas["page"]);
DataTable dt = News.GetNewsList(10, page, "where newstypeid=2");
List <MD_NewsInfo> list = (List <MD_NewsInfo>) ModelConvertHelper <MD_NewsInfo> .ConvertToModel(dt);
if (list.Count > 0)
{
list.ForEach((x) =>
{
x.Body = BSPConfig.ShopConfig.SiteUrl + "/hometice/" + x.NewsId.ToString();
});
JsonSerializerSettings jsetting = new JsonSerializerSettings();
jsetting.DateFormatString = "yyyy-MM-dd HH:mm:ss";
jsetting.ContractResolver = new JsonLimitOutPut(new string[] { "Title", "Time", "Body" }, true);
string data = JsonConvert.SerializeObject(list, jsetting).ToLower();
return(APIResult("success", data, true));
}
else
{
return(APIResult("success", "暂无通知公告"));
}
}
catch (Exception ex)
{
return(APIResult("error", "获取失败"));
}
}
private void bt_query_Click(object sender, RoutedEventArgs e)
{
SqlHelper sqlHelper = new SqlHelper();
string sql = "";
switch (this.comb_title.SelectedIndex)
{
case 0:
sql = "select distinct FileName, ImportDateTime from MCA_ACE_TYPE2_DATA order by ImportDateTime desc";
break;
case 1:
sql = "select distinct FileName, ImportDateTime from MCA_ACE_TYPE2_DATA where FileName like '%" + this.textbox_content.Text + "%' order by ImportDateTime desc";
break;
case 2:
sql = "select distinct FileName, ImportDateTime from MCA_ACE_TYPE2_DATA where ImportDateTime like '%" + this.textbox_content.Text + "%' order by ImportDateTime desc";
break;
}
sqlHelper.getSomeDate(sql);
if (sqlHelper.dt.DefaultView.Count > 0)
{
obc_qvm = ModelConvertHelper <QueryDataViewModelType2> .ConvertToObc(sqlHelper.dt);
DG1.ItemsSource = obc_qvm;
}
else
{
obc_qvm = new ObservableCollection <QueryDataViewModelType2>();
}
DG1.ItemsSource = obc_qvm;
}
public List <_QuestionInfo> GetAllBBSList(string orderType, Paging page)
{
DataSet ds = dal.GetAllBBSList(orderType, page.StartIndex, page.EndIndex);
page.RecordCount = ds.Tables[0].Rows[0][0].ToString().ToInt32();
return(ModelConvertHelper <_QuestionInfo> .ConvertToList(ds.Tables[1]));
}
public _QuestionInfo GetQuestionDetail(int id, long userid, Paging page)
{
//获取问题 基本信息
DataTable dt = dal.GetQuestionDetail(id, userid);
_QuestionInfo qmodel = ModelConvertHelper <_QuestionInfo> .ConverToModel(dt);
if (qmodel != null)
{
#region MyRegion
//qmodel.Comments = new _Comments();
////获取问题对应评论
//DataSet ds = CommentBLL.Instance.GetCommentsByType(id, userid, 1, page.StartIndex, page.EndIndex);
//int recordCount =Convert.ToInt32(ds.Tables[0].Rows[0][0]);
//if (recordCount>0)
//{
// page.RecordCount = recordCount;
// qmodel.Comments.Comments = ModelConvertHelper<_Comment>.ConvertToList(ds.Tables[1]);
// //获取评论的回复
// qmodel.Comments.Comments.ForEach(item =>
// {
// //(非回答作者)如果该回答需要付费并且没有付过费，则先不加载评论的回复
// if (item.CommentUserID == userid || item.IsHideOrFeeToSee != 1 || item.IsFeeAnswer)
// {
// item.ReplyList = ModelConvertHelper<_ReplyComment>.ConvertToList(dal.GetReplyList(item.CommentId, userid));
// }
// });
//}
//qmodel.Comments.CommentPage = page;
#endregion
qmodel.Comments = CommentBLL.Instance.GetCommentCallBack(id, CommentEnumType.BBS.GetHashCode(), PriseEnumType.BBSComment.GetHashCode(), userid, page, ScoreBeloneMainEnumType.Comment_BBS.GetHashCode());
qmodel.Tags = TagBLL.Instance.GetTagByMainID(CommentEnumType.BBS.GetHashCode(), id);
return(qmodel);
}
return(null);
}
/// <summary>
/// 获取组织机构
/// </summary>
/// <returns></returns>
public List <OrgEntity> GetOrg()
{
string ProjectId = OperatorProvider.Provider.CurrentUser.ProjectId;
string sql1 = @"select case when cp.ParentCompanyCode='1' then '0' else cp.ParentCompanyCode end as pid,cp.CompanyCode as id,cp.CompanyFullName as Name,'Org' as TypeName,cast(cp.OrgType as varchar) as OrgType,pc.ProjectId from TbCompany cp
left join TbProjectCompany pc on cp.CompanyCode=pc.CompanyCode where pc.ProjectId=@ProjectId and cp.OrgType!=1 order by cp.id asc";
DataTable dt1 = Db.Context.FromSql(sql1).AddInParameter("@ProjectId", DbType.String, ProjectId).ToDataTable();
string sql2 = "select CompanyCode as id,CompanyFullName as Name,'Org' as TypeName,OrgType from TbCompany where OrgType=1";
DataTable dt2 = Db.Context.FromSql(sql2).ToDataTable();
if (dt2 != null && dt2.Rows.Count > 0)
{
DataTable dt3 = dt1.Select("pid='0'").CopyToDataTable();
for (int i = 0; i < dt2.Rows.Count; i++)
{
DataRow newRow = dt1.NewRow();
newRow["pid"] = dt3.Rows[0]["id"];
newRow["id"] = dt2.Rows[i]["id"];
newRow["Name"] = dt2.Rows[i]["Name"];
newRow["TypeName"] = dt2.Rows[i]["TypeName"];
newRow["OrgType"] = dt2.Rows[i]["OrgType"];
newRow["ProjectId"] = dt3.Rows[0]["ProjectId"];
dt1.Rows.Add(newRow);
}
}
return(ModelConvertHelper <OrgEntity> .ToList(dt1));
}
/// <summary>
/// 根据当前用户ID获取所有对话记录 的 最新一条
/// </summary>
/// <param name="page"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <_MsgBox> GetMyMessage(Paging page, long userId)
{
DataSet ds = dal.GetMyMessage(page.StartIndex, page.EndIndex, userId);
page.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <_MsgBox> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 根据聊天对象ID获取对话记录
/// </summary>
/// <param name="chatPage"></param>
/// <param name="userID"></param>
/// <param name="toUserID"></param>
/// <returns></returns>
public List <_MsgBox> GetDialogByUserID(Paging chatPage, long userID, long toUserID)
{
DataSet ds = dal.GetDialogByUserID(chatPage.StartIndex, chatPage.EndIndex, userID, toUserID);
chatPage.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <_MsgBox> .ConvertToList(ds.Tables[1]));
}
/// <summary>
/// 更新全部书籍
/// </summary>
public static void BooksUpdate(object ob)
{
//获取全部书籍
DataTable dt = SQLiteDBHelper.ExecuteDataTable("select *from Books", null);
List <Book> Books = ModelConvertHelper <Book> .DataTableToList(dt);
foreach (Book book in Books)
{
//获取初始搜索文本
string html = GetHtml.GetHttpWebRequest(book.Url);
BookSource bs = GetBookSource(book.Source);
//检测书源有效性
if (bs.Title is null)
{
Tips tips = new Tips(book.Name + "的书源不存在，请检查书源是否已经被删除掉？");
tips.Show();
return;
}
//获取最新章节
string LatestChapters = Tool.GetRegexStr(html, bs.NewestRegular).Trim();
//获取更新时间
string Update = Tool.GetRegexStr(html, bs.UpdateRegular).Trim();
SQLiteDBHelper.ExecuteNonQuery("Update Books set 'Newest' = '" + LatestChapters + "', 'Update' = '" + Tool.GetUpdataDate(Update) + "' where Id =" + book.Id, null);
}
((MainWindow)ob).Dispatcher.Invoke(new Action(() =>
{
((MainWindow)ob).DataContext = DataFetch.GetBooks();
}));
}
/// <summary>
/// 获取红人用户(红人榜按照积分等级进行排名选前20)
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List <UserViewModel> GetHotUsers()
{
int count = Convert.ToInt32(ConfigHelper.AppSettings("HotUsersCount"));
DataTable dt = dal.GetHotUsers(count);
return(ModelConvertHelper <UserViewModel> .ConvertToList(dt));
}
/// <summary>
/// 分享链接对应奖励
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <ShareCoinAndCount> GetShareCoinList(long userID, ref int count)
{
DataSet ds = dal.GetShareCoinList(userID);
count = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(ModelConvertHelper <ShareCoinAndCount> .ConvertToList(ds.Tables[1]));
}
void btnToSelected_Click(object sender, EventArgs e)
{
int[] selectedRows = this.gridView1.GetSelectedRows();
if (selectedRows.Length < 1)
{
DXMessageBox.ShowInfo("查询结果为空", this);
}
else
{
if (SingleMode && SelectedUsers.Count > 0)
{
DXMessageBox.ShowInfo("单选模式只能选择一个用户", this);
return;
}
var selectedHandle = selectedRows[0];
DataRowView rowv = this.gridView1.GetRow(selectedHandle) as DataRowView;
if (rowv == null)
{
return;
}
DataRow row = rowv.Row;
var user = ModelConvertHelper <Userinfo> .ConvertToOneModel(row);
AddUserToSelected(user);
}
}
/// <summary>
/// 获取网站所有客服
/// </summary>
/// <returns></returns>
public CustomerVM GetCustomers()
{
var list = new CustomerVM();
var cache = CSharpCacheHelper.Get(APPConst.Customoer);
if (cache == null)
{
var type1 = CustomerEnumType.QQ.GetHashCode();
var type2 = CustomerEnumType.WeChar.GetHashCode();
var type3 = CustomerEnumType.WeChar_GZH.GetHashCode();
var dt = dal.GetCustomers();
var request = ModelConvertHelper <Customer> .ConvertToList(dt).OrderByDescending(a => a.CreateTime).ToList();
list.QQs = request.Where(a => a.Type == type1).ToList();
list.WXs = request.Where(a => a.Type == type2).ToList();
list.GZHs = request.Where(a => a.Type == type3).ToList();
CSharpCacheHelper.Set(APPConst.Customoer, list, APPConst.ExpriseTime.Week1);
return(list);
}
else
{
return((CustomerVM)cache);
}
}
public IList <File> GetFilePersonlTree(int pid, int uid)
{
string condition = string.Format("FilePID={0} and UserId={2} and FileExt {1}", pid, "is null", uid);
string sql = string.Format("select a.FileID,a.FileName,a.FileExt,a.FileSize,a.FileCreateTime from [File] a where {0}", condition);
DataTable dt = db.ExecuteDataTable(sql, null);
return(ModelConvertHelper <File> .ConvertToModel(dt));
}
/// <summary>
/// 获取全部书源
/// </summary>
/// <returns>返回全部书源</returns>
public static List <BookSource> GetBookSources()
{
//获取DataTable
DataTable dt = SQLiteDBHelper.ExecuteDataTable("select *from BookSource where State=1", null);
//获取所有书源
return(ModelConvertHelper <BookSource> .DataTableToList(dt));
}
public List <TbAreaAdministration> GetParentAreaJosn(string AreaCode)
{
string sql = @"select * from TbAreaAdministration where FK_AreaCode is null or FK_AreaCode='" + AreaCode + "'";
var model = Db.Context.FromSql(sql).ToDataTable();
var modelList = ModelConvertHelper <TbAreaAdministration> .ToList(model);
return(modelList);
}
public List <_Activity> GetCheckList()
{
DataTable ds = dal.GetCheckList();
List <_Activity> list = new List <_Activity>();
list.AddRange(ModelConvertHelper <_Activity> .ConvertToList(ds).OrderByDescending(a => Convert.ToDateTime(a.ActivityCreateTIme).ToString("yyyy-MM-dd")).ThenByDescending(a => a.PVCount).ToList());
return(list);
}
/// <summary>
/// 执行网站同步
/// </summary>
private void DataUpload()
{
int strart = 0, end = 200, total = 0, amount = 0;
total = GetPostHttpCount();
progressBar1.Maximum = total;
labCountnum.Text = total.ToString();
BackgroundWorker dgWorker = new BackgroundWorker();
dgWorker.DoWork += (senderdg, edg) =>
{
while (total > 0)
{
List <DataModel> model = GetPostHttp(strart, end);
DataTable dtInfo = new DataTable();
if (model != null && model.Count > 0)
{
dtInfo = ModelConvertHelper <DataModel> .ToDataTable(model);
}
amount += DataUpload(dtInfo);
strart = end;
end += 200;
total -= 200;
dgWorker.ReportProgress(amount);
}
};
dgWorker.ProgressChanged += (senderdg, edg) =>
{
progressBar1.Value = edg.ProgressPercentage;
};
dgWorker.RunWorkerCompleted += (senderdg, edg) =>
{
MessageBox.Show(String.Format("成功匹配：{0}条数据！", amount), "提示");
progressBar1.Visible = false;
btnDataUpload.Enabled = true;
this.labUploadnum.Text = amount.ToString();
if (this.cud.dtData.Rows.Count > 0)
{
UploadData ud = new UploadData {
dtData = cud.dtData
};
ud.ShowDialog();
}
};
dgWorker.WorkerReportsProgress = true;
dgWorker.RunWorkerAsync();
}
public IHttpActionResult QueryWalletInfo(WalletInfoModelGet modelGet)
{
DataTable dt = _walletInfoDal.QueryWalletInfo(modelGet.UserId);
IList <WalletInfoModelResult> currencyInfoModelResults = ModelConvertHelper <WalletInfoModelResult> .ConvertToModel(dt);
return(Json(new ResultDataModel <IList <WalletInfoModelResult> > {
Data = currencyInfoModelResults
}));
}
public List <_Article> GetAllArticles(Paging aRticlePage, string keyWord = null, long tagid = 0)
{
DataSet ds = dal.GetAllArticles(aRticlePage.StartIndex, aRticlePage.EndIndex, keyWord, tagid);
List <_Article> list = ModelConvertHelper <_Article> .ConvertToList(ds.Tables[1]);
aRticlePage.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(list);
}
/// <summary>
/// 查询粉丝信息
/// </summary>
/// <param name="fansModelGet"></param>
/// <returns></returns>
public IHttpActionResult QueryFans(FansModelGet fansModelGet)
{
DataTable dtFans = _fansDal.QueryFans(fansModelGet.Id);
IList <FansModelResult> fansModelGets = ModelConvertHelper <FansModelResult> .ConvertToModel(dtFans);
return(Json(new ResultDataModel <IList <FansModelResult> > {
Data = fansModelGets
}));
}
public IHttpActionResult QueryVersion(VersionModelGet modelGet)
{
DataTable dt = _appVersionDal.QueryAppVersion(modelGet.AppType);
IList <VersionModelResult> versionModelResults = ModelConvertHelper <VersionModelResult> .ConvertToModel(dt);
return(Json(new ResultDataModel <VersionModelResult> {
Data = versionModelResults.FirstOrDefault()
}));
}
// GET api/<controller>/5
public IHttpActionResult QueryEmployeeInfo()
{
DataTable dtEmployeeInfo = _employeeInfoDal.QueryEmployeeInfo();
IList <EmployeeInfoModelResult> adminInfoModelResults = ModelConvertHelper <EmployeeInfoModelResult> .ConvertToModel(dtEmployeeInfo);
return(Json(new ResultDataModel <IList <EmployeeInfoModelResult> > {
Data = adminInfoModelResults
}));
}
/// <summary>
/// 获取老用户（180天以上的）
/// </summary>
/// <returns></returns>
public List <UserViewModel> GetOldUsers()
{
int days = Convert.ToInt32(ConfigHelper.AppSettings("NewUsersDays"));
int count = Convert.ToInt32(ConfigHelper.AppSettings("HotUsersCount"));
DataTable dt = dal.GetOldUsers(days, count);
var model = ModelConvertHelper <UserViewModel> .ConvertToList(dt);
return(model.OrderByDescending(a => { return a.SignCount + a.CommentCount; }).ToList());
}
