private void DestroyBasic()
{
try
{
PublisherAdView?.Destroy();
TxtSave = null !;
IconTitle = null !;
IconUrl = null !;
IconCategories = null !;
IconSubCategories = null !;
IconUsersPost = null !;
TxtTitle = null !;
TxtUrl = null !;
TxtCategories = null !;
TxtSubCategories = null !;
SubCategoriesLayout = null !;
MAdapter = null !;
MRecycler = null !;
RadioEnable = null !;
RadioDisable = null !;
LayoutManager = null !;
CategoryId = null !;
SubCategoryId = null !;
PagesId = null !;
DialogType = null !;
UsersPost = null !;
PageData = null !;
PublisherAdView = null !;
}
catch (Exception e)
{
Methods.DisplayReportResultTrack(e);
}
}
public JsonResult Search()
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
//string Where = Request["sqlSet"] == null ? "1=1" : SelectWhere.selectwherestring(Request["sqlSet"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
////字段排序
//String sortField = Request["sortField"];
//String sortOrder = Request["sortOrder"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "ClientUser";
pc.sys_Where = Where;
pc.sys_Order = "Id";
List <ClientUser> list2 = OPBiz.GetPagingData(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = ClientUserSet.Id.NotEqual("");
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
string d = JsonConvert.SerializeObject(dic);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
private void InitData()
{
HttpCookie cookie = Request.Cookies["qx"];
if (cookie != null)
{
qx = cookie.Values["qxid"].ToString();
}
if (qx != "1")
{
Response.Redirect("Error.aspx");
}
int PageIndex = 1;
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out PageIndex);
}
int PageSize = 10;
int TotalCount = 0;
string strWhere = " 1=1 ";
if (Request.QueryString["pid"] != null)
{
subordinate_course_id = Request.QueryString["pid"];
strWhere += " and subordinate_course_id=" + subordinate_course_id;
}
DataTable dt = H_Detail_CourseClass.GetList(PageSize, PageIndex, strWhere, out TotalCount);
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
this.LiteralPage.Text = PageClass.BuildPage(PageIndex, TotalCount, PageSize);
}
private void DestroyBasic()
{
try
{
PublisherAdView?.Destroy();
TxtSave = null;
IconTitle = null;
IconUrl = null;
IconCategories = null;
IconSubCategories = null;
IconUsersPost = null;
TxtTitle = null;
TxtUrl = null;
TxtCategories = null;
TxtSubCategories = null;
SubCategoriesLayout = null;
MAdapter = null;
MRecycler = null;
RadioEnable = null;
RadioDisable = null;
LayoutManager = null;
CategoryId = null;
SubCategoryId = null;
PagesId = null;
DialogType = null;
UsersPost = null;
PageData = null;
PublisherAdView = null;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public ActionResult Index(int page = 1)
{
PageClass pc = new PageClass();
int countOnPage = 3; //количество фильмов на странице
pc.pageMovies = db.Movies.OrderByDescending(x => x.ID).ToList().Skip((page - 1) * countOnPage).Take(countOnPage).ToList();
pc.currPage = page;
pc.pagesAvaible = new System.Collections.Generic.List <int>();
int pagesCount = (int)(db.Movies.Count() / countOnPage);
int ost = db.Movies.Count() % (countOnPage * pagesCount);
pagesCount += ost > 0 ? 1 : 0;
pc.pagesAvaible.Add(page);
for (int i = 1; i < 5; i++)
{
if (page + i <= pagesCount)
{
pc.pagesAvaible.Add(page + i);
}
if (page - i > 0)
{
pc.pagesAvaible.Add(page - i);
}
}
pc.currUser = Session["currUser"] != null ? Session["currUser"].ToString() : "";
return(View(pc));
}
public JsonResult Search()
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
//string Where = Request["sqlSet"] == null ? "1=1" : SelectWhere.selectwherestring(Request["sqlSet"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
Where += " and (isDeleted=0)";
////字段排序
String sortField = Request["sort"];
String sortOrder = Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "FileId";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "TT_FilesInsuran";
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
DataSet ds = OPBiz.GetPagingDataP(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", ds.Tables[0]);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 单位可用
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
/// [HttpPost]
public JsonResult PersonnelFile_Units()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 1000 : int.Parse(Request["rows"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
Where += " and (isDeleted=0) ";
string table = "TF_PersonnelFile";
// if (UserData.UserTypes != 1)
// {
// Where += " and ( UnitsId='" + UserData.DepartmentId + "')";
// table = "v_TF_PersonnelFile_Units_Out";
// }
////字段排序
String sortField = Request["sort"];
String sortOrder = Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = table;
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
DataSet ds = OPBiz.GetPagingDataP(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = TF_PersonnelFileSet.Id.NotEqual("");
dic.Add("rows", ds.Tables[0]);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页获取用户 未添加店铺的用户
/// </summary>
/// <returns></returns>
public JsonResult getUser()
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
//string Where = Request["sqlSet"] == null ? "1=1" : SelectWhere.selectwherestring(Request["sqlSet"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
Where += " AND (UserId not in (SELECT UserId from TT_ShopAppUser where isDeleted=0)) ";
////字段排序
String sortField = Request["sort"];
String sortOrder = Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "UserId,LoginName,TrueName,WeiXinId";
pc.sys_Key = "UserId";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "TT_User";
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
DataSet ds = OPBiz.GetPagingDataP(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", ds.Tables[0]);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
public JsonResult GetList()
{
int pageIndex = string.IsNullOrEmpty(Request.Form["page"]) ? 1 : int.Parse(Request.Form["page"]);
int pageSize = string.IsNullOrEmpty(Request.Form["rows"]) ? 10 : int.Parse(Request.Form["rows"]);
string Where = string.IsNullOrEmpty(Request.Form["sqlSet"]) ? "1=1" : GetSql(Request.Form["sqlSet"]);
////字段排序
String sortField = Request.Form["sort"];
String sortOrder = Request.Form["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
//pc.sys_Key = "id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "rms_buttons";
pc.sys_Where = Where;
if (!string.IsNullOrEmpty(sortField) && !string.IsNullOrEmpty(sortOrder))
{
pc.sys_Order = " order by " + " " + sortField + " " + sortOrder;
}
DataTable ds = RMS_ButtonsService.Instance.sqlToDataTablePage(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", ModelConvertHelper <rms_buttons> .ConvertToModel(ds));
dic.Add("total", pc.RCount);
return(Json(dic));
}
/// <summary>
/// 角色类型
///
/// </summary>
/// <param name="RoleTypes"></param>
/// <returns></returns>
public String GetList(string RoleTypes)
{
int pageIndex = 1;
int pageSize = 500;
////字段排序
//String sortField = Request["sortField"];
//String sortOrder = Request["sortOrder"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "RMS_Role";
pc.sys_Where = "RoleTypes=" + RoleTypes;
pc.sys_Order = "Id";
if (!UserData.RoleId.ToString().Equals("fb38f312-0078-4f44-9cda-1183c8042db8"))//不是系统管理员，不请允许显示系统管理员
{
pc.sys_Where += " and Id!='fb38f312-0078-4f44-9cda-1183c8042db8'";
}
List <RMS_Role> list2 = RDBiz.GetPagingData(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = RMS_RoleSet.ControlId.NotEqual("");
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(JsonHelper.ToJson(dic, true));
}
public JsonResult Search()
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
//string Where = Request["sqlSet"] == null ? "1=1" : SelectWhere.selectwherestring(Request["sqlSet"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
Where += " and (isDeleted=0)";
Where += " and (CreateManId='" + UserData.Id + "')";//只能返回自己添加的
////字段排序
String sortField = Request["sort"];
String sortOrder = Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "v_TS_Shop";
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
List <v_TS_Shop> list2 = OPBiz.GetPagingData <v_TS_Shop>(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(MyJson(dic, JsonRequestBehavior.AllowGet));
}
public string GetByPostIdPage(HttpContext context)
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = context.Request["page"] == null ? 1 : int.Parse(context.Request["page"]);
int pageSize = context.Request["rows"] == null ? 10 : int.Parse(context.Request["rows"]);
string PostId = context.Request["PostId"];
string Where = " PostId='" + PostId + "' and (isDeleted=0)";
////字段排序
String sortField = context.Request["sort"];
String sortOrder = context.Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "Comment";
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
List <Comment> list2 = OPBiz.GetPagingData <Comment>(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(JsonHelper.ToJson(dic, true));
}
private void DestroyBasic()
{
try
{
PublisherAdView?.Destroy();
TxtSave = null !;
IconCompany = null !;
IconPhone = null !;
IconLocation = null !;
IconWebsite = null !;
IconAbout = null !;
TxtCompany = null !;
TxtPhone = null !;
TxtLocation = null !;
TxtWebsite = null !;
TxtAbout = null !;
PagesId = null !;
PageData = null !;
PublisherAdView = null !;
}
catch (Exception e)
{
Methods.DisplayReportResultTrack(e);
}
}
public OptionClass(PageClass P)
{
Title = P.OptionTitle;
Option = P.UniqueID;
Condition = P.Condition;
Action = P.Action;
}
//显示最新用户操作记录
private void BindLogData(int pageIndex)
{
T_User user = new T_User();//Static.GetUserForCookie();
if (user != null && user.UserType == 0)
{
try
{
PageClass pageClass = new PageClass();
pageClass.TableName = "t_logs";
pageClass.ShowField = "*";
pageClass.WhereText = "";
pageClass.OrderText = "LogTime desc";
pageClass.PageSize = 10;
pageClass.PageIndex = pageIndex;
var data = logBLL.SelectForPage(pageClass);
AspNetPager1.PageSize = pageClass.PageSize;
AspNetPager1.RecordCount = pageClass.DataCount;
repLogList.DataSource = data;
repLogList.DataBind();
}
catch (Exception ex)
{
}
}
else
{
loglist.Visible = false;
}
}
public JsonResult GetList()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
////字段排序
//String sortField = Request["sortField"];
//String sortOrder = Request["sortOrder"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "RMS_Buttons";
pc.sys_Where = "1=1";
pc.sys_Order = "Id";
List <RMS_Buttons> list2 = OPBiz.GetPagingData(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = RMS_ButtonsSet.Id.NotEqual("");
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
private void DestroyBasic()
{
try
{
RewardedVideoAd?.OnDestroy(this);
PublisherAdView?.Destroy();
TxtSave = null !;
IconFacebook = null !;
IconTwitter = null !;
IconInstagram = null !;
IconVk = null !;
IconLinkedin = null !;
IconYouTube = null !;
TxtFacebook = null !;
TxtTwitter = null !;
TxtInstagram = null !;
TxtVk = null !;
TxtLinkedin = null !;
TxtYouTube = null !;
PagesId = null !;
PageData = null !;
RewardedVideoAd = null !;
PublisherAdView = null !;
}
catch (Exception e)
{
Methods.DisplayReportResultTrack(e);
}
}
public JsonResult GetList()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
////字段排序
//String sortField = Request["sortField"];
//String sortOrder = Request["sortOrder"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "PushMessage";
pc.sys_Where = "1=1";
//if (!UserData.UserInfo.RoleId.ToString().Equals("fb38f312-0078-4f44-9cda-1183c8042db8"))//不是系统管理员，限制一个医院
//{
// pc.sys_Where += " and YH_HospitalId='" + UserData.UserInfo.YH_HospitalId + "'";
//}
pc.sys_Order = " AddTime Desc";
List <PushMessage> list2 = OPBiz.GetPagingData <PushMessage>(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = PushMessageSet.Id.NotEqual("");
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
protected override void OnCreate(Bundle savedInstanceState)
{
try
{
base.OnCreate(savedInstanceState);
SetTheme(AppSettings.SetTabDarkTheme ? Resource.Style.MyTheme_Dark_Base : Resource.Style.MyTheme_Base);
// Create your application here
SetContentView(Resource.Layout.RecyclerDefaultLayout);
PageId = Intent.GetStringExtra("PagesId");
if (!string.IsNullOrEmpty(Intent.GetStringExtra("PageData")))
{
PageData = JsonConvert.DeserializeObject <PageClass>(Intent.GetStringExtra("PageData"));
}
//Get Value And Set Toolbar
InitComponent();
InitToolbar();
SetRecyclerViewAdapters();
AdsGoogle.Ad_Interstitial(this);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public DataSet GetPagingDataP(PageClass pc)
{
DbParameter[] parameters =
{
new SqlParameter("@tableName", SqlDbType.NVarChar, 200),
new SqlParameter("@strGetFields", SqlDbType.NVarChar, 200),
new SqlParameter("@strOrder", SqlDbType.NVarChar, 200),
new SqlParameter("@PageSize", SqlDbType.Int, 16),
new SqlParameter("@PageIndex", SqlDbType.Int, 16),
new SqlParameter("@TotalCount", SqlDbType.Int, 16),
new SqlParameter("@strWhere", SqlDbType.NVarChar, 200)
};
parameters[0].Value = pc.sys_Table;
parameters[1].Value = pc.sys_Fields;
parameters[2].Value = pc.sys_Order;
parameters[3].Value = pc.sys_PageSize;
parameters[4].Value = pc.sys_PageIndex;
parameters[5].Direction = ParameterDirection.Output;
parameters[6].Value = pc.sys_Where;
using (var db = GetDb())
{
// db.DebugEnabled = true;
DataSet ds = db.ExecuteProToDataSet("sp_PaginationEx", parameters);
pc.RCount = Convert.ToInt32(parameters[5].Value);
pc.PCount = pc.RCount / pc.sys_PageIndex;
return(ds);
}
}
private void DestroyBasic()
{
try
{
PublisherAdView?.Destroy();
TxtSave = null;
IconCompany = null;
IconPhone = null;
IconLocation = null;
IconWebsite = null;
IconAbout = null;
TxtCompany = null;
TxtPhone = null;
TxtLocation = null;
TxtWebsite = null;
TxtAbout = null;
PagesId = null;
PageData = null;
PublisherAdView = null;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
private void DestroyBasic()
{
try
{
RewardedVideoAd?.OnDestroy(this);
TxtSave = null;
IconFacebook = null;
IconTwitter = null;
IconInstagram = null;
IconVk = null;
IconLinkedin = null;
IconYouTube = null;
TxtFacebook = null;
TxtTwitter = null;
TxtInstagram = null;
TxtVk = null;
TxtLinkedin = null;
TxtYouTube = null;
PagesId = null;
PageData = null;
RewardedVideoAd = null;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public JsonResult GetInsuranItermSeel()
{
// SelectWhere.selectwherestring(Request["sqlSet"]);
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
//string Where = Request["sqlSet"] == null ? "1=1" : SelectWhere.selectwherestring(Request["sqlSet"]);
string Where = Request["sqlSet"] == null ? "1=1" : GetSql(Request["sqlSet"]);
Where += " and (isDeleted=0)";
PageClass pc = new PageClass();
pc.sys_Fields = "ItermSeelId,TName,Rates,SCode,Formula,ClaimAmount,Describe";
pc.sys_Key = "ItermSeelId";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "TT_InsuranItermSeel";
pc.sys_Where = Where;
pc.sys_Order = " " + pc.sys_Key + " desc";
DataSet ds = OPBiz.GetPagingDataP(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("rows", ds.Tables[0]);
dic.Add("total", pc.RCount);
//StringBuilder sb = new StringBuilder();
//foreach (DataRow item in ds.Tables[0].Rows)
//{
// sb.AppendFormat("<input type=\"hidden\" name=\"ItermSeelId\" value=\"{0}\"> <label style=\"width:120px;\">{1}</label> <label style=\"width:120px;\">{2}</label> <label style=\"width:200px;\">{3}</label> <input type=\"text\" value=\"\" class=\"easyui-validatebox\" onkeyup=\"clearNoNum(this)\" data-options=\"valueField:'ItemValue',textField:'ItemName',required:true\"> <input type=\"checkbox\" name=\"ce\"> <br> ", item[0], item[1], item[2], item[3]);
//}
return(Json(dic, JsonRequestBehavior.AllowGet));
}
public virtual void Export_OnInit(PageClass page, Control control, string exportDataType)
{
Button btn = control as Button;
//Determine if we're exporting json or xml
ExportMode exportMode = ExportMode.JSON;
if (String.Equals(exportDataType, "xml", StringComparison.InvariantCulture))
{
exportMode = ExportMode.XML;
}
//must force a full postback so that we are sending the file back on a valid Response stream
ForceFullPostback(page, control);
//TODO: Maybe some day do double-submit prevention
//UtilityFunctions.DoubleSubmitPrevention(page, btn);
//Wire up the click event to export the data from all childforms
btn.Click += (s, e) =>
{
//Initialize the ExportService with the current page's form key and FacadeClass
ExportService export = new ExportService(page.szFormKey, page.oFacadeObject, exportMode);
//Get the Xml version of the data
var xmlExport = export.GetDataXml();
//Write the Xml data to the response stream in JSON or XML
export.WriteFileToResponse(xmlExport, HttpContext.Current.Response, $"DataExport_{page.oFacadeObject.GetValue("cst_recno")}");
};
}
protected override void OnCreate(Bundle savedInstanceState)
{
try
{
base.OnCreate(savedInstanceState);
SetTheme(AppSettings.SetTabDarkTheme ? Resource.Style.MyTheme_Dark_Base : Resource.Style.MyTheme_Base);
Methods.App.FullScreenApp(this);
// Create your application here
SetContentView(Resource.Layout.RecyclerDefaultLayout);
PageId = Intent?.GetStringExtra("PageId");
if (!string.IsNullOrEmpty(Intent?.GetStringExtra("PageData")))
{
PageDataClass = JsonConvert.DeserializeObject <PageClass>(Intent?.GetStringExtra("PageData"));
}
//Get Value And Set Toolbar
InitComponent();
InitToolbar();
SetRecyclerViewAdapters();
StartApiService();
}
catch (Exception e)
{
Methods.DisplayReportResultTrack(e);
}
}
//绑定用户列表
private void BindUserList(int pageIndex)
{
string name = txtSeach.Text;
string whereText = " 1=1 ";
if (!string.IsNullOrEmpty(name))
{
whereText += " and (LoginName like '%" + name + "%' or TrueName like '%" + name + "%' or Email like '%" + name + "%')";
}
PageClass pageClass = new PageClass();
pageClass.TableName = "T_User";
pageClass.ShowField = "*";
pageClass.WhereText = whereText;
pageClass.OrderText = "CTime desc";
pageClass.PageSize = 1;
pageClass.PageIndex = pageIndex;
try
{
var data = userBLL.SelectForPage(pageClass);
AspNetPager1.PageSize = pageClass.PageSize;
AspNetPager1.RecordCount = pageClass.DataCount;
repUserList.DataSource = data;
repUserList.DataBind();
}
catch (Exception ex)
{
JsAlert(ex);
}
}
public void InitData()
{
string strWhere = " 1=1 ";
HttpCookie cookie = Request.Cookies["qx"];
if (cookie != null)
{
qx = cookie.Values["qxid"].ToString();
}
if (qx == "2")
{
string username = HttpUtility.UrlDecode(cookie.Values["user"].ToString(), Encoding.UTF8);
strWhere = "username='******'";
}
if (qx == "3" || qx == "4")
{
Response.Write("Error.aspx");
}
int PageIndex = 1;
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out PageIndex);
}
int PageSize = 10;
int TotalCount = 0;
DataTable dt = H_ServiceClass.GetList(PageSize, PageIndex, strWhere, out TotalCount);
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
this.LiteralPage.Text = PageClass.BuildPage(PageIndex, TotalCount, PageSize);
}
public JsonResult GetList()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
////字段排序
//String sortField = Request["sortField"];
//String sortOrder = Request["sortOrder"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "V_Role";
pc.sys_Where = "1=1";
pc.sys_Order = "Id";
if (!UserData.RoleId.ToString().Equals("fb38f312-0078-4f44-9cda-1183c8042db8"))//不是系统管理员，不请允许显示系统管理员
{
pc.sys_Where += " and Id!='fb38f312-0078-4f44-9cda-1183c8042db8'";
}
List <V_Role> list2 = RDBiz.GetPagingData <V_Role>(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = RMS_RoleSet.ControlId.NotEqual("");
dic.Add("rows", list2);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUnitsNotOut(string Id)
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 1000 : int.Parse(Request["rows"]);
string Where = " Id not in(select UnitsId from TF_PersonnelFile_Units_Out where PersonnelFileId='" + Id + "')";
Where += " and (isDeleted=0) ";
////字段排序
String sortField = Request["sort"];
String sortOrder = Request["order"];
PageClass pc = new PageClass();
pc.sys_Fields = "*";
pc.sys_Key = "Id";
pc.sys_PageIndex = pageIndex;
pc.sys_PageSize = pageSize;
pc.sys_Table = "TF_Units";
pc.sys_Where = Where;
pc.sys_Order = " " + sortField + " " + sortOrder;
DataSet ds = OPBiz.GetPagingDataP(pc);
Dictionary <string, object> dic = new Dictionary <string, object>();
// var mql = TF_PersonnelFileSet.Id.NotEqual("");
dic.Add("rows", ds.Tables[0]);
dic.Add("total", pc.RCount);
return(Json(dic, JsonRequestBehavior.AllowGet));
}
private void InitUserData()
{
int PageIndex = 1;
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out PageIndex);
}
int PageSize = 10;
int TotalCount = 0;
string strWhere = "id>1";
if (Request.QueryString["user_name"] != null)
{
string user_name = HttpUtility.UrlDecode(Request.QueryString["user_name"].ToString(), Encoding.UTF8);
strWhere += "and username like'%" + user_name + "%'";
}
if (Request.QueryString["qxid"] != null)
{
string qxid = HttpUtility.UrlDecode(Request.QueryString["qxid"].ToString(), Encoding.UTF8);
strWhere += "and qxid=" + qxid + "";
}
DataTable dt = H_UserClass.GetList(PageSize, PageIndex, strWhere, out TotalCount);
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
this.LiteralPage.Text = PageClass.BuildPage(PageIndex, TotalCount, PageSize);
}
private void GeneratePageLayout()
{
IPageLayout pageLayout = axPageLayoutControl1.PageLayout;
IGraphicsContainer pGraphicsContainer = pageLayout as IGraphicsContainer;
pGraphicsContainer.DeleteAllElements();
IPage pPage = new PageClass();
pPage = pageLayout.Page;
pPage.PutCustomSize(36, 24);
IActiveView pActiveView = pageLayout as IActiveView;
IMap pMap = pActiveView.FocusMap;
IMapFrame mapFrame1 = pGraphicsContainer.FindFrame(pMap) as IMapFrame;
IEnvelope pEnvelope = new EnvelopeClass();
pEnvelope.PutCoords(1.5, 3, 17.5, 20);
IElement pElement = mapFrame1 as IElement;
pElement.Geometry = pEnvelope;
//Map frame 2
IMap mapDF1 = new MapClass();
IMapFrame mapFrame2 = new MapFrameClass();
mapFrame2.Map = mapDF1;
IElement element1 = mapFrame2 as IElement;
IEnvelope envelope1 = new EnvelopeClass();
envelope1.PutCoords(18.5, 3, 34.5, 20);
element1.Geometry = envelope1;
//?????element 1 or bot map always hide???
pGraphicsContainer.AddElement(element1, 0);
//#
//////add map---problem shot
//mapFrame1.Map = m_MapControltop.ActiveView.FocusMap;
//mapFrame2.Map = m_MapControlbase.ActiveView.FocusMap;
//#
//TRY to use ObjectCopy
//copy map to top mapframe of pagelayoutcontrol
IObjectCopy objectCopy1 = new ObjectCopyClass();
object toCopyMap1 = m_MapControltop.ActiveView.FocusMap;
//IMap map1 = toCopyMap1 as IMap;
//map1.IsFramed = true;
object copiedMap1 = objectCopy1.Copy(toCopyMap1);
object toOverwriteMap1 = mapFrame1.Map;
objectCopy1.Overwrite(copiedMap1, ref toOverwriteMap1);
//SetMapExtent1();
//copy map to bot mapframe of pagelayoutcontrol
IObjectCopy objectCopy2 = new ObjectCopyClass();
object toCopyMap2 = m_MapControlbase.ActiveView.FocusMap;
object copiedMap2 = objectCopy2.Copy(toCopyMap2);
object toOverwriteMap2 = mapFrame2.Map;
objectCopy2.Overwrite(copiedMap2, ref toOverwriteMap2);
mapFrame1.Map.Name = "MapTop";
mapFrame2.Map.Name = "MapBot";
//try to change scale
IGraphicsContainer container = this.axPageLayoutControl1.GraphicsContainer;
container.Reset();
IElement element = container.Next();
int index = 0;
while (element != null)
{
if (element is IMapFrame)
{
IMapFrame mapFrame = (IMapFrame)element;
string sMapName = mapFrame.Map.Name;
IElementProperties elementProperties = (IElementProperties)element;
string slementName = elementProperties.Name;
index += 1;
}
element = container.Next();
}
//add title
ITextElement teTitle = new TextElementClass();
IPoint ptTitle = new PointClass();
ptTitle.PutCoords(18, 22.5);
IElement eleTitle = teTitle as IElement;
eleTitle = MakeATextElement(ptTitle, tbStNum.Text + " " + tbStNa.Text + " Historical Aerial Comparison", 80);
pGraphicsContainer.AddElement(eleTitle, 0);
string topYear = cboTopYear.Text;
string botYear = cboBotYear.Text;
//Add subtitle
ITextElement teSubTitle1 = new TextElementClass();
IPoint ptSubTitle1 = new PointClass();
ptSubTitle1.PutCoords(9.5, 21);
IElement eleSubTitle1 = teSubTitle1 as IElement;
eleSubTitle1 = MakeATextElement(ptSubTitle1, topYear, 45);
pGraphicsContainer.AddElement(eleSubTitle1, 0);
//Add Subtitle2
ITextElement teSubTitle2 = new TextElementClass();
IPoint ptSubTitle2 = new PointClass();
ptSubTitle2.PutCoords(26.5, 21);
IElement eleSubTitle2 = teSubTitle2 as IElement;
eleSubTitle2 = MakeATextElement(ptSubTitle2, botYear, 45);
pGraphicsContainer.AddElement(eleSubTitle2, 0);
//Add Scale Bar
AddScaleBar(mapFrame1.Map);
//Add North Arrow
AddNorthArrow(axPageLayoutControl1.PageLayout, mapFrame1.Map);
axPageLayoutControl1.ActiveView.PartialRefresh(esriViewDrawPhase.esriViewGeography, null, null);
MessageBox.Show("Done!");
}
private void _showUpdate(int id)
{
_panelControl(pnl_update);
//attempt
//attempt end
PageClass _page = new PageClass();
rpt_update.DataSource = _page.getPageByID(id);
rpt_update.DataBind();
// SubjectClass _subject = new SubjectClass();
// rpt_update.DataSource = _subject.getSubjectByID(id);
// rpt_update.DataBind();
//ddl_subjectU.DataSource = objSub.getSubjects();
//ddl_subjectU.DataTextField = "menu_name";
//ddl_subjectU.DataValueField = "id";
//ddl_subjectU.DataBind();
}
