Esempio n. 1
0
        private void sign_article_click(HttpContext context)
        {
            var username = DTRequest.GetString("username");
            var password = DTRequest.GetString("password");

            BLL.xiehui   bll   = new BLL.xiehui();
            Model.xiehui model = bll.GetModel(username, password, true);
            if (model == null)
            {
                context.Response.Write("{\"status\": 2, \"msg\": \"用户名或密码有误,请重试!\"}");
                return;
            }

            BLL.article bllArticle   = new BLL.article();
            var         id           = DTRequest.GetInt("id", 0);
            var         articleModel = bllArticle.GetModel(id);

            articleModel.status          = 2;
            articleModel.sign_user_name += username + "|" + DateTime.Now.ToString() + ",";
            //判断当前用户是否已签收过
            var isUserSign = bllArticle.GetList(1, " id=" + id + " and sign_user_name like '%" + username + "|%'", "add_time desc").Tables[0].Rows.Count;

            if (isUserSign > 0)
            {
                context.Response.Write("{\"status\": 0, \"msg\": \"对不起,该用户已经签收!\"}");
                return;
            }
            if (bllArticle.Update(articleModel))
            {
                context.Response.Write("{\"status\": 1, \"msg\": \"恭喜您,签收成功!\"}");
                return;
            }
            context.Response.Write("{\"status\": 0, \"msg\": \"对不起,签收过程中发生错误!\"}");
        }
Esempio n. 2
0
        private void TreeBind()
        {
            BLL.xiehui bll = new BLL.xiehui();
            DataTable  dt  = bll.GetList(0);

            this.ddlParentId.Items.Clear();
            this.ddlParentId.Items.Add(new ListItem("无父级", "0"));
            foreach (DataRow dr in dt.Rows)
            {
                string Id         = dr["id"].ToString();
                int    ClassLayer = int.Parse(dr["class_layer"].ToString());
                string Title      = dr["name"].ToString().Trim();

                if (ClassLayer == 1)
                {
                    this.ddlParentId.Items.Add(new ListItem(Title, Id));
                }
                else
                {
                    Title = "├ " + Title;
                    Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
                    this.ddlParentId.Items.Add(new ListItem(Title, Id));
                }
            }
        }
Esempio n. 3
0
        //保存
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            BLL.xiehui   bll   = new BLL.xiehui();
            Model.xiehui model = GetAdminInfo();

            if (DESEncrypt.Encrypt(txtOldPassword.Text.Trim(), model.salt) != model.password)
            {
                JscriptMsg("旧密码不正确!", "");
                return;
            }
            if (txtPassword.Text.Trim() != txtPassword1.Text.Trim())
            {
                JscriptMsg("两次密码不一致!", "");
                return;
            }
            model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt);
            model.no       = txtRealName.Text.Trim();
            model.tel      = txtTelephone.Text.Trim();

            if (!bll.Update(model))
            {
                JscriptMsg("保存过程中发生错误!", "");
                return;
            }
            Session[DTKeys.SESSION_ADMIN_INFO] = null;
            JscriptMsg("密码修改成功!", "manager_pwd.aspx");
        }
Esempio n. 4
0
        private void TreeBind()
        {
            BLL.xiehui bll = new BLL.xiehui();
            DataTable  dt  = bll.GetList("").Tables[0];

            for (int i = 0; i < 10; i++)
            {
                DropDownList ddlXiehui = FindControl("ddlXiehui" + i) as DropDownList;
                ddlXiehui.Items.Clear();
                ddlXiehui.Items.Add(new ListItem("请选择协会", "0"));
                foreach (DataRow dr in dt.Rows)
                {
                    string Id    = dr["id"].ToString();
                    string Title = dr["name"].ToString().Trim();
                    ddlXiehui.Items.Add(new ListItem(Title, Id));
                }

                BLL.subject subjectBll = new BLL.subject();
                DataTable   dtSubject  = subjectBll.GetParentList(0);

                DropDownList ddlBSubject = FindControl("ddlBSubject" + i) as DropDownList;
                ddlBSubject.Items.Clear();
                ddlBSubject.Items.Add(new ListItem("请选择科目大类", "0"));
                foreach (DataRow dr in dtSubject.Rows)
                {
                    string Id    = dr["id"].ToString();
                    string Title = dr["name"].ToString().Trim();
                    ddlBSubject.Items.Add(new ListItem(Title, Id));
                }
            }
        }
