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();
}
}
}
