public void Search()
{
if (UserInfoDto.RoleType == "R" && string.IsNullOrEmpty(btnShopCode.Text))
{
CommonHandler.ShowMessage(MessageType.Information, "请选择经销商");
return;
}
grcShopScore.DataSource = null;
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string shopCode = btnShopCode.Text;
bool scoreChk = chkScore.Checked;
bool photoScoreChk = chkPhotoScore.Checked;
bool mScoreChk = chkMScore.Checked;
bool lossCheck = chkLoss.Checked;
string province = txtProvince.Text.Trim();
string city = txtCity.Text.Trim();
string group = txtGroup.Text.Trim();
string salesOrAfterSales = txtSalesOrAftersales.Text.Trim();
string carType = txtCarType.Text.Trim();
List <TwoLevelColumnInfo> columnInfoList = SearchHead(projectCode, scoreChk, lossCheck);
List <SalesConsultantReportBodyDto> dataList = SearchBodyData(projectCode, province, city, group, salesOrAfterSales, carType, shopCode, scoreChk, lossCheck);
List <SalesConsultantReportDto> leftList = SearchLeft(projectCode, province, city, group, salesOrAfterSales, carType, shopCode);
DynamicColumnDataSet <TwoLevelColumnInfo, SalesConsultantReportBodyDto, SalesConsultantReportDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, SalesConsultantReportBodyDto, SalesConsultantReportDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, SalesConsultantReportBodyDto, SalesConsultantReportDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, SalesConsultantReportDto>(grvShopScore, list.ColumnInfoList, list.DtoList);
grvShopScore.LeftCoord = 0;
}
public void Search()
{
if (UserInfoDto.RoleType == "R" && string.IsNullOrEmpty(btnShopCode.Text))
{
CommonHandler.ShowMessage(MessageType.Information, "请选择经销商");
return;
}
grcShopScore.DataSource = null;
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string shopCode = btnShopCode.Text;
bool scoreChk = chkScore.Checked;
bool photoScoreChk = chkPhotoScore.Checked;
bool mScoreChk = chkMScore.Checked;
bool lossCheck = chkLoss.Checked;
string province = txtProvince.Text.Trim();
string city = txtCity.Text.Trim();
string group = txtGroup.Text.Trim();
string salesOrAfterSales = txtSalesOrAftersales.Text.Trim();
string carType = txtCarType.Text.Trim();
List <TwoLevelColumnInfo> columnInfoList = SearchHead(projectCode, shopCode, province, city, group, salesOrAfterSales, carType, lossCheck, scoreChk, photoScoreChk, mScoreChk);
List <ShopScoreBodyDto> dataList = SearchBodyData(projectCode, shopCode, province, city, group, salesOrAfterSales, carType, lossCheck, scoreChk, photoScoreChk, mScoreChk);
List <ShopScoreInfoDto> leftList = SearchLeft(projectCode);
DynamicColumnDataSet <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, ShopScoreInfoDto>(grvShopScore, list.ColumnInfoList, list.DtoList);
foreach (GridColumn col in grvShopScore.Columns)
{
for (int i = 0; i < grvShopScore.RowCount; i++)
{
if (col.Caption != "失分说明")
{
if ((grvShopScore.GetRowCellValue(i, col) == null || grvShopScore.GetRowCellValue(i, col).ToString() == ""))
{
grvShopScore.SetRowCellValue(i, col, "--");
}
}
else
{
if (grvShopScore.GetRowCellValue(i, col) != null && grvShopScore.GetRowCellValue(i, col).ToString() == "@@")
{
grvShopScore.SetRowCellValue(i, col, "");
}
}
}
}
grvShopScore.LeftCoord = 0;
}
public static Dictionary <int, GridColumn> BuildDynamicColumn <ColumnInfoType, DtoType>(BandedGridView gridView, List <ColumnInfoType> columnInfoList, List <DtoType> dtoList)
where ColumnInfoType : DynamicColumnInfo
where DtoType : BufferColumnDto
{
gridView.BeginUpdate();
gridView.GridControl.DataSource = null;
ArrayList bandCollection = new ArrayList(gridView.Bands);
GridBand band = null;
for (int i = 0; i < bandCollection.Count; i++)
{
band = (GridBand)bandCollection[i];
if (band.Name.StartsWith(DynamicColumnInfo.UNIQUE_NAME_PREFIX))
{
gridView.Bands.Remove(band);
}
}
ArrayList columnCollection = new ArrayList(gridView.Columns);
BandedGridColumn column = null;
for (int i = 0; i < columnCollection.Count; i++)
{
column = (BandedGridColumn)columnCollection[i];
if (column.Name.StartsWith(DynamicColumnInfo.UNIQUE_NAME_PREFIX))
{
gridView.Columns.Remove(column);
}
}
DynamicColumnUtil.SortDynamicColumnInfo <ColumnInfoType>(columnInfoList);
Dictionary <int, GridColumn> columnDic = new Dictionary <int, GridColumn>();
foreach (DynamicColumnInfo columnInfo in columnInfoList)
{
AddBandAndColumn(gridView, columnDic, columnInfo);
}
gridView.EndUpdate();
gridView.GridControl.DataSource = dtoList;
return(columnDic);
}
public void Search()
{
grcShopScore.DataSource = null;
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string shopCode = btnShopCode.Text;
bool lossCheck = chkLoss.Checked;
bool recheck = chkRecheck.Checked;
bool all = chkAll.Checked;
List <TwoLevelColumnInfo> columnInfoList = SearchHead(projectCode, shopCode);
List <ShopScoreBodyDto> dataList = SearchBodyData(projectCode, shopCode, lossCheck, recheck, all);
List <ShopScoreInfoDto> leftList = SearchLeft(projectCode);
DynamicColumnDataSet <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, ShopScoreBodyDto, ShopScoreInfoDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
//BindGrid
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, ShopScoreInfoDto>(grvShopScore, list.ColumnInfoList, list.DtoList);
//foreach(DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn
foreach (GridColumn col in grvShopScore.Columns)
{
for (int i = 0; i < grvShopScore.RowCount; i++)
{
if (grvShopScore.GetRowCellValue(i, col) == null || grvShopScore.GetRowCellValue(i, col).ToString() == "")
{
grvShopScore.SetRowCellValue(i, col, "--");
}
}
//RepositoryItemTextEdit textBox = new RepositoryItemTextEdit();
//((System.ComponentModel.ISupportInitialize)(textBox)).BeginInit();
//this.grcShopScore.RepositoryItems.Add(textBox);
//textBox.Properties.NullText = "--";
//col.ColumnEdit = textBox;
//((System.ComponentModel.ISupportInitialize)(textBox)).EndInit();
}
grvShopScore.LeftCoord = 0;
}
public void Search()
{
grcShopScore.DataSource = null;
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string type = chkArea.Checked?"BigArea":"";
List <TwoLevelColumnInfo> columnInfoList = SearchHead(type);
List <InspectionStandardReportBodyDto> dataList = SearchBodyData(projectCode, type);
List <InspectionStandardReportDto> leftList = SearchLeft(projectCode);
DynamicColumnDataSet <TwoLevelColumnInfo, InspectionStandardReportBodyDto, InspectionStandardReportDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, InspectionStandardReportBodyDto, InspectionStandardReportDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, InspectionStandardReportBodyDto, InspectionStandardReportDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, InspectionStandardReportDto>(grvShopScore, list.ColumnInfoList, list.DtoList);
grvShopScore.LeftCoord = 0;
}
public override void SearchButtonClick()
{
grcWeightRate.DataSource = null;
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string shopCode = tbnShop.Text;
List <TwoLevelColumnInfo> columnInfoList = SearchHead(projectCode, shopCode);
List <ScoreWeigthBodayRateDto> dataList = SearchBodyData(projectCode, tbnChapter.Text, shopCode, true, chkFCheck.Checked);
List <ScoreWeigthRateDto> leftList = SearchLeft(projectCode, tbnChapter.Text, chkFCheck.Checked);
DynamicColumnDataSet <TwoLevelColumnInfo, ScoreWeigthBodayRateDto, ScoreWeigthRateDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, ScoreWeigthBodayRateDto, ScoreWeigthRateDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, ScoreWeigthBodayRateDto, ScoreWeigthRateDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
//BindGrid
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, ScoreWeigthRateDto>(grvWeightRate, list.ColumnInfoList, list.DtoList);
grvWeightRate.LeftCoord = 0;
}
void webService_SearchFinallyScoreRateCompleted(object sender, XHX.localhost.SearchFinallyScoreRateCompletedEventArgs e)
{
try
{
#region FinallyWeight
DataSet[][] allResult = e.Result;
DataSet[] result = allResult[0];
DataSet leftDataSet = result[2];
DataSet bodyDataDataSet = result[1];
DataSet headDataSet = result[0];
#region Head
List <TwoLevelColumnInfo> columnInfoList = new List <TwoLevelColumnInfo>();
if (headDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < headDataSet.Tables[0].Rows.Count; i++)
{
TwoLevelColumnInfo info = new TwoLevelColumnInfo();
info.Column1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column2"]);
info.Caption1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption1"]);
info.Caption2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption2"]);
info.Order = Convert.ToInt32(headDataSet.Tables[0].Rows[i]["Order"]);
columnInfoList.Add(info);
}
}
#endregion
#region Data
List <FinallyScoreRateBodyDto> dataList = new List <FinallyScoreRateBodyDto>();
if (bodyDataDataSet.Tables.Count > 0 && bodyDataDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < bodyDataDataSet.Tables[0].Rows.Count; i++)
{
FinallyScoreRateBodyDto info = new FinallyScoreRateBodyDto();
info.Column1 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column2"]);
info.ChapterCode = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["CharterCode"]);
if (bodyDataDataSet.Tables[0].Rows[i]["Value"] != DBNull.Value)
{
//string temp = Convert.ToString(Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100);
//info.Value = temp.Split('.')[0] + "." + temp.Split('.')[1].Substring(0, 2) + "%";
info.Value = (Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100).ToString("0.00") + "%";
}
else
{
info.Value = "0.00" + "%";
}
dataList.Add(info);
}
}
#endregion
#region Left
List <FinallyScoreRateDto> leftList = new List <FinallyScoreRateDto>();
if (leftDataSet.Tables.Count > 0 && leftDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < leftDataSet.Tables[0].Rows.Count; i++)
{
FinallyScoreRateDto info = new FinallyScoreRateDto();
info.ChapterCode = Convert.ToString(leftDataSet.Tables[0].Rows[i]["CharterCode"]);
info.ChapterName = Convert.ToString(leftDataSet.Tables[0].Rows[i]["CharterName"]);
//info.Weight = Convert.ToDecimal(leftDataSet.Tables[0].Rows[i]["Weight"]);
leftList.Add(info);
}
}
#endregion
DynamicColumnDataSet <TwoLevelColumnInfo, FinallyScoreRateBodyDto, FinallyScoreRateDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, FinallyScoreRateBodyDto, FinallyScoreRateDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, FinallyScoreRateBodyDto, FinallyScoreRateDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
//BindGrid
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, FinallyScoreRateDto>(grvFinallyScoreRateForWeight, list.ColumnInfoList, list.DtoList);
//InitGridControl(grcShopScore);
//grvShopScore.SetAllColumnEditable(false);
// grcAuditionPass.SetColumnEditableByColumn(true, gcAuditioinHis, gcResume, gcPassTypeCode, gcPassRemark, gcWorkYear);
grvFinallyScoreRateForWeight.LeftCoord = 0;
#endregion
#region FinallyWeightRANK
result = allResult[1];
List <FinallyScoreRateRankDto> finallyScoreRateRankDtoList = new List <FinallyScoreRateRankDto>();
if (result[0].Tables[0].Rows.Count > 0)
{
for (int i = 0; i < result[0].Tables[0].Rows.Count; i++)
{
FinallyScoreRateRankDto finallyScoreRateRankDto = new FinallyScoreRateRankDto();
finallyScoreRateRankDto.ProjectCode = Convert.ToString(result[0].Tables[0].Rows[i]["ProjectCode"]);
finallyScoreRateRankDto.ShopName = Convert.ToString(result[0].Tables[0].Rows[i]["ShopName"]);
finallyScoreRateRankDto.Rate = Convert.ToDecimal(result[0].Tables[0].Rows[i]["Rate"] == null ? 0 : result[0].Tables[0].Rows[i]["Rate"]);
finallyScoreRateRankDto.RANK = Convert.ToInt32(result[0].Tables[0].Rows[i]["RANK"] == DBNull.Value ? 0 : result[0].Tables[0].Rows[i]["RANK"]);
finallyScoreRateRankDtoList.Add(finallyScoreRateRankDto);
}
}
grcFinallyScoreRateForOrder.DataSource = finallyScoreRateRankDtoList;
#endregion
}
catch (Exception ex)
{
CommonHandler.ShowMessage(MessageType.Information, ex.Message); return;
}
finally
{
this.Enabled = true;
}
}
private void webService_SearchScoreRateCompleted(object sender, XHX.localhost.SearchScoreRateCompletedEventArgs e)
{
try
{
DataSet[][] allResult = e.Result;
#region Chapter
DataSet[] result = allResult[0];
DataSet leftDataSet = result[2];
DataSet bodyDataDataSet = result[1];
DataSet headDataSet = result[0];
#region Head
List <TwoLevelColumnInfo> columnInfoList = new List <TwoLevelColumnInfo>();
if (headDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < headDataSet.Tables[0].Rows.Count; i++)
{
TwoLevelColumnInfo info = new TwoLevelColumnInfo();
info.Column1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column2"]);
info.Caption1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption1"]);
info.Caption2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption2"]);
info.Order = Convert.ToInt32(headDataSet.Tables[0].Rows[i]["Order"]);
columnInfoList.Add(info);
}
}
List <TwoLevelColumnInfo> tempList = new List <TwoLevelColumnInfo>();
for (int i = 0; i < columnInfoList.Count; i++)
{
if (columnInfoList[i].Order > 4)
{
tempList.Add(columnInfoList[i]);
}
}
List <int> existOrderList = new List <int>();
for (int i = 0; i < tempList.Count; i++)
{
if (!existOrderList.Contains(tempList[i].Order))
{
tempList[i].Order = tempList[i].Order;// + i
existOrderList.Add(tempList[i].Order);
}
else
{
int tempOrder = tempList[i].Order;
while (existOrderList.Contains(tempOrder))
{
tempOrder++;
}
tempList[i].Order = tempOrder;// + i
existOrderList.Add(tempOrder);
}
}
List <TwoLevelColumnInfo> lastlist = new List <TwoLevelColumnInfo>();
for (int i = 0; i < columnInfoList.Count; i++)
{
if (columnInfoList[i].Order < 5)
{
lastlist.Add(columnInfoList[i]);
}
}
for (int i = 0; i < tempList.Count; i++)
{
lastlist.Add(tempList[i]);
}
columnInfoList.Clear();
columnInfoList = lastlist;
#endregion
#region Data
List <ScoreRateForChapterBodyDto> dataList = new List <ScoreRateForChapterBodyDto>();
if (bodyDataDataSet.Tables.Count > 0 && bodyDataDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < bodyDataDataSet.Tables[0].Rows.Count; i++)
{
ScoreRateForChapterBodyDto info = new ScoreRateForChapterBodyDto();
info.Column1 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column2"]);
info.ChapterCode = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["CharterCode"]);
if (bodyDataDataSet.Tables[0].Rows[i]["Value"] != DBNull.Value)
{
//string temp = Convert.ToString(Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100);
//info.Value = temp.Split('.')[0] + "." + temp.Split('.')[1].Substring(0, 2) + "%";
info.Value = (Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100).ToString("0.00") + "%";
}
else
{
info.Value = "0.00" + "%";
}
dataList.Add(info);
}
}
#endregion
#region Left
List <ScoreRateForChapterDto> leftList = new List <ScoreRateForChapterDto>();
if (leftDataSet.Tables.Count > 0 && leftDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < leftDataSet.Tables[0].Rows.Count; i++)
{
ScoreRateForChapterDto info = new ScoreRateForChapterDto();
info.ChapterCode = Convert.ToString(leftDataSet.Tables[0].Rows[i]["CharterCode"]);
info.ChapterName = Convert.ToString(leftDataSet.Tables[0].Rows[i]["CharterName"]);
leftList.Add(info);
}
}
#endregion
DynamicColumnDataSet <TwoLevelColumnInfo, ScoreRateForChapterBodyDto, ScoreRateForChapterDto> list = new DynamicColumnDataSet <TwoLevelColumnInfo, ScoreRateForChapterBodyDto, ScoreRateForChapterDto>(columnInfoList, dataList, leftList);
if (list != null && list.ColumnInfoList != null)
{
list.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, ScoreRateForChapterBodyDto, ScoreRateForChapterDto>(list.ColumnInfoList, list.DataList, list.DtoList);
}
//BindGrid
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, ScoreRateForChapterDto>(grvChapterRatio, list.ColumnInfoList, list.DtoList);
//InitGridControl(grcShopScore);
//grvShopScore.SetAllColumnEditable(false);
// grcAuditionPass.SetColumnEditableByColumn(true, gcAuditioinHis, gcResume, gcPassTypeCode, gcPassRemark, gcWorkYear);
grvChapterRatio.LeftCoord = 0;
#endregion
#region Link
result = allResult[1];
leftDataSet = result[2];
bodyDataDataSet = result[1];
headDataSet = result[0];
#region Head
columnInfoList = new List <TwoLevelColumnInfo>();
if (headDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < headDataSet.Tables[0].Rows.Count; i++)
{
TwoLevelColumnInfo info = new TwoLevelColumnInfo();
info.Column1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Column2"]);
info.Caption1 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption1"]);
info.Caption2 = Convert.ToString(headDataSet.Tables[0].Rows[i]["Caption2"]);
info.Order = Convert.ToInt32(headDataSet.Tables[0].Rows[i]["Order"]);
columnInfoList.Add(info);
}
}
tempList = new List <TwoLevelColumnInfo>();
for (int i = 0; i < columnInfoList.Count; i++)
{
if (columnInfoList[i].Order > 4)
{
tempList.Add(columnInfoList[i]);
}
}
existOrderList = new List <int>();
for (int i = 0; i < tempList.Count; i++)
{
if (!existOrderList.Contains(tempList[i].Order))
{
tempList[i].Order = tempList[i].Order;// + i
existOrderList.Add(tempList[i].Order);
}
else
{
int tempOrder = tempList[i].Order;
while (existOrderList.Contains(tempOrder))
{
tempOrder++;
}
tempList[i].Order = tempOrder;// + i
existOrderList.Add(tempOrder);
}
}
lastlist = new List <TwoLevelColumnInfo>();
for (int i = 0; i < columnInfoList.Count; i++)
{
if (columnInfoList[i].Order < 5)
{
lastlist.Add(columnInfoList[i]);
}
}
for (int i = 0; i < tempList.Count; i++)
{
lastlist.Add(tempList[i]);
}
columnInfoList.Clear();
columnInfoList = lastlist;
#endregion
#region Data
List <ScoreRateForLinkBodyDto> dataList1 = new List <ScoreRateForLinkBodyDto>();
if (bodyDataDataSet.Tables.Count > 0 && bodyDataDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < bodyDataDataSet.Tables[0].Rows.Count; i++)
{
ScoreRateForLinkBodyDto info = new ScoreRateForLinkBodyDto();
info.Column1 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column1"]);
info.Column2 = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["Column2"]);
info.LinkCode = Convert.ToString(bodyDataDataSet.Tables[0].Rows[i]["LinkCode"]);
if (bodyDataDataSet.Tables[0].Rows[i]["Value"] != DBNull.Value)
{
//string temp = Convert.ToString(Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100);
//info.Value = temp.Split('.')[0] + "." + temp.Split('.')[1].Substring(0, 2) + "%";
info.Value = (Convert.ToDecimal(bodyDataDataSet.Tables[0].Rows[i]["Value"]) * 100).ToString("0.00") + "%";
}
else
{
info.Value = "0.00" + "%";
}
dataList1.Add(info);
}
}
#endregion
#region Left
List <ScoreRateForLinkDto> leftList1 = new List <ScoreRateForLinkDto>();
if (leftDataSet.Tables.Count > 0 && leftDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < leftDataSet.Tables[0].Rows.Count; i++)
{
ScoreRateForLinkDto info = new ScoreRateForLinkDto();
info.LinkCode = Convert.ToString(leftDataSet.Tables[0].Rows[i]["LinkCode"]);
info.LinkName = Convert.ToString(leftDataSet.Tables[0].Rows[i]["LinkName"]);
leftList1.Add(info);
}
}
#endregion
DynamicColumnDataSet <TwoLevelColumnInfo, ScoreRateForLinkBodyDto, ScoreRateForLinkDto> list1 = new DynamicColumnDataSet <TwoLevelColumnInfo, ScoreRateForLinkBodyDto, ScoreRateForLinkDto>(columnInfoList, dataList1, leftList1);
if (list1 != null && list1.ColumnInfoList != null)
{
list1.DtoList = DynamicColumnUtil.CombineDynamicColumnDto <TwoLevelColumnInfo, ScoreRateForLinkBodyDto, ScoreRateForLinkDto>(list1.ColumnInfoList, list1.DataList, list1.DtoList);
}
//BindGrid
CommonHandler.BuildDynamicColumn <TwoLevelColumnInfo, ScoreRateForLinkDto>(grvLinkRatio, list1.ColumnInfoList, list1.DtoList);
//InitGridControl(grcShopScore);
//grvShopScore.SetAllColumnEditable(false);
// grcAuditionPass.SetColumnEditableByColumn(true, gcAuditioinHis, gcResume, gcPassTypeCode, gcPassRemark, gcWorkYear);
grvLinkRatio.LeftCoord = 0;
#endregion
#region Subject
result = allResult[2];
List <SubjectDto> subjectList = new List <SubjectDto>();
if (result[0].Tables[0].Rows.Count > 0)
{
for (int i = 0; i < result[0].Tables[0].Rows.Count; i++)
{
SubjectDto subjectDto = new SubjectDto();
subjectDto.SubjectCode = Convert.ToString(result[0].Tables[0].Rows[i]["SubjectCode"]);
subjectDto.CheckPoint = Convert.ToString(result[0].Tables[0].Rows[i]["CheckPoint"]);
if (result[0].Tables[0].Rows[i]["全国"] != DBNull.Value)
{
subjectDto.AllCountry = (Convert.ToDecimal(result[0].Tables[0].Rows[i]["全国"]) * 100).ToString("0.00") + "%";
}
else
{
subjectDto.AllCountry = "0.00" + "%";
}
if (result[0].Tables[0].Rows[i]["东区"] != DBNull.Value)
{
subjectDto.EastArea = (Convert.ToDecimal(result[0].Tables[0].Rows[i]["东区"]) * 100).ToString("0.00") + "%";
}
else
{
subjectDto.EastArea = "0.00" + "%";
}
if (result[0].Tables[0].Rows[i]["南区"] != DBNull.Value)
{
subjectDto.SouthArea = (Convert.ToDecimal(result[0].Tables[0].Rows[i]["南区"]) * 100).ToString("0.00") + "%";
}
else
{
subjectDto.SouthArea = "0.00" + "%";
}
if (result[0].Tables[0].Rows[i]["西区"] != DBNull.Value)
{
subjectDto.WestArea = (Convert.ToDecimal(result[0].Tables[0].Rows[i]["西区"]) * 100).ToString("0.00") + "%";
}
else
{
subjectDto.WestArea = "0.00" + "%";
}
if (result[0].Tables[0].Rows[i]["北区"] != DBNull.Value)
{
subjectDto.NorthArea = (Convert.ToDecimal(result[0].Tables[0].Rows[i]["北区"]) * 100).ToString("0.00") + "%";
}
else
{
subjectDto.NorthArea = "0.00" + "%";
}
//subjectDto.EastArea = Convert.ToDecimal(result[0].Tables[0].Rows[i]["东区"] == DBNull.Value ? ("0.00" + "%") : (Convert.ToDecimal(result[0].Tables[0].Rows[i]["东区"]) * 100).ToString("0.00") + "%");
//subjectDto.SouthArea = Convert.ToDecimal(result[0].Tables[0].Rows[i]["南区"] == DBNull.Value ? ("0.00" + "%") : (Convert.ToDecimal(result[0].Tables[0].Rows[i]["南区"]) * 100).ToString("0.00") + "%");
//subjectDto.WestArea = Convert.ToDecimal(result[0].Tables[0].Rows[i]["西区"] == DBNull.Value ? ("0.00" + "%") : (Convert.ToDecimal(result[0].Tables[0].Rows[i]["西区"]) * 100).ToString("0.00") + "%");
//subjectDto.NorthArea = Convert.ToDecimal(result[0].Tables[0].Rows[i]["北区"] == DBNull.Value ? ("0.00" + "%") : (Convert.ToDecimal(result[0].Tables[0].Rows[i]["北区"]) * 100).ToString("0.00") + "%");
subjectList.Add(subjectDto);
}
}
grcSubjectRatio.DataSource = subjectList;;
#endregion
}
catch (Exception ex)
{
CommonHandler.ShowMessage(MessageType.Information, ex.Message); return;
}
finally
{
this.Enabled = true;
}
}
