/// <summary>
/// 绑定plenishOrderSource源到dataGridView中
/// </summary>
/// <param name="listPage"></param>
private void BindingScrapOrderSource(DistributorWithdrawRecordPage listPage)
{
if (listPage != null && listPage.DistributorWithdrawRecords != null)
{
foreach (var item in listPage.DistributorWithdrawRecords)
{
item.DistributorName = PfCustomerCache.GetUserNameWithPf(item.DistributorID);
}
}
// this.dataGridViewPagingSumCtrl.BindingDataSource(DataGridViewUtil.ToDataTable(listPage?.DistributorWithdrawRecords), null, listPage?.TotalEntityCount, listPage?.DistributorWithdrawRecordSum);
this.dataGridViewPagingSumCtrl.BindingDataSource(listPage?.DistributorWithdrawRecords, null, listPage?.TotalEntityCount, listPage?.DistributorWithdrawRecordSum);
//dataGridViewPagingSumCtrl.BindingDataSource<DistributorWithdrawRecord>(DataGridViewUtil.ToDataTable(listPage?.DistributorWithdrawRecords));
this.skinSplitContainer1.Panel2Collapsed = true;
}
private void BindingSource(PfAccountRecordPage listPage)
{
this.skinSplitContainer1.Panel2Collapsed = true;
if (listPage != null && listPage.PfAccountRecords != null && listPage.PfAccountRecords.Count > 0)
{
foreach (var item in listPage.PfAccountRecords)
{
item.PfCustomerName = PfCustomerCache.GetPfCustomerName(item.PfCustomerID);
item.AccountTypeName = GlobalUtil.GetPfAccountTypeName(item.AccountType);
item.AdminUserName = PfCustomerCache.GetUserNameWithPf(item.AdminUserID);
}
}
this.dataGridViewPagingSumCtrl.BindingDataSource(listPage?.PfAccountRecords, null, listPage?.TotalEntityCount);
}
//简单打印示例
public static void Print(PfOrder item, DataGridView dataGridView2, int times = 1)
{
InteractResult <PrintTemplateInfo> result;
if (item.IsRefundOrder)
{
result = CommonGlobalCache.ServerProxy.GetPrintTemplateInfo(PrintTemplateType.PfTOrder);
}
else
{
result = CommonGlobalCache.ServerProxy.GetPrintTemplateInfo(PrintTemplateType.PfOrder);
}
if (result.ExeResult == ExeResult.Success)
{
PrintTemplateInfo CurrentPTemplate = result.Data;
for (int c = 0; c < CurrentPTemplate.PrintCount; c++)
{
GoldPrinter.MisGoldPrinter misGoldPrinter = new GoldPrinter.MisGoldPrinter(false, new PrinterMargins(20, 20, 20, 20, 800, 1129));
if (CurrentPTemplate.OrderName != "")
{
misGoldPrinter.Title = CurrentPTemplate.OrderName; //主标题（C#用\n表示换行） }
misGoldPrinter.Caption = "";
double headRow = Math.Round(Convert.ToSingle(CurrentPTemplate.SystemVariables.Count / 2));
Header header = new Header(Convert.ToInt32(headRow) + 1, 2);
header.IsDrawAllPage = true;
CommonGlobalUtil.WriteLog("变量总数=" + CurrentPTemplate.SystemVariables.Count + "\r\n" + "应显示行号=" + headRow + 1);
//GoldPrinter.MisGoldPrinter misGoldPrinter = new GoldPrinter.MisGoldPrinter(false, new PrinterMargins(20, 20, 20, 20, 787, 1129));
// if (item.IsRefundOrder)
// {
// misGoldPrinter.Title = "批发退货单";
// }
// else
// {
// misGoldPrinter.Title = "批发发货单";
// }
//// misGoldPrinter.Title = "批发单"; //主标题（C#用\n表示换行）
// misGoldPrinter.Caption = ""; //副标题
// //misGoldPrinter.Top = "单号：" + item.AllocateOrder.ID + "|收货方：" + CommonGlobalCache.GetShopName(item.AllocateOrder.DestShopID) + "|开单日期：" + item.AllocateOrder.CreateTime; //抬头，一行三列的文字说明，用|分隔
for (int i = 0; i < CurrentPTemplate.SystemVariables.Count; i++)
{
int curR = 0;
if (i < 2)
{
curR = 0;
}
else
{
double resRow = i / 2;
curR = Convert.ToInt32(Math.Round(resRow));
}
string KeyStr = "";
if (CurrentPTemplate.SystemVariables[i] == "单号")
{
KeyStr = "批发单号：";
header.SetText(curR, i % 2, CurrentPTemplate.SystemVariables[i] + item.ID);
}
else if (CurrentPTemplate.SystemVariables[i] == "客户")
{
KeyStr = "客 户：";
header.SetText(curR, i % 2, KeyStr + PfCustomerCache.GetUserNameWithPf(item.PfCustomerID));
}
else if (CurrentPTemplate.SystemVariables[i] == "开单时间")
{
KeyStr = "开单时间：";
header.SetText(curR, i % 2, KeyStr + item.CreateTime.GetDateTimeFormats('f')[0].ToString());
}
else if (CurrentPTemplate.SystemVariables[i] == "操作人")
{
KeyStr = "操 作 人：";
header.SetText(curR, i % 2, KeyStr + CommonGlobalCache.GetUserName(item.AdminUserID));
}
else if (CurrentPTemplate.SystemVariables[i] == "付款方式")
{
KeyStr = "付款方式：";
header.SetText(curR, i % 2, KeyStr + item.PayTypeName);
}
else if (CurrentPTemplate.SystemVariables[i] == "总数量")
{
KeyStr = "总 数 量：";
header.SetText(curR, i % 2, KeyStr + item.TotalCount.ToString());
}
else if (CurrentPTemplate.SystemVariables[i] == "上欠金额")
{
KeyStr = "上欠金额：";
header.SetText(curR, i % 2, KeyStr + item.PaymentBalanceOld.ToString());
}
else if (CurrentPTemplate.SystemVariables[i] == "本次应收金额")
{
KeyStr = "本次应收金额：";
header.SetText(curR, i % 2, KeyStr + item.TotalPfPrice.ToString());
}
else if (CurrentPTemplate.SystemVariables[i] == "应收总额")
{
KeyStr = "应收总额：";
header.SetText(curR, i % 2, KeyStr + item.PaymentBalance.ToString());
}
else if (CurrentPTemplate.SystemVariables[i] == "单据备注")
{
KeyStr = "备 注：";
header.SetText(curR, i % 2, KeyStr + item.Remarks.ToString());
}
}
// Header header = new Header(4, 3); //行列数基本不受限制，但超过一页失去意义，因为以Body为主，以其它为辅
// header.IsDrawAllPage = true; //可以指定每页是否重复打印
//header.SetText(0, 0, "批发单号：" + item.ID);
//header.SetText(0, 1, "客 户：" + PfCustomerCache.GetUserNameWithPf(item.PfCustomerID));
//header.SetText(0, 2, "开单时间：" + item.CreateTime.GetDateTimeFormats('f')[0].ToString()); //DataSource可以是字符串、一维数组、二维数组、DataTable、WinDataGrid、WebDataGrid、ListView\ListView、
//header.SetText(1, 0, "操 作 人：" + CommonGlobalCache.GetUserName(item.AdminUserID));
//header.SetText(1, 1, "付款方式：" + item.PayTypeName); //同仁们还可以根据实际应用对GridBase的DataSource进行扩展
//header.SetText(1, 2, String.Empty);
//header.SetText(2, 0, "总 数 量：" + item.TotalCount.ToString());
//header.SetText(2, 1, "批发总额：" + item.TotalPfPrice.ToString()); //同仁们还可以根据实际应用对GridBase的DataSource进行扩展
//header.SetText(2, 2, String.Empty);
//header.SetText(3, 0, "备 注：" );
//header.SetText(3, 1, item.Remarks); //同仁们还可以根据实际应用对GridBase的DataSource进行扩展
//header.SetText(3, 2, String.Empty);
misGoldPrinter.Header = header;
List <PrintColumnInfo> dataGV = CurrentPTemplate.PrintColumnInfos;
string ColumnsList = string.Empty;
foreach (PrintColumnInfo itemC in dataGV)
{
ColumnsList += itemC.Name + ",";
}
CommonGlobalUtil.WriteLog("模板设置打印列表头为=" + ColumnsList + "\r\n");
bool isflag = false;
if (dataGV.Count == 0)
{
isflag = true;
}
// DataTable dt = dataGridView2.DataSource as DataTable;
// DataTable newDt = new DataTable();
List <int> columnCount = new List <int>();
int pinrtColNum = 0;
string dataGridColumnsList = string.Empty;
for (int i = 0; i < dataGridView2.Columns.Count; i++)
{
DataGridViewColumn column = dataGridView2.Columns[i];
//if (column.HeaderText == "F" || column.HeaderText == "XS" || column.HeaderText == "S" || column.HeaderText == "M" || column.HeaderText == "L"
// || column.HeaderText == "XL" || column.HeaderText == "XL2" || column.HeaderText == "XL3" || column.HeaderText == "XL4" || column.HeaderText == "XL5"
// || column.HeaderText == "XL6")
//{
// if (dataGV.FindAll(t => t.Name == "尺码列").Count > 0)
// {
// columnCount.Add(i);
// }
// else
// {
// column.Visible = false;
// }
//}
//else
//{
if (dataGV.FindAll(t => t.Name == column.HeaderText).Count > 0)
{
columnCount.Add(i);
dataGridColumnsList += column.HeaderText + ",";
pinrtColNum++;
}
else
{
if (dataGV.FindAll(t => t.Name == column.DataPropertyName).Count > 0)
{
columnCount.Add(i);
column.HeaderText = column.HeaderText.Replace("\r\n", " ");
dataGridColumnsList += column.DataPropertyName + ",";
pinrtColNum++;
}
else
{
if (column.DataPropertyName.Contains("XL"))
{
string name = column.DataPropertyName; //XL3
//3XL
string newname = name.Replace("XL", "");
string checkstr = newname + "XL";
if (dataGV.FindAll(t => t.Name == checkstr).Count > 0)
{
columnCount.Add(i);
column.HeaderText = column.HeaderText.Replace("\r\n", " ");
dataGridColumnsList += column.DataPropertyName + ",";
pinrtColNum++;
}
else
{
column.Visible = false;
}
}
else
{
column.Visible = false;
}
}
}
//}
CommonGlobalUtil.WriteLog("DataGridView能打印的列为=" + dataGridColumnsList);
if (isflag)
{
if (i == 0)
{
columnCount.Add(i);
column.Visible = true;
column.HeaderText = "";
DataTable dt = new DataTable();
DataColumn c1 = new DataColumn();
c1.ColumnName = "HeaderText";
dt.Columns.Add(c1);
dataGridView2.DataSource = null;
dataGridView2.DataSource = dt;
}
}
}
misGoldPrinter.DataSource = DataGridViewUtil.ToStringArray(dataGridView2, true, true);
if (!Directory.Exists(CommonGlobalUtil.SystemDir + "EXPORTS\\"))
{
Directory.CreateDirectory(CommonGlobalUtil.SystemDir + "EXPORTS\\");
}
misGoldPrinter.FileName = CommonGlobalUtil.SystemDir + "EXPORTS\\" + item.ID + ".jpg";
((GoldPrinter.Body)(misGoldPrinter.Body)).Font = dataGridView2.Font;
/* int[] widths = new int[] {
* 80,100,50,40, 50,
* 30,30,30,30,30,30,30,30,30,30,30
* ,40,50,50
* };*/
int[] widths = new int[CurrentPTemplate.PrintColumnInfos.Count];
CommonGlobalUtil.WriteLog("widths长度" + widths.Length);
CommonGlobalUtil.WriteLog("实际打印数量=" + pinrtColNum + "\r\n" + "设置能打印的列数量=" + widths.Length.ToString());
for (int j = 0; j < CurrentPTemplate.PrintColumnInfos.Count; j++)
{
widths[j] = Convert.ToInt32(CurrentPTemplate.PrintColumnInfos[j].Rate);
}
List <int> widthList = new List <int>();
for (int i = 0; i < CurrentPTemplate.PrintColumnInfos.Count; i++)
{
DataGridViewColumn column = dataGridView2.Columns[columnCount[i]];
if (column.Visible && !String.IsNullOrEmpty(column.HeaderText))
{
widthList.Add(widths[i]);
}
else
{
/* if (column.Visible && !String.IsNullOrEmpty(column.DataPropertyName))
* {
* widthList.Add(widths[i]);
* }*/
}
}
if (isflag)
{
widths = new int[1];
widths[0] = 100;
widthList.Add(widths[0]);
}
widths = widthList.ToArray();
int newWidth = 800;
/* int totalWidth = 0;
* for (int i = 0; i < widths.Length; i++)
* {
* totalWidth += widths[i];
* }*/
for (int i = 0; i < widths.Length; i++)
{
widths[i] = decimal.ToInt32(Math.Round((widths[i] * newWidth * (decimal)0.1), 0, MidpointRounding.AwayFromZero));
// widths[i] = decimal.ToInt32(Math.Round((widths[i] * newWidth * (decimal)1.0 / totalWidth), 0, MidpointRounding.AwayFromZero));
}
((GoldPrinter.Body)(misGoldPrinter.Body)).ColsWidth = widths;
//((GoldPrinter.Body)(misGoldPrinter.Body)).RowHeight = 100;
misGoldPrinter.Preview();
misGoldPrinter.Dispose();
misGoldPrinter = null;
}
}
}
}