//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(); } }