Esempio n. 5
0
        //批量删除
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            ChkAdminLevel("xiehui_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限
            int sucCount   = 0;
            int errorCount = 0;

            BLL.xiehui bll = new BLL.xiehui();
            for (int i = 0; i < rptList.Items.Count; i++)
            {
                int      id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
                CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
                if (cb.Checked)
                {
                    if (bll.Delete(id))
                    {
                        sucCount += 1;
                    }
                    else
                    {
                        errorCount += 1;
                    }
                }
            }
            AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除管理员" + sucCount + "条,失败" + errorCount + "条"); //记录日志
            JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("xiehui_list.aspx", "keywords={0}", this.keywords));
        }
Esempio n. 6
0
 private void ShowInfo(int _id)
 {
     BLL.xiehui   bll   = new BLL.xiehui();
     Model.xiehui model = bll.GetModel(_id);
     ddlParentId.SelectedValue = model.parent_id.ToString();
     ddlRoleId.SelectedValue   = model.role_id.ToString();
     txtUserName.Text          = model.no;
     txtUserName.ReadOnly      = true;
     txtUserName.Attributes.Remove("ajaxurl");
     if (!string.IsNullOrEmpty(model.password))
     {
         txtPassword.Attributes["value"] = txtPassword1.Attributes["value"] = defaultpassword;
     }
     txtRealName.Text      = model.name;
     ddlTown.SelectedValue = model.town;
     town_Change_Click("", new EventArgs());
     ddlVillage.SelectedValue = model.village;
     txtPerson.Text           = model.person;
     txtTel.Text     = model.tel;
     txtAddress.Text = model.address;
     if (model.is_lock == 0)
     {
         cbIsLock.Checked = true;
     }
     else
     {
         cbIsLock.Checked = false;
     }
 }
Esempio n. 7
0
        private void TreeBind()
        {
            BLL.xiehui bll = new BLL.xiehui();
            DataTable  dt  = bll.GetList("").Tables[0];

            this.ddlXiehui.Items.Clear();
            this.ddlXiehui.Items.Add(new ListItem("请选择协会", "0"));
            foreach (DataRow dr in dt.Rows)
            {
                string Id    = dr["id"].ToString();
                string Title = dr["name"].ToString().Trim();
                this.ddlXiehui.Items.Add(new ListItem(Title, Id));
            }

            BLL.subject bllSubject = new BLL.subject();
            DataTable   dtSubject  = bllSubject.GetParentList(0);

            ddlBSubject.Items.Clear();
            ddlBSubject.Items.Add(new ListItem("请选择科目大类", "0"));
            foreach (DataRow dr in dtSubject.Rows)
            {
                string Id    = dr["id"].ToString();
                string Title = dr["name"].ToString().Trim();
                ddlBSubject.Items.Add(new ListItem(Title, Id));
            }
        }
Esempio n. 8
0
 /// <summary>
 /// 判断管理员是否已经登录(解决Session超时问题)
 /// </summary>
 public bool IsAdminLogin()
 {
     //如果Session为Null
     if (Session[DTKeys.SESSION_ADMIN_INFO] != null)
     {
         return(true);
     }
     else
     {
         //检查Cookies
         string adminname = Utils.GetCookie("AdminName", "DTcms");
         string adminpwd  = Utils.GetCookie("AdminPwd", "DTcms");
         if (adminname != "" && adminpwd != "")
         {
             BLL.xiehui   bll   = new BLL.xiehui();
             Model.xiehui model = bll.GetModel(adminname, adminpwd);
             if (model != null)
             {
                 Session[DTKeys.SESSION_ADMIN_INFO] = model;
                 return(true);
             }
         }
     }
     return(false);
 }
Esempio n. 9
0
 private void ShowInfo(int _id)
 {
     BLL.xiehui   bll   = new BLL.xiehui();
     Model.xiehui model = bll.GetModel(_id);
     txtUserName.Text  = model.no;
     txtRealName.Text  = model.name;
     txtTelephone.Text = model.tel;
 }
Esempio n. 10
0
        private void RptBind(string _strWhere, string _orderby)
        {
            BLL.xiehui bll = new BLL.xiehui();
            DataTable  dt  = bll.GetList(0);

            this.rptList.DataSource = dt;
            this.rptList.DataBind();
        }
