protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { CommonAdapter ca = new CommonAdapter(); int currencyID = Int32.Parse(e.Row.Cells[4].Text); e.Row.Cells[4].Text = ca.getCurrencyByID(currencyID); if (e.Row.RowIndex > -1 && this.SelectedItems != null) { CheckBox cbx = (CheckBox)e.Row.FindControl("cbItem"); int i = e.Row.RowIndex; string id = string.Format("{0}${1}${2}${3}${4}", this.GridView1.DataKeys[i].Values[0].ToString(), this.GridView1.DataKeys[i].Values[1].ToString(), this.GridView1.DataKeys[i].Values[2].ToString(), this.GridView1.DataKeys[i].Values[3].ToString(), this.GridView1.DataKeys[i].Values[4].ToString() ); if (SelectedItems.Contains(id)) { cbx.Checked = true; } else { cbx.Checked = false; } } } }
public DataSet Query(int startRowIndex, int maximumRows, string connection, string tableName, string selectFields, string where, string orderBy, ref int totalCount) { QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, selectFields, tableName, orderBy, where); //OnBuildQueryCondition(qc); CommonAdapter adapter = new CommonAdapter(connection); DataSet result = adapter.SplitPageQuery(qc, totalCount <= 0); if (result.Tables.Count > 1) { totalCount = (int)result.Tables[1].Rows[0][0]; } var contextCacheKey = connection + "." + tableName + ".Query"; ObjectContextCache.Instance[contextCacheKey] = totalCount; //当页码超出索引的,返回最大页 if (result.Tables[0].Rows.Count == 0 && totalCount > 0) { int newStartRowIndex = (totalCount - 1) / maximumRows * maximumRows; totalCount = -1; result = Query(newStartRowIndex, maximumRows, connection, tableName, selectFields, where, orderBy, ref totalCount); } return(result); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { CommonAdapter ca = new CommonAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { Label lblCurrency = e.Row.Cells[7].FindControl("lbl_fcurrencyid") as Label; if (!string.IsNullOrEmpty(lblCurrency.Text)) { int currencyID = Int32.Parse(lblCurrency.Text); lblCurrency.Text = ca.getCurrencyByID(currencyID); Label lblAmountFor = e.Row.Cells[3].FindControl("lbl_amountfor") as Label; amountforAll += Decimal.Parse(lblAmountFor.Text); Label lblReceiveAmountFor = e.Row.Cells[4].FindControl("lbl_fpayamountfor") as Label; payamountforAll += Decimal.Parse(lblReceiveAmountFor.Text); Label lblUnReceiveAmountFor = e.Row.Cells[5].FindControl("lbl_funpayamountfor") as Label; unpayamountforAll += Decimal.Parse(lblUnReceiveAmountFor.Text); } } else if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[2].Text = "汇总"; e.Row.Cells[3].Text = amountforAll.ToString(); //采购发票中金额 e.Row.Cells[4].Text = payamountforAll.ToString(); //已支付金额 e.Row.Cells[5].Text = unpayamountforAll.ToString(); //未支付金额 e.Row.Cells[6].Text = checkamountforAll.ToString(); //单据金额 } }
private void bindControls() { RoundImageView rImgView = FindViewById <RoundImageView>(Resource.Id.img_avator); if (blogger.Avatar.Contains("png") || blogger.Avatar.Contains("jpg") || blogger.Avatar.Contains("gif")) { imgLoader.DisplayImage(blogger.Avatar, rImgView, displayImageOptions); } TextView textHomePage = FindViewById <TextView>(Resource.Id.text_homepage); textHomePage.Text = blogger.Link.ToString(); TextView textBloggerApp = FindViewById <TextView>(Resource.Id.text_blogapp); textBloggerApp.Text = blogger.BlogApp; TextView textPostCount = FindViewById <TextView>(Resource.Id.text_blog_count); textPostCount.Text = "博文数:" + blogger.PostCount.ToString(); TextView textLastPost = FindViewById <TextView>(Resource.Id.text_lastupdate); textLastPost.Text = "最后更新:" + CommonHelper.DateDiff(DateTime.Now, blogger.Updated) + "前"; comAdaper = new CommonAdapter <Article>(this, Resource.Layout.blogger_article_list_item, articles); comAdaper.OnGetView += comAdapter_OnGetView; pListView.Adapter = comAdaper; pListView.ItemClick += pListView_ItemClick; ptrl = FindViewById <PullToRefreshLayout>(Resource.Id.refresh_view); ptrl.setOnRefreshListener(this); ptrl.AutoRefresh(); }
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e) { CommonAdapter ca = new CommonAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { Label lblCurrency = e.Row.Cells[7].FindControl("lbl_fcurrencyid") as Label; if (!string.IsNullOrEmpty(lblCurrency.Text)) { int currencyID = Int32.Parse(lblCurrency.Text); lblCurrency.Text = ca.getCurrencyByID(currencyID); Label lblDepositAmountForAll = e.Row.Cells[3].FindControl("lbl_amount_all") as Label; if (!string.IsNullOrEmpty(lblDepositAmountForAll.Text)) { DepositAmountForAll += Decimal.Parse(lblDepositAmountForAll.Text); } Label lblPayAmountFor = e.Row.Cells[4].FindControl("lbl_fpayamountfor") as Label; DepositPayAmountforAll += Decimal.Parse(lblPayAmountFor.Text); Label lblUnPayAmountFor = e.Row.Cells[5].FindControl("lbl_funpayamountfor") as Label; DepositUnPayAmountforAll += Decimal.Parse(lblUnPayAmountFor.Text); TextBox lblDepositCheckAmountFor = e.Row.Cells[6].FindControl("txt_deposit_checkamountfor") as TextBox; DepositCheckAmountForAll += Decimal.Parse(lblDepositCheckAmountFor.Text); } } else if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[2].Text = "汇总"; e.Row.Cells[3].Text = DepositAmountForAll.ToString(); //采购订单中金额 e.Row.Cells[4].Text = DepositPayAmountforAll.ToString(); //已支付金额 e.Row.Cells[5].Text = DepositUnPayAmountforAll.ToString(); //未支付金额 e.Row.Cells[6].Text = DepositCheckAmountForAll.ToString(); //单据金额 } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { CommonAdapter ca = new CommonAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { if (!string.IsNullOrEmpty(e.Row.Cells[7].Text) && e.Row.Cells[7].Text != " ") { int currencyID = Int32.Parse(e.Row.Cells[7].Text); e.Row.Cells[7].Text = ca.getCurrencyByID(currencyID); amountforAll += Decimal.Parse(e.Row.Cells[3].Text); payamountforAll += Decimal.Parse(e.Row.Cells[4].Text); unpayamountforAll += Decimal.Parse(e.Row.Cells[5].Text); TextBox tb_fcheckamountfor = e.Row.Cells[6].FindControl("txt_fcheckamountfor") as TextBox; checkamountforAll += Decimal.Parse(tb_fcheckamountfor.Text); } } else if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[2].Text = "汇总"; e.Row.Cells[3].Text = amountforAll.ToString(); //单据金额 e.Row.Cells[4].Text = payamountforAll.ToString(); //已支付金额 e.Row.Cells[5].Text = unpayamountforAll.ToString(); //未支付金额 e.Row.Cells[6].Text = checkamountforAll.ToString(); //单据金额 } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { init(); txt_recetpt_no.Text = LoadLastReceiptID(); d_date.Text = check_date.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); CommonAdapter ca = new CommonAdapter(); int selectedValue = ca.getIDByName(UserInfoAdapter.CurrentUser.Name); ddl_preparer.SelectedValue = ddl_checker.SelectedValue = selectedValue.ToString(); } else { UserInfo user = UserInfoAdapter.CurrentUser; if (Session[user.Name] != null) { ds = (DataSet)Session[user.Name]; Session[user.Name] = null; show(ds, GridView1); } if (Session[user.Name + "InDec"] != null) { ds = (DataSet)Session[user.Name + "InDec"]; Session[user.Name + "InDec"] = null; show(ds, GridView2); initAmount(); } if (Session[user.Name + "Depos"] != null) { ds = (DataSet)Session[user.Name + "Depos"]; Session[user.Name + "Depos"] = null; show(ds, GridView3); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { init(); } else { UserInfo user = UserInfoAdapter.CurrentUser; if (Session[user.Name + "POOrder"] != null) { ds = (DataSet)Session[user.Name + "POOrder"]; Session[user.Name + "POOrder"] = null; show(ds); } } txt_deposit_id.Text = LoadLastDepositId(); amountAll = Decimal.Parse(GridView1.FooterRow.Cells[3].Text); agent_date.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); CommonAdapter ca = new CommonAdapter(); int selectedValue = ca.getIDByName(UserInfoAdapter.CurrentUser.Name); ddl_agenter.SelectedValue = selectedValue.ToString(); }
private void setData(string id) { if (string.IsNullOrEmpty(id)) { return; } PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter(); DataSet head = ida.getInDecreaseHeadByBillNo(id); lbl_customer.Text = head.Tables[0].Rows[0]["customer"].ToString(); lbl_indecrease_id.Text = id; if (!string.IsNullOrEmpty(head.Tables[0].Rows[0]["currencyID"].ToString())) { int currency = Int32.Parse(head.Tables[0].Rows[0]["currencyID"].ToString()); CommonAdapter ca = new CommonAdapter(); lbl_currency.Text = ca.getCurrencyByID(currency); } lbl_agenter.Text = head.Tables[0].Rows[0]["agenter"].ToString(); lbl_agente_date.Text = head.Tables[0].Rows[0]["agent_date"].ToString(); DataSet list = ida.getInDecreaseInfoByBillNo(id); gridviewBind(list); }
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ReceiptAuditAdapter raa = new ReceiptAuditAdapter(); string type = e.Row.Cells[3].Text; e.Row.Cells[3].Text = raa.getTypeNameByCode(type); CommonAdapter ca = new CommonAdapter(); int currencyID = Int32.Parse(e.Row.Cells[6].Text); e.Row.Cells[6].Text = ca.getCurrencyByID(currencyID); //0-未核销,1-部分核销,2-完全核销 int check_status = Int32.Parse(e.Row.Cells[14].Text); switch (check_status) { case 1: e.Row.Cells[14].Text = "部分核销"; break; case 2: e.Row.Cells[14].Text = "完全核销"; break; default: e.Row.Cells[14].Text = "未核销"; break; } int DepartmentID = Int32.Parse(e.Row.Cells[8].Text); e.Row.Cells[8].Text = ca.getDepartmentNameByID(DepartmentID); int EmpID = Int32.Parse(e.Row.Cells[9].Text); e.Row.Cells[9].Text = ca.getEmpNameByID(EmpID); int CheckerID = Int32.Parse(e.Row.Cells[10].Text); e.Row.Cells[10].Text = ca.getEmpNameByID(CheckerID); string auditstatus = e.Row.Cells[13].Text.ToLower(); if (auditstatus == "3") { e.Row.Cells[13].Text = "通过"; Button btnDelete = e.Row.Cells[0].FindControl("btnDelete") as Button; btnDelete.Enabled = false; } else if (auditstatus == "2") { e.Row.Cells[13].Text = "不通过"; } else if (auditstatus == "1") { e.Row.Cells[13].Text = "待审核"; } else { e.Row.Cells[13].Text = "未提交"; } } }
private void ddlDataBind() { CommonAdapter ca = new CommonAdapter(); DropDownList1.DataSource = ca.getTaxReturnState(); DropDownList1.DataTextField = "name"; DropDownList1.DataValueField = "code"; DropDownList1.DataBind(); }
private void bindControls() { comAdaper = new CommonAdapter <ArticleComment>(this, Resource.Layout.comments_list_item, comments); comAdaper.OnGetView += comAdapter_OnGetView; pListView.Adapter = comAdaper; ptrl.setOnRefreshListener(this); btnSend = FindViewById <Button>(Resource.Id.btn_send); btnSend.Click += btnSend_Click; textComments = FindViewById <EditText>(Resource.Id.text_comment); }
private void ddlCurrencyBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getCurrency(); ddl_currency.DataTextField = "FName"; ddl_currency.DataValueField = "FCurrencyID"; ddl_currency.DataSource = ds; ddl_currency.DataBind(); }
private void ddlDepartmentBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getDepartment(); ddl_department.DataTextField = "FName"; ddl_department.DataValueField = "FItemID"; ddl_department.DataSource = ds; ddl_department.DataBind(); }
private void ddlAgenterBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getEmp(); ddl_agenter.DataTextField = "FName"; ddl_agenter.DataValueField = "FItemID"; ddl_agenter.DataSource = ds; ddl_agenter.DataBind(); }
private void delivery_mode_Bind() { CommonAdapter ca = new CommonAdapter(); DropDownList1.DataSource = ca.getDeliveryMode(); DropDownList1.DataTextField = "name"; DropDownList1.DataValueField = "code"; DropDownList1.DataBind(); DropDownList1.SelectedIndex = 0; }
private void button2_Click(object sender, EventArgs e) { var buff = Image.FromFile(openFileDialog1.FileName).GetBuffer(); using (var adp = new CommonAdapter()) { string fileName = Path.GetFileName(openFileDialog1.FileName); adp.spAddImage(fileName, buff, 1); } productsTableAdapter.AddProduct(dataSet.Products, Convert.ToInt32(comboBoxCategory.SelectedValue), Convert.ToInt32(comboBoxBrand.SelectedValue), Convert.ToInt32(comboBoxModel.SelectedValue), Convert.ToInt32(numericUpDownPrice.Value), 1); this.productsTableAdapter.Fill(this.dataSet.Products); }
private void ddlDataBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getTaxReturnState(); DataRow dr = ds.Tables[0].NewRow(); dr["name"] = "请选择"; dr["code"] = ""; ds.Tables[0].Rows.InsertAt(dr, 0); DropDownList1.DataSource = ds; DropDownList1.DataTextField = "name"; DropDownList1.DataValueField = "code"; DropDownList1.DataBind(); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { CommonAdapter ca = new CommonAdapter(); int currencyID = 1; if (!string.IsNullOrEmpty(e.Row.Cells[3].Text) && e.Row.Cells[3].Text != " ") { currencyID = Int32.Parse(e.Row.Cells[3].Text); } e.Row.Cells[3].Text = ca.getCurrencyByID(currencyID); } }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { int index = GridView1.SelectedIndex; GridViewRow gvr = GridView1.SelectedRow; txt_account_id.Text = gvr.Cells[3].Text; txt_account_name.Text = gvr.Cells[1].Text; txt_opening_bank.Text = gvr.Cells[2].Text; HiddenField1.Value = gvr.Cells[3].Text; txt_amount.Text = gvr.Cells[5].Text; CommonAdapter ca = new CommonAdapter(); ddl_currency.SelectedValue = ca.getIDByCurrency(gvr.Cells[4].Text).ToString(); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.my_posts); InitalComponents(); SetPageTitle("我的博客"); comAdaper = new CommonAdapter <Article>(this, Resource.Layout.blogger_article_list_item, articles); comAdaper.OnGetView += comAdapter_OnGetView; pListView.Adapter = comAdaper; pListView.ItemClick += pListView_ItemClick; ptrl = FindViewById <PullToRefreshLayout>(Resource.Id.refresh_view); ptrl.setOnRefreshListener(this); ptrl.AutoRefresh(); }
private void btnSetImage_Click(object sender, EventArgs e) { if (fileDialog.ShowDialog() == DialogResult.OK) { var buff = Image.FromFile(fileDialog.FileName).GetBuffer(); using (var adp = new CommonAdapter()) { string fileName = Path.GetFileName(fileDialog.FileName); adp.spAddImage(fileName, buff, 1); //todo add userid this.productsTableAdapter.Fill(this.contactHomeDataSet.Products); this.vwFilesTableAdapter.Fill(this.contactHomeDataSet.VwFiles); } } }
public void DropDownListBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getXuFang(); DataRow dr = ds.Tables[0].NewRow(); dr["company_name"] = "请选择"; dr["id"] = 0; ds.Tables[0].Rows.InsertAt(dr, 0); ddlModel.DataSource = ds; ddlModel.DataTextField = "company_name"; ddlModel.DataValueField = "id"; ddlModel.DataBind(); }
public void ddlGongFangBind() { CommonAdapter ca = new CommonAdapter(); DataSet ds = ca.getCustomers(); DataRow dr = ds.Tables[0].NewRow(); dr["company_name"] = "请选择"; dr["id"] = 0; ds.Tables[0].Rows.InsertAt(dr, 0); ddlGongFang.DataSource = ds; ddlGongFang.DataTextField = "company_name"; ddlGongFang.DataValueField = "id"; ddlGongFang.DataBind(); }
private DataView InnerQuery(int startRowIndex, int maximumRows, string where, string orderBy, ref int totalCount) { QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, "*", this._DefaultTableName, orderBy, where); OnBuildQueryCondition(qc); CommonAdapter adapter = new CommonAdapter(GetConnectionName()); DataView result = adapter.SplitPageQuery(qc, ref totalCount); ObjectContextCache.Instance[ContextCacheKey] = totalCount; return result; }
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { View view = inflater.Inflate(Resource.Layout.article_fragment_page, container, false); InitalComponents(); plistView = view.FindViewById <PullableListView>(Resource.Id.lv_articles); comAdaper = new CommonAdapter <NewInfo>(this.Activity, Resource.Layout.new_list_item, news); comAdaper.OnGetView += comAdapter_OnGetView; plistView.Adapter = comAdaper; plistView.ItemClick += plistView_ItemClick; ptrl = view.FindViewById <PullToRefreshLayout>(Resource.Id.refresh_view); ptrl.setOnRefreshListener(this); ptrl.AutoRefresh(); return(view); }
private static WfClientUserOperationLogPageQueryResult QueryUserOperationLog(QueryCondition qc, int totalCount) { CommonAdapter adapter = new CommonAdapter(UserOperationLogAdapter.Instance.ConnectionName); UserOperationLogCollection serverLogs = adapter.SplitPageQuery <UserOperationLog, UserOperationLogCollection>(qc, ref totalCount); WfClientUserOperationLogCollection clientLogs = WfClientUserOperationLogConverter.Instance.ServerToClient(serverLogs); WfClientUserOperationLogPageQueryResult result = new WfClientUserOperationLogPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientLogs); return(result); }
private void HeadBind() { string account_id = ddl_account.SelectedValue; AccountLogAdapter ala = new AccountLogAdapter(); DataSet ds = ala.getAccount(account_id); DataRow dr = ds.Tables[0].Rows[0]; lbl_account_id.Text = dr["account_id"].ToString(); lbl_account_name.Text = dr["account_name"].ToString(); lbl_opening_bank.Text = dr["opening_bank"].ToString(); CommonAdapter ca = new CommonAdapter(); int currencyID = Int32.Parse(dr["currencyID"].ToString()); lbl_currency.Text = ca.getCurrencyByID(currencyID); lbl_amount.Text = dr["amount"].ToString(); }
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string currencyId = e.Row.Cells[3].Text; CommonAdapter ca = new CommonAdapter(); e.Row.Cells[3].Text = ca.getCurrencyByID(Int32.Parse(currencyId)); HiddenField hnfCheckStatus = e.Row.Cells[0].FindControl("hnf_check_status") as HiddenField; int check_status = Int32.Parse(hnfCheckStatus.Value); if (check_status == 2) { Button btn_delete = e.Row.Cells[0].FindControl("btnDelete") as Button; btn_delete.Enabled = false; } } }
public WfClientProcessDescriptorInfoPageQueryResult QueryProcessDescriptorInfo(int startRowIndex, int maximumRows, string where, string orderBy, int totalCount) { OperationContext.Current.FillContextToOguServiceContext(); if (orderBy.IsNullOrEmpty()) { orderBy = "MODIFY_TIME DESC"; } string selectFields = "PROCESS_KEY, APPLICATION_NAME, PROGRAM_NAME, PROCESS_NAME, ENABLED, CREATE_TIME, CREATOR_ID, CREATOR_NAME, MODIFY_TIME, MODIFIER_ID, MODIFIER_NAME, IMPORT_TIME, IMPORT_USER_ID, IMPORT_USER_NAME"; QueryCondition qc = new QueryCondition( startRowIndex, maximumRows, selectFields, ORMapping.GetMappingInfo(typeof(WfProcessDescriptorInfo)).TableName, orderBy); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); builder.AppendTenantCode(); if (where.IsNotEmpty()) { where += " AND "; } where += builder.ToSqlString(TSqlBuilder.Instance); qc.WhereClause = where; CommonAdapter adapter = new CommonAdapter(WfProcessDescriptorInfoAdapter.Instance.ConnectionName); WfProcessDescriptorInfoCollection processInfo = adapter.SplitPageQuery <WfProcessDescriptorInfo, WfProcessDescriptorInfoCollection>(qc, ref totalCount); WfClientProcessDescriptorInfoCollection clientInfo = new WfClientProcessDescriptorInfoCollection(); WfClientProcessDescriptorInfoConverter.Instance.ServerToClient(processInfo, clientInfo); WfClientProcessDescriptorInfoPageQueryResult result = new WfClientProcessDescriptorInfoPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientInfo); return(result); }
private static WfClientProcessCurrentInfoPageQueryResult QueryProcessInfo(QueryCondition qc, int totalCount) { CommonAdapter adapter = new CommonAdapter(WfProcessCurrentInfoAdapter.Instance.ConnectionName); WfProcessCurrentInfoCollection processInfo = adapter.SplitPageQuery <WfProcessCurrentInfo, WfProcessCurrentInfoCollection>(qc, ref totalCount); WfClientProcessCurrentInfoCollection clientInfo = new WfClientProcessCurrentInfoCollection(); WfClientProcessCurrentInfoConverter.Instance.ServerToClient(processInfo, clientInfo); WfClientProcessCurrentInfoPageQueryResult result = new WfClientProcessCurrentInfoPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientInfo); return(result); }
private static WfClientProcessCurrentInfoPageQueryResult QueryProcessInfo(QueryCondition qc, int totalCount) { CommonAdapter adapter = new CommonAdapter(WfProcessCurrentInfoAdapter.Instance.ConnectionName); WfProcessCurrentInfoCollection processInfo = adapter.SplitPageQuery<WfProcessCurrentInfo, WfProcessCurrentInfoCollection>(qc, ref totalCount); WfClientProcessCurrentInfoCollection clientInfo = new WfClientProcessCurrentInfoCollection(); WfClientProcessCurrentInfoConverter.Instance.ServerToClient(processInfo, clientInfo); WfClientProcessCurrentInfoPageQueryResult result = new WfClientProcessCurrentInfoPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientInfo); return result; }
private static WfClientUserOperationLogPageQueryResult QueryUserOperationLog(QueryCondition qc, int totalCount) { CommonAdapter adapter = new CommonAdapter(UserOperationLogAdapter.Instance.ConnectionName); UserOperationLogCollection serverLogs = adapter.SplitPageQuery<UserOperationLog, UserOperationLogCollection>(qc, ref totalCount); WfClientUserOperationLogCollection clientLogs = WfClientUserOperationLogConverter.Instance.ServerToClient(serverLogs); WfClientUserOperationLogPageQueryResult result = new WfClientUserOperationLogPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientLogs); return result; }
public DataSet Query(int startRowIndex, int maximumRows, string connection, string tableName, string selectFields, string where, string orderBy, ref int totalCount) { QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, selectFields, tableName, orderBy, where); //OnBuildQueryCondition(qc); CommonAdapter adapter = new CommonAdapter(connection); DataSet result = adapter.SplitPageQuery(qc, totalCount <= 0); if (result.Tables.Count > 1) totalCount = (int)result.Tables[1].Rows[0][0]; var contextCacheKey = connection + "." + tableName + ".Query"; ObjectContextCache.Instance[contextCacheKey] = totalCount; //当页码超出索引的,返回最大页 if (result.Tables[0].Rows.Count == 0 && totalCount > 0) { int newStartRowIndex = (totalCount - 1) / maximumRows * maximumRows; totalCount = -1; result = Query(newStartRowIndex, maximumRows, connection, tableName, selectFields, where, orderBy, ref totalCount); } return result; }
public WfClientProcessDescriptorInfoPageQueryResult QueryProcessDescriptorInfo(int startRowIndex, int maximumRows, string where, string orderBy, int totalCount) { OperationContext.Current.FillContextToOguServiceContext(); if (orderBy.IsNullOrEmpty()) orderBy = "MODIFY_TIME DESC"; string selectFields = "PROCESS_KEY, APPLICATION_NAME, PROGRAM_NAME, PROCESS_NAME, ENABLED, CREATE_TIME, CREATOR_ID, CREATOR_NAME, MODIFY_TIME, MODIFIER_ID, MODIFIER_NAME, IMPORT_TIME, IMPORT_USER_ID, IMPORT_USER_NAME"; QueryCondition qc = new QueryCondition( startRowIndex, maximumRows, selectFields, ORMapping.GetMappingInfo(typeof(WfProcessDescriptorInfo)).TableName, orderBy); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); builder.AppendTenantCode(); if (where.IsNotEmpty()) where += " AND "; where += builder.ToSqlString(TSqlBuilder.Instance); qc.WhereClause = where; CommonAdapter adapter = new CommonAdapter(WfProcessDescriptorInfoAdapter.Instance.ConnectionName); WfProcessDescriptorInfoCollection processInfo = adapter.SplitPageQuery<WfProcessDescriptorInfo, WfProcessDescriptorInfoCollection>(qc, ref totalCount); WfClientProcessDescriptorInfoCollection clientInfo = new WfClientProcessDescriptorInfoCollection(); WfClientProcessDescriptorInfoConverter.Instance.ServerToClient(processInfo, clientInfo); WfClientProcessDescriptorInfoPageQueryResult result = new WfClientProcessDescriptorInfoPageQueryResult(); result.TotalCount = totalCount; result.QueryResult.CopyFrom(clientInfo); return result; }
/// <summary> /// 表单分页查询 /// </summary> /// <param name="startRowIndex"></param> /// <param name="maximumRows"></param> /// <param name="where"></param> /// <param name="orderBy"></param> /// <param name="totalCount"></param> /// <returns></returns> public AppCommonInfoCollection GetFormQueryWithCount(int startRowIndex, int maximumRows, string where, string orderBy, ref int totalCount) { if (string.IsNullOrEmpty(where)) where = "1 = 1"; if (string.IsNullOrEmpty(orderBy)) orderBy = "CREATE_TIME DESC"; if (RolesDefineConfig.GetConfig().IsCurrentUserInRoles("ProcessAdmin") == false) { ConnectiveSqlClauseCollection cscc = WfAclAdapter.Instance.GetAclQueryConditionsByUser(string.Empty); string resourceIDList = string.Format("SELECT RESOURCE_ID FROM WF.ACL WHERE {0}", cscc.ToSqlString(TSqlBuilder.Instance)); where = string.Format("{0} AND ACI.RESOURCE_ID IN ({1})", where, resourceIDList); } //LDM 加上ACI.PROGRAM_NAME as [PROGRAM_NAME1], //兼容远洋地产的查询(表单工作程序里没有对 APPLICATIONFORM_INFO 表插入数据行) string strSelect = @" ACI.APPLICATION_NAME,ACI.[PROGRAM_NAME] as [PROGRAM_NAME_MCS],ACI.RESOURCE_ID,ACI.[SUBJECT],ACI.[EMERGENCY]," + " ACI.URL,ACI.CREATOR_ID, ACI.CREATOR_NAME,ACI.CREATE_TIME,ACI.DRAFT_DEPARTMENT_NAME"; string strfrom = @" WF.APPLICATIONS_COMMON_INFO as ACI (nolock)"; QueryCondition qc = new QueryCondition( startRowIndex, maximumRows, strSelect, strfrom, orderBy, where ); CommonAdapter commonAdapter = new CommonAdapter(ConnectionDefine.SearchConnectionName); DataSet ds = commonAdapter.SplitPageQuery(qc, totalCount < 0); AppCommonInfoCollection FormQueryEntitys = new AppCommonInfoCollection(); foreach (DataRow row in ds.Tables[0].Rows) { AppCommonInfo entity = new AppCommonInfo(); ORMapping.DataRowToObject(row, entity); FormQueryEntitys.Add(entity); } if (ds.Tables.Count > 1) totalCount = (int)ds.Tables[1].Rows[0][0]; HttpContext.Current.Items["UserFormQueryEntityCount"] = totalCount; //当页码超出索引的,返回最大页 if (FormQueryEntitys.Count == 0 && totalCount > 0) { int newStartRowIndex = (totalCount - 1) / maximumRows * maximumRows; totalCount = -1; FormQueryEntitys = GetFormQueryWithCount(newStartRowIndex, maximumRows, where, orderBy, ref totalCount); } return FormQueryEntitys; }