Прописал
| Код |
MessageBox.Show("well done");
|
Успешно выдало сообщение, после чего та же история.
Привожу полный код программки:
| Код |
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
namespace RFID_prj
{
/// <summary>
/// Summary description for ship_invoice.
/// </summary>
public class ship_invoice : System.Windows.Forms.Form
{
public DataTable dtable;
/// <summary>
/// № паллеты по накладноя для отгрузки
/// </summary>
public static int _pallet_count=1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
public ship_invoice(string invoice)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
this.tb_invoice.Text=invoice;
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
private void ship_invoice_Load(object sender, System.EventArgs e)
{
dtable=new DataTable("names");
dtable.Columns.Add("dot",typeof(System.String));
dtable.Columns.Add("name",typeof(System.String));
dtable.Columns.Add("amount",typeof(System.String));
dtable.Columns.Add("amountfact36",typeof(System.String));
dtable.Columns.Add("amountfact56",typeof(System.String));
dtable.Columns.Add("stat",typeof(System.String));
DataSet ds=new DataSet();
ds.Tables.Add(dtable);
dg.SetDataBinding(ds,"names");
AddTableStyle();
AddData();
}
private void AddTableStyle()
{
DataGridTableStyle dgts=new DataGridTableStyle();
dgts.MappingName="names";
dgts.AllowSorting=false;
DataGridTextBoxColumn db=new DataGridTextBoxColumn();
dgts.RowHeadersVisible=false;
db.MappingName="dot";
db.Alignment=HorizontalAlignment.Center;
db.HeaderText="№ паллеты";
db.Width=80;
dgts.GridColumnStyles.Add(db);
db=new DataGridTextBoxColumn();
db.MappingName="name";
db.HeaderText="Наименование продукции";
db.Alignment=HorizontalAlignment.Center;
db.Width=300;
dgts.GridColumnStyles.Add(db);
db=new DataGridTextBoxColumn();
db.MappingName="amount";
db.HeaderText="Количество";
db.Width=125;
db.Alignment=HorizontalAlignment.Center;
dgts.GridColumnStyles.Add(db);
ColoredTextBoxColumn coloredColumn1 = new ColoredTextBoxColumn();
coloredColumn1.MappingName = "amountfact36";
coloredColumn1.HeaderText = "";
coloredColumn1.Width=0;
coloredColumn1.Alignment=HorizontalAlignment.Center;
coloredColumn1.NeedBackground += new ColoredTextBoxColumn.NeedBackgroundEventHandler(OnNeedBackround_fact);
dgts.GridColumnStyles.Add(coloredColumn1);
coloredColumn1 = new ColoredTextBoxColumn();
coloredColumn1.MappingName = "amountfact56";
coloredColumn1.HeaderText = "";
coloredColumn1.Width=0;
coloredColumn1.Alignment=HorizontalAlignment.Center;
coloredColumn1.NeedBackground += new ColoredTextBoxColumn.NeedBackgroundEventHandler(OnNeedBackround_fact);
dgts.GridColumnStyles.Add(coloredColumn1);
ColoredTextBoxColumn coloredColumn = new ColoredTextBoxColumn();
coloredColumn.MappingName = "stat";
coloredColumn.HeaderText = "";
coloredColumn.Width=0;
coloredColumn.Alignment=HorizontalAlignment.Center;
coloredColumn.NeedBackground += new ColoredTextBoxColumn.NeedBackgroundEventHandler(OnNeedBackround);
DataGridTableStyle tableStyle = new DataGridTableStyle();
dgts.GridColumnStyles.Add(coloredColumn);
dg.TableStyles.Add(dgts);
}
private void AddData()
{
dtable.Clear();
MySql.Data.MySqlClient.MySqlCommand cmd=new MySql.Data.MySqlClient.MySqlCommand("SELECT pallet,count(*),invoice2_mas.series,max(numfrom),max(numtill) from invoice2_mas left join tagstate on invoice2_mas.UID=tagstate.UID where invoice='new' group by pallet",LogIn.conn);
MySqlDataReader reader=null;
try
{
reader=cmd.ExecuteReader();
while(reader.Read())
{
DataRow drow=dtable.NewRow();
drow[0]=reader.GetString(0);
drow[1]="Трудовые книжки";
drow[2]=reader.GetString(1);
dtable.Rows.Add(drow);
drow=dtable.NewRow();
drow[0]="";
drow[1]="Серия "+reader.GetString(2)+" № с "+reader.GetString(3)+" по "+reader.GetString(4);
drow[2]=Convert.ToString(reader.GetInt32(1)*250);
dtable.Rows.Add(drow);
}
}
catch(MySqlException ex)
{
MessageBox.Show("Произошла ошибка при заполнении данных по текущей накладной.\nКод Ошибки:\n"+ex.Message);
}
catch(Exception ex)
{
MessageBox.Show("Произошла ошибка при заполнении данных по текущей накладной.\nКод Ошибки:\n"+ex.Message);
}
finally
{
if(reader!=null)
reader.Close();
}
}
void OnNeedBackround(object sender, ColoredTextBoxColumn.NeedBackgroundEventArgs e)
{
switch((string)dg[e.RowNum,5])
{
case "комплект":
{
e.Brush=new SolidBrush(Color.SpringGreen);
break;
}
case "нет комплекта...":
{
e.Brush=new SolidBrush(Color.Tomato);
break;
}
default:
{
e.Brush=new SolidBrush(Color.White);
break;
}
}
}
/// <summary>
/// Разрисовка ячеек для количества считанных меток
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void OnNeedBackround_fact(object sender, ColoredTextBoxColumn.NeedBackgroundEventArgs e)
{
switch((string)dg[e.RowNum,4])
{
case "нет комплекта...":
{
e.Brush=new SolidBrush(Color.Red);
break;
}
default:
{
e.Brush=new SolidBrush(Color.White);
break;
}
}
}
private void but_add_Click(object sender, System.EventArgs e)
{
try
{
Add_TK1 isa=new Add_TK1(this.tb_invoice.Text);
isa.TopMost=true;
isa.ShowDialog();
MessageBox.Show("well done");
}
catch(System.Runtime.InteropServices.SEHException ex)
{
MessageBox.Show(ex.Message,"1st");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message,"2nd");
}
}
}
}
|
|
