using MESHelper
.Models;
using System;
using System
.Collections
.Generic;
using System
.ComponentModel;
using System
.Data;
using System
.Drawing;
using System
.Linq;
using System
.Text;
using System
.Threading
.Tasks;
using System
.Windows
.Forms;
using MESHelper
.IBusiness;
using Tools
.DB;
using AMES
.NormalTool;
using Models;
using SqlSugar;
using DevExpress
.Utils
.About;
using DevComponents
.DotNetBar
.Controls;
namespace AMES
.HandInput
{
public partial
class GetOrderForm : Form
{
private GetOrderForm()
{
InitializeComponent();
}
private static GetOrderForm _instance;
//首页
public static int pageStart = 1;
//当前页数
public int pageIndex = ((pageStart - 1) * pageSize);
//每页显示的记录数
private static int pageSize = 10;
//总记录数
private static int recordCount;
//总页数
private static int pageCount = 0;
public static GetOrderForm GetInstance()
{
if (_instance == null)
{
_instance = new GetOrderForm();
}
return _instance;
}
private void GetOrder_
button_Click(
object sender, EventArgs e)
{
var allData = GetOrder
.GetOrderMethod();
foreach (var item in allData
.Data)
{
DbContext
.P_WorkOrder_DB
.Insert(new Models
.P_WorkOrder
{
FactoryName = item
.FactoryName,
MfgLineName = item
.MfgLineName,
WorkOrderName = item
.WorkOrderName,
WorkOrderNo = item
.ProductName,
ProductionNo = item
.ProductItemNo,
ProductFamily = item
.ProductFamily,
PlanNumber = item
.Qty,
OrderName = item
.OrderName,
PlannedcompletionDate = item
.PlannedcompletionDate,
PlannedstartDate = item
.PlannedstartDate,
DoneNumber = "1",
WorkOrderRuleID = 0,
WorkOrderType = "N",
WorkOrderStatus = 1,
});
}
DbContext
.Db
.Ado
.ExecuteCommand("DELETE FROM P_WorkOrder WHERE ID NOT IN (SELECT MIN(ID) FROM P_WorkOrder GROUP BY WorkOrderName)");
MessageBox
.Show("获取工单成功");
}
private void Select_
button_Click(
object sender, EventArgs e)
{
DateTime yesterday = DateTime
.Today
.AddDays(-1);
DateTime tomorrow = DateTime
.Today
.AddDays(1);
recordCount = DbContext
.Db
.Ado
.GetInt("SELECT COUNT(*) FROM P_WorkOrder");
//recordCount = 0;
pageCount = (int)Math
.Ceiling((double)recordCount / pageSize);
dataGridView1
.DataSource = DbContext
.Db
.Queryable<P_WorkOrder>()
.Select(x => new
{
x
.FactoryName,
x
.MfgLineName,
x
.WorkOrderName,
x
.WorkOrderNo,
x
.ProductionNo,
x
.ProductFamily,
x
.PlanNumber,
x
.OrderName,
x
.PlannedcompletionDate,
x
.PlannedstartDate,
x
.DoneNumber,
x
.WorkOrderRuleID,
x
.WorkOrderType,
x
.WorkOrderStatus,
})
.OrderBy(x => x
.PlannedstartDate, OrderByType
.Desc)
.ToPageList(pageStart, pageSize, ref recordCount)
.ToList();
//设置表头
dataGridView1
.Columns["FactoryName"]
.HeaderText = "工厂名称";
dataGridView1
.Columns["MfgLineName"]
.HeaderText = "产线名称";
dataGridView1
.Columns["WorkOrderName"]
.HeaderText = "工单名称";
dataGridView1
.Columns["WorkOrderNo"]
.HeaderText = "产品型号";
dataGridView1
.Columns["ProductionNo"]
.HeaderText = "产品料号";
dataGridView1
.Columns["ProductFamily"]
.HeaderText = "产品系列";
dataGridView1
.Columns["PlanNumber"]
.HeaderText = "计划产量";
dataGridView1
.Columns["OrderName"]
.HeaderText = "订单";
dataGridView1
.Columns["PlannedcompletionDate"]
.HeaderText = "计划结束时间";
dataGridView1
.Columns["PlannedstartDate"]
.HeaderText = "计划开始时间";
dataGridView1
.Columns["DoneNumber"]
.HeaderText = "实际产量";
dataGridView1
.Columns["WorkOrderRuleID"]
.HeaderText = "工单规则编号";
dataGridView1
.Columns["WorkOrderType"]
.HeaderText = "工单类型";
dataGridView1
.Columns["WorkOrderStatus"]
.HeaderText = "工单状态";
//禁止自动选中第一行
dataGridView1
.Rows[0]
.Selected = false;
All_textBox
.Text = recordCount
.To
String();
PageAll_textBox
.Text = pageCount
.To
String();
Page_textBox
.Text = (pageIndex + 1)
.To
String();
}
private void dataGridView1_CellClick(
object sender, DataGridViewCellEventArgs e)
{
FactoryName_textBox
.Text = dataGridView1
.CurrentRow
.Cells["FactoryName"]
.Value
.To
String();
MfgLineName_textBox
.Text = dataGridView1
.CurrentRow
.Cells["MfgLineName"]
.Value
.To
String();
WorkOrderName_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderName"]
.Value
.To
String();
WorkOrderNo_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderNo"]
.Value
.To
String();
ProductionNo_textBox
.Text = dataGridView1
.CurrentRow
.Cells["ProductionNo"]
.Value
.To
String();
ProductFamily_textBox
.Text = dataGridView1
.CurrentRow
.Cells["ProductFamily"]
.Value
.To
String();
PlanNumber_textBox
.Text = dataGridView1
.CurrentRow
.Cells["PlanNumber"]
.Value
.To
String();
OrderName_textBox
.Text = dataGridView1
.CurrentRow
.Cells["OrderName"]
.Value
.To
String();
PlannedcompletionDate_textBox
.Text = dataGridView1
.CurrentRow
.Cells["PlannedcompletionDate"]
.Value
.To
String();
PlannedstartDate_textBox
.Text = dataGridView1
.CurrentRow
.Cells["PlannedstartDate"]
.Value
.To
String();
DoneNumber_textBox
.Text = dataGridView1
.CurrentRow
.Cells["DoneNumber"]
.Value
.To
String();
WorkOrderRuleID_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderRuleID"]
.Value
.To
String();
WorkOrderType_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderType"]
.Value
.To
String();
WorkOrderStatus_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderStatus"]
.Value
.To
String();
UseOrder_textBox
.Text = dataGridView1
.CurrentRow
.Cells["WorkOrderName"]
.Value
.To
String();
}
private void SetOrder_
button_Click(
object sender, EventArgs e)
{
DbContext
.Db
.Ado
.ExecuteCommand("UPDATE P_WorkOrder SET WorkOrderType = 'P' WHERE WorkOrderName = '" + WorkOrderName_textBox
.Text
.Trim() + "'");
Select_
button_Click(sender, e);
SetOrder_
button.Enabled = false;
UseOrder_textBox
.Text = WorkOrderName_textBox
.Text;
MessageBox
.Show("设置成功");
}
private void Pre_
button_Click(
object sender, EventArgs e)
{
if (pageStart == 1)
{
Page_textBox
.Text = pageStart
.To
String();
}
else if (pageStart > 1 || pageStart <= pageCount)
{
pageStart--;
pageIndex = (pageStart - 1);
Page_textBox
.Text = pageStart
.To
String();
Select_
button_Click(sender, e);
}
}
private void Next_
button_Click(
object sender, EventArgs e)
{
if (pageStart == pageCount)
{
Page_textBox
.Text = pageStart
.To
String();
}
else if (pageStart >= 1 || pageStart <= pageCount)
{
pageStart++;
pageIndex = pageStart - 1;
Page_textBox
.Text = pageStart
.To
String();
Select_
button_Click(sender, e);
}
}
private void dgv_RowPostPaint(
object sender, DataGridViewRowPostPaintEventArgs e)
{
Rectangle rectangle = new Rectangle(e
.RowBounds
.Location
.X,
e
.RowBounds
.Location
.Y,
dataGridView1
.RowHeadersWidth - 4,
e
.RowBounds
.Height);
TextRenderer.DrawText(e
.Graphics, (e
.RowIndex + 1)
.To
String(),
dataGridView1
.RowHeadersDefaultCellStyle
.Font,
rectangle,
dataGridView1
.RowHeadersDefaultCellStyle
.ForeColor,
TextFormatFlags
.VerticalCenter | TextFormatFlags
.Right);
}
private void GetOrderForm_FormClosing(
object sender, FormClosingEventArgs e)
{
_instance = null;
}
private void UpdateOrder_
button_Click(
object sender, EventArgs e)
{
DbContext
.Db
.Ado
.ExecuteCommand("UPDATE P_WorkOrder SET WorkOrderType = 'N' WHERE WorkOrderType = 'P'");
DbContext
.Db
.Ado
.ExecuteCommand("UPDATE P_WorkOrder SET WorkOrderType = 'P' WHERE WorkOrderName = '" + WorkOrderName_textBox
.Text
.Trim() + "'");
Select_
button_Click(sender, e);
UseOrder_textBox
.Text = WorkOrderName_textBox
.Text;
MessageBox
.Show("切换成功");
}
private void GetOrderForm_Load(
object sender, EventArgs e)
{
var info = DbContext
.P_WorkOrder_DB
.GetList(x => x
.WorkOrderType == "P")
.ToList();
foreach (var item in info)
{
FactoryName_textBox
.Text = item
.FactoryName;
MfgLineName_textBox
.Text = item
.MfgLineName;
WorkOrderName_textBox
.Text = item
.WorkOrderName;
WorkOrderNo_textBox
.Text = item
.WorkOrderNo;
ProductionNo_textBox
.Text = item
.ProductionNo;
ProductFamily_textBox
.Text = item
.ProductFamily;
PlanNumber_textBox
.Text = item
.PlanNumber;
OrderName_textBox
.Text = item
.OrderName;
PlannedcompletionDate_textBox
.Text = item
.PlannedcompletionDate;
PlannedstartDate_textBox
.Text = item
.PlannedstartDate;
DoneNumber_textBox
.Text = item
.DoneNumber;
WorkOrderRuleID_textBox
.Text = item
.WorkOrderRuleID
.To
String();
WorkOrderType_textBox
.Text = item
.WorkOrderType;
WorkOrderStatus_textBox
.Text = item
.WorkOrderStatus
.To
String();
UseOrder_textBox
.Text = item
.WorkOrderName;
}
}
}
}
本文介绍了一个使用C#在图片上绘制文本的例子。通过创建Bitmap对象并利用Graphics类进行绘图，展示了如何设置字体、颜色及绘制边界。此外，还演示了如何测量文本大小并将其显示在PictureBox中。
扫一扫
5010
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