Esempio n. 11
0
        private void LevelBind()
        {
            BLL.xiehui bll = new BLL.xiehui();
            DataTable  dt  = bll.GetList(" name<>'' and name<>'管理员'").Tables[0];

            ddlXieHui.Items.Clear();
            ddlXieHui.Items.Add(new ListItem("请选择所属协会", "0"));
            foreach (DataRow dr in dt.Rows)
            {
                string Id    = dr["id"].ToString();
                string Title = dr["name"].ToString().Trim();
                ddlXieHui.Items.Add(new ListItem(Title, Id));
            }
        }
Esempio n. 12
0
 //保存排序
 protected void btnSave_Click(object sender, EventArgs e)
 {
     BLL.xiehui bll = new BLL.xiehui();
     for (int i = 0; i < rptList.Items.Count; i++)
     {
         int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
         int sortId;
         if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
         {
             sortId = 99;
         }
         bll.UpdateField(id, "sort_id=" + sortId.ToString());
     }
     AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存导航排序"); //记录日志
     JscriptMsg("保存排序成功!", "xiehui_list.aspx");
 }
Esempio n. 13
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string userName = txtUserName.Text.Trim();
            string userPwd  = txtPassword.Text.Trim();

            if (userName.Equals("") || userPwd.Equals(""))
            {
                msgtip.InnerHtml = "请输入用户名或密码";
                return;
            }
            if (Session["AdminLoginSun"] == null)
            {
                Session["AdminLoginSun"] = 1;
            }
            else
            {
                Session["AdminLoginSun"] = Convert.ToInt32(Session["AdminLoginSun"]) + 1;
            }
            //判断登录错误次数
            if (Session["AdminLoginSun"] != null && Convert.ToInt32(Session["AdminLoginSun"]) > 5)
            {
                msgtip.InnerHtml = "错误超过5次,关闭浏览器重新登录!";
                return;
            }
            BLL.xiehui   bll   = new BLL.xiehui();
            Model.xiehui model = bll.GetModel(userName, userPwd, true);
            if (model == null)
            {
                msgtip.InnerHtml = "用户名或密码有误,请重试!";
                return;
            }
            Session[DTKeys.SESSION_ADMIN_INFO] = model;
            Session.Timeout = 45;
            //写入登录日志
            Model.siteconfig siteConfig = new BLL.siteconfig().loadConfig();
            if (siteConfig.logstatus > 0)
            {
                new BLL.manager_log().Add(model.id, model.no, DTEnums.ActionEnum.Login.ToString(), "用户登录");
            }
            //写入Cookies
            Utils.WriteCookie("DTRememberName", model.no, 14400);
            Utils.WriteCookie("AdminName", "DTcms", model.no);
            Utils.WriteCookie("AdminPwd", "DTcms", model.password);
            Response.Redirect("index.aspx");
            return;
        }
Esempio n. 14
0
        private bool DoEdit(int _id)
        {
            bool result = false;

            BLL.xiehui   bll      = new BLL.xiehui();
            Model.xiehui model    = bll.GetModel(_id);
            int          parentId = int.Parse(ddlParentId.SelectedValue);

            //如果选择的父ID不是自己,则更改
            if (parentId != model.id)
            {
                model.parent_id = parentId;
            }
            model.role_id   = int.Parse(ddlRoleId.SelectedValue);
            model.role_type = new BLL.manager_role().GetModel(model.role_id).role_type;
            if (cbIsLock.Checked == true)
            {
                model.is_lock = 0;
            }
            else
            {
                model.is_lock = 1;
            }
            //判断密码是否更改
            if (txtPassword.Text.Trim() != defaultpassword)
            {
                //获取用户已生成的salt作为密钥加密
                model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt);
            }
            model.name    = txtRealName.Text.Trim();
            model.town    = ddlTown.SelectedValue.ToString();
            model.village = ddlVillage.SelectedValue.ToString();
            model.person  = txtPerson.Text.Trim();
            model.tel     = txtTel.Text.Trim();
            model.address = txtAddress.Text.Trim();

            if (bll.Update(model))
            {
                AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改账号:" + model.no); //记录日志
                result = true;
            }

            return(result);
        }
