//readonly ProcCardDataSet _ds = new ProcCardDataSet();
private void FrmPrint_Load(object sender, EventArgs e)
{
//var sql = "SELECT a.*,c.Dept FROM udstr a LEFT JOIN dbo.udone b ON b.sgdhao=a.sgdhao " +
// "LEFT JOIN DZDJ.dbo.TB_Dept c ON c.ID=b.DeptId " +
// $"WHERE zling='{SqlHelper.ProcCardNo}' AND DeptId='{SqlHelper.DeptId}' ORDER BY a.gxone,a.gxtwo";
//SqlHelper.FillDataset(SqlHelper.GetConnection(), CommandType.Text, sql, _ds, new string[] {"ProcCard"});
var cardDataSet = ProcCard.GetProcCardDataSet(SqlHelper.ProcCardNo);
var rds = new ReportDataSource("ProcCard", cardDataSet.Tables[0]);
reportViewer1.LocalReport.ReportPath = "ProcCard.rdlc";
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.RefreshReport();
}
private void InitDataGridView3()
{
var ds = ProcCard.GetProcCardDataSet(txtProcCardNo2.Text.Trim());
dataGridView3.DataSource = ds.Tables[0];
dataGridView3.AutoResizeColumns();
//for (int i = 0; i < dataGridView3.ColumnCount; i++)
//{
// dataGridView3.Columns[i].Width = 100;
//}
//dataGridView3.Columns[0].Width = 100;
//dataGridView3.Columns[1].Width = 100;
//dataGridView3.Columns[2].Width = 100;
//dataGridView3.Columns[3].Width = 100;
//dataGridView3.Columns[4].Width = 100;
//dataGridView3.Columns[5].Width = 100;
//dataGridView3.Columns[6].Width = 100;
//dataGridView3.Columns[7].Width = 100;
//dataGridView3.Columns[8].Width = 100;
//dataGridView3.Columns[9].Width = 100;
//dataGridView3.Columns[10].Width = 100;
dataGridView3.Sort(dataGridView3.Columns[1], ListSortDirection.Ascending);
}
private void btnPrint2_Click(object sender, EventArgs e)
{
if (txtProcCardNo2.Text.Length < 7)
{
MessageBox.Show("单号长度不能小于7", Resources.T提示);
txtProcCardNo2.Focus();
}
else
{
var gl = SqlHelper.ProcCardNo;
var lg = gl;
if (lg == "")
{
MessageBox.Show("单号不能为空", Resources.T提示);
txtProcCardNo2.Focus();
}
else
{
//var print = new FrmPrintRdlc();
//print.ShowDialog();
var dtDataTable = (DataTable)dataGridView3.DataSource;
ProcCard.SaveExcel(txtProcCardNo2.Text.Trim(), out var error);
if (!string.IsNullOrEmpty(error))
{
MessageUtil.ShowError(error);
}
//var dictReplace = new Dictionary<string, string>();
//foreach (DataRow row in dtDataTable.Rows)
//foreach (DataColumn column in dtDataTable.Columns)
// dictReplace.Add(column.ColumnName, row[column.ColumnName].ToString());
//AsposeExcelTools.ExportWithReplace(ExcelTemplateFile, txtProcCardNo2 + ".xlsx", dictReplace);
}
}
}
public FrmProcCard()
{
KeyDown += FrmWin_KeyDown;
InitializeComponent();
ProcCard = new ProcCard();
}
private void btnAdd_Click(object sender, EventArgs e) //保存
{
if (btnAdd.Text == Resources.A新增)
{
txtWONo.Text = "";
txtPrtDwgNo.Text = "";
txtProcCardNo.Text = "";
txtWONo.Focus();
btnAdd.Text = Resources.A保存;
txtWONo.ReadOnly = false;
InitDataGridView2();
InitDataGridView1();
txtProcCardNo.Text = ProcCard.GetProcCardNo();
}
else
{
var sql = $"SELECT TOP 1 * FROM udone WHERE sgdhao='{txtWONo.Text.Trim()}'";
var dataReader = SqlHelper.ExecuteReader(SqlHelper.GetConnection(), CommandType.Text, sql);
if (dataReader.HasRows)
{
dataReader.Read();
var pONo = dataReader["ddhao"].ToString().Trim();
var cust = dataReader["kehu"].ToString().Trim();
var planDate = dataReader["jhwxri"].ToString().Trim();
var prtDwgNo = dataReader["tuhao"].ToString().Trim();
var prtName = dataReader["name"].ToString().Trim().Replace("'", "''");
var pageNo = dataReader["yema"].ToString().Trim();
var meatrial = dataReader["cailiao"].ToString().Trim();
var qty = dataReader["sulia"].ToString().Trim();
dataReader.Close();
if (dataGridView1.RowCount == 0)
{
return;
}
var conn = SqlHelper.GetConnection();
conn.Open();
var tran = conn.BeginTransaction();
using (tran)
{
try
{
txtProcCardNo.Text = ProcCard.GetProcCardNo();
//using (QRCodeGenerator qrGenerator = new QRCodeGenerator())
//{
// using (QRCodeData qrCodeData = qrGenerator.CreateQrCode(txtProcCardNo.Text, (QRCodeGenerator.ECCLevel)_appConfig.AppConfigGet("eccLevel").ToInt32()))
// {
// using (QRCode qrCode = new QRCode(qrCodeData))
// {
// var img= qrCode.GetGraphic(20, Color.Black, Color.White,new Bitmap("/ICO/dz.png"), 18);
// }
// }
//}
for (var i = 0; i < dataGridView1.RowCount - 1; i++)
{
var craftSeq = dataGridView1.Rows[i].Cells["工序号"].Value.ToString();
var craft = dataGridView1.Rows[i].Cells["工序名称"].Value.ToString();
var processCardSeq = dataGridView1.Rows[i].Cells["加工工序"].Value.ToString();
var debugTime = decimal.Parse(dataGridView1.Rows[i].Cells["调机时间"].Value + "");
var singleProcTime = decimal.Parse(dataGridView1.Rows[i].Cells["单件时间"].Value + "");
var processUPrice = decimal.Parse(dataGridView1.Rows[i].Cells["序价"].Value + "");
var formula = int.Parse(dataGridView1.Rows[i].Cells["公式"].Value + "");
var subsidy = decimal.Parse(dataGridView1.Rows[i].Cells["补助"].Value + "");
//string strId4 = dgvExcelView.Rows[i].Cells["件资合计"].Value.ToString();
//string strId5 = dgvExcelView.Rows[i].Cells["id5"].Value.ToString();
if (craftSeq == "" || processCardSeq == "")
{
continue;
}
var strSql =
"insert into udstr(zling,sgdhao,ddhao,kehu,jhqi,tuhao,name,yema,suliang,cailiao,gxone," +
$"gxname,gxtwo,tiao,danjian,xuj,gongsi,buzu,cjriqi,cjren) values('{txtProcCardNo.Text.Trim()}','{txtWONo.Text.Trim()}','{pONo}','{cust}','{planDate}','{prtDwgNo}','{prtName}'," +
$"'{pageNo}','{qty}','{meatrial}','{craftSeq}','{craft}','{processCardSeq}','{debugTime}','{singleProcTime}','{processUPrice}','{formula}','{subsidy}','{DateTime.Now}','{SqlHelper.UserName}')";
SqlHelper.ExecuteNonQuery(tran, CommandType.Text, strSql);
strSql =
"insert into udktr(zling,sgdhao,ddhao,kehu,jhqi,tuhao,name,yema,suliang,cailiao,gxone," +
$"gxname,gxtwo,tiao,danjian,xuj,gongsi,buzu,cjriqi,cjren) values('{txtProcCardNo.Text.Trim()}','{txtWONo.Text.Trim()}','{pONo}','{cust}','{planDate}','{prtDwgNo}','{prtName}'," +
$"'{pageNo}','{qty}','{meatrial}','{craftSeq}','{craft}','{processCardSeq}','{debugTime}','{singleProcTime}','{processUPrice}','{formula}','{subsidy}','{DateTime.Now}','{SqlHelper.UserName}')";
SqlHelper.ExecuteNonQuery(tran, CommandType.Text, strSql);
}
tran.Commit();
MessageBox.Show(@"保存成功", Resources.T提示);
SqlHelper.ProcCardNo = txtProcCardNo.Text.Trim();
}
catch (Exception ex)
{
tran.Rollback();
MessageBox.Show(ex.Message);
}
}
var sqlkgy = $"UPDATE udone set beione='1' WHERE sgdhao='{txtWONo.Text.Trim()}'";
SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sqlkgy);
}
dataReader.Close();
btnAdd.Text = Resources.A新增;
txtWONo.Focus();
txtWONo.ReadOnly = true;
InitDataGridView2();
InitDataGridView1();
}
}
