/// <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;
}