Esempio n. 15
0
        private bool DoAdd()
        {
            Model.xiehui model = new Model.xiehui();
            BLL.xiehui   bll   = new BLL.xiehui();
            model.parent_id = int.Parse(ddlParentId.SelectedValue);
            model.role_id   = int.Parse(ddlRoleId.SelectedValue);
            model.role_type = new BLL.manager_role().GetModel(model.role_id).role_type;
            if (cbIsLock.Checked == true)
            {
                model.is_lock = 0;
            }
            else
            {
                model.is_lock = 1;
            }
            //检测用户名是否重复
            if (bll.Exists(txtUserName.Text.Trim()))
            {
                return(false);
            }
            model.no = txtUserName.Text.Trim();
            //获得6位的salt加密字符串
            model.salt = Utils.GetCheckCode(6);
            //以随机生成的6位字符串做为密钥加密
            model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt);
            model.name     = txtRealName.Text.Trim();
            model.town     = ddlTown.SelectedValue.ToString();
            model.village  = ddlVillage.SelectedValue.ToString();
            model.person   = txtPerson.Text.Trim();
            model.tel      = txtTel.Text.Trim();
            model.address  = txtAddress.Text.Trim();
            model.add_time = DateTime.Now;

            if (bll.Add(model) > 0)
            {
                AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加账号:" + model.no); //记录日志
                return(true);
            }
            return(false);
        }
Esempio n. 16
0
        private List <StatisEntity> GetStatisList()
        {
            BLL.account bll       = new BLL.account();
            BLL.xiehui  xiehuiBll = new BLL.xiehui();

            var id   = xiehuiBll.GetId(txtTown.Text, txtVillage.Text);
            var ds   = bll.GetStatisList(this.keywords, Utils.StrToInt(id, 0), Utils.StrToInt(this.bSubject, 0), Utils.StrToInt(this.sSubject, 0)).Tables[0];
            var list = new List <StatisEntity>();

            foreach (DataRow item in ds.Rows)
            {
                BLL.subject_detail subjectDetailBll = new BLL.subject_detail();
                var subjcetDetail = subjectDetailBll.GetModel(Utils.StrToInt(item["b_subject"].ToString(), 0), Utils.StrToInt(item["s_subject"].ToString(), 0));
                if (subjcetDetail == null)
                {
                    continue;
                }
                var model  = new StatisEntity();
                var xiehui = xiehuiBll.GetModel(Utils.StrToInt(item["xiehui_id"].ToString(), 0));

                BLL.subject subjectBll   = new BLL.subject();
                var         bSubjectName = subjectBll.GetName(Utils.StrToInt(item["b_subject"].ToString(), 0));
                var         sSubjectName = subjectBll.GetName(Utils.StrToInt(item["s_subject"].ToString(), 0));

                model.Town      = xiehui.town;
                model.Village   = xiehui.village;
                model.XieHui    = xiehui.name;
                model.BBSubjcet = bSubjectName;
                model.SSbuject  = sSubjectName;
                model.Amount    = subjcetDetail.amount.ToString();
                model.BQJie     = item["jie"].ToString();
                model.BQDai     = item["dai"].ToString();
                model.QmAmount  = (Utils.StrToInt(subjcetDetail.amount.ToString(), 0) - Utils.StrToInt(item["jie"].ToString(), 0) + Utils.StrToInt(item["dai"].ToString(), 0)).ToString();
                list.Add(model);
            }
            return(list);
        }
