哥是非专业人事。请专业人事谈谈哥的东西。c#+winform+sql server
窗体看上去太简单。这个是用来继承用的。
在这个父窗体中,包含了一个架构。看一下继承得到的窗体。
--------------------编程问答-------------------- 父窗体。
接下来我将从数据库设计,到数据收集,再到数据展现同高手们一同探讨
--------------------编程问答-------------------- 不知道怎么上传文件。用来继承的父窗体也上传不了。 --------------------编程问答-------------------- using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Reporting.WinForms;
namespace jinxiaocun
{
public partial class caigrk : nysong .nysong
{
public caigrk()
{
co = "Data Source=.; Initial Catalog=jxc;User Id=sa;Pwd=";
jiegsql = "select spbh 商品编号,spmch 商品名称,dw 单位,shpgg 商品规格,shpchd 商品产地,shl 数量,dj 单价,jine 金额 from cgrkmx where 1=2";
//cxsql = "select banman 版面,wei 版面位,danjia 单价,0 as 次数,0 应收金额,' ' 开始期,'' 结束期,shuoming 说明 from shfeije where banman like song_value";
cxsql = "select spbh 商品编号,spmch 商品名称,dw 单位,shpgg 商品规格,shpchd 商品产地,0 数量,dj 单价,0 金额 from spkfk where spbh like song_value or spmch like song_value or zjm like song_value";
lxx = "";//打开主表数据辅助查询录入
djming = "采购入库";
InitializeComponent();
toolStripButton4.Visible = false;
textBox2.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
textBox3.Text = "cgrk" + soosn("cgrk", 1).ToString().TrimEnd();//不加1取单据号
DataSet aaa = new DataSet();
aaa = songsql_oledb("select ywy 业务员 from ZHIYDOC where zhiw='业务员'", "sso");
for (int i = 0; i < aaa.Tables["sso"].Rows.Count; i++)
{
comboBox1.Items.Add(aaa.Tables["sso"].Rows[i][0]);
}
DataSet sop = new DataSet();
sop = songsql_oledb("select * from cgrkmx where djbh='" + textBox3.Text + "'", "abc");
if (sop.Tables["abc"].Rows.Count != 0) { textBox3.Text = "cgrk" + soosn("cgrk", 0).ToString().TrimEnd(); }
song_grid1(jiegsql);
}
private void textBox4_DoubleClick(object sender, EventArgs e)
{
tttso = 4;
cxdjtou = "仓库选择";//打开单据头查询
labelsong.Text = cxdjtou;
cxtait("select ckid 仓库代码,ckmch 仓库名称,ckmji 仓库面积,fzr 负责人,dianhua 电话,qita 说明 from ckzl");//查询单据头内容
}
public override void grid2_to_djtext(int row)//填单据头
{
//MessageBox.Show(dataGridView2.Rows[row ].Cells[1].Value.ToString ());
if (tttso == 4)
{
textBox4.Text = dataGridView2.Rows[row].Cells[1].Value.ToString().TrimEnd() + "(" + dataGridView2.Rows[row].Cells[0].Value.ToString().TrimEnd() + ")";
panel1.Visible = false;
}
if (tttso == 1)
{
textBox1.Text = dataGridView2.Rows[row].Cells[1].Value.ToString().TrimEnd() + "(" + dataGridView2.Rows[row].Cells[0].Value.ToString().TrimEnd() + ")";
panel1.Visible = false;
}
}
private void textBox1_DoubleClick(object sender, EventArgs e)
{
tttso = 1;
cxdjtou = "客户选择";//打开单据头查询
labelsong.Text = cxdjtou;
cxtait("select kehuid 客户代码,kehuming 客户名称,dizhi 地址,dianhua 电话,qita 说明 from kehuzl");//查询单据头内容
}
public override void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)//计算两列得到第三列
{//用来定义一列 等于两列的积,或两列的和。
//MessageBox .Show ( e.RowIndex.ToString ());
//jijsuan(r);
jijsuan(e.RowIndex, 5, 6, 7, 1);//*法
//hejsuan(e.RowIndex, 3, 5, 6, 2);//+法
}
public override void songdata() //存入数据库
{
DataSet sop = new DataSet();
sop = songsql_oledb("select * from cgrkmx where djbh='" + textBox3.Text + "'", "abc");
if (sop.Tables["abc"].Rows.Count != 0) { MessageBox.Show("当前单据号已存在,如果已打印请新开单据!"); return; }
SqlConnection conn = new SqlConnection(co);
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM cgrkmx where 1=2", conn);
SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, "spp");
DataTable dttt = ds.Tables["spp"];
if (dataGridView1.Rows.Count > 0)
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[1].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[2].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[3].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[4].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[5].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[6].Value.ToString() != "" &&
dataGridView1.Rows[i].Cells[7].Value.ToString() != "")
{
// spbh 商品编号,spmch 商品名称,dw 单位,shpgg 商品规格,shpchd 商品产地,shl 数量,dj 单价,jine 金额
DataRow newRow = dttt.NewRow();
newRow["djbh"] = textBox3.Text;
newRow["rq"] = textBox2.Text;// ((int)(i + 1)).ToString();
newRow["plh"] = ((int)(i + 1)).ToString();
newRow["djbhrqplh"] = textBox3.Text + textBox2.Text + ((int)(i + 1)).ToString();
newRow["ywy"] = comboBox1.Text;
newRow["kehu"] = textBox3.Text;
newRow["spbh"] = dataGridView1.Rows[i].Cells[0].Value;
newRow["spmch"] = dataGridView1.Rows[i].Cells[1].Value;
newRow["dw"] = dataGridView1.Rows[i].Cells[2].Value;
newRow["shpgg"] = dataGridView1.Rows[i].Cells[3].Value;
newRow["shpchd"] = dataGridView1.Rows[i].Cells[4].Value;
newRow["shl"] = ToDBC(dataGridView1.Rows[i].Cells[5].Value.ToString ());
newRow["dj"] = ToDBC(dataGridView1.Rows[i].Cells[6].Value.ToString ());
newRow["jine"] = ToDBC(dataGridView1.Rows[i].Cells[7].Value.ToString ());
newRow["ywy"] = comboBox1.Text ;
newRow["rkck"] = textBox4.Text;
newRow["kehu"] = textBox1.Text;
dttt.Rows.Add(newRow);
adapter.Update(ds, "spp");
}
else
{
MessageBox.Show("数据不完整或违反规则不能存盘");
return;
}
}
proc();
if (DialogResult.OK == MessageBox.Show("存盘完毕,如果未打印新开下一单据请点新开单据,是否打印?", "打印提示!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
panel3.Visible = true;
panel3.Width = this.Width;
panel3.Top = toolStrip1.Height;
panel3.Left = 0;
panel3.Height = this.Height - toolStrip1.Height;
toolStripButton1.Visible = false;
toolStripButton2.Visible = false;
toolStripButton4.Visible = true;
toolStripButton3.Visible = false;
songprint();
}
}
}
补充:.NET技术 , C#