private void SetColumns(DataGridViewColumnCollection columns)
{
DataGridViewColumn column;
DataGridViewCellStyle style;
//
//Index
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Id";
column.HeaderText = "Id";
column.Name = "plainClmRequestId";
column.Width = 40;
//
// clmRowIndex
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ParentId";
column.HeaderText = "RequestId";
column.Name = "plainClmRequestId";
column.Width = 50;
//
//Request
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Request";
column.HeaderText = "Request";
column.Name = "plainClmRequest";
column.Width = 150;
//
// Start
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Format = "MMM dd, HH:mm:ss.fff";
column.DataPropertyName = "StartDate";
column.DefaultCellStyle = style;
column.HeaderText = "Start";
column.Name = "plainClmStart";
column.Width = 110;
//
// clmConnectId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ConnectId";
column.HeaderText = "ConnectId";
column.Name = "plainClmConnectId";
column.Width = 70;
//
// clmLoginId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "LoginId";
column.HeaderText = "LoginId";
column.Name = "plainClmLoginId";
column.Width = 70;
//
// clmCallId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "CallId";
column.HeaderText = "CallId";
column.Name = "plainClmCallId";
column.Width = 70;
//
// clmUserName
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "User";
column.HeaderText = "User";
column.Name = "plainClmUserName";
column.Width = 70;
//
// clmThreadName
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Thread";
column.HeaderText = "Thread";
column.Name = "plainClmThreadName";
//
// clmType
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Type";
column.HeaderText = "Type";
column.Name = "plainClmType";
column.Width = 40;
//
// clmExecutionTime
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
column.DataPropertyName = "DbTime";
column.DefaultCellStyle = style;
column.HeaderText = "DbTime(ms)";
column.Name = "plainClmDbTime";
column.Width = 80;
//
// clmRowAffected
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
column.DataPropertyName = "RowAffected";
column.DefaultCellStyle = style;
column.HeaderText = "Affected rows";
column.Name = "plainClmRowAffected";
//
// clmMethod
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Method";
column.HeaderText = "Method";
column.Name = "plainClmMethod";
column.Width = 350;
//
// clmSchema
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "DbSchema";
column.HeaderText = "DbSchema";
column.Name = "plainClmSchema";
//
// clmMessage
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Message";
column.HeaderText = "Message";
column.Name = "plainClmMessage";
}
private void button3_Click(object sender, EventArgs e)
{
string className = this.comboBox1.Text;
string startTime = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
string endTime = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
DataTable dt = studentInfoCtl.GetClassCheckInfo(className, startTime, endTime);
//DataColumn dc = new DataColumn("序号", typeof(int));
//dt.Columns.Add(dc);
this.dataGridView1.DataSource = dt;
this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = this.dataGridView1.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = this.dataGridView1.Columns;
if (columns.Count > 0)
{
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < this.dataGridView1.Width)
{
int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW;
int eachColumnAddedWidth = leftTotalWidht / (columns.Count);
for (int i = 0; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
}
/////////////////////////////////////////////////////////////////////////////////////
double y = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
try
{
DateTime date = DateTime.Parse(dr["考勤时间"].ToString());
string rate = dr["出勤率"].ToString();
y = double.Parse(rate);
ChartSeriesValue csv = new ChartSeriesValue(date, (decimal)y);
this.chart1.Series.Values.Add(csv);
if (i == 0)
{
this.chart1.XAxis.Scale.Minimum = date.AddDays(-0.5);
}
if (i == dt.Rows.Count - 1)
{
this.chart1.XAxis.Scale.Maximum = date.AddDays(0.5);
}
}
catch (System.Exception ex)
{
}
}
/////////////////////////////////////////////////////////////////////////////////////
/*
* barChart.Items.Clear();
*
* Color clrGreen = Color.FromArgb(255, 82, 206, 60);
* Color clrYellow = Color.FromArgb(255, 234, 234, 134);
* Color clrRed = Color.FromArgb(255, 253, 95, 77);
* double y = 0;
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* DataRow dr = dt.Rows[i];
* try
* {
* string date = dr["考勤时间"].ToString().Substring(0, 10);
* string rate = dr["出勤率"].ToString();
* y = double.Parse(rate);
* Color clrSelected = clrGreen;
* if (y < 85)
* {
* clrSelected = clrYellow;
* }
* if (y < 60)
* {
* clrSelected = clrRed;
* }
* barChart.Add(rate + "%", y, (i + 1).ToString(), clrSelected);
* //barChart.Add(rate + "%", y, (i + 1).ToString(), Color.FromArgb(255, 200, 255, 255));
* }
* catch (System.Exception ex)
* {
*
* }
*
* }
* barChart.RedrawChart();
*/
/*
* GraphPane myPane = zgc.GraphPane;
*
* // Set the Titles
*
* myPane.Title.Text = "出勤率折线图";
* myPane.XAxis.Title.Text = "考勤时间";
* myPane.YAxis.Title.Text = "出勤率";
*
* // Make up some data arrays based on the Sine function
*
* double x, y;
* PointPairList list = new PointPairList();
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* DataRow dr = dt.Rows[i];
* try
* {
* DateTime date = DateTime.Parse(dr["考勤时间"].ToString());
* x = (double)new XDate(date.Year, date.Month, date.Day);
* y = double.Parse(dr["出勤率"].ToString());
* list.Add(x, y);
* }
* catch (System.Exception ex)
* {
*
* }
*
* }
*
* // Generate a red curve with diamond
*
* // symbols, and "Porsche" in the legend
*
* LineItem myCurve = myPane.AddCurve("出勤率折线图",
* list, Color.Red, SymbolType.Diamond);
*
*
* // Tell ZedGraph to refigure the
*
* // axes since the data have changed
*
* zgc.AxisChange();
*/
}
void helper_RequestCompleted_disposeList(object o)
{
//if (this.InvokeRequired)
//{
// this.Invoke(new deleControlInvoke(updateDatagrid), o);
//}
deleControlInvoke dele = delegate(object oProductList)
{
string strProduct = (string)oProductList;
Debug.WriteLine(
string.Format("frmProductManage.helper_RequestCompleted_disposeList -> response = {0}"
, strProduct));
Product u2 = fastJSON.JSON.Instance.ToObject <Product>(strProduct);
object olist = fastJSON.JSON.Instance.ToObjectList(strProduct, typeof(List <Product>), typeof(Product));
DataTable dt = null;
if (this.dataGridView1.DataSource == null)
{
dt = new DataTable();
dt.Columns.Add("产品编号", typeof(string));
dt.Columns.Add("产品名称", typeof(string));
dt.Columns.Add("生产日期", typeof(string));
dt.Columns.Add("产品类别", typeof(string));
dt.Columns.Add("产品备注信息", typeof(string));
}
else
{
dt = (DataTable)dataGridView1.DataSource;
}
dt.Rows.Clear();
foreach (Product c in (List <Product>)olist)
{
dt.Rows.Add(new object[] {
c.productID, c.productName, c.produceDate, c.productCategory, c.descript
});
Debug.WriteLine(c.productID + " " + c.produceDate);
}
this.dataGridView1.DataSource = dt;
this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = this.dataGridView1.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = this.dataGridView1.Columns;
if (columns.Count > 0)
{
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < this.dataGridView1.Width)
{
int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW;
int eachColumnAddedWidth = leftTotalWidht / (columns.Count);
for (int i = 0; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
}
};
this.Invoke(dele, o);
}
private void InitializeColumns(DataGridViewColumnCollection columns)
{
columns.Clear();
DataGridViewColumn column;
//
// clmIndex
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Id";
column.HeaderText = "Id";
column.Name = "clmIndex";
column.ReadOnly = true;
column.Width = 35;
column.ToolTipText = "Index";
//
// clmFrec
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Title";
column.HeaderText = "Frec";
column.Name = "clmFrec";
column.ReadOnly = true;
column.Width = 166;
column.ToolTipText = "Frec";
//
// clmTime
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "TimeString";
column.HeaderText = "Start";
column.Name = "clmTime";
column.ReadOnly = true;
column.Width = 75;
column.ToolTipText = "Start time";
//
// clmWait
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ResponceWaitTime";
column.HeaderText = "Wait";
column.Name = "clmWait";
column.ReadOnly = true;
column.Width = 60;
column.ToolTipText = "Waiting time to responce";
//
// clmTable
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "TableName";
column.HeaderText = "Table";
column.Name = "clmTable";
column.ReadOnly = true;
column.Width = 120;
column.ToolTipText = "Table name";
//
// clmSession
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "SessionId";
column.HeaderText = "Session";
column.Name = "clmSession";
column.ReadOnly = true;
column.Width = 130;
column.ToolTipText = "Project session";
column.Visible = false;
//
// clmThread
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Thread";
column.HeaderText = "Thread";
column.Name = "clmThread";
column.ReadOnly = true;
column.Width = 45;
column.ToolTipText = "Thread";
column.Visible = false;
//
// clmParseDuration
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ParseDuration";
column.HeaderText = "Parse duration";
column.Name = "clmParseDuration";
column.ReadOnly = true;
column.Width = 120;
column.ToolTipText = "Frec parse duration";
column.Visible = false;
//
// clmServer
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Server";
column.HeaderText = "Server";
column.Name = "clmServer";
column.ReadOnly = true;
column.Width = 120;
column.ToolTipText = "Server";
column.Visible = false;
}
private void AbrePasta_Click(object sender, EventArgs e)
{
string valor = "0";
string dtemissao = "";
string hremissao = "";
string numerocupom = "0";
string id = "";
string chcanc = "";
System.DateTime varData;
decimal varValor;
int varNumeroCupom;
string varId;
string varChCanc;
List <DadosCupom> lCupons = new List <DadosCupom>();
Hashtable hashtableCupons = new Hashtable();
//define as propriedades do controle
//OpenFileDialog
this.ofd1.Multiselect = true;
this.ofd1.Title = "Selecionar pasta arquivos SAT";
ofd1.InitialDirectory = @"C:\";
//filtra para exibir somente arquivos de imagens
ofd1.Filter = "Images (*.XML)|*.XML|" + "All files (*.*)|*.*";
ofd1.CheckFileExists = true;
ofd1.CheckPathExists = true;
ofd1.FilterIndex = 2;
ofd1.RestoreDirectory = true;
ofd1.ReadOnlyChecked = true;
ofd1.ShowReadOnly = true;
DialogResult dr = this.ofd1.ShowDialog();
if (dr == System.Windows.Forms.DialogResult.OK)
{
Pasta = Path.GetDirectoryName(ofd1.FileName);
DirectoryInfo Dir = new DirectoryInfo(Pasta);
FileInfo[] Files = Dir.GetFiles("*", SearchOption.AllDirectories).OrderBy(p => p.CreationTimeUtc).ToArray();
//Array.Sort(Files, (x, y) => Comparer<DateTime>.Default.Compare(x.CreationTime, y.CreationTime));
txtCaminhoXML.Text = Pasta.ToString();
// Le os arquivos selecionados
foreach (FileInfo File in Files)
{
//txtArquivo.Text += arquivo;
// cria um PictureBox
try
{
XmlTextReader reader = new XmlTextReader(File.FullName);
//ArrayList elementos = new ArrayList();
valor = "0";
dtemissao = "";
hremissao = "";
numerocupom = "0";
id = "";
chcanc = "";
varValor = 0;
varNumeroCupom = 0;
varId = "";
varChCanc = "";
while ((reader.Read()))
{
if (reader.NodeType == XmlNodeType.Element)
{
switch (reader.Name)
{
case "vCFe":
valor = reader.ReadString();
break;
case "dEmi":
dtemissao = reader.ReadString();
break;
case "hEmi":
hremissao = reader.ReadString();
break;
case "nCFe":
numerocupom = reader.ReadString();
break;
case "infCFe":
id = reader.GetAttribute("Id");
chcanc = reader.GetAttribute("chCanc") ?? "";
break;
}
}
}
DateTimeFormatInfo usDtfi = new CultureInfo("pt-PT", false).DateTimeFormat;
varData = Convert.ToDateTime(dtemissao.Substring(6, 2) + "/" + dtemissao.Substring(4, 2) + "/" + dtemissao.Substring(0, 4) + " " + hremissao.Substring(0, 2) + ":" + hremissao.Substring(2, 2) + ":" + hremissao.Substring(4, 2), usDtfi);
varValor = Convert.ToDecimal(valor, new CultureInfo("en-US"));
varNumeroCupom = Convert.ToInt32(numerocupom);
varId = Convert.ToString(id);
varChCanc = Convert.ToString(chcanc);
//lCupons.Add(new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc));
if (varChCanc.Length > 0)
{
if (hashtableCupons.ContainsKey(varChCanc))
{
//hashtableCupons[varChCanc] = new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc);
((DadosCupom)hashtableCupons[varChCanc]).chcanc = varId;
}
else
{
//hashtableCupons.Add(varId, new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc));
hashtableCupons.Add(varId, new DadosCupom(0, varData, 0, varChCanc, varId));
}
}
else
{
if (hashtableCupons.ContainsKey(varId))
{
((DadosCupom)hashtableCupons[varId]).Numero = varNumeroCupom;
((DadosCupom)hashtableCupons[varId]).Data = varData;
((DadosCupom)hashtableCupons[varId]).Valor = varValor;
}
else
{
hashtableCupons.Add(varId, new DadosCupom(varNumeroCupom, varData, varValor, varId, varChCanc));
}
}
}
catch (SecurityException ex)
{
// O usuário não possui permissão para ler arquivos
MessageBox.Show("Erro de segurança Contate o administrador de segurança da rede.\n\n" +
"Mensagem : " + ex.Message + "\n\n" +
"Detalhes (enviar ao suporte):\n\n" + ex.StackTrace);
}
catch (Exception ex)
{
// Não pode carregar a imagem (problemas de permissão)
MessageBox.Show(". Você pode não ter permissão para ler o arquivo , ou " +
" ele pode estar corrompido.\n\nErro reportado : " + ex.Message);
}
}
//LblTotal.Text = Convert.ToString(lCupons.Sum(item => item.Valor));
LblTotal.Text = "Total: " + Convert.ToString(DadosCupom.Soma(hashtableCupons));
List <DadosCupom> hashToList = new List <DadosCupom>();
foreach (DictionaryEntry de in hashtableCupons)
{
hashToList.Add((DadosCupom)de.Value);
}
//Teoricamente ordenar aqui
//List<DadosCupom> SortedList = hashToList.OrderBy(o => o.Data).ToList();
SortedList = hashToList.OrderBy(o => o.Data).ToList();
var bindingList = new BindingList <DadosCupom>(SortedList);
var source1 = new BindingSource(bindingList, null);
dgvHashCupons.DataSource = source1;
dgvHashCupons.AutoResizeColumns();
DataGridViewColumnCollection c = dgvHashCupons.Columns;
c[0].HeaderText = "N. Cupom";
c[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
c[1].HeaderText = "Data hora";
c[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
c[2].HeaderText = "Valor";
c[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
c[3].HeaderText = "Chave de acesso";
c[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
c[4].HeaderText = "Chave de acesso cancelamento";
c[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
}
private void View1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (!DataGridViewUtil.CheckPerrmisson(this, sender, e))
{
return;
}
foreach (var cItem in curControlList)
{
DataGridViewColumnCollection ColumnsList = view.Columns;
for (int i = 0; i < ColumnsList.Count; i++)
{
string controlName = "Delivery" + cItem.ToString();
DataGridViewLinkColumn curLink = (DataGridViewLinkColumn)view.Columns[controlName];
DataGridViewColumn curI = ColumnsList[i];
DataTable dt = (DataTable)curI.DataGridView.DataSource;
int t = e.ColumnIndex;
int p = curI.Index;
if (curI.DataPropertyName == controlName && e.ColumnIndex == curI.Index)
{
if (e.RowIndex >= 0)
{
sendOutGoodDetailForm form = new sendOutGoodDetailForm();
DataRow item = dt.Rows[e.RowIndex];
GetPfInvoicingPara changePara = new GetPfInvoicingPara();
// ReflectionHelper.CopyProperty(this.pagePara, changePara);
// string headList = this.view.MergeColumnNames[0];
//this.view.MergeColumnNames[]
changePara.CostumeID = item["CostumeID"].ToString();
changePara.PfCustomerID = item["PfCustomerID" + cItem].ToString();
changePara.SizeName = item["SizeName"].ToString();
changePara.ColorName = item["ColorName"].ToString();
changePara.StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value);
changePara.EndDate = new CJBasic.Date(this.dateTimePicker_End.Value);
form.ShowDialog(changePara);
}
}
string controlName1 = "Retail" + cItem.ToString();
DataGridViewLinkColumn curLink1 = (DataGridViewLinkColumn)view.Columns[controlName1];
DataGridViewColumn curI1 = ColumnsList[i];
if (curI1.DataPropertyName == controlName1 && e.ColumnIndex == curI1.Index)
{
if (e.RowIndex >= 0)
{
CustomSaleGoodDetailForm form = new CustomSaleGoodDetailForm();
DataRow item = dt.Rows[e.RowIndex];
GetPfInvoicingPara changePara = new GetPfInvoicingPara();
// ReflectionHelper.CopyProperty(this.pagePara, changePara);
changePara.CostumeID = item["CostumeID"].ToString();
changePara.PfCustomerID = item["PfCustomerID" + cItem].ToString();
changePara.SizeName = item["SizeName"].ToString();
changePara.ColorName = item["ColorName"].ToString();
changePara.StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value);
changePara.EndDate = new CJBasic.Date(this.dateTimePicker_End.Value);
form.ShowDialog(changePara);
}
}
/* string controlName2 = "PfCustomerStore" + cItem.ToString();
* DataGridViewLinkColumn curLink2 = (DataGridViewLinkColumn)view.Columns[controlName2];
* DataGridViewColumn curI2 = ColumnsList[i];
* if (curI1.DataPropertyName == controlName2 && e.ColumnIndex == curI2.Index)
* {
*
* int j = 0;
* }*/
}
//if (e.ColumnIndex == curLink.Index)
//{
//}
//DataGridViewLinkColumn curLink1 = (DataGridViewLinkColumn)view.Columns[controlName];
//if (e.ColumnIndex == curLink1.Index)
//{
//}
//string controlName2 = "PfCustomerStore" + cItem.ToString();
//DataGridViewLinkColumn curLink2 = (DataGridViewLinkColumn)view.Columns[controlName];
//if (e.ColumnIndex == curLink2.Index)
//{
//}
}
}
public HeaderCollection(DataGridViewColumnCollection cols)
{
_headerList = new List <HeaderItem>();
BindCollection = cols;
_iniLock = false;
}
/// <summary>
/// Gets the data from the Data Grid and puts it back in the function.
/// </summary>
/// <param name="destination">
/// The <see cref="PFunction2D"/> object where
/// the data will be stored if it succeeds validation.
/// </param>
/// <returns>True if the operation was successful, False otherwise.</returns>
private bool DataGridToPointFunctionData(PFunction2D destination)
{
PFunction2D tempFunction = new PFunction2D();
// Check if bind was executed. Is it still needed?
if (base.m_Project != null)
{
base.m_Project.ResetExpressionParser();
base.m_Project.CreateSymbols();
#if MONO
// If it's running on Mono the event EditingControlShowing doesn't work, so
// convert the decimal separators in the data grid before calculating the points.
if (Engine.RunningOnMono)
{
fairmatDataGridViewPointData.ConvertDecimalSeparators();
}
#endif
DataGridViewRowCollection rows = fairmatDataGridViewPointData.Rows;
DataGridViewColumnCollection columns = fairmatDataGridViewPointData.Columns;
// Sets the sizes of the function. Additionally check if the row.Count is zero,
// in that case it means there are no columns and rows and so must be handled
// separately
tempFunction.SetSizes(columns.Count, rows.Count > 0 ? rows.Count - 1 : 0);
// First load the column headers values
for (int x = columns.Count - 1; x >= 0; x--)
{
// DataGridView in case the header cell is edited to an empty string replaces
// its value with DBNull (non existent value).
// So, substitute the cell value explicitly with the empty string.
if (columns[x].HeaderCell.Value is DBNull ||
columns[x].HeaderCell.Value == null)
{
columns[x].HeaderCell.Value = string.Empty;
}
try
{
tempFunction[x, -1] = RightValue.ConvertFrom(columns[x].HeaderText, true);
}
catch (Exception e)
{
MessageBox.Show("The string " + columns[x].HeaderText + " (column " +
"position " + (x + 1) + ") is invalid due to: " +
e.Message, DataExchange.ApplicationName);
return(false);
}
}
// Then the rows and the cells.
for (int y = rows.Count - 2; y >= 0; y--)
{
// DataGridView in case the header cell is edited to an empty string replaces
// its value with DBNull (non existent value).
// So, substitute the cell value explicitly with the empty string.
if (rows[y].HeaderCell.Value is DBNull || rows[y].HeaderCell.Value == null)
{
rows[y].HeaderCell.Value = string.Empty;
}
try
{
tempFunction[-1, y] = RightValue.ConvertFrom(rows[y].HeaderCell.Value, true);
}
catch (Exception e)
{
MessageBox.Show("The string " + rows[y].HeaderCell.Value + " (row " +
"position " + (y + 1) + ") is invalid due to: " +
e.Message, DataExchange.ApplicationName);
return(false);
}
for (int x = 0; x < columns.Count; x++)
{
// DataGridView in case the cell is edited to an empty string replaces
// its value with DBNull (non existent value).
// So, substitute the cell value explicitly with the empty string.
if (rows[y].Cells[x].Value is DBNull)
{
rows[y].Cells[x].Value = string.Empty;
}
try
{
tempFunction[x, y] = RightValue.ConvertFrom(rows[y].Cells[x].Value, true);
}
catch (Exception e)
{
MessageBox.Show("The string " + rows[y].Cells[x].Value +
" (position " + (x + 1) + ", " + (y + 1) + ") " +
"is invalid due to: " + e.Message,
DataExchange.ApplicationName);
return(false);
}
}
}
}
try
{
// Save the information about the interpolation/extrapolation
tempFunction.Interpolation = this.interpolationExtrapolationControlPF.GetInterpolationType();
tempFunction.LeastSquaresCoefficients = this.interpolationExtrapolationControlPF.LeastSquareCoefficients;
tempFunction.Extrapolation = this.interpolationExtrapolationControlPF.GetExtrapolationType();
}
catch (Exception e)
{
MessageBox.Show("The selected functionality is currently not usable: " + e.Message,
DataExchange.ApplicationName);
return(false);
}
tempFunction.CopyTo(destination);
return(true);
}
public ColumnCollection(DataGridViewColumnCollection columnCollection)
{
_base = columnCollection;
}
void RefreshDataView()
{
string start = rfidCheck_CheckOn.GetFormatDateTimeString(this.dTPStart.Value);
string end = rfidCheck_CheckOn.GetFormatDateTimeString(this.dTPEnd.Value);
string bj = null;
if (this.cmBbj.Text != null && this.cmBbj.Text.Trim() != "")
{
bj = cmBbj.Text;
}
string nj = null;
if (this.cmBnj.Text != null && this.cmBnj.Text.Trim() != "")
{
nj = cmBnj.Text;
}
DataSet ds = rfidCheck_CheckOn.GetStatisticCheckInfoDataSet(start, end, nj, bj);
if (null != ds)
{
this.dataGridView1.DataSource = ds.Tables[0];
}
this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = this.dataGridView1.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = this.dataGridView1.Columns;
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < this.dataGridView1.Width)
{
int leftTotalWidht = this.dataGridView1.Width - columnsW - headerW;
int eachColumnAddedWidth = leftTotalWidht / columns.Count;
for (int i = 0; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
/*
*
* List<CheckPerson> records = rfidCheck_CheckOn.GetCheckedPersonList(this.dateTimePicker1.Value.ToShortDateString());
* //List<CheckPerson> records = rfidCheck_CheckOn.GetCheckedPersonList("2011/5/10 9:00:00");
* DataTable table = new DataTable("Records");
* DataColumn column;
* DataRow row;
*
* // Create new DataColumn, set DataType,
* // ColumnName and add to DataTable.
* column = new DataColumn("学号");
* //column.Unique = true;
* // Add the Column to the DataColumnCollection.
* table.Columns.Add(column);
* column = new DataColumn("姓名");
* // Add the Column to the DataColumnCollection.
* table.Columns.Add(column);
* column = new DataColumn("考勤时间");
* // Add the Column to the DataColumnCollection.
* table.Columns.Add(column);
*
* for (int i = 0; i < records.Count; i++)
* {
* row = table.NewRow();
* CheckPerson cp = records[i];
* Person p = cp.person;
* row["学号"] = p.id_num;
* row["姓名"] = p.name;
* row["考勤时间"] = cp.checkDate;
* table.Rows.Add(row);
* }
* this.dataGridView1.DataSource = table;
*
* this.dataGridView1.Columns[0].Width = 80;
* this.dataGridView1.Columns[1].Width = 80;
* this.dataGridView1.Columns[2].Width = 120;
*/
}
/// <summary>
/// Copies the selected cells into the clipboard.
/// </summary>
/// <param name="addErrorInfo">if set to <c>true</c> [add error information].</param>
/// <param name="cutLength">if set to <c>true</c> [cut length].</param>
/// <param name="alternatingRows">if set to <c>true</c> [alternating rows].</param>
/// <param name="columns">The columns.</param>
/// <param name="rows">The rows.</param>
/// <param name="selectedCells">The selected cells.</param>
/// <param name="cancellationToken">The cancellation token.</param>
private void CopySelectedCellsIntoClipboard(
bool addErrorInfo,
bool cutLength,
bool alternatingRows,
[NotNull] DataGridViewColumnCollection columns,
[NotNull] DataGridViewRowCollection rows,
[NotNull] DataGridViewSelectedCellCollection selectedCells,
CancellationToken cancellationToken)
{
var buffer = new StringBuilder();
var dataObject = new DataObject();
// If there are multiple cells Add a header and a neat HTML table
var sbHtml = new StringBuilder(m_HtmlStyle.TableOpen);
var leftCol = int.MaxValue;
var rightCol = int.MinValue;
var topRow = int.MaxValue;
var bottomRow = int.MinValue;
foreach (DataGridViewCell cell in selectedCells)
{
if (cell.OwningColumn.DisplayIndex < leftCol)
{
leftCol = cell.OwningColumn.DisplayIndex;
}
if (cell.OwningColumn.DisplayIndex > rightCol)
{
rightCol = cell.OwningColumn.DisplayIndex;
}
if (cell.RowIndex < topRow)
{
topRow = cell.RowIndex;
}
if (cell.RowIndex > bottomRow)
{
bottomRow = cell.RowIndex;
}
}
var hasRowError = HasRowErrors(topRow, bottomRow + 1, rows);
var visibleColumns = new List <int>();
sbHtml.Append(m_HtmlStyle.TROpenAlt);
for (var col = leftCol; col <= rightCol; col++)
{
foreach (DataGridViewColumn diplayCol in columns)
{
if (diplayCol.DisplayIndex == col && diplayCol.Visible && diplayCol.HeaderText != ReaderConstants.cErrorField)
{
visibleColumns.Add(col);
sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, diplayCol.HeaderText));
if (buffer.Length > 0)
{
buffer.Append('\t');
}
buffer.Append(EscapeTab(diplayCol.HeaderText));
break;
}
}
}
if (hasRowError && addErrorInfo)
{
sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, c_ErrorInfo));
buffer.Append('\t');
buffer.Append(c_ErrorInfo);
}
sbHtml.AppendLine(m_HtmlStyle.TRClose);
buffer.AppendLine();
var trAlternate = false;
var lastRefresh = DateTime.Now;
for (var row = topRow; row <= bottomRow; row++)
{
if (rows[row].IsNewRow)
{
continue;
}
if (cancellationToken.IsCancellationRequested)
{
return;
}
sbHtml.Append(trAlternate ? m_HtmlStyle.TROpenAlt : m_HtmlStyle.TROpen);
if (alternatingRows)
{
trAlternate = !trAlternate;
}
var written = false;
if (cancellationToken.IsCancellationRequested)
{
return;
}
for (var col = leftCol; col <= rightCol; col++)
{
if (!visibleColumns.Contains(col))
{
continue;
}
foreach (DataGridViewCell cell in selectedCells)
{
if (cell.RowIndex != row)
{
continue;
}
if (cell.OwningColumn.DisplayIndex != col)
{
continue;
}
AddCell(cell, buffer, sbHtml, col > leftCol, addErrorInfo, cutLength, m_HtmlStyle);
written = true;
break;
}
if (written)
{
continue;
}
buffer.Append('\t');
sbHtml.Append(m_HtmlStyle.TDEmpty);
}
AppendRowError(buffer, sbHtml, rows[row].ErrorText, addErrorInfo && hasRowError, m_HtmlStyle);
sbHtml.AppendLine(m_HtmlStyle.TRClose);
buffer.AppendLine();
if (!((DateTime.Now - lastRefresh).TotalSeconds > 0.2))
{
continue;
}
lastRefresh = DateTime.Now;
Extensions.ProcessUIElements();
}
sbHtml.AppendLine(m_HtmlStyle.TableClose);
dataObject.SetData(DataFormats.Html, true, m_HtmlStyle.ConvertToHtmlFragment(sbHtml.ToString()));
dataObject.SetData(DataFormats.Text, true, buffer.ToString());
dataObject.SetClipboard();
}
/// <summary>
/// Copies all cells to the clipboard
/// </summary>
/// <param name="addErrorInfo">if set to <c>true</c> [add error information].</param>
/// <param name="cutLength">if set to <c>true</c> [cut length].</param>
/// <param name="alternatingRows">if set to <c>true</c> [alternating rows].</param>
/// <param name="columns">The columns.</param>
/// <param name="rows">The rows.</param>
/// <param name="cancellationToken">The cancellation token.</param>
private void CopyAllCellsIntoClipboard(
bool addErrorInfo,
bool cutLength,
bool alternatingRows,
[NotNull] DataGridViewColumnCollection columns,
[NotNull] DataGridViewRowCollection rows,
CancellationToken cancellationToken)
{
var buffer = new StringBuilder();
var sbHtml = new StringBuilder(m_HtmlStyle.TableOpen);
sbHtml.Append(m_HtmlStyle.TROpenAlt);
var first = true;
var visibleColumns = new SortedDictionary <int, DataGridViewColumn>();
foreach (DataGridViewColumn c in columns)
{
// Do not include the error field it will be retrieved from the error collection with nice coloring
if (c.Visible && c.HeaderText != ReaderConstants.cErrorField)
{
visibleColumns.Add(c.DisplayIndex, c);
}
}
var hasRowError = HasRowErrors(0, rows.Count, rows);
foreach (var col in visibleColumns.Values)
{
var headerText = col.HeaderText;
sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, headerText));
if (!first)
{
buffer.Append('\t');
}
else
{
first = false;
}
buffer.Append(EscapeTab(headerText));
}
if (hasRowError && addErrorInfo)
{
sbHtml.Append(HTMLStyle.AddTd(m_HtmlStyle.TH, c_ErrorInfo));
buffer.Append('\t');
buffer.Append(c_ErrorInfo);
}
sbHtml.AppendLine(m_HtmlStyle.TRClose);
buffer.AppendLine();
var trAlternate = false;
var lastRefresh = DateTime.Now;
for (var row = 0; row < rows.Count; row++)
{
if (rows[row].IsNewRow)
{
break;
}
sbHtml.Append(trAlternate ? m_HtmlStyle.TROpenAlt : m_HtmlStyle.TROpen);
if (alternatingRows)
{
trAlternate = !trAlternate;
}
first = true;
foreach (var col in visibleColumns.Values)
{
if (cancellationToken.IsCancellationRequested)
{
return;
}
var cell = rows[row].Cells[col.Index];
AddCell(cell, buffer, sbHtml, !first, addErrorInfo, cutLength, m_HtmlStyle);
first = false;
}
AppendRowError(buffer, sbHtml, rows[row].ErrorText, addErrorInfo && hasRowError, m_HtmlStyle);
sbHtml.AppendLine(m_HtmlStyle.TRClose);
buffer.AppendLine();
if (!((DateTime.Now - lastRefresh).TotalSeconds > 0.2))
{
continue;
}
lastRefresh = DateTime.Now;
Extensions.ProcessUIElements();
}
sbHtml.AppendLine(m_HtmlStyle.TableClose);
var dataObject = new DataObject();
dataObject.SetData(DataFormats.Html, true, m_HtmlStyle.ConvertToHtmlFragment(sbHtml.ToString()));
dataObject.SetData(DataFormats.Text, true, buffer.ToString());
dataObject.SetClipboard();
}
public ConditionsForm(DataGridViewColumnCollection columns)
{
InitializeComponent();
conditions = new List <Condition>();
Initialize(columns);
}
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection)
{
if (columns.Contains(name))
{
return(false);
}
if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
return(false);
}
return(((nameCreationService == null) || nameCreationService.IsValidName(name)) || ((allowDuplicateNameInLiveColumnCollection && (liveColumns != null)) && liveColumns.Contains(name)));
}
public DisplayedColumns(DataGridViewColumnCollection columns)
{
InitializeComponent();
Columns = columns;
}
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection, out string errorString)
{
if (columns.Contains(name))
{
errorString = "DataGridViewDuplicateColumnName " + name;// SR.GetString("DataGridViewDuplicateColumnName", new object[] { name });
return(false);
}
if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
errorString = "DesignerHostDuplicateName " + name;//SR.GetString("DesignerHostDuplicateName", new object[] { name });
return(false);
}
if (((nameCreationService != null) && !nameCreationService.IsValidName(name)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
errorString = "CodeDomDesignerLoaderInvalidIdentifier " + name; // SR.GetString("CodeDomDesignerLoaderInvalidIdentifier", new object[] { name });
return(false);
}
errorString = string.Empty;
return(true);
}
/// <summary>
/// Наполнить колонки на основе типа.
/// </summary>
/// <param name="columns">Коллекция колонок</param>
/// <param name="type">Тип, размеченный аттрибутами</param>
public static void ParseAllPropsIntoColumns(DataGridViewColumnCollection columns, Type type)
{
PropertyInfo[] props = type.GetProperties();
ArrayList propsNames = new ArrayList(props.Length);
foreach (PropertyInfo prop in props)
{
PropertyOrderAttribute att = (PropertyOrderAttribute)Attribute.GetCustomAttribute(prop, typeof(PropertyOrderAttribute));
if (att != null)
{
propsNames.Add(new PropertyOrderPair(prop.Name, att.Order));
}
else
{
propsNames.Add(new PropertyOrderPair(prop.Name, 0));
}
}
propsNames.Sort();
DataGridViewCell cell = new DataGridViewTextBoxCell();
for (int i = 0; i < propsNames.Count; ++i)
{
PropertyInfo prop = type.GetProperty((propsNames[i] as PropertyOrderPair).Name);
ColumnNameAttribute attName = (ColumnNameAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnNameAttribute));
if (attName != null)
{
DataGridViewColumn column = new DataGridViewColumn();
column.Name = attName.ColumnName;
column.CellTemplate = cell;
ColumnWidthAttribute attWidth = (ColumnWidthAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnWidthAttribute));
if (attWidth != null)
{
column.Width = attWidth.ColumnWidth;
}
else
{
column.Width = 100;
}
ColumnTextAttribute attText = (ColumnTextAttribute)Attribute.GetCustomAttribute(prop, typeof(ColumnTextAttribute));
if (attText != null)
{
column.HeaderText = attText.ColumnText;
}
else
{
column.HeaderText = attName.ColumnName;
}
if (prop.GetSetMethod() != null)
{
ReadOnlyAttribute attRO = (ReadOnlyAttribute)Attribute.GetCustomAttribute(prop, typeof(ReadOnlyAttribute));
if (attRO != null)
{
column.ReadOnly = attRO.IsReadOnly;
}
}
ContentAlignmentAttribute attAl = (ContentAlignmentAttribute)Attribute.GetCustomAttribute(prop, typeof(ContentAlignmentAttribute));
if (attAl != null)
{
column.HeaderCell.Style.Alignment = (DataGridViewContentAlignment)(attAl.Alignment);
}
columns.Add(column);
}
}
}
public override bool ReceiveDialogMessage(DialogMessage message)
{
if (customizer == null)
{
customizer = (Properties)base.CustomizationObject;
reportStructure = (ReportStructure)customizer.Get("Generator");
}
if (message == DialogMessage.Activated)
{
this.model = reportStructure.CreateAndFillReportModel();
this.resultDataSet = FillGrid();
if (this.resultDataSet != null)
{
this.grdQuery.DataSource = this.resultDataSet.Tables[0];
foreach (DataGridViewColumn dd in this.grdQuery.Columns)
{
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Right;
cb.Checked = true;
dd.HeaderCell = cb;
dd.SortMode = DataGridViewColumnSortMode.NotSortable;
}
this.grdQuery.AllowUserToOrderColumns = true;
}
base.EnableNext = true;
base.EnableFinish = true;
}
else if (message == DialogMessage.Finish)
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
// only checked columns are used in the report
ReportItemCollection sourceItems = WizardHelper.DataItemsFromDataSet(this.resultDataSet);
AvailableFieldsCollection abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet);
ReportItemCollection destItems = new ReportItemCollection();
foreach (DataGridViewColumn cc in displayCols)
{
DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell;
if (hc.Checked)
{
BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText);
destItems.Add(br);
}
}
reportStructure.ReportItemCollection.AddRange(destItems);
if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0))
{
reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
}
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
}
base.EnableNext = true;
base.EnableFinish = true;
}
return(true);
}
void helper_RequestCompleted_getProductInfoForInventoryList(object o)
{
deleControlInvoke dele = delegate(object oProductList)
{
string strProduct = (string)oProductList;
object olist = fastJSON.JSON.Instance.ToObjectList(strProduct, typeof(List <Product>), typeof(Product));
DataTable dt = null;
if (this.dgvProductInfo.DataSource == null)
{
dt = new DataTable();
dt.Columns.Add("产品编号", typeof(string));
dt.Columns.Add("产品名称", typeof(string));
dt.Columns.Add("生产日期", typeof(string));
dt.Columns.Add("产品类别", typeof(string));
dt.Columns.Add("产品备注信息", typeof(string));
}
else
{
dt = (DataTable)dgvProductInfo.DataSource;
}
dt.Rows.Clear();
foreach (Product p in (List <Product>)olist)
{
dt.Rows.Add(new object[] {
p.productID,
p.productName,
p.produceDate,
p.productCategory,
p.descript
});
}
dgvProductInfo.DataSource = dt;
if (!this.dgvProductInfo.Columns.Contains("checkColumn"))
{
DataGridViewCheckBoxColumn cbc = CreateCheckBoxColumn();
dgvProductInfo.Columns.Insert(0, cbc);
}
foreach (DataGridViewRow vr in this.dgvProductInfo.Rows)
{
DataGridViewCheckBoxCell cbc = (DataGridViewCheckBoxCell)vr.Cells[0];
cbc.Value = LightStatus.TurnedOff;
}
this.dgvProductInfo.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = this.dgvProductInfo.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = this.dgvProductInfo.Columns;
columns[0].Width = 50;
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < this.dgvProductInfo.Width)
{
int leftTotalWidht = this.dgvProductInfo.Width - columnsW - headerW;
int eachColumnAddedWidth = leftTotalWidht / (columns.Count - 1);
for (int i = 1; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
};
this.Invoke(dele, o);
}
public void RefreshOrderInfo()
{
DataTable dt = null;
if (this.dgvOrderInfo.DataSource == null)
{
dt = new DataTable();
dt.Columns.Add("产品名称", typeof(string));
dt.Columns.Add("订购数量", typeof(string));
}
else
{
dt = (DataTable)dgvOrderInfo.DataSource;
}
dgvOrderInfo.DataSource = dt;
if (!this.dgvOrderInfo.Columns.Contains("checkColumn"))
{
DataGridViewCheckBoxColumn cc = new DataGridViewCheckBoxColumn();
cc.HeaderText = "";
cc.Name = "checkColumn";
cc.Width = 50;
dgvOrderInfo.Columns.Insert(0, cc);
}
this.dgvOrderInfo.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
int headerW = this.dgvOrderInfo.RowHeadersWidth;
int columnsW = 0;
DataGridViewColumnCollection columns = this.dgvOrderInfo.Columns;
columns[0].Width = 50;
for (int i = 0; i < columns.Count; i++)
{
columnsW += columns[i].Width;
}
if (columnsW + headerW < this.dgvOrderInfo.Width)
{
int leftTotalWidht = this.dgvOrderInfo.Width - columnsW - headerW;
int eachColumnAddedWidth = leftTotalWidht / (columns.Count - 1);
for (int i = 1; i < columns.Count; i++)
{
columns[i].Width += eachColumnAddedWidth;
}
}
string jsonString = string.Empty;
HttpWebConnect helper = new HttpWebConnect();
helper.RequestCompleted += new deleGetRequestObject(helper_RequestCompleted_getAllOrders);
string url = RestUrl.getAllOrders;
helper.TryPostData(url, jsonString);
return;
//DataTable table = new DataTable("order");
//DataColumn column;
//DataRow row;
//// Create new DataColumn, set DataType,
//// ColumnName and add to DataTable.
//column = new DataColumn("产品编号");
//table.Columns.Add(column);
//column = new DataColumn("名称");
//table.Columns.Add(column);
//column = new DataColumn("数量");
//table.Columns.Add(column);
//for (int i = 0; i < 10; i++)
//{
// row = table.NewRow();
// row["产品编号"] = "001" + i.ToString();
// row["名称"] = "john" + i.ToString();
// row["数量"] = i.ToString();
// table.Rows.Add(row);
//}
DataTable table = null;
table = ctlOrder.GetOrderTable();
this.dgvOrderInfo.DataSource = table;
}
///<summary>
///printUrikakeZan
///印刷ダイアログ
///</summary>
private void printUrikakeZan()
{
//グリッドに表示されていない場合
if (gridTokuisaki.Rows.Count == 0)
{
return;
}
//PDF作成後の入れ物
string strFile = "";
//データの取り出し用
DataTable dtPrintData = new DataTable();
//列情報を取得
DataGridViewColumnCollection cols = gridTokuisaki.Columns;
//行情報を取得
DataGridViewRowCollection rows = gridTokuisaki.Rows;
//取引先経理情報登録時の情報
List <string> lstTorihiki = new List <string>();
//年月日の日付フォーマット後を入れる用
string strYMDformat = "";
this.Cursor = Cursors.WaitCursor;
//空チェック（開始得意先コード）
if (StringUtl.blIsEmpty(lblsetTokuisakiCdopen.CodeTxtText) == false)
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
lblsetTokuisakiCdopen.Focus();
return;
}
//空チェック（終了得意先コード）
if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false)
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
lblsetTokuisakiCdclose.Focus();
return;
}
////パワーユーザーの場合
//if ("1".Equals(this.etsuranFlg))
//{
// //空チェック（終了得意先コード）
// if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false)
// {
// this.Cursor = Cursors.Default;
// // メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
// BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
// basemessagebox.ShowDialog();
// lblsetTokuisakiCdclose.Focus();
// return;
// }
//}
//日付フォーマット生成、およびチェック
strYMDformat = txtYMopen.chkDateYMDataFormat(txtYMopen.Text);
//開始年月日の日付チェック
if (strYMDformat == "")
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が日付でない場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMopen.Focus();
return;
}
else
{
txtYMopen.Text = strYMDformat;
}
//初期化
strYMDformat = "";
//日付フォーマット生成、およびチェック
strYMDformat = txtYMclose.chkDateYMDataFormat(txtYMclose.Text);
//終了年月日の日付チェック
if (strYMDformat == "")
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が日付でない場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMclose.Focus();
return;
}
else
{
txtYMclose.Text = strYMDformat;
}
this.Cursor = Cursors.Default;
//年月日が空の場合
if (txtYMopen.blIsEmpty() == false)
{
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMopen.Focus();
return;
}
//年月日が空の場合
if (txtYMclose.blIsEmpty() == false)
{
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMclose.Focus();
return;
}
//検索開始得意先コードのチェック
if (lblsetTokuisakiCdopen.chkTxtTorihikisaki() == true)
{
lblsetTokuisakiCdopen.Focus();
return;
}
//検索終了得意先コードのチェック
if (lblsetTokuisakiCdclose.chkTxtTorihikisaki() == true)
{
lblsetTokuisakiCdclose.Focus();
return;
}
////パワーユーザーの場合
//if ("1".Equals(this.etsuranFlg))
//{
// //スルー
//}
//else
//{
// //データチェック（年月度が同じの場合）
// if (txtYMopen.Text == txtYMclose.Text)
// {
// //一か月単位は出来ないメッセージ（OK）
// BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_VIEW, "１ケ月単位は指定できません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
// basemessagebox.ShowDialog();
// txtYMopen.Focus();
// return;
// }
//}
this.Cursor = Cursors.WaitCursor;
DataTable dtGridViewTokusaki = new DataTable();
List <string> lstStringViewData = new List <string>();
lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText);
lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText);
////パワーユーザーの場合
//if ("1".Equals(this.etsuranFlg))
//{
// lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText);
//}
//else
//{
// lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText);
//}
string strShuturyoku = "";
//出力順のラジオボタン判定
if (radShuturyoku.radbtn0.Checked == true)
{
strShuturyoku = "Tokuisaki";
}
else
{
strShuturyoku = "Hurigana";
}
lstStringViewData.Add(DateTime.Parse(txtYMopen.Text).ToString("yyyy/MM/dd"));
lstStringViewData.Add(DateTime.Parse(txtYMclose.Text).ToString("yyyy/MM/dd"));
lstStringViewData.Add(strShuturyoku);
C0520_KaikakekinZandakaIchiranKakunin_B kaikakekakuninB = new C0520_KaikakekinZandakaIchiranKakunin_B();
try
{
dtPrintData = kaikakekakuninB.getPrintData(lstStringViewData);
this.Cursor = Cursors.Default;
//初期値
Common.Form.PrintForm pf = new Common.Form.PrintForm(this, "", CommonTeisu.SIZE_A4, YOKO);
pf.ShowDialog(this);
//プレビューの場合
if (this.printFlg == CommonTeisu.ACTION_PREVIEW)
{
//現在時間と使用者ＰＣユーザー名を確保
lstTorihiki.Add(DateTime.Now.ToString());
lstTorihiki.Add(SystemInformation.UserName);
this.Cursor = Cursors.WaitCursor;
//結果セットをレコードセットに
strFile = kaikakekakuninB.dbToPdf(dtPrintData, lstTorihiki);
this.Cursor = Cursors.Default;
//印刷できなかった場合
if (strFile == "")
{
//印刷時エラーメッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
// プレビュー
pf.execPreview(strFile);
}
// 一括印刷の場合
else if (this.printFlg == CommonTeisu.ACTION_PRINT)
{
//現在時間と使用者ＰＣユーザー名を確保
lstTorihiki.Add(DateTime.Now.ToString());
lstTorihiki.Add(SystemInformation.UserName);
this.Cursor = Cursors.WaitCursor;
//結果セットをレコードセットに
strFile = kaikakekakuninB.dbToPdf(dtPrintData, lstTorihiki);
this.Cursor = Cursors.Default;
//印刷できなかった場合
if (strFile == "")
{
//印刷時エラーメッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
// 一括印刷
pf.execPrint(null, strFile, CommonTeisu.SIZE_A4, CommonTeisu.YOKO, true);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
//データロギング
new CommonException(ex);
//例外発生メッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
}
/// <summary>
/// Settings the read only for schedule grid.
/// </summary>
private void SettingReadOnlyForScheduleGrid()
{
try
{
ScheduleSearchDataGridView.ScrollBars = ScrollBars.Both;
DataGridViewColumnCollection columns = this.ScheduleSearchDataGridView.Columns;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].ReadOnly = true;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleIDColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.ScheduleNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.StreetAddressColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.NAICSColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.DescriptionColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.ParcelNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.StatementNumberColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerIDColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.OwnerNameColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.LegalColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.DistrictColumn.ColumnName].SortMode = DataGridViewColumnSortMode.Programmatic;
columns[this.scheduleSelectionData.GetScheduleSelection.RollYearColumn.ColumnName].HeaderText = "Roll Year";
columns[this.scheduleSelectionData.GetScheduleSelection.FilingDateColumn.ColumnName].HeaderText = "Filling Date";
columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].HeaderText = "Business Name";
columns[this.scheduleSelectionData.GetScheduleSelection.PropertyTypeColumn.ColumnName].HeaderText = "Property Type";
columns[this.scheduleSelectionData.GetScheduleSelection.BuisnessNameColumn.ColumnName].Width = 150;
}
catch (Exception ex)
{
ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm);
}
}
///<summary>
/// F10：Excel出力
///</summary>
private void exportXls()
{
// SaveFileDialogクラスのインスタンスを作成
SaveFileDialog sfd = new SaveFileDialog();
// ファイル名の指定
sfd.FileName = "買掛金残高一覧確認_" + DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss") + ".xlsx";
// デフォルトパス取得（デスクトップ）
string Init_dir = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
//はじめに表示されるフォルダを指定する
sfd.InitialDirectory = Init_dir;
// ファイルフィルタの設定
sfd.Filter = "すべてのファイル(*.*)|*.*";
if (sfd.ShowDialog() == DialogResult.OK)
{
// グリッドに表示されていない場合
if (gridTokuisaki.Rows.Count == 0)
{
return;
}
//データの取り出し用
DataTable dtPrintData = new DataTable();
//列情報を取得
DataGridViewColumnCollection cols = gridTokuisaki.Columns;
//行情報を取得
DataGridViewRowCollection rows = gridTokuisaki.Rows;
//取引先経理情報登録時の情報
List <string> lstTorihiki = new List <string>();
//年月日の日付フォーマット後を入れる用
string strYMDformat = "";
this.Cursor = Cursors.WaitCursor;
//空チェック（開始得意先コード）
if (StringUtl.blIsEmpty(lblsetTokuisakiCdopen.CodeTxtText) == false)
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
lblsetTokuisakiCdopen.Focus();
return;
}
//空チェック（終了得意先コード）
if (StringUtl.blIsEmpty(lblsetTokuisakiCdclose.CodeTxtText) == false)
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
lblsetTokuisakiCdclose.Focus();
return;
}
//日付フォーマット生成、およびチェック
strYMDformat = txtYMopen.chkDateYMDataFormat(txtYMopen.Text);
//開始年月日の日付チェック
if (strYMDformat == "")
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が日付でない場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMopen.Focus();
return;
}
else
{
txtYMopen.Text = strYMDformat;
}
//初期化
strYMDformat = "";
//日付フォーマット生成、およびチェック
strYMDformat = txtYMclose.chkDateYMDataFormat(txtYMclose.Text);
//終了年月日の日付チェック
if (strYMDformat == "")
{
this.Cursor = Cursors.Default;
// メッセージボックスの処理、項目が日付でない場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "入力された日付が正しくありません。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMclose.Focus();
return;
}
else
{
txtYMclose.Text = strYMDformat;
}
this.Cursor = Cursors.Default;
//年月日が空の場合
if (txtYMopen.blIsEmpty() == false)
{
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMopen.Focus();
return;
}
//年月日が空の場合
if (txtYMclose.blIsEmpty() == false)
{
// メッセージボックスの処理、項目が空の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_INPUT, "項目が空です。\r\n日付を入力してください。 ", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
txtYMclose.Focus();
return;
}
//検索開始得意先コードのチェック
if (lblsetTokuisakiCdopen.chkTxtTorihikisaki() == true)
{
lblsetTokuisakiCdopen.Focus();
return;
}
//検索終了得意先コードのチェック
if (lblsetTokuisakiCdclose.chkTxtTorihikisaki() == true)
{
lblsetTokuisakiCdclose.Focus();
return;
}
this.Cursor = Cursors.WaitCursor;
DataTable dtGridViewTokusaki = new DataTable();
List <string> lstStringViewData = new List <string>();
lstStringViewData.Add(lblsetTokuisakiCdopen.CodeTxtText);
lstStringViewData.Add(lblsetTokuisakiCdclose.CodeTxtText);
string strShuturyoku = "";
//出力順のラジオボタン判定
if (radShuturyoku.radbtn0.Checked == true)
{
strShuturyoku = "Tokuisaki";
}
else
{
strShuturyoku = "Hurigana";
}
lstStringViewData.Add(DateTime.Parse(txtYMopen.Text).ToString("yyyy/MM/dd"));
lstStringViewData.Add(DateTime.Parse(txtYMclose.Text).ToString("yyyy/MM/dd"));
lstStringViewData.Add(strShuturyoku);
C0520_KaikakekinZandakaIchiranKakunin_B kaikakekakuninB = new C0520_KaikakekinZandakaIchiranKakunin_B();
try
{
DataTable dtXlsData = kaikakekakuninB.getPrintData(lstStringViewData);
if (dtXlsData.Rows.Count > 0)
{
CreatePdf cpdf = new CreatePdf();
// 出力するヘッダを設定
string[] header =
{
"コード",
"得意先名",
"年月",
"前月買掛残",
"支払現金",
"支払小切手",
"支払振込",
"支払手形",
"支払相殺",
"支払手数料",
"支払その他",
"繰越残高",
"当月仕入高",
"当月消費税",
"当月残高",
"税区",
};
// Linqで出力対象の項目をSelect
// カラム名は以下のようにつける(カラム名でフォーマットを判断するため)
// 金額関係：＊＊＊kingaku
// 単価関係：＊＊＊tanka
// 原価：＊＊＊genka
// 数量：＊＊＊suryo
var outDat = dtXlsData.AsEnumerable()
.Select(dat => new
{
code = dat["コード"],
tokuisakiName = dat["得意先名"],
YM = dat["年月"],
zenkaikakezanKingaku = dat["前月買掛残"],
siharaiGenkinKingaku = dat["支払現金"],
siharaiKogiteKingaku = dat["支払小切手"],
siharaiFurikomiKingaku = dat["支払振込"],
siharaiTegataKingaku = dat["支払手形"],
siharaiSosaiKingaku = dat["支払相殺"],
siharaiTesuryoKingaku = dat["支払手数料"],
siharaiSonotaKingaku = dat["支払その他"],
kurikosizanKingaku = dat["繰越残高"],
togetuUriageKingaku = dat["当月仕入高"],
togetuZeiKingaku = dat["当月消費税"],
togetuZanKingaku = dat["当月残高"],
zeiku = dat["税区"]
}).ToList();
// listをDataTableに変換
DataTable dtKaikakeZan = cpdf.ConvertToDataTable(outDat);
string outFile = sfd.FileName;
cpdf.DtToXls(dtKaikakeZan, "買掛金残高一覧確認", outFile, 3, 1, header);
this.Cursor = Cursors.Default;
// メッセージボックスの処理、Excel作成完了の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_VIEW, "Excelファイルを作成しました。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_INFOMATION);
basemessagebox.ShowDialog();
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
//データロギング
new CommonException(ex);
//例外発生メッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
}
}
private static IDataGridViewColumnCollection GetColumnCollectionWithMock(out DataGridViewColumnCollection mock)
{
DataGridView dataGridView = new DataGridView();
mock = MockRepository.GenerateMock<Gizmox.WebGUI.Forms.DataGridViewColumnCollection>(dataGridView);
return new DataGridViewVWG.DataGridViewColumnCollectionVWG(mock);
}
private void SetRequestColumns(DataGridViewColumnCollection columns)
{
DataGridViewColumn column;
DataGridViewCellStyle style;
//
//Index
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Id";
column.HeaderText = "Id";
column.Name = "clmRequestId";
column.Width = 40;
//
//Request
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "Request";
column.HeaderText = "Request";
column.Name = "clmRequest";
column.Width = 150;
//
// Start
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Format = "MMM dd, HH:mm:ss.fff";
column.DataPropertyName = "StartDate";
column.DefaultCellStyle = style;
column.HeaderText = "Start";
column.Name = "clmStart";
column.Width = 110;
//
// clmFinish
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Format = "HH:mm:ss.fff";
column.DataPropertyName = "FinishDate";
column.DefaultCellStyle = style;
column.HeaderText = "Finish";
column.Name = "clmFinish";
column.Visible = false;
column.Width = 75;
//
// clmTotalTime
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
style = new DataGridViewCellStyle();
style.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
style.Format = "N0";
column.DataPropertyName = "TotalTime";
column.DefaultCellStyle = style;
column.HeaderText = "Total time";
column.Name = "clmTotalTime";
column.Width = 80;
//
// clmConnectId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ConnectId";
column.HeaderText = "ConnectId";
column.Name = "clmConnectId";
column.Visible = false;
column.Width = 70;
//
// clmLoginId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "LoginId";
column.HeaderText = "LoginId";
column.Name = "clmLoginId";
column.Visible = false;
column.Width = 70;
//
// clmCallId
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "CallId";
column.HeaderText = "CallId";
column.Name = "clmCallId";
column.Visible = false;
column.Width = 70;
//
// clmUserName
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "UserName";
column.HeaderText = "User";
column.Name = "clmUserName";
column.Visible = false;
column.Width = 70;
//
// clmThreadName
//
column = new DataGridViewTextBoxColumn();
columns.Add(column);
column.DataPropertyName = "ThreadName";
column.HeaderText = "Thread";
column.Name = "clmThreadName";
column.Visible = false;
}