Esempio n. 17
0
        private void ShowInfo(int _id)
        {
            BLL.article   bll   = new BLL.article();
            Model.article model = bll.GetModel(_id);

            ddlCategoryId.SelectedValue = model.category_id.ToString();
            txtCallIndex.Text           = model.call_index;
            txtTitle.Text   = model.title;
            txtLinkUrl.Text = model.link_url;
            //不是相册图片就绑定
            string filename = model.img_url.Substring(model.img_url.LastIndexOf("/") + 1);

            if (!filename.StartsWith("thumb_"))
            {
                txtImgUrl.Text = model.img_url;
            }
            txtSeoTitle.Text        = model.seo_title;
            txtSeoKeywords.Text     = model.seo_keywords;
            txtSeoDescription.Text  = model.seo_description;
            txtZhaiyao.Text         = model.zhaiyao;
            txtContent.Value        = model.content;
            txtSortId.Text          = model.sort_id.ToString();
            txtClick.Text           = model.click.ToString();
            rblStatus.SelectedValue = model.status.ToString();

            BLL.xiehui managerBll = new BLL.xiehui();
            string     realName   = managerBll.GetRealName(model.user_name);

            txtCreatName.Text = realName;

            if (action == DTEnums.ActionEnum.Edit.ToString())
            {
                txtAddTime.Text = model.add_time.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (model.is_msg == 1)
            {
                cblItem.Items[0].Selected = true;
            }
            if (model.is_top == 1)
            {
                cblItem.Items[1].Selected = true;
            }
            if (model.is_red == 1)
            {
                cblItem.Items[2].Selected = true;
            }
            if (model.is_hot == 1)
            {
                cblItem.Items[3].Selected = true;
            }
            if (model.is_slide == 1)
            {
                cblItem.Items[4].Selected = true;
            }
            //扩展字段赋值
            List <Model.article_attribute_field> ls1 = new BLL.article_attribute_field().GetModelList(this.channel_id, "");

            foreach (Model.article_attribute_field modelt1 in ls1)
            {
                switch (modelt1.control_type)
                {
                case "single-text":     //单行文本
                    TextBox txtControl = FindControl("field_control_" + modelt1.name) as TextBox;
                    if (txtControl != null && model.fields.ContainsKey(modelt1.name))
                    {
                        if (modelt1.is_password == 1)
                        {
                            txtControl.Attributes.Add("value", model.fields[modelt1.name]);
                        }
                        else
                        {
                            txtControl.Text = model.fields[modelt1.name];
                        }
                    }
                    break;

                case "multi-text":     //多行文本
                    goto case "single-text";

                case "editor":     //编辑器
                    HtmlTextArea txtAreaControl = FindControl("field_control_" + modelt1.name) as HtmlTextArea;
                    if (txtAreaControl != null && model.fields.ContainsKey(modelt1.name))
                    {
                        txtAreaControl.Value = model.fields[modelt1.name];
                    }
                    break;

                case "images":     //图片上传
                    goto case "single-text";

                case "video":     //视频上传
                    goto case "single-text";

                case "number":     //数字
                    goto case "single-text";

                case "checkbox":     //复选框
                    CheckBox cbControl = FindControl("field_control_" + modelt1.name) as CheckBox;
                    if (cbControl != null && model.fields.ContainsKey(modelt1.name))
                    {
                        if (model.fields[modelt1.name] == "1")
                        {
                            cbControl.Checked = true;
                        }
                        else
                        {
                            cbControl.Checked = false;
                        }
                    }
                    break;

                case "multi-radio":     //多项单选
                    RadioButtonList rblControl = FindControl("field_control_" + modelt1.name) as RadioButtonList;
                    if (rblControl != null && model.fields.ContainsKey(modelt1.name))
                    {
                        rblControl.SelectedValue = model.fields[modelt1.name];
                    }
                    break;

                case "multi-checkbox":     //多项多选
                    CheckBoxList cblControl = FindControl("field_control_" + modelt1.name) as CheckBoxList;
                    if (cblControl != null && model.fields.ContainsKey(modelt1.name))
                    {
                        string[] valArr = model.fields[modelt1.name].Split(',');
                        for (int i = 0; i < cblControl.Items.Count; i++)
                        {
                            cblControl.Items[i].Selected = false;     //先取消默认的选中
                            foreach (string str in valArr)
                            {
                                if (cblControl.Items[i].Value == str)
                                {
                                    cblControl.Items[i].Selected = true;
                                }
                            }
                        }
                    }
                    break;
                }
            }
            //绑定图片相册
            if (filename.StartsWith("thumb_"))
            {
                hidFocusPhoto.Value = model.img_url; //封面图片
            }
            rptAlbumList.DataSource = model.albums;
            rptAlbumList.DataBind();
            //绑定内容附件
            rptAttachList.DataSource = model.attach;
            rptAttachList.DataBind();
            //赋值用户组价格
            if (model.group_price != null)
            {
                for (int i = 0; i < this.rptPrice.Items.Count; i++)
                {
                    int hideId = Convert.ToInt32(((HiddenField)this.rptPrice.Items[i].FindControl("hideGroupId")).Value);
                    foreach (Model.user_group_price modelt in model.group_price)
                    {
                        if (hideId == modelt.group_id)
                        {
                            ((HiddenField)this.rptPrice.Items[i].FindControl("hidePriceId")).Value = modelt.id.ToString();
                            ((TextBox)this.rptPrice.Items[i].FindControl("txtGroupPrice")).Text    = modelt.price.ToString();
                        }
                    }
                }
            }
        }
Esempio n. 18
0
        private List <StatisEntity> GetStatisList()
        {
            BLL.account        bll              = new BLL.account();
            BLL.xiehui         xiehuiBll        = new BLL.xiehui();
            BLL.subject        subjectBll       = new BLL.subject();
            BLL.subject_detail subjectDetailBll = new BLL.subject_detail();

            var ds   = bll.GetStatisList(this.keywords, 0, Utils.StrToInt(ddlBSubject.SelectedValue, 0), Utils.StrToInt(ddlSSubject.SelectedValue, 0)).Tables[0];
            var list = new List <StatisEntity>();

            foreach (DataRow dr in ds.Rows)
            {
                var xiehui = xiehuiBll.GetModel(Utils.StrToInt(dr["xiehui_id"].ToString(), 0));
                var model  = new StatisEntity();
                model.Town    = xiehui.town;
                model.Village = xiehui.village;
                model.XieHui  = xiehui.name;
                model.XianJin = GetAmount("现金", dr);
                model.YHCK    = GetAmount("银行存款", dr);
                model.JCHZJ   = GetAmount("借出互助金", dr);
                //资产小计=现金+银行存款+借出互助金
                model.ZCXJ = (Utils.StrToInt(model.XianJin, 0) + Utils.StrToInt(model.YHCK, 0) + Utils.StrToInt(model.JCHZJ, 0)).ToString();
                //借出互助资金占比率=资产小计/借出互助金
                model.JCZB  = Utils.StrToInt(model.JCHZJ, 0) == 0 ? "0" : (Utils.StrToInt(model.ZCXJ, 0) / Utils.StrToInt(model.JCHZJ, 0)).ToString();
                model.RHHZ  = GetAmount("会员入会互助金", dr);
                model.ZFHZJ = GetAmount("政府拨入互助资金", dr);
                //负债小计=会员入会互助金+政府拨入互助金
                model.FZXJ = (Utils.StrToInt(model.RHHZ, 0) + Utils.StrToInt(model.ZFHZJ, 0)).ToString();
                //净资产=资产小计-负债小计
                model.JZC  = (Utils.StrToInt(model.ZCXJ, 0) + Utils.StrToInt(model.FZXJ, 0)).ToString();
                model.ZFBZ = GetAmount("政府补助收入", dr);
                model.JCZY = GetAmount("互助金占用费收入", dr);
                model.YWGL = GetAmount("业务管理费收入", dr);
                model.GYJ  = GetAmount("公益金", dr);
                //收入小计=政府补助收入+互助金占用费收入+业务管理费收入+公益金
                model.SRXJ = (Utils.StrToInt(model.ZFBZ, 0) + Utils.StrToInt(model.JCZY, 0) + Utils.StrToInt(model.YWGL, 0) + Utils.StrToInt(model.GYJ, 0)).ToString();
                model.HDZC = GetAmount("业务活动支出", dr);
                //本期结余=收入小计-业务活动支出
                model.BQJY = (Utils.StrToInt(model.SRXJ, 0) + Utils.StrToInt(model.HDZC, 0)).ToString();
                list.Add(model);
            }
            //var list = new List<StatisEntity>()
            //{
            //   new StatisEntity(){Town="漩涡镇",Village="茨沟村",XieHui="漩涡镇茨沟村协会",XianJin="",YHCK="191816.41",JCHZJ="556000.00",ZCXJ="747816.41",JCZB="74.35%",RHHZ="54600.00",ZFHZJ="693780",FZXJ="748380",JZC="-563.59 ",ZFBZ="",JCZY="250.00",GYJ="",SRXJ="1261.41",HDZC="1825",BQJY="-563.59"},

            //   new StatisEntity(){Town="漩涡镇",Village="东河村",XieHui="漩涡镇东河村协会",XianJin="",YHCK="307102.74",JCHZJ="451000.00",ZCXJ="758102.74",JCZB="59.49%",RHHZ="39400.00",ZFHZJ="713420",FZXJ="752820",JZC="5282.74",ZFBZ="",JCZY="5282.74",GYJ="",SRXJ="5282.74",HDZC="",BQJY="5282.74"},

            //   new StatisEntity(){Town="漩涡镇",Village="金星村",XieHui="漩涡镇金星村协会",XianJin="",YHCK="237406.44 ",JCHZJ="555000.00",ZCXJ="792406.44",JCZB="70.04%",RHHZ="48300.00",ZFHZJ="741740",FZXJ="790040",JZC="2366.44",ZFBZ="",JCZY="2366.44",GYJ="",SRXJ="2366.44",HDZC="",BQJY="2366.44"},

            //   new StatisEntity(){Town="漩涡镇",Village="田凤村",XieHui="漩涡镇田凤村协会",XianJin="",YHCK="494204.05",JCHZJ="305000.00",ZCXJ="799204.05",JCZB="38.16%",RHHZ="27000.00",ZFHZJ="770950",FZXJ="797950",JZC="1254.05",ZFBZ="",JCZY="1254.05",GYJ="",SRXJ="1254.05",HDZC="",BQJY="1254.05"},

            //   new StatisEntity(){Town="漩涡镇",Village="田堰村",XieHui="漩涡镇田堰村协会",XianJin="",YHCK="441926.13",JCHZJ="310000.00",ZCXJ="751926.13",JCZB="41.23%",RHHZ="29900.00",ZFHZJ="715700",FZXJ="745600",JZC="6326.13",ZFBZ="",JCZY="8121.13",GYJ="",SRXJ="8121.13",HDZC="1795",BQJY="6326.13"},

            //   new StatisEntity(){Town="漩涡镇",Village="上七村",XieHui="漩涡镇上七村协会",XianJin="",YHCK="500379.17",JCHZJ="",ZCXJ="500379.17",JCZB="0.00%",RHHZ="",ZFHZJ="500000",FZXJ="500000",JZC="379.17",ZFBZ="",JCZY="379.17",GYJ="",SRXJ="379.17",HDZC="",BQJY="379.17"},

            //   new StatisEntity(){Town="漩涡镇",Village="龙泉村",XieHui="漩涡镇龙泉村协会",XianJin="237",YHCK="170990.74",JCHZJ="370000.00",ZCXJ="541227.74",JCZB="68.36%",RHHZ="42700.00",ZFHZJ="500000",FZXJ="542700",JZC="-1472.26",ZFBZ="",JCZY="290.74",GYJ="",SRXJ="290.74",HDZC="1763",BQJY="-1472.26"},

            //   new StatisEntity(){Town="漩涡镇",Village="中银村",XieHui="漩涡镇中银村协会",XianJin="47",YHCK="246524.64",JCHZJ="412000.00",ZCXJ="658571.64",JCZB="62.56%",RHHZ="41900.00",ZFHZJ="600000",FZXJ="641900",JZC="16671.64",ZFBZ="",JCZY="18576.64",GYJ="",SRXJ="18576.64",HDZC="1905",BQJY="16671.64"},
            //};
            return(list);
            //BLL.account bll = new BLL.account();
            //var ds = bll.GetStatisList(this.keywords,1, Utils.StrToInt(this.bSubject, 0), Utils.StrToInt(this.sSubject, 0)).Tables[0];
            //var list = new List<StatisEntity>();
            //foreach (DataRow item in ds.Rows)
            //{
            //    BLL.subject_detail subjectDetailBll = new BLL.subject_detail();
            //    var subjcetDetail = subjectDetailBll.GetModel(Utils.StrToInt(item["b_subject"].ToString(), 0), Utils.StrToInt(item["s_subject"].ToString(), 0));
            //    if (subjcetDetail == null)
            //    {
            //        continue;
            //    }
            //    var model = new StatisEntity();
            //    BLL.xiehui xiehuiBll = new BLL.xiehui();
            //    var xiehui = xiehuiBll.GetModel(Utils.StrToInt(item["xiehui_id"].ToString(), 0));

            //    BLL.subject subjectBll = new BLL.subject();
            //    var bSubjectName = subjectBll.GetName(Utils.StrToInt(item["b_subject"].ToString(), 0));
            //    var sSubjectName = subjectBll.GetName(Utils.StrToInt(item["s_subject"].ToString(), 0));

            //    model.Town = xiehui.town;
            //    model.Village = xiehui.village;
            //    model.XieHui = xiehui.name;
            //    model.BBSubjcet = bSubjectName;
            //    model.SSbuject = sSubjectName;
            //    model.Amount = subjcetDetail.amount.ToString();
            //    model.BQJie = item["jie"].ToString();
            //    model.BQDai = item["dai"].ToString();
            //    model.QmAmount = (Utils.StrToInt(subjcetDetail.amount.ToString(), 0) - Utils.StrToInt(item["jie"].ToString(), 0) + Utils.StrToInt(item["dai"].ToString(), 0)).ToString();
            //    list.Add(model);
            //}
            //return list;
        }