private void InitilizeSplGrid()
{
if (dgSpl.Rows.Count > 0)
{
dgSpl.Rows.Clear();
}
if (dgSpl.Columns.Count > 0)
{
dgSpl.Columns.Clear();
}
dgSpl.Dock = DockStyle.Fill;
//0
dgSpl.Columns.Add("Id", "Id");
dgSpl.Columns["Id"].Width = 0;
dgSpl.Columns["Id"].Visible = false;
dgSpl.Columns["Id"].ReadOnly = true;
//1
dgSpl.Columns.Add("cName", "Client Name");
dgSpl.Columns["cName"].Width = 200;
dgSpl.Columns["cName"].Visible = false;
dgSpl.Columns["cName"].ReadOnly = true;
dgSpl.Columns["cName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgSpl.Columns.Add("fName", "Format Name");
dgSpl.Columns["fName"].Width = 200;
dgSpl.Columns["fName"].Visible = true;
dgSpl.Columns["fName"].ReadOnly = true;
dgSpl.Columns["fName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgSpl.Columns.Add("pName", "Playlist Name");
dgSpl.Columns["pName"].Width = 400;
dgSpl.Columns["pName"].Visible = true;
dgSpl.Columns["pName"].ReadOnly = true;
dgSpl.Columns["pName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgSpl.Columns.Add("sTime", "Start Time");
dgSpl.Columns["sTime"].Width = 200;
dgSpl.Columns["sTime"].Visible = true;
dgSpl.Columns["sTime"].ReadOnly = true;
dgSpl.Columns["sTime"].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgSpl.Columns.Add("eTime", "End Time");
dgSpl.Columns["eTime"].Width = 200;
dgSpl.Columns["eTime"].Visible = true;
dgSpl.Columns["eTime"].ReadOnly = true;
dgSpl.Columns["eTime"].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgSpl.Columns.Add("wDay", "Week Day");
dgSpl.Columns["wDay"].Width = 200;
dgSpl.Columns["wDay"].Visible = true;
dgSpl.Columns["wDay"].ReadOnly = true;
dgSpl.Columns["wDay"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewLinkColumn EditAdvt = new DataGridViewLinkColumn();
EditAdvt.HeaderText = "Edit";
EditAdvt.Text = "Edit";
EditAdvt.DataPropertyName = "Edit";
dgSpl.Columns.Add(EditAdvt);
EditAdvt.UseColumnTextForLinkValue = true;
EditAdvt.Width = 70;
EditAdvt.Visible = true;
dgSpl.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgSpl.Columns.Add("TokenId", "TokenId");
dgSpl.Columns["TokenId"].Width = 0;
dgSpl.Columns["TokenId"].Visible = false;
dgSpl.Columns["TokenId"].ReadOnly = true;
}
public Form1()
{
InitializeComponent();
_updatedHDrives = new List <HDriveInformation.HDriveData>();
this.SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.OptimizedDoubleBuffer | ControlStyles.UserPaint, true);
_foundHdrives = new List <HDriveInformation.HDriveData>();
_storedData = new ConfigFile("config.xml");
dataGridView.RowHeadersWidth = 4; // the left row header size.
dataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
dataGridView.AllowUserToResizeRows = false;
dataGridView.AutoResizeColumns();
dataGridView.ColumnCount = 7;
dataGridView.Columns[0].Name = "IP";
dataGridView.Columns[1].Name = "MAC";
dataGridView.Columns[2].Name = "S/N";
dataGridView.Columns[3].Name = "FW. version";
dataGridView.Columns[4].Name = "GUI version";
dataGridView.Columns[5].Name = "Boot version";
dataGridView.Columns[6].Name = "App ID";
DataGridViewProgressColumn column = new DataGridViewProgressColumn();
column.HeaderText = "Progress";
dataGridView.Columns.Add(column);
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
var fwUpdate = new DataGridViewLinkColumn();
fwUpdate.UseColumnTextForLinkValue = true;
fwUpdate.HeaderText = "FW update";
fwUpdate.Text = "update";
dataGridView.Columns.Add(fwUpdate);
var guiUpdateButton = new DataGridViewLinkColumn();
guiUpdateButton.UseColumnTextForLinkValue = true;
guiUpdateButton.HeaderText = "GUI update";
guiUpdateButton.Text = "update";
dataGridView.Columns.Add(guiUpdateButton);
var uploadConfigFile = new DataGridViewLinkColumn();
uploadConfigFile.UseColumnTextForLinkValue = true;
uploadConfigFile.HeaderText = "Upload config";
uploadConfigFile.Text = "upload";
dataGridView.Columns.Add(uploadConfigFile);
dataGridView.Columns[0].Width = 90;
dataGridView.Columns[1].Width = 120;
dataGridView.Columns[2].Width = 60;
dataGridView.Columns[3].Width = 90;
dataGridView.Columns[4].Width = 90;
dataGridView.Columns[5].Width = 90;
dataGridView.Columns[6].Width = 70;
dataGridView.Columns[7].Width = 70;
dataGridView.Columns[8].Width = 80;
dataGridView.Columns[9].Width = 80;
dataGridView.Columns[10].Width = 80;
var t1 = new System.Windows.Forms.Timer();
t1.Tick += UpdateProgressBar;
t1.Interval = 100;
t1.Start();
_buttonVisibility = false;
dataGridView.Rows.Clear();
_hdriveSearcher = new FindHDrives(
int.Parse(_storedData.getParameter("PingTimeout"))
, int.Parse(_storedData.getParameter("StartIP"))
, int.Parse(_storedData.getParameter("StopIP"))
, _storedData.getParameter("BaseIP")
, int.Parse(_storedData.getParameter("PingSequenceTimeout"))
, NewHDriveFound
, HDriveSearchFinished
);
_hdriveSearcher.StartPingSweep();
}
private void Reservations_Load(object sender, EventArgs e)
{
string s = "select Reservation_date,R_id from Reserve_Info where cust_email='" + email + "'";
DataTable dt1 = dataaccess_layer.GetRecords(s);
for (int i = 0; i < dt1.Rows.Count; i++)
{
TimeSpan ts = DateTime.Now.Date.Subtract(Convert.ToDateTime(dt1.Rows[i][0]));
int no_of_days = ts.Days;
if (no_of_days > 7)
{
string s1 = "Delete from Reserve_Info where R_id='" + dt1.Rows[i][1] + "'";
dataaccess_layer.ProcessQuery(s1);
}
}
DataTable dt = new DataTable();
string conn = "Data Source=DESKTOP-OPN87JD\\SQLEXPRESS;Initial Catalog=ExpDB;Integrated Security=True";
SqlConnection sc = null;
sc = new SqlConnection(conn);
try
{
sc.Open();
SqlCommand cmd = new SqlCommand("Reservations", sc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", email);
SqlDataReader sdr = cmd.ExecuteReader();
dt.Columns.Add("Reservation ID");
dt.Columns.Add("Flight Number");
dt.Columns.Add("Airlines");
dt.Columns.Add("Ticket Type");
dt.Columns.Add("Source");
dt.Columns.Add("Date Of Journey");
dt.Columns.Add("Departure time");
dt.Columns.Add("Destination");
dt.Columns.Add("Price");
dt.Columns.Add("Number Of Passengers");
dt.Columns.Add("Passenger 1");
dt.Columns.Add("Passenger 2");
dt.Columns.Add("Passenger 3");
dt.Columns.Add("Passenger 4");
dt.Columns.Add("Passenger 5");
while (sdr.Read())
{
DataRow dr = dt.NewRow();
dr["Reservation ID"] = sdr["R_id"];
dr["Flight Number"] = sdr["F_NO"];
dr["Airlines"] = sdr["A_NAME"];
dr["Source"] = sdr["src"];
dr["Ticket Type"] = sdr["Ticket_type"];
dr["Date Of Journey"] = sdr["DOJ"];
dr["Destination"] = sdr["dest"];
dr["Departure time"] = sdr["DEPART_TIME"];
dr["Price"] = sdr["Fare"];
if (sdr["Ticket_type"].ToString() == "Economy")
{
dr["Number Of Passengers"] = sdr["No_of_seats_Economy"];
}
else
{
dr["Number of Passengers"] = sdr["No_of_Business"];
}
dr["Passenger 1"] = sdr["Passenger1"];
dr["Passenger 2"] = sdr["Passenger2"];
dr["Passenger 3"] = sdr["Passenger3"];
dr["Passenger 4"] = sdr["Passenger4"];
dr["Passenger 5"] = sdr["Passenger5"];
dt.Rows.Add(dr);
dgreservations.DataSource = null;
dgreservations.DataSource = dt;
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Book";
Editlink.DataPropertyName = "lnkColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Book";
if (dgreservations.Columns.Count == 15)
{
dgreservations.Columns.Add(Editlink);
}
}
}
catch (Exception ex)
{
bussiness_accesslayer.LogErrorFile(ex.Message + DateTime.Now.ToLongDateString() + DateTime.Now.ToLongTimeString());
MessageBox.Show("Internal Error Occured", "Sorry");
this.BeginInvoke(new MethodInvoker(Close));
}
}
private void Gridview_Employee_Production_First_Date_Dataview()
{
Hashtable ht = new Hashtable();
System.Data.DataTable dt = new System.Data.DataTable();
Hashtable htlivecount = new Hashtable();
Hashtable htreworkcount = new Hashtable();
Hashtable htsuperqccount = new Hashtable();
DataTable dtlivecount = new DataTable();
DataTable dtreworkcount = new DataTable();
DataTable dtsuperqccount = new DataTable();
Hashtable htlivetype = new Hashtable();
DataTable dtlivetype = new DataTable();
Hashtable htReworktype = new Hashtable();
DataTable dtReworktype = new DataTable();
Hashtable htSuperqctype = new Hashtable();
DataTable dtsuperqctype = new DataTable();
if (Employee_Completd != "0")
{
htlivecount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_LIVE_Completed_Order_Status_Count");
htlivecount.Add("@Firstdate", First_Date);
htlivecount.Add("@Hour", Employee_Hour);
htlivecount.Add("@User_Id", Employee_User_Id);
htreworkcount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_REWORK_Completed_Order_Status_Count");
htreworkcount.Add("@Firstdate", First_Date);
htreworkcount.Add("@Hour", Employee_Hour);
htreworkcount.Add("@User_Id", Employee_User_Id);
htsuperqccount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_SUPER_QC_Completed_Order_Status_Count");
htsuperqccount.Add("@Firstdate", First_Date);
htsuperqccount.Add("@Hour", Employee_Hour);
htsuperqccount.Add("@User_Id", Employee_User_Id);
htlivetype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_LIVE_Completed_OrderType_Wise_Status_Count");
htlivetype.Add("@Firstdate", First_Date);
htlivetype.Add("@Hour", Employee_Hour);
htlivetype.Add("@User_Id", Employee_User_Id);
htReworktype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_REWORK_Completed_OrderType_Wise_Status_Count");
htReworktype.Add("@Firstdate", First_Date);
htReworktype.Add("@Hour", Employee_Hour);
htReworktype.Add("@User_Id", Employee_User_Id);
htSuperqctype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_SUPER_QC_Completed_OrderType_Wise_Status_Count");
htSuperqctype.Add("@Firstdate", First_Date);
htSuperqctype.Add("@Hour", Employee_Hour);
htSuperqctype.Add("@User_Id", Employee_User_Id);
}
else if (Employee_Completd == "0")
{
htlivecount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_LIVE_NOT_Completed_Order_Status_Count");
htlivecount.Add("@Firstdate", First_Date);
htlivecount.Add("@Hour", Employee_Hour);
htlivecount.Add("@User_Id", Employee_User_Id);
htreworkcount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_REWORK_NOT_Completed_Order_Status_Count");
htreworkcount.Add("@Firstdate", First_Date);
htreworkcount.Add("@Hour", Employee_Hour);
htreworkcount.Add("@User_Id", Employee_User_Id);
htsuperqccount.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_SUPER_QC_NOT_Completed_Order_Status_Count");
htsuperqccount.Add("@Firstdate", First_Date);
htsuperqccount.Add("@Hour", Employee_Hour);
htsuperqccount.Add("@User_Id", Employee_User_Id);
htlivetype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_LIVE_NOT_Completed_OrderType_Wise_Status_Count");
htlivetype.Add("@Firstdate", First_Date);
htlivetype.Add("@Hour", Employee_Hour);
htlivetype.Add("@User_Id", Employee_User_Id);
htReworktype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_REWORK_NOT_Completed_OrderType_Wise_Status_Count");
htReworktype.Add("@Firstdate", First_Date);
htReworktype.Add("@Hour", Employee_Hour);
htReworktype.Add("@User_Id", Employee_User_Id);
htSuperqctype.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_SUPER_QC_NOT_Completed_OrderType_Wise_Status_Count");
htSuperqctype.Add("@Firstdate", First_Date);
htSuperqctype.Add("@Hour", Employee_Hour);
htSuperqctype.Add("@User_Id", Employee_User_Id);
}
dtlivecount = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htlivecount);
dtreworkcount = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htreworkcount);
dtsuperqccount = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htsuperqccount);
dtlivetype = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htlivetype);
dtReworktype = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htReworktype);
dtsuperqctype = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", htSuperqctype);
if (dtlivecount.Rows.Count > 0)
{
Grid_Live_Task_Count.DataSource = dtlivecount;
}
else
{
Grid_Live_Task_Count.Rows.Clear();
}
if (dtlivetype.Rows.Count > 0)
{
Grdi_Live_OrderType_Count.DataSource = dtlivetype;
}
else
{
Grdi_Live_OrderType_Count.Rows.Clear();
}
if (dtreworkcount.Rows.Count > 0)
{
Grid_Rework_Task_Count.DataSource = dtreworkcount;
}
else
{
Grid_Rework_Task_Count.Rows.Clear();
}
if (dtReworktype.Rows.Count > 0)
{
Grdi_Rework_OrderType_Count.DataSource = dtReworktype;
}
else
{
Grdi_Rework_OrderType_Count.Rows.Clear();
}
if (dtsuperqccount.Rows.Count > 0)
{
Grid_Super_Qc_Task_Count.DataSource = dtsuperqccount;
}
else
{
Grid_Super_Qc_Task_Count.Rows.Clear();
}
if (dtsuperqctype.Rows.Count > 0)
{
Grdi_Super_Qc_OrderType_Count.DataSource = dtsuperqctype;
}
else
{
Grdi_Super_Qc_OrderType_Count.Rows.Clear();
}
ArrangeGrid(Grid_Live_Task_Count);
ArrangeGrid(Grdi_Live_OrderType_Count);
ArrangeGrid(Grid_Rework_Task_Count);
ArrangeGrid(Grdi_Rework_OrderType_Count);
ArrangeGrid(Grid_Super_Qc_Task_Count);
ArrangeGrid(Grdi_Super_Qc_OrderType_Count);
if (Employee_Completd != "0")
{
ht.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_COMPLETED");
}
else
{
ht.Add("@Trans", "SELECT_BY_HOUR_BY_FIRST_DATE_NOT_COMPLETED");
}
ht.Add("@Hour", Employee_Hour);
ht.Add("@Firstdate", First_Date);
ht.Add("@User_Id", Employee_User_Id);
dttargetorder = dataaccess.ExecuteSP("Sp_User_24_7_Employee_Production_Report", ht);
if (dttargetorder.Rows.Count > 0)
{
System.Data.DataTable temptable = dttargetorder.Clone();
int startindex = currentpageindex * pagesize;
int endindex = currentpageindex * pagesize + pagesize;
if (endindex > dttargetorder.Rows.Count)
{
endindex = dttargetorder.Rows.Count;
}
for (int i = startindex; i < endindex; i++)
{
DataRow row = temptable.NewRow();
GetDataRow_Target_Orders(ref row, dttargetorder.Rows[i]);
temptable.Rows.Add(row);
}
lbl_total.Text = dttargetorder.Rows.Count.ToString();
if (temptable.Rows.Count > 0)
{
lbl_Name.Text = dttargetorder.Rows[0]["User_Name"].ToString();
}
if (temptable.Rows.Count > 0)
{
// grd_Targetorder.DataBind();
grd_Targetorder.DataSource = null;
grd_Targetorder.AutoGenerateColumns = false;
grd_Targetorder.ColumnCount = 14;
grd_Targetorder.Columns[0].Name = "SNo";
grd_Targetorder.Columns[0].HeaderText = "S. No";
grd_Targetorder.Columns[0].Width = 65;
grd_Targetorder.Columns[1].Name = "Production Date";
grd_Targetorder.Columns[1].HeaderText = "PRODUCTION DATE";
grd_Targetorder.Columns[1].DataPropertyName = "Order_Production_Date";
grd_Targetorder.Columns[1].Width = 150;
grd_Targetorder.Columns[2].Name = "User Name";
grd_Targetorder.Columns[2].HeaderText = "USER NAME";
grd_Targetorder.Columns[2].DataPropertyName = "User_Name";
grd_Targetorder.Columns[2].Width = 110;
grd_Targetorder.Columns[3].Name = "Order Number";
grd_Targetorder.Columns[3].HeaderText = "ORDER NUMBER";
grd_Targetorder.Columns[3].DataPropertyName = "Client_Order_Number";
grd_Targetorder.Columns[3].Width = 175;
grd_Targetorder.Columns[3].Visible = false;
DataGridViewLinkColumn link = new DataGridViewLinkColumn();
grd_Targetorder.Columns.Add(link);
link.Name = "Order Number";
link.HeaderText = "ORDER NUMBER";
link.DataPropertyName = "Client_Order_Number";
link.Width = 200;
link.DisplayIndex = 1;
grd_Targetorder.Columns[4].Name = "Client Name";
grd_Targetorder.Columns[4].HeaderText = "CLIENT NAME";
grd_Targetorder.Columns[4].DataPropertyName = "Client_Name";
grd_Targetorder.Columns[4].Width = 130;
grd_Targetorder.Columns[5].Name = "SubProcessName";
grd_Targetorder.Columns[5].HeaderText = "SUB PROCESS NAME";
grd_Targetorder.Columns[5].DataPropertyName = "Sub_ProcessName";
grd_Targetorder.Columns[5].Width = 220;
grd_Targetorder.Columns[6].Name = "OrderType";
grd_Targetorder.Columns[6].HeaderText = "ORDER TYPE";
grd_Targetorder.Columns[6].DataPropertyName = "Order_Type";
grd_Targetorder.Columns[6].Width = 160;
grd_Targetorder.Columns[7].Name = "Order_Work_Type";
grd_Targetorder.Columns[7].HeaderText = "ORDER WORK TYPE";
grd_Targetorder.Columns[7].DataPropertyName = "Order_Work_Type";
grd_Targetorder.Columns[7].Width = 160;
grd_Targetorder.Columns[8].Name = "Task";
grd_Targetorder.Columns[8].HeaderText = "TASK";
grd_Targetorder.Columns[8].DataPropertyName = "Order_Status";
grd_Targetorder.Columns[8].Width = 120;
grd_Targetorder.Columns[9].Name = "Status";
grd_Targetorder.Columns[9].HeaderText = "PROGRESS STATUS";
grd_Targetorder.Columns[9].DataPropertyName = "Progress_Status";
grd_Targetorder.Columns[9].Width = 160;
grd_Targetorder.Columns[10].Name = "StartTime";
grd_Targetorder.Columns[10].HeaderText = "START TIME";
grd_Targetorder.Columns[10].DataPropertyName = "Start_Time";
grd_Targetorder.Columns[10].Width = 120;
grd_Targetorder.Columns[11].Name = "EndTime";
grd_Targetorder.Columns[11].HeaderText = "END TIME";
grd_Targetorder.Columns[11].DataPropertyName = "End_Time";
grd_Targetorder.Columns[11].Width = 120;
grd_Targetorder.Columns[12].Name = "TotalTime";
grd_Targetorder.Columns[12].HeaderText = "TOTAL TIME";
grd_Targetorder.Columns[12].DataPropertyName = "Total_Time";
grd_Targetorder.Columns[12].Width = 100;
grd_Targetorder.Columns[13].Name = "Order Id";
grd_Targetorder.Columns[13].HeaderText = "Order id";
grd_Targetorder.Columns[13].DataPropertyName = "Order_ID";
grd_Targetorder.Columns[13].Width = 100;
grd_Targetorder.Columns[13].Visible = false;
grd_Targetorder.DataSource = temptable;
}
else
{
grd_Targetorder.Visible = true;
//grd_Targetorder.Rows.Clear();
grd_Targetorder.DataSource = null;
}
lblRecordsStatus.Text = (currentpageindex + 1) + " / " + (int)Math.Ceiling(Convert.ToDecimal(dttargetorder.Rows.Count) / pagesize);
for (int i = 0; i < grd_Targetorder.Rows.Count; i++)
{
grd_Targetorder.Rows[i].Cells[0].Value = i + 1;
}
}
}
public void LoadData()
{
try
{
if (buttonclicked == 0)
{
if (updateid == "" || updateid == null)
{
grdstock.DataSource = null;
grdstock.Columns.Clear();
}
}
if (updateid == "")
{
DataGridViewLinkColumn bcol = new DataGridViewLinkColumn();
bcol.HeaderText = "Current Stock";
bcol.Text = "View";
bcol.Name = "CurrStock";
bcol.UseColumnTextForLinkValue = true;
grdstock.Columns.Add(bcol);
}
userrights = cs.getdataset("Select * from UserRights where isactive=1 and uid='" + Master.userid + "'");
if (cnt == 0)
{
#region ForInsertStockReportLoad
DTPFrom123.CustomFormat = Master.dateformate;
DataTable product = new DataTable();
//DataTable opstock = new DataTable();
//DataTable salestock = new DataTable();
//DataTable purchasestock = new DataTable();
//DataTable salereturnstock = new DataTable();
//DataTable purchasereturnstock = new DataTable();
//DataTable POSSale = new DataTable();
//DataTable production = new DataTable();
//DataTable adjuststock = new DataTable();
//dt.Columns.Add("Item Code");
//dt.Columns.Add("Name of Item");
//dt.Columns.Add("Make/Model");
//dt.Columns.Add("batch");
//dt.Columns.Add("Op. Stock");
//dt.Columns.Add("Purchase");
//dt.Columns.Add("Sale");
//dt.Columns.Add("POSSale");
//dt.Columns.Add("Sale Return");
//dt.Columns.Add("Purchase Return");
//dt.Columns.Add("Production");
//dt.Columns.Add("Closing");
//dt.Columns.Add("Total Amount");
//dt.Columns.Add("Adjust Stock");
//dt.Columns.Add("Remarks");
string columnname = "";
if (txtsearch.Text == "Make")
{
columnname = "companyname";
columnindex = 4;
}
else if (txtsearch.Text == "GroupName")
{
columnname = "GroupName";
}
else if (txtsearch.Text == "Item Name")
{
columnname = "Product_Name";
columnindex = 3;
}
else if (txtsearch.Text == "Item Code")
{
columnname = "itemnumber";
columnindex = 2;
}
//get productmaster
if (txtser.Text == "")
{
if (buttonclicked == 0)
{
// dt = cs.getdataset("select p.ProductID as Id,p.itemnumber as [Item Code],p.Product_Name as [Name of item],c.companyname as [Make/Model],pp.Batchno as Batch,0 as [Adjust Stock],'' as Remark from productmaster p inner join (select productid, Batchno from productpricemaster where isactive=1) as pp on pp.productid=p.productid inner join companymaster c on c.companyid=p.companyid where p.isactive=1 order by p.product_name");
dt = cs.getdataset("select p.ProductID as Id,p.itemnumber as [Item Code],p.Product_Name as [Name of item],c.companyname as [Make/Model],pp.Batchno as Batch,0 as [Adjust Stock],'' as Remark,pp.ProPriceid from productmaster p inner join (select productid, Batchno,ProPriceid from productpricemaster where isactive=1) as pp on pp.productid=p.productid inner join companymaster c on c.companyid=p.companyid where p.isactive=1 order by p.product_name");
bindgrid();
}
else
{
AllGridviewByEmpId("");
}
}
else
{
if (txtsearch.SelectedIndex == 0)
{
MessageBox.Show("Select Column Name");
return;
}
else
{
string query = txtser.Text.ToUpper();
FilterGridviewByEmpId(query, columnindex);
//foreach (DataGridViewRow row in grdstock.Rows)
//{
// CurrencyManager currencyManager1 = (CurrencyManager)BindingContext[grdstock.DataSource];
// currencyManager1.SuspendBinding();
// row.Visible = false;
// currencyManager1.ResumeBinding();
//}
//if (query.Trim() != "")
//{
// foreach (DataGridViewRow row in grdstock.Rows)
// {
// foreach (TableCell cell in row.Cells)
// {
// string cellText = cell.Text;
// if (cell.Text == "" && cell.Controls.Count > 0)
// {
// cellText = ((System.Web.UI.DataBoundLiteralControl)cell.Controls[0]).Text;
// }
// if (cellText.IndexOf(query) > -1)
// {
// row.Visible = true;
// break;
// }
// }
// }
//}
//else
//{
// foreach (GridViewRow row in grdstock.Rows)
// {
// row.Visible = true;
// }
//}
// dt = cs.getdataset("select p.ProductID as Id,p.itemnumber as [Item Code],p.Product_Name as [Name of item],c.companyname as [Make/Model],pp.Batchno as Batch,0 as [Adjust Stock],'' as Remark from productmaster p inner join (select productid, Batchno from productpricemaster where isactive=1) as pp on pp.productid=p.productid inner join companymaster c on c.companyid=p.companyid where p.isactive=1 and " + columnname + " like '%" + txtser.Text.Replace(" ", "%") + "%' order by p.product_name");
// bindgrid();
// FlagForStock = 1;
}
}
//POSSale = cs.getdataset("select ISNULL(SUM(Qty), 0) AS POSSale,ItemName,batchno from BillPOSProductMaster where isactive=1 group by ItemName,batchno");
//opstock = cs.getdataset("select * from productpricemaster where isactive=1");
//purchasestock = cs.getdataset("select ISNULL(SUM(Pqty), 0) AS Purchase, productid,batch from billproductmaster where Billtype = 'P' and isactive = 1 group by productid,batch");
//salestock = cs.getdataset("select ISNULL(SUM(Pqty), 0) AS Sale, productid,batch from billproductmaster where Billtype = 'S' and isactive = 1 group by productid,batch");
//salereturnstock = cs.getdataset("select ISNULL(SUM(Pqty), 0) AS SaleReturn, productid,batch from billproductmaster where Billtype = 'SR' and isactive = 1 group by productid,batch");
//purchasereturnstock = cs.getdataset("select ISNULL(SUM(Pqty), 0) AS PurchaseReturn, productid,batch from billproductmaster where Billtype = 'PR' and isactive = 1 group by productid,batch");
//production = cs.getdataset("select ISNULL(SUM(fQty), 0) AS fqty,proitem from tblfinishedgoodsqty where isactive=1 group by proitem");
//adjuststock = cs.getdataset("select ISNULL(SUM(adjuststock), 0) AS adjuststock, itemid,batch from stockadujestmentitemmaster where stockdate<='" + Convert.ToDateTime(DTPFrom.Text).ToString(Master.dateformate) + "' and isactive = 1 group by itemid,batch");
//for (int i = 0; i < product.Rows.Count; i++)
//{
// DataTable isbatch = cs.getdataset("select * from ProductPriceMaster where isactive=1 and Productid='" + product.Rows[i]["ProductID"].ToString() + "'");
// if (isbatch.Rows.Count > 0)
// {
// for (int k = 0; k < isbatch.Rows.Count; k++)
// {
// if(i== 6158)
// {
// }
// DataRow dr = dt.NewRow();
// dr["ID"] = product.Rows[i]["ProductID"].ToString();
// dr["Item Code"] = product.Rows[i]["itemnumber"].ToString();
// dr["Name of Item"] = product.Rows[i]["Product_Name"].ToString();
// dr["Make/Model"] = product.Rows[i]["companyname"].ToString();
// dr["batch"] = isbatch.Rows[k]["batchno"].ToString();
// dr["Adjust Stock"] = "0";
// dt.Rows.Add(dr);
// }
// }
//}
#endregion
}
else
{
#region ForUpdateStockReportLoad
//if (userrights.Rows.Count > 0)
//{
// if (userrights.Rows[28]["u"].ToString() == "False")
// {
// btnsubmit.Enabled = false;
// }
// if (userrights.Rows[28]["d"].ToString() == "False")
// {
// btndelete.Enabled = false;
// }
// if (userrights.Rows[28]["p"].ToString() == "False")
// {
// BtnPayment.Enabled = false;
// btnprint.Enabled = false;
// }
//}
#endregion
}
}
catch
{
}
}
private void InitializeComponent()
{
DataGridViewCellStyle dataGridViewCellStyle = new DataGridViewCellStyle();
DataGridViewCellStyle dataGridViewCellStyle2 = new DataGridViewCellStyle();
this.DataGridView2 = new DataGridView();
this.DataGridViewTextBoxColumn1 = new DataGridViewTextBoxColumn();
this.Column1 = new DataGridViewCheckBoxColumn();
this.Column2 = new DataGridViewCheckBoxColumn();
this.Column3 = new DataGridViewCheckBoxColumn();
this.Column4 = new DataGridViewCheckBoxColumn();
this.Column5 = new DataGridViewCheckBoxColumn();
this.Column6 = new DataGridViewCheckBoxColumn();
this.Column7 = new DataGridViewCheckBoxColumn();
this.Column8 = new DataGridViewCheckBoxColumn();
this.Column9 = new DataGridViewCheckBoxColumn();
this.Column10 = new DataGridViewCheckBoxColumn();
this.Column11 = new DataGridViewCheckBoxColumn();
this.Column12 = new DataGridViewCheckBoxColumn();
this.Column13 = new DataGridViewCheckBoxColumn();
this.Column14 = new DataGridViewCheckBoxColumn();
this.Column15 = new DataGridViewCheckBoxColumn();
this.Column16 = new DataGridViewCheckBoxColumn();
this.Column17 = new DataGridViewCheckBoxColumn();
this.Column18 = new DataGridViewCheckBoxColumn();
this.Column19 = new DataGridViewCheckBoxColumn();
this.Column20 = new DataGridViewCheckBoxColumn();
this.Column21 = new DataGridViewCheckBoxColumn();
this.Column22 = new DataGridViewCheckBoxColumn();
this.Column23 = new DataGridViewCheckBoxColumn();
this.Column24 = new DataGridViewCheckBoxColumn();
this.Column25 = new DataGridViewCheckBoxColumn();
this.Column26 = new DataGridViewCheckBoxColumn();
this.Column27 = new DataGridViewCheckBoxColumn();
this.Column28 = new DataGridViewCheckBoxColumn();
this.Column29 = new DataGridViewCheckBoxColumn();
this.Column30 = new DataGridViewCheckBoxColumn();
this.Column31 = new DataGridViewCheckBoxColumn();
this.Column32 = new DataGridViewCheckBoxColumn();
this.Column33 = new DataGridViewCheckBoxColumn();
this.Column34 = new DataGridViewCheckBoxColumn();
this.Column35 = new DataGridViewCheckBoxColumn();
this.Column36 = new DataGridViewCheckBoxColumn();
this.Column37 = new DataGridViewCheckBoxColumn();
this.Column38 = new DataGridViewTextBoxColumn();
this.Column39 = new DataGridViewTextBoxColumn();
this.Column40 = new DataGridViewTextBoxColumn();
this.Column41 = new DataGridViewLinkColumn();
((ISupportInitialize)this.DataGridView2).BeginInit();
base.SuspendLayout();
dataGridViewCellStyle.BackColor = Color.FromArgb(241, 244, 248);
this.DataGridView2.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle;
this.DataGridView2.BackgroundColor = Color.White;
this.DataGridView2.BorderStyle = BorderStyle.Fixed3D;
dataGridViewCellStyle2.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle2.BackColor = SystemColors.Control;
dataGridViewCellStyle2.Font = new Font("宋体", 9f, FontStyle.Regular, GraphicsUnit.Point, 134);
dataGridViewCellStyle2.ForeColor = SystemColors.WindowText;
dataGridViewCellStyle2.SelectionBackColor = SystemColors.Highlight;
dataGridViewCellStyle2.SelectionForeColor = SystemColors.HighlightText;
dataGridViewCellStyle2.WrapMode = DataGridViewTriState.True;
this.DataGridView2.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;
this.DataGridView2.ColumnHeadersHeight = 32;
this.DataGridView2.Columns.AddRange(new DataGridViewColumn[]
{
this.DataGridViewTextBoxColumn1,
this.Column1,
this.Column2,
this.Column3,
this.Column4,
this.Column5,
this.Column6,
this.Column7,
this.Column8,
this.Column9,
this.Column10,
this.Column11,
this.Column12,
this.Column13,
this.Column14,
this.Column15,
this.Column16,
this.Column17,
this.Column18,
this.Column19,
this.Column20,
this.Column21,
this.Column22,
this.Column23,
this.Column24,
this.Column25,
this.Column26,
this.Column27,
this.Column28,
this.Column29,
this.Column30,
this.Column31,
this.Column32,
this.Column33,
this.Column34,
this.Column35,
this.Column36,
this.Column37,
this.Column38,
this.Column39,
this.Column40,
this.Column41
});
this.DataGridView2.Dock = DockStyle.Fill;
this.DataGridView2.GridColor = SystemColors.ActiveBorder;
this.DataGridView2.Location = new Point(0, 0);
this.DataGridView2.MultiSelect = false;
this.DataGridView2.Name = "DataGridView2";
this.DataGridView2.RowTemplate.Height = 23;
this.DataGridView2.SelectionMode = DataGridViewSelectionMode.CellSelect;
this.DataGridView2.Size = new Size(911, 321);
this.DataGridView2.TabIndex = 22;
this.DataGridView2.CellMouseClick += new DataGridViewCellMouseEventHandler(this.DataGridView2CellMouseClick);
this.DataGridViewTextBoxColumn1.HeaderText = "端口号";
this.DataGridViewTextBoxColumn1.Name = "DataGridViewTextBoxColumn1";
this.DataGridViewTextBoxColumn1.Width = 40;
this.Column1.HeaderText = "电表状态字";
this.Column1.Name = "Column1";
this.Column1.Width = 50;
this.Column2.HeaderText = "搜寻新增或更换电表";
this.Column2.Name = "Column2";
this.Column2.Width = 80;
this.Column3.HeaderText = "定时校时";
this.Column3.Name = "Column3";
this.Column3.Width = 40;
this.Column4.HeaderText = "冻结抄表";
this.Column4.Name = "Column4";
this.Column4.Width = 40;
this.Column5.HeaderText = "只抄重点表";
this.Column5.Name = "Column5";
this.Column5.Width = 50;
this.Column6.HeaderText = "不允许自动抄表";
this.Column6.Name = "Column6";
this.Column6.Width = 60;
this.Column7.HeaderText = "1日";
this.Column7.Name = "Column7";
this.Column7.Width = 25;
this.Column8.HeaderText = "2日";
this.Column8.Name = "Column8";
this.Column8.Width = 25;
this.Column9.HeaderText = "3日";
this.Column9.Name = "Column9";
this.Column9.Width = 25;
this.Column10.HeaderText = "4日";
this.Column10.Name = "Column10";
this.Column10.Width = 25;
this.Column11.HeaderText = "5日";
this.Column11.Name = "Column11";
this.Column11.Width = 25;
this.Column12.HeaderText = "6日";
this.Column12.Name = "Column12";
this.Column12.Width = 25;
this.Column13.HeaderText = "7日";
this.Column13.Name = "Column13";
this.Column13.Width = 25;
this.Column14.HeaderText = "8日";
this.Column14.Name = "Column14";
this.Column14.Width = 25;
this.Column15.HeaderText = "9日";
this.Column15.Name = "Column15";
this.Column15.Width = 25;
this.Column16.HeaderText = "10日";
this.Column16.Name = "Column16";
this.Column16.Width = 25;
this.Column17.HeaderText = "11日";
this.Column17.Name = "Column17";
this.Column17.Width = 25;
this.Column18.HeaderText = "12日";
this.Column18.Name = "Column18";
this.Column18.Width = 25;
this.Column19.HeaderText = "13日";
this.Column19.Name = "Column19";
this.Column19.Width = 25;
this.Column20.HeaderText = "14日";
this.Column20.Name = "Column20";
this.Column20.Width = 25;
this.Column21.HeaderText = "15日";
this.Column21.Name = "Column21";
this.Column21.Width = 25;
this.Column22.HeaderText = "16日";
this.Column22.Name = "Column22";
this.Column22.Width = 25;
this.Column23.HeaderText = "17日";
this.Column23.Name = "Column23";
this.Column23.Width = 25;
this.Column24.HeaderText = "18日";
this.Column24.Name = "Column24";
this.Column24.Width = 25;
this.Column25.HeaderText = "19日";
this.Column25.Name = "Column25";
this.Column25.Width = 25;
this.Column26.HeaderText = "20日";
this.Column26.Name = "Column26";
this.Column26.Width = 25;
this.Column27.HeaderText = "21日";
this.Column27.Name = "Column27";
this.Column27.Width = 25;
this.Column28.HeaderText = "22日";
this.Column28.Name = "Column28";
this.Column28.Width = 25;
this.Column29.HeaderText = "23日";
this.Column29.Name = "Column29";
this.Column29.Width = 25;
this.Column30.HeaderText = "24日";
this.Column30.Name = "Column30";
this.Column30.Width = 25;
this.Column31.HeaderText = "25日";
this.Column31.Name = "Column31";
this.Column31.Width = 25;
this.Column32.HeaderText = "26日";
this.Column32.Name = "Column32";
this.Column32.Width = 25;
this.Column33.HeaderText = "27日";
this.Column33.Name = "Column33";
this.Column33.Width = 25;
this.Column34.HeaderText = "28日";
this.Column34.Name = "Column34";
this.Column34.Width = 25;
this.Column35.HeaderText = "29日";
this.Column35.Name = "Column35";
this.Column35.Width = 25;
this.Column36.HeaderText = "30日";
this.Column36.Name = "Column36";
this.Column36.Width = 25;
this.Column37.HeaderText = "31日";
this.Column37.Name = "Column37";
this.Column37.Width = 25;
this.Column38.HeaderText = "抄表(HHMM)";
this.Column38.Name = "Column38";
this.Column38.Width = 60;
this.Column39.HeaderText = "间隔时间";
this.Column39.Name = "Column39";
this.Column39.Width = 60;
this.Column40.HeaderText = "校时(DDHHmm)";
this.Column40.Name = "Column40";
this.Column40.Width = 60;
this.Column41.HeaderText = "时段表";
this.Column41.Name = "Column41";
this.Column41.Text = "00";
base.AutoScaleDimensions = new SizeF(6f, 12f);
base.ClientSize = new Size(911, 321);
base.Controls.Add(this.DataGridView2);
base.Name = "AFN04_33";
this.Text = "终端抄表运行参数设置";
((ISupportInitialize)this.DataGridView2).EndInit();
base.ResumeLayout(false);
}
private void InitializeComponent()
{
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
btn_pageRight = new System.Windows.Forms.Button();
btn_pageLeft = new System.Windows.Forms.Button();
l_status = new System.Windows.Forms.Label();
btn_statusAll = new System.Windows.Forms.Button();
btn_statusNormal = new System.Windows.Forms.Button();
btn_statusCancel = new System.Windows.Forms.Button();
l_memberList = new System.Windows.Forms.Label();
btn_quickManager = new System.Windows.Forms.Button();
l_pageInfo = new System.Windows.Forms.Label();
btn_firstPage = new System.Windows.Forms.Button();
btn_previousPage = new System.Windows.Forms.Button();
btn_nextPage = new System.Windows.Forms.Button();
btn_lastPage = new System.Windows.Forms.Button();
l_pageNow = new System.Windows.Forms.Label();
btn_SearchPurchase = new System.Windows.Forms.Button();
btn_CreatePurchase = new System.Windows.Forms.Button();
label1 = new System.Windows.Forms.Label();
tb_supplierKeyword = new System.Windows.Forms.TextBox();
dataGridView1 = new System.Windows.Forms.DataGridView();
Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column2 = new System.Windows.Forms.DataGridViewLinkColumn();
Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
hidden_Status = new System.Windows.Forms.DataGridViewTextBoxColumn();
btn_supplierFilter = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)pb_virtualKeyBoard).BeginInit();
((System.ComponentModel.ISupportInitialize)dataGridView1).BeginInit();
SuspendLayout();
btn_pageRight.FlatAppearance.BorderSize = 0;
btn_pageRight.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_pageRight.Image = POS_Client.Properties.Resources.right;
btn_pageRight.Location = new System.Drawing.Point(933, 185);
btn_pageRight.Name = "btn_pageRight";
btn_pageRight.Size = new System.Drawing.Size(48, 371);
btn_pageRight.TabIndex = 41;
btn_pageRight.UseVisualStyleBackColor = true;
btn_pageRight.Click += new System.EventHandler(btn_pageRight_Click);
btn_pageLeft.FlatAppearance.BorderSize = 0;
btn_pageLeft.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_pageLeft.Image = POS_Client.Properties.Resources.left;
btn_pageLeft.Location = new System.Drawing.Point(0, 185);
btn_pageLeft.Name = "btn_pageLeft";
btn_pageLeft.Size = new System.Drawing.Size(48, 378);
btn_pageLeft.TabIndex = 42;
btn_pageLeft.UseVisualStyleBackColor = true;
btn_pageLeft.Click += new System.EventHandler(btn_pageLeft_Click);
l_status.AutoSize = true;
l_status.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
l_status.Location = new System.Drawing.Point(47, 94);
l_status.Name = "l_status";
l_status.Size = new System.Drawing.Size(41, 20);
l_status.TabIndex = 43;
l_status.Text = "狀態";
btn_statusAll.BackColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusAll.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusAll.FlatAppearance.CheckedBackColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusAll.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_statusAll.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_statusAll.ForeColor = System.Drawing.Color.White;
btn_statusAll.Location = new System.Drawing.Point(96, 90);
btn_statusAll.Name = "btn_statusAll";
btn_statusAll.Size = new System.Drawing.Size(69, 29);
btn_statusAll.TabIndex = 44;
btn_statusAll.Text = "全部";
btn_statusAll.UseVisualStyleBackColor = false;
btn_statusAll.Click += new System.EventHandler(btn_statusAll_Click);
btn_statusNormal.BackColor = System.Drawing.Color.White;
btn_statusNormal.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusNormal.FlatAppearance.CheckedBackColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusNormal.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_statusNormal.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_statusNormal.ForeColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusNormal.Location = new System.Drawing.Point(173, 90);
btn_statusNormal.Name = "btn_statusNormal";
btn_statusNormal.Size = new System.Drawing.Size(69, 29);
btn_statusNormal.TabIndex = 45;
btn_statusNormal.Text = "正常";
btn_statusNormal.UseVisualStyleBackColor = false;
btn_statusNormal.Click += new System.EventHandler(btn_statusNormal_Click);
btn_statusCancel.BackColor = System.Drawing.Color.White;
btn_statusCancel.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusCancel.FlatAppearance.CheckedBackColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_statusCancel.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_statusCancel.ForeColor = System.Drawing.Color.FromArgb(247, 106, 45);
btn_statusCancel.Location = new System.Drawing.Point(250, 90);
btn_statusCancel.Name = "btn_statusCancel";
btn_statusCancel.Size = new System.Drawing.Size(69, 29);
btn_statusCancel.TabIndex = 46;
btn_statusCancel.Text = "已取消";
btn_statusCancel.UseVisualStyleBackColor = false;
btn_statusCancel.Click += new System.EventHandler(btn_statusSuspend_Click);
l_memberList.AutoSize = true;
l_memberList.Font = new System.Drawing.Font("微軟正黑體", 14.25f, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 136);
l_memberList.Image = POS_Client.Properties.Resources.oblique;
l_memberList.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
l_memberList.Location = new System.Drawing.Point(47, 49);
l_memberList.Name = "l_memberList";
l_memberList.Size = new System.Drawing.Size(82, 24);
l_memberList.TabIndex = 51;
l_memberList.Text = " 進貨單";
l_memberList.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
btn_quickManager.BackColor = System.Drawing.Color.FromArgb(34, 159, 208);
btn_quickManager.FlatAppearance.BorderSize = 0;
btn_quickManager.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_quickManager.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_quickManager.ForeColor = System.Drawing.Color.White;
btn_quickManager.Location = new System.Drawing.Point(805, 91);
btn_quickManager.Name = "btn_quickManager";
btn_quickManager.Size = new System.Drawing.Size(115, 30);
btn_quickManager.TabIndex = 57;
btn_quickManager.Text = "庫存快速管理";
btn_quickManager.UseVisualStyleBackColor = false;
btn_quickManager.Visible = false;
btn_quickManager.Click += new System.EventHandler(btn_quickManager_Click);
l_pageInfo.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
l_pageInfo.Location = new System.Drawing.Point(302, 52);
l_pageInfo.Name = "l_pageInfo";
l_pageInfo.Size = new System.Drawing.Size(386, 20);
l_pageInfo.TabIndex = 58;
l_pageInfo.Text = "共{0}筆．{1}頁｜目前在第1頁\r\n";
l_pageInfo.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
btn_firstPage.BackColor = System.Drawing.Color.White;
btn_firstPage.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(125, 156, 35);
btn_firstPage.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_firstPage.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_firstPage.Image = POS_Client.Properties.Resources.first;
btn_firstPage.Location = new System.Drawing.Point(309, 588);
btn_firstPage.Name = "btn_firstPage";
btn_firstPage.Size = new System.Drawing.Size(69, 29);
btn_firstPage.TabIndex = 59;
btn_firstPage.UseVisualStyleBackColor = false;
btn_firstPage.Click += new System.EventHandler(btn_firstPage_Click);
btn_previousPage.BackColor = System.Drawing.Color.White;
btn_previousPage.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(125, 156, 35);
btn_previousPage.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_previousPage.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_previousPage.Image = POS_Client.Properties.Resources.prev;
btn_previousPage.Location = new System.Drawing.Point(384, 588);
btn_previousPage.Name = "btn_previousPage";
btn_previousPage.Size = new System.Drawing.Size(69, 29);
btn_previousPage.TabIndex = 60;
btn_previousPage.UseVisualStyleBackColor = false;
btn_previousPage.Click += new System.EventHandler(btn_pageLeft_Click);
btn_nextPage.BackColor = System.Drawing.Color.White;
btn_nextPage.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(125, 156, 35);
btn_nextPage.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_nextPage.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_nextPage.Image = POS_Client.Properties.Resources.next;
btn_nextPage.Location = new System.Drawing.Point(532, 588);
btn_nextPage.Name = "btn_nextPage";
btn_nextPage.Size = new System.Drawing.Size(69, 29);
btn_nextPage.TabIndex = 62;
btn_nextPage.UseVisualStyleBackColor = false;
btn_nextPage.Click += new System.EventHandler(btn_pageRight_Click);
btn_lastPage.BackColor = System.Drawing.Color.White;
btn_lastPage.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(125, 156, 35);
btn_lastPage.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_lastPage.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_lastPage.Image = POS_Client.Properties.Resources.last;
btn_lastPage.Location = new System.Drawing.Point(607, 588);
btn_lastPage.Name = "btn_lastPage";
btn_lastPage.Size = new System.Drawing.Size(69, 29);
btn_lastPage.TabIndex = 63;
btn_lastPage.UseVisualStyleBackColor = false;
btn_lastPage.Click += new System.EventHandler(btn_lastPage_Click);
l_pageNow.BackColor = System.Drawing.Color.FromArgb(125, 156, 35);
l_pageNow.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
l_pageNow.Font = new System.Drawing.Font("微軟正黑體", 14.25f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
l_pageNow.ForeColor = System.Drawing.Color.White;
l_pageNow.Location = new System.Drawing.Point(459, 588);
l_pageNow.Name = "l_pageNow";
l_pageNow.Size = new System.Drawing.Size(67, 29);
l_pageNow.TabIndex = 64;
l_pageNow.Text = "{0}";
l_pageNow.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
btn_SearchPurchase.BackColor = System.Drawing.Color.FromArgb(34, 159, 208);
btn_SearchPurchase.FlatAppearance.BorderSize = 0;
btn_SearchPurchase.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_SearchPurchase.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_SearchPurchase.ForeColor = System.Drawing.Color.White;
btn_SearchPurchase.Location = new System.Drawing.Point(818, 47);
btn_SearchPurchase.Name = "btn_SearchPurchase";
btn_SearchPurchase.Size = new System.Drawing.Size(102, 30);
btn_SearchPurchase.TabIndex = 57;
btn_SearchPurchase.Text = "進貨單查詢";
btn_SearchPurchase.UseVisualStyleBackColor = false;
btn_SearchPurchase.Click += new System.EventHandler(btn_SearchPurchase_Click);
btn_CreatePurchase.BackColor = System.Drawing.Color.FromArgb(34, 159, 208);
btn_CreatePurchase.FlatAppearance.BorderSize = 0;
btn_CreatePurchase.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_CreatePurchase.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_CreatePurchase.ForeColor = System.Drawing.Color.White;
btn_CreatePurchase.Location = new System.Drawing.Point(702, 47);
btn_CreatePurchase.Name = "btn_CreatePurchase";
btn_CreatePurchase.Size = new System.Drawing.Size(102, 30);
btn_CreatePurchase.TabIndex = 57;
btn_CreatePurchase.Text = "新建進貨單";
btn_CreatePurchase.UseVisualStyleBackColor = false;
btn_CreatePurchase.Click += new System.EventHandler(btn_createCommodity_Click);
label1.AutoSize = true;
label1.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
label1.Location = new System.Drawing.Point(337, 94);
label1.Name = "label1";
label1.Size = new System.Drawing.Size(89, 20);
label1.TabIndex = 43;
label1.Text = "供應商篩選";
tb_supplierKeyword.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
tb_supplierKeyword.Location = new System.Drawing.Point(433, 90);
tb_supplierKeyword.Name = "tb_supplierKeyword";
tb_supplierKeyword.Size = new System.Drawing.Size(209, 29);
tb_supplierKeyword.TabIndex = 66;
tb_supplierKeyword.Text = "請輸入名稱或統一編號";
tb_supplierKeyword.Enter += new System.EventHandler(tb_supplierKeyword_Enter);
tb_supplierKeyword.KeyDown += new System.Windows.Forms.KeyEventHandler(tb_supplierKeyword_KeyDown);
tb_supplierKeyword.Leave += new System.EventHandler(tb_supplierKeyword_Leave);
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.AllowUserToResizeColumns = false;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.BackgroundColor = System.Drawing.Color.White;
dataGridView1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
dataGridView1.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single;
dataGridViewCellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle.BackColor = System.Drawing.Color.FromArgb(102, 102, 102);
dataGridViewCellStyle.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle.ForeColor = System.Drawing.Color.White;
dataGridViewCellStyle.Padding = new System.Windows.Forms.Padding(6);
dataGridViewCellStyle.SelectionBackColor = System.Drawing.Color.FromArgb(102, 102, 102);
dataGridViewCellStyle.SelectionForeColor = System.Drawing.Color.White;
dataGridViewCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle;
dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridView1.Columns.AddRange(Column1, Column2, Column3, Column4, Column5, hidden_Status);
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle2.Font = new System.Drawing.Font("新細明體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
dataGridView1.DefaultCellStyle = dataGridViewCellStyle2;
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.Location = new System.Drawing.Point(54, 141);
dataGridView1.Margin = new System.Windows.Forms.Padding(0);
dataGridView1.Name = "dataGridView1";
dataGridView1.ReadOnly = true;
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle3.Font = new System.Drawing.Font("新細明體", 9f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
dataGridView1.RowHeadersDefaultCellStyle = dataGridViewCellStyle3;
dataGridView1.RowHeadersVisible = false;
dataGridView1.RowTemplate.Height = 40;
dataGridView1.Size = new System.Drawing.Size(866, 422);
dataGridView1.TabIndex = 71;
dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(dataGridView1_CellContentClick);
Column1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
dataGridViewCellStyle4.Font = new System.Drawing.Font("微軟正黑體", 13f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle4.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle4.SelectionForeColor = System.Drawing.Color.Black;
Column1.DefaultCellStyle = dataGridViewCellStyle4;
Column1.FillWeight = 100.7162f;
Column1.HeaderText = "進貨日期";
Column1.Name = "Column1";
Column1.ReadOnly = true;
Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column2.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
dataGridViewCellStyle5.Font = new System.Drawing.Font("微軟正黑體", 13f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle5.ForeColor = System.Drawing.Color.Blue;
dataGridViewCellStyle5.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle5.SelectionForeColor = System.Drawing.Color.Blue;
Column2.DefaultCellStyle = dataGridViewCellStyle5;
Column2.FillWeight = 100.7162f;
Column2.HeaderText = "系統單號";
Column2.Name = "Column2";
Column2.ReadOnly = true;
Column2.Resizable = System.Windows.Forms.DataGridViewTriState.True;
Column3.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
dataGridViewCellStyle6.Font = new System.Drawing.Font("微軟正黑體", 13f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle6.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle6.SelectionForeColor = System.Drawing.Color.Black;
Column3.DefaultCellStyle = dataGridViewCellStyle6;
Column3.FillWeight = 201.4324f;
Column3.HeaderText = "進貨(供應)廠商名稱";
Column3.Name = "Column3";
Column3.ReadOnly = true;
Column3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column4.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
dataGridViewCellStyle7.Font = new System.Drawing.Font("微軟正黑體", 13f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle7.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle7.SelectionForeColor = System.Drawing.Color.Black;
Column4.DefaultCellStyle = dataGridViewCellStyle7;
Column4.FillWeight = 83.22656f;
Column4.HeaderText = "單據總價";
Column4.Name = "Column4";
Column4.ReadOnly = true;
Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column5.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
dataGridViewCellStyle8.Font = new System.Drawing.Font("微軟正黑體", 13f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle8.SelectionBackColor = System.Drawing.Color.White;
dataGridViewCellStyle8.SelectionForeColor = System.Drawing.Color.Black;
Column5.DefaultCellStyle = dataGridViewCellStyle8;
Column5.FillWeight = 73.90863f;
Column5.HeaderText = "狀態";
Column5.Name = "Column5";
Column5.ReadOnly = true;
Column5.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
hidden_Status.HeaderText = "(隱藏_訂單狀態)";
hidden_Status.Name = "hidden_Status";
hidden_Status.ReadOnly = true;
hidden_Status.Visible = false;
btn_supplierFilter.BackColor = System.Drawing.Color.FromArgb(125, 156, 35);
btn_supplierFilter.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn_supplierFilter.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
btn_supplierFilter.ForeColor = System.Drawing.Color.White;
btn_supplierFilter.Location = new System.Drawing.Point(648, 90);
btn_supplierFilter.Name = "btn_supplierFilter";
btn_supplierFilter.Size = new System.Drawing.Size(48, 29);
btn_supplierFilter.TabIndex = 72;
btn_supplierFilter.Text = "GO";
btn_supplierFilter.UseVisualStyleBackColor = false;
btn_supplierFilter.Click += new System.EventHandler(btn_supplierFilter_Click);
base.AutoScaleDimensions = new System.Drawing.SizeF(6f, 12f);
base.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
base.ClientSize = new System.Drawing.Size(981, 661);
base.Controls.Add(btn_supplierFilter);
base.Controls.Add(dataGridView1);
base.Controls.Add(tb_supplierKeyword);
base.Controls.Add(btn_CreatePurchase);
base.Controls.Add(btn_SearchPurchase);
base.Controls.Add(btn_quickManager);
base.Controls.Add(l_pageNow);
base.Controls.Add(btn_lastPage);
base.Controls.Add(btn_nextPage);
base.Controls.Add(btn_previousPage);
base.Controls.Add(btn_firstPage);
base.Controls.Add(l_pageInfo);
base.Controls.Add(l_memberList);
base.Controls.Add(btn_statusCancel);
base.Controls.Add(btn_statusNormal);
base.Controls.Add(btn_statusAll);
base.Controls.Add(label1);
base.Controls.Add(l_status);
base.Controls.Add(btn_pageLeft);
base.Controls.Add(btn_pageRight);
base.Name = "frmInventoryMangement";
base.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
Text = "農委會防檢局POS系統";
base.Load += new System.EventHandler(frmInventoryMangement_Load);
base.Controls.SetChildIndex(btn_pageRight, 0);
base.Controls.SetChildIndex(btn_pageLeft, 0);
base.Controls.SetChildIndex(l_status, 0);
base.Controls.SetChildIndex(label1, 0);
base.Controls.SetChildIndex(btn_statusAll, 0);
base.Controls.SetChildIndex(btn_statusNormal, 0);
base.Controls.SetChildIndex(btn_statusCancel, 0);
base.Controls.SetChildIndex(l_memberList, 0);
base.Controls.SetChildIndex(l_pageInfo, 0);
base.Controls.SetChildIndex(btn_firstPage, 0);
base.Controls.SetChildIndex(btn_previousPage, 0);
base.Controls.SetChildIndex(btn_nextPage, 0);
base.Controls.SetChildIndex(btn_lastPage, 0);
base.Controls.SetChildIndex(l_pageNow, 0);
base.Controls.SetChildIndex(btn_quickManager, 0);
base.Controls.SetChildIndex(btn_SearchPurchase, 0);
base.Controls.SetChildIndex(btn_CreatePurchase, 0);
base.Controls.SetChildIndex(tb_supplierKeyword, 0);
base.Controls.SetChildIndex(dataGridView1, 0);
base.Controls.SetChildIndex(pb_virtualKeyBoard, 0);
base.Controls.SetChildIndex(btn_supplierFilter, 0);
((System.ComponentModel.ISupportInitialize)pb_virtualKeyBoard).EndInit();
((System.ComponentModel.ISupportInitialize)dataGridView1).EndInit();
ResumeLayout(false);
PerformLayout();
}
private void InitGrid(DataGridView Grid, string user)
{
Grid.Columns.Clear();
Grid.Rows.Clear();
Grid.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240);
Grid.MultiSelect = false;
Grid.BorderStyle = BorderStyle.Fixed3D;
Grid.BackgroundColor = Color.FromKnownColor(KnownColor.White);
Grid.GridColor = Color.FromKnownColor(KnownColor.ActiveBorder);
Grid.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
Grid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
Grid.ColumnHeadersHeight = 25;
DataGridViewTextBoxColumn dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "项目分类";
dataGridViewTextBoxColumn.Name = "zdmc";
dataGridViewTextBoxColumn.Width = 80;
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "项目名称";
dataGridViewTextBoxColumn.Name = "gybz";
dataGridViewTextBoxColumn.Width = 150;
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "AFN";
dataGridViewTextBoxColumn.Name = "gygs";
dataGridViewTextBoxColumn.Width = 35;
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "FN";
dataGridViewTextBoxColumn.Name = "xzjs";
dataGridViewTextBoxColumn.Width = 35;
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "PN";
dataGridViewTextBoxColumn.Name = "kzm";
dataGridViewTextBoxColumn.Width = 35;
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
DataGridViewLinkColumn dataGridViewLinkColumn = new DataGridViewLinkColumn();
dataGridViewLinkColumn.HeaderText = "发送数据";
dataGridViewLinkColumn.Name = "ckz";
dataGridViewLinkColumn.Width = 80;
dataGridViewLinkColumn.ReadOnly = true;
dataGridViewLinkColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewLinkColumn);
dataGridViewLinkColumn = new DataGridViewLinkColumn();
dataGridViewLinkColumn.HeaderText = "接收数据";
dataGridViewLinkColumn.Name = "ckz";
dataGridViewLinkColumn.Width = 200;
dataGridViewLinkColumn.ReadOnly = true;
dataGridViewLinkColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewLinkColumn);
dataGridViewTextBoxColumn = new DataGridViewTextBoxColumn();
dataGridViewTextBoxColumn.HeaderText = "时间";
dataGridViewTextBoxColumn.Name = "kddzm";
dataGridViewTextBoxColumn.ReadOnly = true;
dataGridViewTextBoxColumn.Width = 80;
dataGridViewTextBoxColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
Grid.Columns.Add(dataGridViewTextBoxColumn);
Grid.AllowUserToAddRows = false;
}
public int add_col_dgv(string field, string title, grid_cell_type cell_type = grid_cell_type.text
, int width = 100, bool wrap = false, string after_col = "", bool fill = false, string format = ""
, int maxlength = 0, bool?read_only = null, bool bold = false, Color?fc = null)
{
DataGridViewColumn add_col = null;
if (cell_type == grid_cell_type.text)
{
add_col = new DataGridViewTextBoxColumn()
{
HeaderText = title
}
}
;
else if (cell_type == grid_cell_type.check)
{
add_col = new DataGridViewCheckBoxColumn()
{
AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells, HeaderText = title
};
add_col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
else if (cell_type == grid_cell_type.link)
{
add_col = new DataGridViewLinkColumn()
{
HeaderText = title, ActiveLinkColor = Color.White, LinkBehavior = LinkBehavior.SystemDefault
, LinkColor = Color.Blue, TrackVisitedState = true, VisitedLinkColor = Color.DodgerBlue
}
}
;
else if (cell_type == grid_cell_type.combo)
{
add_col = new DataGridViewComboBoxColumn()
{
HeaderText = title
}
}
;
// aggiunta colonna
int nc = -1, i = 0;
if (after_col != "")
{
foreach (DataGridViewColumn dgvc in this.Columns)
{
if (dgvc.Name == after_col)
{
nc = i + 1; break;
}
i++;
}
}
int n = -1;
if (nc >= 0)
{
n = nc;
if (add_col != null)
{
this.Columns.Insert(n, add_col);
}
else
{
this.Columns.Insert(n, new DataGridViewColumn()
{
HeaderText = title
});
}
}
else
{
n = add_col != null?this.Columns.Add(add_col) : this.Columns.Add(field, title);
}
// init
this.Columns[n].Tag = cell_type;
this.Columns[n].Name = field;
this.Columns[n].DataPropertyName = field;
if (read_only.HasValue)
{
this.Columns[n].ReadOnly = read_only.Value;
}
if (width >= 0)
{
this.Columns[n].Width = width;
}
this.Columns[n].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (wrap)
{
this.Columns[n].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
}
if (fill)
{
this.Columns[n].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
if (maxlength > 0 && this.Columns[n] is DataGridViewTextBoxColumn)
{
((DataGridViewTextBoxColumn)this.Columns[n]).MaxInputLength = maxlength;
}
//if(bold && this.style != null) this.Columns[n].DefaultCellStyle.Font = this.style.font_grid_bold;
if (fc.HasValue)
{
this.Columns[n].DefaultCellStyle.ForeColor = fc.Value;
}
// format
if (string.IsNullOrEmpty(format))
{
if (cell_type == grid_cell_type.money)
{
this.Columns[n].DefaultCellStyle.Format = "C";
}
else if (cell_type == grid_cell_type.date)
{
this.Columns[n].DefaultCellStyle.Format = "ddd dd MMMM yyyy";
}
else if (cell_type == grid_cell_type.date_time)
{
this.Columns[n].DefaultCellStyle.Format = "dd MMMM yyyy HH:mm:ss";
}
}
else
{
this.Columns[n].DefaultCellStyle.Format = format;
}
// alignment
if (cell_type == grid_cell_type.integer || cell_type == grid_cell_type.money)
{
this.Columns[n].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
else if (cell_type == grid_cell_type.check || cell_type == grid_cell_type.date ||
cell_type == grid_cell_type.date_time)
{
this.Columns[n].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
else
{
this.Columns[n].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
}
// value type
this.Columns[n].ValueType = cell_type == grid_cell_type.integer ? typeof(int)
: (cell_type == grid_cell_type.date || cell_type == grid_cell_type.date_time ? typeof(DateTime)
: (cell_type == grid_cell_type.money ? Type.GetType("System.Decimal") : typeof(string)));
return(n);
}
private void InitializeServersList()
{
serverlistDataSource = new BindingSource
{
new ServerListItem
{
Status = ServerListItemStatus.NotStarted,
ServerName = "oraclelinuxvm",
IPAddress = "172.16.100.2",
Port = 22,
Username = "******",
Password = "******",
Log = string.Empty
}
};
gvServersList.AutoGenerateColumns = false;
gvServersList.AutoSize = true;
gvServersList.DataSource = serverlistDataSource;
// Initialize and add a Progress column
DataGridViewColumn column = new DataGridViewImageColumn
{
DataPropertyName = "Progess",
Name = "Progress"
};
gvServersList.Columns.Add(column);
// Initialize and add a Server Name column.
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "ServerName",
Name = "Server Name"
};
gvServersList.Columns.Add(column);
// Initialize and add a IP Address column.
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "IPAddress",
Name = "IP Address"
};
gvServersList.Columns.Add(column);
// Initialize and add a Port column.
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "Port",
Name = "Port"
};
gvServersList.Columns.Add(column);
// Initialize and add a Username column.
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "Username",
Name = "Username"
};
gvServersList.Columns.Add(column);
// Initialize and add a Password column.
column = new DataGridViewTextBoxColumn
{
DataPropertyName = "Password",
Name = "Password"
};
gvServersList.Columns.Add(column);
// Initialize and add a Password column.
column = new DataGridViewLinkColumn
{
Name = "Log"
};
gvServersList.Columns.Add(column);
}
private void initPage()
{
this.textBox1.KeyDown += button1_KeyDown;
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView2.AutoGenerateColumns = false;
DataGridViewColumn colNum = new DataGridViewTextBoxColumn();
colNum.DataPropertyName = "num";
colNum.Name = "num";
colNum.HeaderText = "编号";
DataGridViewColumn colNum2 = new DataGridViewTextBoxColumn();
colNum2.DataPropertyName = "num";
colNum2.Name = "num";
colNum2.HeaderText = "编号";
dataGridView1.Columns.Add(colNum);
dataGridView2.Columns.Add(colNum2);
DataGridViewColumn colName = new DataGridViewTextBoxColumn();
colName.DataPropertyName = "name";
colName.Name = "name";
colName.HeaderText = "名称";
DataGridViewColumn colName2 = new DataGridViewTextBoxColumn();
colName2.DataPropertyName = "name";
colName2.Name = "name";
colName2.HeaderText = "名称";
dataGridView1.Columns.Add(colName);
dataGridView2.Columns.Add(colName2);
DataGridViewColumn colId = new DataGridViewTextBoxColumn();
colId.DataPropertyName = "id";
colId.Visible = false;
colId.Name = "id";
DataGridViewColumn colId2 = new DataGridViewTextBoxColumn();
colId2.DataPropertyName = "id";
colId2.Visible = false;
colId2.Name = "id";
dataGridView1.Columns.Add(colId);
dataGridView2.Columns.Add(colId2);
DataGridViewColumn colStatus = new DataGridViewTextBoxColumn();
colStatus.DataPropertyName = "status";//字段
colStatus.Name = "status";
colStatus.HeaderText = "状态";
DataGridViewColumn colStatus2 = new DataGridViewTextBoxColumn();
colStatus2.DataPropertyName = "status";//字段
colStatus2.Name = "status";
colStatus2.HeaderText = "状态";
dataGridView1.Columns.Add(colStatus);
dataGridView2.Columns.Add(colStatus2);
DataGridViewColumn colIsActive = new DataGridViewLinkColumn();
colIsActive.DataPropertyName = "isActive";//字段
colIsActive.Visible = false;
colIsActive.Name = "isActive";
DataGridViewColumn colIsActive2 = new DataGridViewLinkColumn();
colIsActive2.DataPropertyName = "isActive";//字段
colIsActive2.Visible = false;
colIsActive2.Name = "isActive";
dataGridView1.Columns.Add(colIsActive);
dataGridView2.Columns.Add(colIsActive2);
}
public void BindGrid()
{
try
{
string imagePath = Application.StartupPath + "\\Images\\";
DataTable dt = new DataTable();
dt = BaseClass._BAL.GetAllUserDetails();
if (dt.Rows.Count > 0)
{
dt = BaseClass._BAL.AutoNumberedTable(dt);
listUserName = dt.AsEnumerable().Select(r => r.Field <string>("UserName")).ToList();
listContactNo = dt.AsEnumerable().Select(r => r.Field <string>("ContactNo")).ToList();
dgvUser.Columns.Clear();
dgvUser.DataSource = null;
dgvUser.DataSource = dt;
DataGridViewLinkColumn dgvLink = new DataGridViewLinkColumn();
dgvLink.HeaderText = "Edit";
dgvLink.Name = "Edit";
dgvLink.LinkColor = Color.Blue;
dgvLink.TrackVisitedState = true;
dgvLink.Text = "Edit";
dgvLink.UseColumnTextForLinkValue = true;
dgvUser.Columns.Add(dgvLink);
DataGridViewLinkColumn dgvLink1 = new DataGridViewLinkColumn();
dgvLink1.HeaderText = "Delete";
dgvLink1.Name = "Delete";
dgvLink1.LinkColor = Color.Blue;
dgvLink1.TrackVisitedState = true;
dgvLink1.Text = "Delete";
dgvLink1.UseColumnTextForLinkValue = true;
dgvUser.Columns.Add(dgvLink1);
dgvUser.Columns["SNo"].Width = 50;
dgvUser.Columns["FirstName"].Width = 120;
dgvUser.Columns["LastName"].Width = 120;
dgvUser.Columns["Role"].Width = 60;
dgvUser.Columns["ContactNo"].Width = 120;
dgvUser.Columns["UserName"].Width = 120;
dgvUser.Columns["Edit"].Width = 60;
dgvUser.Columns["Delete"].Width = 60;
dgvUser.Columns["FirstName"].HeaderText = "First Name";
dgvUser.Columns["LastName"].HeaderText = "Last Name";
dgvUser.Columns["ContactNo"].HeaderText = "Contact No";
dgvUser.Columns["UserId"].Visible = false;
dgvUser.Columns["Password"].Visible = false;
for (int i = 0; i < dgvUser.Columns.Count; i++)
{
dgvUser.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
}
}
catch (Exception ex)
{
Logger.Logger.WriteLog(ex);
}
}
private void initTable()
{
dataGridView1.AutoGenerateColumns = false;
DataGridViewColumn colId = new DataGridViewLinkColumn();
colId.DataPropertyName = "id";//字段
colId.Visible = false;
colId.Name = "id";
dataGridView1.Columns.Add(colId);
DataGridViewColumn colUId = new DataGridViewLinkColumn();
colUId.DataPropertyName = "uid";//字段
colUId.Visible = false;
colUId.Name = "uid";
dataGridView1.Columns.Add(colUId);
DataGridViewColumn colUName = new DataGridViewTextBoxColumn();
colUName.DataPropertyName = "username";//字段
colUName.HeaderText = "用户名";
dataGridView1.Columns.Add(colUName);
DataGridViewColumn colName = new DataGridViewTextBoxColumn();
colName.DataPropertyName = "fullname";//字段
colName.HeaderText = "名称";
dataGridView1.Columns.Add(colName);
dataGridView2.AutoGenerateColumns = false;
DataGridViewColumn colId2 = new DataGridViewLinkColumn();
colId2.DataPropertyName = "id";//字段
colId2.Visible = false;
colId2.Name = "id";
dataGridView2.Columns.Add(colId2);
DataGridViewColumn colUId2 = new DataGridViewLinkColumn();
colUId2.DataPropertyName = "uid";//字段
colUId2.Visible = false;
colUId2.Name = "uid";
dataGridView2.Columns.Add(colUId2);
DataGridViewColumn colUName2 = new DataGridViewTextBoxColumn();
colUName2.DataPropertyName = "username";//字段
colUName2.HeaderText = "用户名";
dataGridView2.Columns.Add(colUName2);
DataGridViewColumn colName2 = new DataGridViewTextBoxColumn();
colName2.DataPropertyName = "fullname";//字段
colName2.HeaderText = "名称";
dataGridView2.Columns.Add(colName2);
dataGridView3.AutoGenerateColumns = false;
DataGridViewColumn colId3 = new DataGridViewLinkColumn();
colId3.DataPropertyName = "id";//字段
colId3.Visible = false;
colId3.Name = "id";
dataGridView3.Columns.Add(colId3);
DataGridViewColumn colUId3 = new DataGridViewLinkColumn();
colUId3.DataPropertyName = "uid";//字段
colUId3.Visible = false;
colUId3.Name = "uid";
dataGridView3.Columns.Add(colUId3);
DataGridViewColumn colUName3 = new DataGridViewTextBoxColumn();
colUName3.DataPropertyName = "username";//字段
colUName3.HeaderText = "用户名";
dataGridView3.Columns.Add(colUName3);
DataGridViewColumn colName3 = new DataGridViewTextBoxColumn();
colName3.DataPropertyName = "fullname";//字段
colName3.HeaderText = "名称";
dataGridView3.Columns.Add(colName3);
tabControl1.Selected += TabControl1_Selected;
}
void loadData()
{
dgv.Columns.Clear();
dgv.DataSource = null;
var source = Global.db.OrderItems
.ToArray()
.Select(x => new
{
x.ID,
x.Part.Name,
type = x.Order.TransactionType.Name,
x.Order.Date,
x.Amount,
source = x.Order.SourceWarehouseID == null ? "-" : x.Order.Warehouse.Name,
destination = x.Order.DestinationWarehouseID == null ? "-" : x.Order.Warehouse1.Name
}).ToArray();
source = source.OrderByDescending(a => a.Date).ThenBy(a => a.type).ToArray();
if (SORTED_COLUMN != null)
{
switch (SORT_COL_INDEX)
{
case 1:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.Name).ToArray();
}
else
{
source = source.OrderByDescending(a => a.Name).ToArray();
}
break;
case 2:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.type).ToArray();
}
else
{
source = source.OrderByDescending(a => a.type).ToArray();
}
break;
case 3:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.Date).ToArray();
}
else
{
source = source.OrderByDescending(a => a.Date).ToArray();
}
break;
case 4:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.Amount).ToArray();
}
else
{
source = source.OrderByDescending(a => a.Amount).ToArray();
}
break;
case 5:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.source).ToArray();
}
else
{
source = source.OrderByDescending(a => a.source).ToArray();
}
break;
case 6:
if (SORT_DIRECTION == 0)
{
source = source.OrderBy(a => a.destination).ToArray();
}
else
{
source = source.OrderByDescending(a => a.destination).ToArray();
}
break;
default:
break;
}
}
BindingSource binding = new BindingSource();
binding.DataSource = source;
dgv.DataSource = binding;
dgv.Columns[0].Visible = false;
dgv.Columns[1].HeaderText = "Part Name";
dgv.Columns[2].HeaderText = "Transaction Type";
dgv.Columns[3].HeaderText = "Date";
dgv.Columns[4].HeaderText = "Amount";
dgv.Columns[5].HeaderText = "Source";
dgv.Columns[6].HeaderText = "Destination";
dgv.Columns[3].Width = 70;
dgv.Columns[4].Width = 70;
dgv.Columns[5].Width = 100;
dgv.Columns[6].Width = 100;
foreach (DataGridViewRow row in dgv.Rows)
{
if (row.Cells[2].Value.ToString() == "Purchase Order")
{
row.Cells[4].Style.BackColor = Color.SpringGreen;
}
}
var btnEdit = new DataGridViewLinkColumn
{
Name = "Edit",
Text = "Edit",
UseColumnTextForLinkValue = true,
HeaderText = "Action"
};
var btnRemove = new DataGridViewLinkColumn
{
Name = "Remove",
Text = "Remove",
UseColumnTextForLinkValue = true,
HeaderText = "Action"
};
dgv.Columns.AddRange(btnEdit);
dgv.Columns.AddRange(btnRemove);
dgv.Columns[7].Width = 40;
dgv.Columns[8].Width = 60;
SORTED_COLUMN = dgv.Columns[SORT_COL_INDEX];
if (SORTED_COLUMN != null)
{
SORTED_COLUMN.HeaderCell.SortGlyphDirection = SORT_DIRECTION == 0 ? System.Windows.Forms.SortOrder.Ascending : System.Windows.Forms.SortOrder.Descending;
}
}
private void InitilizeAdvtGrid()
{
if (dgAdvtDetail.Rows.Count > 0)
{
dgAdvtDetail.Rows.Clear();
}
if (dgAdvtDetail.Columns.Count > 0)
{
dgAdvtDetail.Columns.Clear();
}
//0
dgAdvtDetail.Columns.Add("tId", "TokenId");
dgAdvtDetail.Columns["tId"].Width = 70;
dgAdvtDetail.Columns["tId"].Visible = true;
dgAdvtDetail.Columns["tId"].ReadOnly = true;
dgAdvtDetail.Columns["tId"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgAdvtDetail.Columns.Add("expD", "Expiry Date");
dgAdvtDetail.Columns["expD"].Width = 120;
dgAdvtDetail.Columns["expD"].Visible = true;
dgAdvtDetail.Columns["expD"].ReadOnly = false;
dgAdvtDetail.Columns["expD"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//1
dgAdvtDetail.Columns.Add("Name", "Name");
dgAdvtDetail.Columns["Name"].Width = 200;
dgAdvtDetail.Columns["Name"].Visible = true;
dgAdvtDetail.Columns["Name"].ReadOnly = true;
dgAdvtDetail.Columns["Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//2
dgAdvtDetail.Columns.Add("loc", "Location");
dgAdvtDetail.Columns["loc"].Width = 160;
dgAdvtDetail.Columns["loc"].Visible = true;
dgAdvtDetail.Columns["loc"].ReadOnly = false;
dgAdvtDetail.Columns["loc"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgAdvtDetail.Columns.Add("cName", "City Name");
dgAdvtDetail.Columns["cName"].Width = 115;
dgAdvtDetail.Columns["cName"].Visible = true;
dgAdvtDetail.Columns["cName"].ReadOnly = false;
dgAdvtDetail.Columns["cName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//3
dgAdvtDetail.Columns.Add("sName", "State Name");
dgAdvtDetail.Columns["sName"].Width = 120;
dgAdvtDetail.Columns["sName"].Visible = true;
dgAdvtDetail.Columns["sName"].ReadOnly = false;
dgAdvtDetail.Columns["sName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgAdvtDetail.Columns.Add("coName", "Country");
dgAdvtDetail.Columns["coName"].Width = 170;
dgAdvtDetail.Columns["coName"].Visible = true;
dgAdvtDetail.Columns["coName"].ReadOnly = false;
dgAdvtDetail.Columns["coName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgAdvtDetail.Columns.Add("ver", "Type");
dgAdvtDetail.Columns["ver"].Width = 170;
dgAdvtDetail.Columns["ver"].Visible = true;
dgAdvtDetail.Columns["ver"].ReadOnly = false;
dgAdvtDetail.Columns["ver"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgAdvtDetail.Columns.Add("userId", "UserId");
dgAdvtDetail.Columns["userId"].Width = 0;
dgAdvtDetail.Columns["userId"].Visible = false;
dgAdvtDetail.Columns["userId"].ReadOnly = false;
DataGridViewLinkColumn ModifyToken = new DataGridViewLinkColumn();
ModifyToken.HeaderText = "Modify";
ModifyToken.Text = "Modify";
ModifyToken.DataPropertyName = "Modify";
dgAdvtDetail.Columns.Add(ModifyToken);
ModifyToken.UseColumnTextForLinkValue = true;
ModifyToken.Width = 70;
ModifyToken.Visible = true;
dgAdvtDetail.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
//private void loadMenuProvider()
//{
// View_MenuProvider_RBusinessLogic view_MenuProvider_RBusinessLogic = new View_MenuProvider_RBusinessLogic();
// List<View_MenuProvider_R> view_MenuProvider_RList = new List<View_MenuProvider_R>();
// view_MenuProvider_RList = view_MenuProvider_RBusinessLogic.GetAllView_MenuProvider_R();
// dgvMenuProvider_R.DataSource = view_MenuProvider_RList;
//}
//初始化界面
public void setColumn()
{
dgvMenu.Columns[0].HeaderText = "ID";
dgvMenu.Columns[0].Visible = false;
dgvMenu.Columns[1].HeaderText = "序号";
dgvMenu.Columns[2].HeaderText = "菜名";
dgvMenu.Columns[3].HeaderCell.Value = "单位";
dgvMenu.Columns[4].HeaderCell.Value = "数量";
//dgvMenu.Columns[5].Visible = false;
dgvMenu.Columns[5].HeaderCell.Value = "价格";
dgvMenu.Columns[6].HeaderCell.Value = "备注";
dgvMenu.Columns[1].ReadOnly = true;
dgvMenu.Columns[2].ReadOnly = true;
dgvMenu.Columns[3].ReadOnly = true;
dgvOrder.Columns[0].HeaderText = "订单号";
dgvOrder.Columns[1].HeaderText = "序号";
dgvOrder.Columns[2].HeaderText = "订单名";
dgvOrder.Columns[3].HeaderText = "班组";
dgvOrder.Columns[4].HeaderText = "下单人";
dgvOrder.Columns[5].HeaderText = "下单时间";
dgvOrder.Columns[5].Width = 180;
dgvOrder.Columns[6].HeaderText = "审核者";
dgvOrder.Columns[7].HeaderText = "状态";
dgvOrder.Columns[8].HeaderText = "备注";
DataGridViewLinkColumn editeLinkColumn = new DataGridViewLinkColumn();
//editeLinkColumn.Name = "EditeOrder";
editeLinkColumn.Text = "编辑";
editeLinkColumn.Width = 35;
editeLinkColumn.UseColumnTextForLinkValue = true;
dgvOrder.Columns.Insert(9, editeLinkColumn);
DataGridViewLinkColumn deleteLinkColumn = new DataGridViewLinkColumn();
//deleteLinkColumn.Name = "DeleteOrder";
deleteLinkColumn.Text = "删除";
deleteLinkColumn.Width = 35;
deleteLinkColumn.UseColumnTextForLinkValue = true;
dgvOrder.Columns.Insert(10, deleteLinkColumn);
DataGridViewLinkColumn commitLinkColumn = new DataGridViewLinkColumn();
//commitLinkColumn.Name = "SubmitOrder";
commitLinkColumn.Text = "提交";
commitLinkColumn.Width = 35;
commitLinkColumn.UseColumnTextForLinkValue = true;
dgvOrder.Columns.Insert(11, commitLinkColumn);
dgvSubmitOrder.Columns[0].HeaderText = "订单号";
dgvSubmitOrder.Columns[1].HeaderText = "序号";
dgvSubmitOrder.Columns[2].HeaderText = "订单名";
dgvSubmitOrder.Columns[3].HeaderText = "班组";
dgvSubmitOrder.Columns[4].HeaderText = "下单人";
dgvSubmitOrder.Columns[5].HeaderText = "下单时间";
dgvSubmitOrder.Columns[5].Width = 200;
dgvSubmitOrder.Columns[6].HeaderText = "审核者";
dgvSubmitOrder.Columns[7].HeaderText = "状态";
dgvSubmitOrder.Columns[8].HeaderText = "备注";
DataGridViewLinkColumn lookLinkColumn = new DataGridViewLinkColumn();
//lookLinkColumn.Name = "LookOrder";
lookLinkColumn.Text = "查看";
lookLinkColumn.UseColumnTextForLinkValue = true;
dgvSubmitOrder.Columns.Insert(9, lookLinkColumn);
dgvPassOrder.Columns[0].HeaderText = "订单号";
dgvPassOrder.Columns[1].HeaderText = "序号";
dgvPassOrder.Columns[2].HeaderText = "订单名";
dgvPassOrder.Columns[3].HeaderText = "班组";
dgvPassOrder.Columns[4].HeaderText = "下单人";
dgvPassOrder.Columns[5].HeaderText = "下单时间";
dgvPassOrder.Columns[5].Width = 200;
dgvPassOrder.Columns[6].HeaderText = "审核者";
dgvPassOrder.Columns[7].HeaderText = "状态";
dgvPassOrder.Columns[8].HeaderText = "备注";
DataGridViewLinkColumn LinkColumn = new DataGridViewLinkColumn();
//LinkColumn.Name = "LookOrder";
LinkColumn.Text = "查看";
LinkColumn.UseColumnTextForLinkValue = true;
dgvPassOrder.Columns.Insert(9, LinkColumn);
}
private void InitializeComponent()
{
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle = new System.Windows.Forms.DataGridViewCellStyle();
dataGridView1 = new System.Windows.Forms.DataGridView();
Column1 = new System.Windows.Forms.DataGridViewLinkColumn();
Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)dataGridView1).BeginInit();
SuspendLayout();
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.AllowUserToResizeColumns = false;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.BackgroundColor = System.Drawing.Color.White;
dataGridView1.BorderStyle = System.Windows.Forms.BorderStyle.None;
dataGridView1.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single;
dataGridViewCellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle.BackColor = System.Drawing.Color.FromArgb(255, 228, 181);
dataGridViewCellStyle.Font = new System.Drawing.Font("微軟正黑體", 12f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, 136);
dataGridViewCellStyle.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle.Padding = new System.Windows.Forms.Padding(6);
dataGridViewCellStyle.SelectionBackColor = System.Drawing.Color.FromArgb(255, 192, 192);
dataGridViewCellStyle.SelectionForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle;
dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridView1.Columns.AddRange(Column1, Column2, Column3, Column4, Column5, Column6, Column7);
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.Location = new System.Drawing.Point(0, 0);
dataGridView1.Margin = new System.Windows.Forms.Padding(0);
dataGridView1.Name = "dataGridView1";
dataGridView1.RowHeadersVisible = false;
dataGridView1.RowTemplate.Height = 24;
dataGridView1.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;
dataGridView1.Size = new System.Drawing.Size(570, 41);
dataGridView1.TabIndex = 7;
dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(dataGridView1_CellContentClick);
Column1.HeaderText = "銷售單號";
Column1.Name = "Column1";
Column1.Resizable = System.Windows.Forms.DataGridViewTriState.True;
Column1.Width = 210;
Column2.HeaderText = "購買會員";
Column2.Name = "Column2";
Column2.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column2.Width = 200;
Column3.HeaderText = "銷售總額(原始)";
Column3.Name = "Column3";
Column3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column3.Width = 160;
Column4.HeaderText = "付款模式總計";
Column4.Name = "Column4";
Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column4.Width = 200;
Column5.HeaderText = "數量";
Column5.Name = "Column5";
Column5.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column5.Width = 60;
Column6.HeaderText = "品項";
Column6.Name = "Column6";
Column6.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column6.Width = 60;
Column7.HeaderText = "狀態";
Column7.Name = "Column7";
Column7.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Column7.Width = 60;
base.AutoScaleDimensions = new System.Drawing.SizeF(6f, 12f);
base.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
BackColor = System.Drawing.SystemColors.ActiveBorder;
base.Controls.Add(dataGridView1);
base.Margin = new System.Windows.Forms.Padding(0);
base.Name = "ucSaleOrderInfo";
base.Size = new System.Drawing.Size(570, 20);
((System.ComponentModel.ISupportInitialize)dataGridView1).EndInit();
ResumeLayout(false);
}
//public void BindCategories()
//{
// try
// {
// CategoryManager objCategoryManager = new CategoryManager();
// NandanaResult dsCategorydetails = objCategoryManager.GetCategoryDetails();
// if (dsCategorydetails.resultDS != null && dsCategorydetails.resultDS.Tables[0].Rows.Count > 0)
// {
// // cmbCategoryName.Items.Clear();
// cmbCategoryName.DisplayMember = "Category_Name";
// cmbCategoryName.ValueMember = "Category_ID";
// cmbCategoryName.DataSource = GetComboBoxedDataTable(dsCategorydetails.resultDS.Tables[0], "Category_ID", "Category_Name", "0", "-Select Category-");
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error While retriving data from Category table");
// }
//}
public void GetDocumentDetails()
{
dgvDocuments.Columns.Clear();
dgvDocuments.AutoGenerateColumns = false;
dgvDocuments.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvDocuments.ColumnHeadersDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml("#444444");
this.dgvDocuments.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Segoe UI", 11.00F);
DataGridViewColumn clnDocumentID = new DataGridViewTextBoxColumn();
clnDocumentID.DataPropertyName = "Document_ID";
clnDocumentID.Name = "Document_ID";
dgvDocuments.Columns.Add(clnDocumentID);
clnDocumentID.Visible = false;
DataGridViewLinkColumn clnDocumentName = new DataGridViewLinkColumn();
clnDocumentName.LinkBehavior = System.Windows.Forms.LinkBehavior.NeverUnderline;
clnDocumentName.LinkColor = Color.Blue;
clnDocumentName.DataPropertyName = "File_Name";
clnDocumentName.Name = "Document Name";
dgvDocuments.Columns.Add(clnDocumentName);
dgvDocuments.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;
//dgvDocuments.Columns[2].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
DataGridViewColumn clnDocumentPath = new DataGridViewTextBoxColumn();
clnDocumentPath.DataPropertyName = "File_Path";
clnDocumentPath.Name = "Document Path";
dgvDocuments.Columns.Add(clnDocumentPath);
clnDocumentPath.Visible = false;
DataGridViewColumn clnKeywordID = new DataGridViewTextBoxColumn();
clnKeywordID.DataPropertyName = "Keyword_ID";
clnKeywordID.Name = "Keyword_ID";
dgvDocuments.Columns.Add(clnKeywordID);
clnKeywordID.Visible = false;
DataGridViewColumn clnKeyword = new DataGridViewTextBoxColumn();
clnKeyword.DataPropertyName = "Keyword";
clnKeyword.Name = "Folder";
dgvDocuments.Columns.Add(clnKeyword);
dgvDocuments.Columns[4].HeaderCell.SortGlyphDirection = SortOrder.None;
//dgvDocuments.Columns[2].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
DataGridViewColumn clnProcesstype = new DataGridViewTextBoxColumn();
clnProcesstype.DataPropertyName = "ProcessType";
clnProcesstype.Name = "Import By";
dgvDocuments.Columns.Add(clnProcesstype);
DataGridViewColumn clnDate = new DataGridViewTextBoxColumn();
clnDate.DataPropertyName = "Date";
clnDate.Name = "Date";
dgvDocuments.Columns.Add(clnDate);
dgvDocuments.Columns[5].HeaderCell.SortGlyphDirection = SortOrder.None;
try
{
ShowDocumentsManager objShowDocumentsManager = new ShowDocumentsManager();
NandanaResult dsgetScannedDocumentResultsdetails = objShowDocumentsManager.ShowScannedDocuments();
if (dsgetScannedDocumentResultsdetails.resultDS != null && dsgetScannedDocumentResultsdetails.resultDS.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsgetScannedDocumentResultsdetails.resultDS.Tables[0].Rows)
{
if (dr["Date"].ToString() != "")
{
dr["Date"] = DateTime.Parse(dr["Date"].ToString(), System.Globalization.CultureInfo.InvariantCulture).ToString();
}
}
dgvDocuments.DataSource = dsgetScannedDocumentResultsdetails.resultDS.Tables[0];
}
else
{
//pnlError.Visible = true;
//pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
//pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
//lblErrorMsg.Text = "No records to display";
//lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2);
dgvDocuments.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error While retriving data from ScannedDocumentresuls table");
}
}
// Updates views
private void UpdateView()
{
roleGridView.Columns.Clear();
roleGridView.DataSource = roleController.Read(roleSearch.Text.ToString(), listSwitch);
#region Edit Column
DataGridViewLinkColumn editColumn = new DataGridViewLinkColumn();
{
editColumn.HeaderText = "Editar";
editColumn.Text = "Editar";
editColumn.UseColumnTextForLinkValue = true;
editColumn.Width = 48;
editColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
editColumn.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
roleGridView.Columns.Add(editColumn);
#endregion
#region Delete Column
DataGridViewLinkColumn deleteColumn = new DataGridViewLinkColumn();
{
deleteColumn.HeaderText = "Excluir";
deleteColumn.Text = "Excluir";
deleteColumn.UseColumnTextForLinkValue = true;
deleteColumn.Width = 48;
deleteColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
deleteColumn.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
roleGridView.Columns.Add(deleteColumn);
#endregion
#region Restore Column
DataGridViewLinkColumn restoreColumn = new DataGridViewLinkColumn();
{
restoreColumn.HeaderText = "Restaurar";
restoreColumn.Text = "Restaurar";
restoreColumn.UseColumnTextForLinkValue = true;
restoreColumn.Width = 72;
restoreColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
restoreColumn.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
roleGridView.Columns.Add(restoreColumn);
#endregion
#region Columns Settings
roleGridView.Columns[0].Visible = false;
roleGridView.Columns[1].HeaderText = "Função";
roleGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
roleGridView.Columns[2].Visible = false;
if (listSwitch)
{
roleGridView.Columns[3].Visible = false;
roleGridView.Columns[4].Visible = false;
}
else
{
roleGridView.Columns[5].Visible = false;
}
#endregion
}
public void bindIncomeGrid()
{
IncomeDetailManager cl = new IncomeDetailManager();
DataSet ds = cl.ListIncomeDetails();
if (ds.Tables[0].Rows.Count > 0)
{
IncomeDetailGrid.AutoGenerateColumns = false;
IncomeDetailGrid.DataSource = null;
//Set Columns Count
IncomeDetailGrid.ColumnCount = 6;
//Add Columns
IncomeDetailGrid.Columns[0].Name = "TransactionID";
IncomeDetailGrid.Columns[0].HeaderText = "Transaction ID";
IncomeDetailGrid.Columns[0].DataPropertyName = "TransactionID";
IncomeDetailGrid.Columns[1].HeaderText = "Name";
IncomeDetailGrid.Columns[1].Name = "Name";
IncomeDetailGrid.Columns[1].DataPropertyName = "Name";
IncomeDetailGrid.Columns[2].Name = "LocationID";
IncomeDetailGrid.Columns[2].HeaderText = "Location";
IncomeDetailGrid.Columns[2].DataPropertyName = "LocationID";
IncomeDetailGrid.Columns[3].Name = "Date";
IncomeDetailGrid.Columns[3].HeaderText = "Date";
IncomeDetailGrid.Columns[3].DataPropertyName = "Date";
IncomeDetailGrid.Columns[4].Name = "Amount";
IncomeDetailGrid.Columns[4].HeaderText = "Amount";
IncomeDetailGrid.Columns[4].DataPropertyName = "Amount";
IncomeDetailGrid.Columns[5].Name = "Note";
IncomeDetailGrid.Columns[5].HeaderText = "Note";
IncomeDetailGrid.Columns[5].DataPropertyName = "Note";
IncomeDetailGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
IncomeDetailGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
IncomeDetailGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//IncomeDetailGrid.Columns.Insert(6, (DataGridViewColumn)db);
}
}
protected void Get_User_24_7_Hour_Wise_Next()
{
System.Data.DataTable temptable = dttargetorder.Clone();
int startindex = currentpageindex * pagesize;
int endindex = currentpageindex * pagesize + pagesize;
if (endindex > dttargetorder.Rows.Count)
{
endindex = dttargetorder.Rows.Count;
}
for (int i = startindex; i < endindex; i++)
{
DataRow row = temptable.NewRow();
GetDataRow_Target_Orders(ref row, dttargetorder.Rows[i]);
temptable.Rows.Add(row);
}
lbl_total.Text = dttargetorder.Rows.Count.ToString();
if (temptable.Rows.Count > 0)
{
lbl_Name.Text = dttargetorder.Rows[0]["User_Name"].ToString();
}
if (temptable.Rows.Count > 0)
{
// grd_Targetorder.DataBind();
grd_Targetorder.DataSource = null;
grd_Targetorder.AutoGenerateColumns = false;
grd_Targetorder.ColumnCount = 14;
grd_Targetorder.Columns[0].Name = "SNo";
grd_Targetorder.Columns[0].HeaderText = "S. No";
grd_Targetorder.Columns[0].Width = 65;
grd_Targetorder.Columns[1].Name = "Production Date";
grd_Targetorder.Columns[1].HeaderText = "PRODUCTION DATE";
grd_Targetorder.Columns[1].DataPropertyName = "Order_Production_Date";
grd_Targetorder.Columns[1].Width = 150;
grd_Targetorder.Columns[2].Name = "User Name";
grd_Targetorder.Columns[2].HeaderText = "USER NAME";
grd_Targetorder.Columns[2].DataPropertyName = "User_Name";
grd_Targetorder.Columns[2].Width = 110;
grd_Targetorder.Columns[3].Name = "Order Number";
grd_Targetorder.Columns[3].HeaderText = "ORDER NUMBER";
grd_Targetorder.Columns[3].DataPropertyName = "Client_Order_Number";
grd_Targetorder.Columns[3].Width = 175;
grd_Targetorder.Columns[3].Visible = false;
DataGridViewLinkColumn link = new DataGridViewLinkColumn();
grd_Targetorder.Columns.Add(link);
link.Name = "Order Number";
link.HeaderText = "ORDER NUMBER";
link.DataPropertyName = "Client_Order_Number";
link.Width = 200;
link.DisplayIndex = 1;
grd_Targetorder.Columns[4].Name = "Client Name";
grd_Targetorder.Columns[4].HeaderText = "CLIENT NAME";
grd_Targetorder.Columns[4].DataPropertyName = "Client_Name";
grd_Targetorder.Columns[4].Width = 130;
grd_Targetorder.Columns[5].Name = "SubProcessName";
grd_Targetorder.Columns[5].HeaderText = "SUB PROCESS NAME";
grd_Targetorder.Columns[5].DataPropertyName = "Sub_ProcessName";
grd_Targetorder.Columns[5].Width = 220;
grd_Targetorder.Columns[6].Name = "OrderType";
grd_Targetorder.Columns[6].HeaderText = "ORDER TYPE";
grd_Targetorder.Columns[6].DataPropertyName = "Order_Type";
grd_Targetorder.Columns[6].Width = 160;
grd_Targetorder.Columns[7].Name = "Order_Work_Type";
grd_Targetorder.Columns[7].HeaderText = "ORDER WORK TYPE";
grd_Targetorder.Columns[7].DataPropertyName = "Order_Work_Type";
grd_Targetorder.Columns[7].Width = 160;
grd_Targetorder.Columns[8].Name = "Task";
grd_Targetorder.Columns[8].HeaderText = "TASK";
grd_Targetorder.Columns[8].DataPropertyName = "Order_Status";
grd_Targetorder.Columns[8].Width = 120;
grd_Targetorder.Columns[9].Name = "Status";
grd_Targetorder.Columns[9].HeaderText = "PROGRESS STATUS";
grd_Targetorder.Columns[9].DataPropertyName = "Progress_Status";
grd_Targetorder.Columns[9].Width = 160;
grd_Targetorder.Columns[10].Name = "StartTime";
grd_Targetorder.Columns[10].HeaderText = "START TIME";
grd_Targetorder.Columns[10].DataPropertyName = "Start_Time";
grd_Targetorder.Columns[10].Width = 120;
grd_Targetorder.Columns[11].Name = "EndTime";
grd_Targetorder.Columns[11].HeaderText = "END TIME";
grd_Targetorder.Columns[11].DataPropertyName = "End_Time";
grd_Targetorder.Columns[11].Width = 120;
grd_Targetorder.Columns[12].Name = "TotalTime";
grd_Targetorder.Columns[12].HeaderText = "TOTAL TIME";
grd_Targetorder.Columns[12].DataPropertyName = "Total_Time";
grd_Targetorder.Columns[12].Width = 100;
grd_Targetorder.Columns[13].Name = "Order Id";
grd_Targetorder.Columns[13].HeaderText = "Order id";
grd_Targetorder.Columns[13].DataPropertyName = "Order_ID";
grd_Targetorder.Columns[13].Width = 100;
grd_Targetorder.Columns[13].Visible = false;
grd_Targetorder.DataSource = temptable;
}
else
{
grd_Targetorder.Visible = true;
//grd_Targetorder.Rows.Clear();
grd_Targetorder.DataSource = null;
}
lblRecordsStatus.Text = (currentpageindex + 1) + " / " + (int)Math.Ceiling(Convert.ToDecimal(dttargetorder.Rows.Count) / pagesize);
for (int i = 0; i < grd_Targetorder.Rows.Count; i++)
{
grd_Targetorder.Rows[i].Cells[0].Value = i + 1;
}
}
private void InitializeGrid()
{
// Currency Decimal Style
DataGridViewCellStyle dstyleCurrency = new DataGridViewCellStyle();
dstyleCurrency.Format = "C";
dstyleCurrency.NullValue = "";
dstyleCurrency.Alignment = DataGridViewContentAlignment.MiddleRight;
// Currency Decimal Style
DataGridViewCellStyle dstyleDecimal = new DataGridViewCellStyle();
dstyleDecimal.Format = "N2";
dstyleDecimal.NullValue = "0.00";
dstyleDecimal.Alignment = DataGridViewContentAlignment.MiddleRight;
// Wrapping Text Style
DataGridViewCellStyle dstyleWrapText = new DataGridViewCellStyle();
dstyleWrapText.NullValue = "";
dstyleWrapText.Alignment = DataGridViewContentAlignment.TopLeft;
dstyleWrapText.WrapMode = DataGridViewTriState.True;
// ID Column --
DataGridViewTextBoxColumn colID = new DataGridViewTextBoxColumn();
colID.HeaderText = "LineID";
colID.DataPropertyName = "LineID";
colID.Width = 75;
// PartID Column --
DataGridViewLinkColumn colPartID = new DataGridViewLinkColumn();
colPartID.HeaderText = "PartID";
colPartID.DataPropertyName = "PartID";
colPartID.Width = 50;
// Description Column --
DataGridViewTextBoxColumn colDescription = new DataGridViewTextBoxColumn();
colDescription.HeaderText = "Description";
colDescription.DataPropertyName = "Description";
colDescription.Width = 450;
colDescription.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
// Unit of Measure --
DataGridViewComboBoxColumn colUnit = new DataGridViewComboBoxColumn();
colUnit.Width = 60;
colUnit.DisplayMember = "UOM";
colUnit.ValueMember = "UID";
colUnit.DataPropertyName = "Uom";
// UnitCost ----------
DataGridViewTextBoxColumn colCost = new DataGridViewTextBoxColumn();
colCost.Width = 60;
colCost.HeaderText = "Cost";
colCost.DataPropertyName = "UnitCost";
colCost.DefaultCellStyle = dstyleCurrency;
// Qnty ----------
DataGridViewTextBoxColumn colQnty = new DataGridViewTextBoxColumn();
colQnty.Width = 60;
colQnty.HeaderText = "Qnty";
colQnty.DataPropertyName = "Qnty";
colQnty.DefaultCellStyle = dstyleDecimal;
// Extended ----------
DataGridViewTextBoxColumn colExtended = new DataGridViewTextBoxColumn();
colExtended.Width = 60;
colExtended.HeaderText = "Extended";
colExtended.DataPropertyName = "Extended";
colExtended.DefaultCellStyle = dstyleCurrency;
colUnit.DataSource = _partService.Units();
view.Columns.AddRange(colID, colPartID, colDescription, colUnit, colCost, colQnty, colExtended);
view.Dock = DockStyle.None;
this.Controls.Add(view);
BindGrid();
bsLineItems.DataSource = lineItems;
}
private void PopulateColumns()
{
BusyPopulatingColumns = true;
EditColumns.Clear();
dataGridViewX1.Columns.Clear();
if (ShowDeleteColumn)
{
DataGridViewImageColumn col = new DataGridViewImageColumn();
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
col.DefaultCellStyle.NullValue = DeleteImage;
col.HeaderText = "";
col.Frozen = FrozenColumnIndex.HasValue;
dataGridViewX1.Columns.Add(col);
}
for (int i = 0; i < Columns.Count; i++)
{
ColumnItem column = Columns[i];
//DataGridViewColumn colNullableCheckbox = null;
DataGridViewColumn col = null;
switch (column.ControlType)
{
case ColumnItem.ColumnTypes.Checkbox:
col = new DataGridViewCheckBoxColumn();
break;
case ColumnItem.ColumnTypes.Textbox:
col = new DataGridViewTextBoxColumnEx();
((DataGridViewTextBoxColumnEx)col).DisabledColor = DisabledColor;
((DataGridViewTextBoxColumnEx)col).InvalidColor = InvalidColor;
((DataGridViewTextBoxColumnEx)col).BackColor = BackColor;
break;
case ColumnItem.ColumnTypes.IntegerInput:
col = new DataGridViewIntegerInputColumn();
((DataGridViewIntegerInputColumn)col).DisplayControlForCurrentCellOnly = true;
((DataGridViewIntegerInputColumn)col).BackgroundStyle.Border = eStyleBorderType.None;
((DataGridViewIntegerInputColumn)col).ShowUpDown = true;
break;
case ColumnItem.ColumnTypes.NullableCheckBox:
col = new DataGridViewComboBoxColumnEx();
List <string> vals = new List <string>(new string[] { "", "True", "False" });
((DataGridViewComboBoxColumnEx)col).DataSource = vals;
((DataGridViewComboBoxColumnEx)col).DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
((DataGridViewComboBoxColumnEx)col).FlatStyle = FlatStyle.Flat;
((DataGridViewComboBoxColumnEx)col).DisabledColor = DisabledColor;
((DataGridViewComboBoxColumnEx)col).InvalidColor = InvalidColor;
((DataGridViewComboBoxColumnEx)col).BackColor = BackColor;
break;
case ColumnItem.ColumnTypes.NullableTextBox:
col = new DataGridViewTextBoxColumnEx();
((DataGridViewTextBoxColumnEx)col).DisabledColor = DisabledColor;
((DataGridViewTextBoxColumnEx)col).InvalidColor = InvalidColor;
((DataGridViewTextBoxColumnEx)col).BackColor = BackColor;
break;
case ColumnItem.ColumnTypes.NullableIntegerInput:
col = new DataGridViewTextBoxColumnEx();
((DataGridViewTextBoxColumnEx)col).DisabledColor = DisabledColor;
((DataGridViewTextBoxColumnEx)col).InvalidColor = InvalidColor;
((DataGridViewTextBoxColumnEx)col).BackColor = BackColor;
((DataGridViewTextBoxColumnEx)col).Alignment = DataGridViewContentAlignment.MiddleRight;
break;
case ColumnItem.ColumnTypes.ComboBox:
col = new DataGridViewComboBoxColumnEx();
List <string> keys = column.ComboItems.Keys.ToList();
keys.Sort();
((DataGridViewComboBoxColumnEx)col).DataSource = keys;
((DataGridViewComboBoxColumnEx)col).DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox;
((DataGridViewComboBoxColumnEx)col).FlatStyle = FlatStyle.Flat;
((DataGridViewComboBoxColumnEx)col).DisabledColor = DisabledColor;
((DataGridViewComboBoxColumnEx)col).InvalidColor = InvalidColor;
((DataGridViewComboBoxColumnEx)col).BackColor = BackColor;
break;
case ColumnItem.ColumnTypes.Image:
col = new DataGridViewImageColumn();
break;
case ColumnItem.ColumnTypes.Link:
col = new DataGridViewLinkColumn();
break;
case ColumnItem.ColumnTypes.None:
col = new DataGridViewLinkColumn();
break;
default:
throw new NotImplementedException("Not handled yet");
}
//if (colNullableCheckbox != null)
//{
// colNullableCheckbox.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;// true;
// colNullableCheckbox.Resizable = DataGridViewTriState.False;// false;
// dataGridViewX1.Columns.Add(colNullableCheckbox);
//}
col.Frozen = (FrozenColumnIndex.HasValue && i < FrozenColumnIndex);
col.HeaderText = column.Text;
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; //.AllCells;
col.Resizable = DataGridViewTriState.True;
col.ReadOnly = column.ReadOnly;
dataGridViewX1.Columns.Add(col);
EditColumns.Add(dataGridViewX1.Columns.Count - 1, i);
}
//dataGridViewX1.Columns[1].Frozen = true;
BusyPopulatingColumns = false;
}
