/// <summary> /// 设置Grid的colModel的内容 /// </summary> /// <returns></returns> public string GetColumnSettings() { string strSettings = ""; string strColumnNames = ""; List<JqGridColumns> ColumnList = new List<JqGridColumns>(); JqGridColumns NameColumns = new JqGridColumns(); NameColumns.name = "NodeName"; NameColumns.index = "NodeName"; NameColumns.width = "80"; ColumnList.Add(NameColumns); JqGridColumns CodeColumns = new JqGridColumns(); CodeColumns.name = "NodeCode"; CodeColumns.index = "NodeCode"; CodeColumns.width = "80"; ColumnList.Add(CodeColumns); JqGridColumns ValueColumns = new JqGridColumns(); ValueColumns.name = "NodeValue"; ValueColumns.index = "NodeValue"; ValueColumns.width = "80"; ColumnList.Add(ValueColumns); for (int i = 0; i < 3; i++) { JqGridColumns currentColumn = ColumnList[i]; strSettings += "{ \"name\": \"" + currentColumn.name + "\",\"index\": \"" + currentColumn.index + "\",\"width\": \"" + currentColumn.width + "\"},"; strColumnNames += "\"" + currentColumn.name + "\","; } strSettings = "[" + strSettings.Substring(0, strSettings.Length - 1) +"]"+ "!" +"["+ strColumnNames.Substring(0, strColumnNames.Length - 1) + "]"; return strSettings; }
public string GetColumnSettings() { string strSettings = ""; string strColumnNames = ""; Guid skuGid = selectedProductSKUGuid; Guid orgId = organizationGuid; GeneralMeasureUnit oGeneralMesureUnit = new GeneralMeasureUnit(); //取出组织所对应的货币,取自MemberOrgCulture List<MemberOrgCulture> oMemberOrgCulture = dbEntity.MemberOrgCultures.Include("Currency").Where(p => p.OrgID == orgId && p.Ctype == 1 && p.aCurrency != Guid.Empty).OrderBy(p => p.Sorting).ToList(); //根据取出的货币数,生成货币的columnmodel List<JqGridColumns> listColumnModel = new List<JqGridColumns>(); int nMemberCultureListCount = oMemberOrgCulture.Count; for (int i = 0; i < nMemberCultureListCount; i++) { JqGridColumns oColumnModel = new JqGridColumns(); oColumnModel.name = oMemberOrgCulture.ElementAt(i).Currency.Code + LiveAzure.Resource.Model.Product.ProductOnUnitPrice.MarketPrice + "|" + LiveAzure.Resource.Model.Product.ProductOnUnitPrice.SalePrice; oColumnModel.index = oMemberOrgCulture.ElementAt(i).Currency.Code; oColumnModel.width = "80"; oColumnModel.align = "center"; listColumnModel.Add(oColumnModel); } //除了自动生成的货币列之外,还有必然存在的三列 + ISDEFAULT //显示计量单位,即销售的计量单位 JqGridColumns standardColumn = new JqGridColumns(); standardColumn.name = LiveAzure.Resource.Model.Product.ProductInfoItem.StdUnit;// "StdUnit"; standardColumn.index = "StdUnit"; standardColumn.width = "40"; standardColumn.align = "center"; listColumnModel.Add(standardColumn); //转换比率 JqGridColumns unitRadioColumn = new JqGridColumns(); unitRadioColumn.name = LiveAzure.Resource.Model.Product.ProductOnUnitPrice.UnitRatio;//"UnitRatio"; unitRadioColumn.index = "UnitRatio"; unitRadioColumn.width = "20"; unitRadioColumn.align = "right"; listColumnModel.Add(unitRadioColumn); //计量精度 JqGridColumns percisionColumn = new JqGridColumns(); percisionColumn.name = LiveAzure.Resource.Model.Product.ProductOnUnitPrice.Percision;//"Percision"; percisionColumn.index = "Percision"; percisionColumn.width = "10"; percisionColumn.align = "right"; listColumnModel.Add(percisionColumn); //IsDefault JqGridColumns isDefaultColumn = new JqGridColumns(); isDefaultColumn.name = LiveAzure.Resource.Model.Product.ProductOnUnitPrice.IsDefault;//"Percision"; isDefaultColumn.index = "isDefault"; isDefaultColumn.width = "10"; isDefaultColumn.align = "center"; listColumnModel.Add(isDefaultColumn); //======================================================================================================= for (int i = 0; i < listColumnModel.Count; i++) { JqGridColumns currentColumn = listColumnModel.ElementAt(i); strSettings += "{ \"name\": \"" + currentColumn.name + "\",\"index\": \"" + currentColumn.index + "\",\"width\": \"" + currentColumn.width + "\",\"align\": \"" + currentColumn.align + "\"},"; strColumnNames += "\"" + currentColumn.name + "\","; } strSettings = "[" + "{ \"name\": \"Gid\",\"index\": \"Gid\",\"width\": \"80\" , \"hidden\":true},{\"name\": \"" + LiveAzure.Resource.Model.Product.ProductOnUnitPrice.ShowUnit + "\",\"index\": \"ShowUnit\",\"width\": \"80\"}," + strSettings.Substring(0, strSettings.Length - 1) + "]" + "!" + "[" + "\"Gid\"," + "\"" + LiveAzure.Resource.Model.Product.ProductOnUnitPrice.ShowUnit + "\"," + strColumnNames.Substring(0, strColumnNames.Length - 1) + "]"; return strSettings; }