private void InitResource() { if (string.IsNullOrEmpty(this.trvwResourceType.SelectedValue)) { using (pm2Entities pm2Entities = new pm2Entities()) { string typeId = ( from t in pm2Entities.Res_ResourceType where t.ResourceTypeCode == this.dropResourceType.SelectedValue select t.ResourceTypeId).FirstOrDefault <string>(); cn.justwin.BLL.Resource resource = new cn.justwin.BLL.Resource(); //DataTable resource2 = resource.GetResource(typeId, this.pagesize3, this.AspNetPager1.CurrentPageIndex, this.txtCode.Text.Trim(), this.txtName.Text.Trim()); //this.AspNetPager1.RecordCount = resource.GetResourceCount(typeId, this.txtCode.Text.Trim(), this.txtName.Text.Trim()); DataTable resource2 = resource.GetResource(typeId, this.pagesize3, this.AspNetPager1.CurrentPageIndex, this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtModelNumber.Text.Trim()); this.AspNetPager1.RecordCount = resource.GetResourceCount(typeId, this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtModelNumber.Text.Trim()); this.gvwResource.DataSource = resource2; this.gvwResource.DataBind(); return; } } cn.justwin.BLL.Resource resource3 = new cn.justwin.BLL.Resource(); DataTable resourceByRerourceType = resource3.GetResourceByRerourceType(this.trvwResourceType.SelectedValue, this.pagesize3, this.AspNetPager1.CurrentPageIndex, this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtModelNumber.Text.Trim()); this.AspNetPager1.RecordCount = resource3.GetResourceCoutByResourceType(this.trvwResourceType.SelectedValue, this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtModelNumber.Text.Trim()); this.gvwResource.DataSource = resourceByRerourceType; this.gvwResource.DataBind(); }
private void InitAspNetPager() { System.DateTime arg_05_0 = System.DateTime.Now; this.txtCode.Text = string.Empty; this.txtName.Text = string.Empty; this.txtSpecification.Text = string.Empty; this.txtModelNumber.Text = string.Empty; this.AspNetPager1.PageSize = this.pagesize3; this.AspNetPager1.CurrentPageIndex = 1; if (string.IsNullOrEmpty(this.trvwResourceType.SelectedValue)) { using (pm2Entities pm2Entities = new pm2Entities()) { string typeId = ( from t in pm2Entities.Res_ResourceType where t.ResourceTypeCode == this.dropResourceType.SelectedValue select t.ResourceTypeId).FirstOrDefault <string>(); cn.justwin.BLL.Resource resource = new cn.justwin.BLL.Resource(); this.AspNetPager1.RecordCount = resource.GetResourceCount(typeId, string.Empty, string.Empty, string.Empty, string.Empty); goto IL_1B3; } } cn.justwin.BLL.Resource resource2 = new cn.justwin.BLL.Resource(); this.AspNetPager1.RecordCount = resource2.GetResourceCoutByResourceType(this.trvwResourceType.SelectedValue, this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtModelNumber.Text.Trim()); IL_1B3: System.DateTime arg_1B8_0 = System.DateTime.Now; }
public string GetColumnName(string dbcolumn) { string result = ""; DataTable resourceColumn = new cn.justwin.BLL.Resource().GetResourceColumn(); foreach (DataRow dataRow in resourceColumn.Rows) { if (System.Convert.ToString(dataRow["name"]) == dbcolumn) { result = System.Convert.ToString(dataRow["value"]); } } return(result); }
public void BindGv() { if (!string.IsNullOrEmpty(base.Request["id"].ToString())) { string strWhere = "AND r.ResourceId IN ( select CID from Res_ResourceRelation where FID='" + base.Request["id"].ToString() + "')"; //string strWhere = " AND r.ResourceId IN ('067ef1eb-3386-4a00-8133-d33154337057','0842da52-2cf1-40ba-86e4-058a1e8fc16d')"; cn.justwin.BLL.Resource resource = new cn.justwin.BLL.Resource(); DataTable table = resource.Query(this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex, strWhere, "");//string condition, string priceTypeCondition); System.Collections.Generic.IList <PriceType> priceTypes = PriceType.GetPriceTypes(base.UserCode); if (this.gvResource.Columns.Count < 14 + priceTypes.Count) { int num = 9; foreach (PriceType current in priceTypes) { BoundField boundField = new BoundField(); boundField.DataField = current.PriceTypeName; boundField.HeaderText = current.PriceTypeName; this.gvResource.Columns.Insert(num++, boundField); } } //table.Columns.Remove("采购价"); //table.Columns.Remove("目标成本价"); //table.Columns.Remove("最后采购价"); table.Columns.Add("NUM"); foreach (DataRow dr in table.Rows) { DataTable dt = publicDbOpClass.DataTableQuary("select NUM from Res_ResourceRelation where CID ='" + dr["ResourceId"].ToString() + "' and FID='" + base.Request["id"].ToString() + "'"); if (dt.Rows.Count == 1) { dr["NUM"] = dt.Rows[0]["NUM"]; } else { dr["NUM"] = "0"; } } this.gvResource.DataSource = table; this.gvResource.DataBind(); } else { this.gvResource.DataSource = null; this.gvResource.DataBind(); } }
private void InitResource(string resources) { if (!string.IsNullOrEmpty(resources)) { ISerializable serializable = new cn.justwin.Serialize.JsonSerializer(); string[] array = serializable.Deserialize <string[]>(resources); if (array != null) { cn.justwin.BLL.Resource resource = new cn.justwin.BLL.Resource(); DataTable resource2 = resource.GetResource(array); DataColumn dataColumn = new DataColumn("sprice", typeof(decimal)); dataColumn.DefaultValue = 0.000m; DataColumn dataColumn2 = new DataColumn("number", typeof(decimal)); dataColumn2.DefaultValue = 0m; DataColumn dataColumn3 = new DataColumn("Total", typeof(decimal)); dataColumn3.DefaultValue = 0m; DataColumn dataColumn4 = new DataColumn("pscode", typeof(string)); dataColumn4.DefaultValue = string.Empty; resource2.Columns.Add(dataColumn4); DataColumn dataColumn5 = new DataColumn("ModifyStockId", typeof(string)); dataColumn5.DefaultValue = string.Empty; resource2.Columns.Add(dataColumn5); resource2.Columns.Add(dataColumn2); resource2.Columns.Add(dataColumn); resource2.Columns.Add(dataColumn3); string conPurchasePcode = this.purchase.GetConPurchasePcode(this.contractId); List <string> resourceNumber = this.GetResourceNumber(); for (int i = 0; i < resource2.Rows.Count; i++) { DataRow dataRow = resource2.Rows[i]; dataRow["pscode"] = conPurchasePcode; try { dataRow["number"] = Convert.ToDecimal(resourceNumber[i]); } catch { } } DataColumn dataColumn6 = new DataColumn("corp", typeof(string)); dataColumn6.DefaultValue = this.hfldBId.Value; resource2.Columns.Add(dataColumn6); DataColumn dataColumn7 = new DataColumn("CorpName", typeof(string)); dataColumn7.DefaultValue = this.GetCorpName(this.hfldBId.Value); resource2.Columns.Add(dataColumn7); if (this.ViewState["resource"] == null) { this.ViewState["resource"] = resource2; } else { DataTable dataTable = this.ViewState["resource"] as DataTable; for (int j = 0; j < dataTable.Rows.Count; j++) { DataRow dataRow2 = dataTable.Rows[j]; for (int k = 0; k < array.Length; k++) { if (dataRow2["ResourceId"].ToString() == array[k]) { try { dataRow2["number"] = resourceNumber[k]; } catch { } } } } dataTable = this.MergeDataTable(dataTable, resource2); } this.DataBindPurchaseplanStock(); } } }