using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
using Base;namespace 生产物流
{
public partial class Frm_销售单 : Base.Frm_zhcb
{
private LinkDataBase link = new LinkDataBase(); private DataTable myTable0, myTable1;
private DataRow myRow0, myRow1; private DataSet myDataSet = new DataSet();
private string tableName1, tableName2, strSQL1, strSQL2;
public Frm_销售单()
{
InitializeComponent();
} private void Frm_销售单_Load(object sender, EventArgs e)
{
base.DataList();
MessageBox.Show("姓名,权限,身份 = '" + publicbl.M姓名 + "','" + publicbl.M权限 + "','" + publicbl.M身份 + "'"); this.fzgx(); DataRelation drl = new DataRelation("主从表", parentcol, childcol, false); base.ds.Relations.Add(drl); if ((publicbl.M权限 == "4") || (publicbl.M权限 == "7"))
{
//base.btn_Save.Enabled = false;
//this.btn_Save.Enabled = true;
base.btn_Del1.Enabled = false;
base.btn_Del2.Enabled = false;
base.btn_Qz.Enabled = false;
base.btn_Count.Enabled = false;
base.btn_Cg.Text = "入库存档";
}
else
{
base.btn_Cg.Enabled = false;
} if (publicbl.M身份 == "0")
{
btn_Qz.Text = "营销员签字";
}
else
{
btn_Qz.Text = "营销领导签字";
} this.MyDataSource();
if (myDataSet != null)
{
this.MyDataGridView();
}
}
private void MyDataSource()
{
tableName1 = "客户商信息表";
tableName2 = "产品信息表";
strSQL1 = "SELECT * FROM 客户商信息表";
strSQL2 = "SELECT * FROM 产品信息表"; this.myDataSet.Clear();
this.myDataSet = link.RunSelect(strSQL1, tableName1);
this.myDataSet = link.RunSelect(strSQL2, tableName2);
}
private void MyDataGridView()
{
dataGridView1.AutoGenerateColumns = false;
dataGridView2.AutoGenerateColumns = false; dataGridView1.AllowUserToOrderColumns = true;
dataGridView2.AllowUserToOrderColumns = true; dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.InactiveCaptionText;
dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.InactiveCaptionText;
dataGridView1.MultiSelect = false;
dataGridView2.MultiSelect = false; dataGridView1.SelectionMode = DataGridViewSelectionMode.CellSelect;
dataGridView2.SelectionMode = DataGridViewSelectionMode.CellSelect; dataGridView1.RowTemplate.Height = 30;
dataGridView2.RowTemplate.Height = 30; dataGridView1.VirtualMode = true;
dataGridView2.VirtualMode = true; DataGridViewComboBoxColumn col名称 = new DataGridViewComboBoxColumn(); col名称.DataPropertyName = "名称"; col名称.DataSource = myDataSet.Tables["客户商信息表"];
col名称.ValueMember = "名称";
col名称.DisplayMember = "名称";
col名称.HeaderText = "客户商";
col名称.Name = "名称";
col名称.ReadOnly = false;
col名称.Width = 120; dataGridView1.Columns.Add(col名称); DataGridViewTextBoxColumn col销售日期 = new DataGridViewTextBoxColumn(); col销售日期.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; col销售日期.DataPropertyName = "销售日期"; col销售日期.DefaultCellStyle.Format = "yyyy-MM-dd";
col销售日期.HeaderText = "销售日期";
col销售日期.Name = "销售日期";
col销售日期.ReadOnly = true; dataGridView1.Columns.Add(col销售日期); DataGridViewComboBoxColumn col品名 = new DataGridViewComboBoxColumn(); col品名.DataPropertyName = "品名"; col品名.DataSource = myDataSet.Tables["产品信息表"];
col品名.ValueMember = "品名";
col品名.DisplayMember = "品名";
col品名.HeaderText = "品名";
col品名.Name = "品名";
col品名.ReadOnly = false;
col品名.Width = 120; dataGridView2.Columns.Add(col品名); }
protected override void OverName()
{
base.OverName();
sendTableName1 = "销售单";
sendTableName2 = "销售单明细";
sendStrSQL1 = "SELECT * FROM 销售单";
sendStrSQL2 = "SELECT * FROM 销售单明细"; this.Text = "销售合同单窗口";
GBox1.Text = "销售单";
GBox2.Text = "销售单明细";
}
protected override void fzgx()
{
base.fzgx();
parentcol = ds.Tables["销售单"].Columns["销售单号"];
childcol = ds.Tables["销售单明细"].Columns["销售单号"];
}
protected override void qianzi()
{
base.qianzi();
if (publicbl.M身份 == "0")
{
link.UpdateDataBase("Update 销售单 Set 营销员 = '" + publicbl.M姓名 + "'"); }
else
{
link.UpdateDataBase("Update 销售单 Set 领导签字 = '" + publicbl.M姓名 + "'"); } base.DataList();
}
protected override void jsje()
{
base.jsje();
base.jsje(); base.RowNumber1 = dataGridView1.Rows.Count;
base.RowNumber2 = dataGridView2.Rows.Count; this.dataGridView1.CurrentCell = this.dataGridView1[0, 1];
this.dataGridView2.CurrentCell = this.dataGridView2[0, 1];
try
{
for (i = 0; i < RowNumber1 - 1; i++)
{
s = 0.0m;
this.myTable0 = base.ds.Tables[0];
this.myRow0 = myTable0.Rows[i];
M单据号 = (int)myRow0[0]; for (j = 0; j < RowNumber2 - 1; j++)
{
this.myTable1 = base.ds.Tables[1];
this.myRow1 = myTable1.Rows[j];
M单号 = (int)myRow1[1]; M金额 = 0.0m;
if (M单号 == M单据号)
{
M进价 = (decimal)myRow1[4];
M数量 = (int)myRow1[5];
M金额 = M进价 * M数量;
this.dataGridView2.Rows[j].Cells[6].Value = M金额;
}
s = s + M金额;
}
this.dataGridView1.Rows[i].Cells[6].Value = s;
}
base.DataSave();
base.DataList();
}
catch (Exception ex)
{
MessageBox.Show("计算金额失败!原因是 " + ex.Message.ToString(), "请注意!");
}
}
protected override void ckgl()
{
base.ckgl();
if ((publicbl.M权限 == "4") || (publicbl.M权限 == "7"))
{ link.UpdateDataBase("Update 销售单 Set 仓管员 = '" + publicbl.M姓名 + "'");
base.DataList(); if (MessageBox.Show("仓管员签字成功,按确认键办理出库!",
"确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{ base.DataList();
MessageBox.Show("办理成品出库成功,数据表已清空!"); }
catch (Exception ex)
{ MessageBox.Show("办理成品出库手续失败!原因是:" + ex.Message.ToString(), "请注意!");
}
} }
else
{
MessageBox.Show("你无权使用此按钮的操作!");
}
} private void Btn_Save_Click(object sender, EventArgs e)
{
//this.btn_Save.Enabled = true; }
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
using Base;namespace 生产物流
{
public partial class Frm_销售单 : Base.Frm_zhcb
{
private LinkDataBase link = new LinkDataBase(); private DataTable myTable0, myTable1;
private DataRow myRow0, myRow1; private DataSet myDataSet = new DataSet();
private string tableName1, tableName2, strSQL1, strSQL2;
public Frm_销售单()
{
InitializeComponent();
} private void Frm_销售单_Load(object sender, EventArgs e)
{
base.DataList();
MessageBox.Show("姓名,权限,身份 = '" + publicbl.M姓名 + "','" + publicbl.M权限 + "','" + publicbl.M身份 + "'"); this.fzgx(); DataRelation drl = new DataRelation("主从表", parentcol, childcol, false); base.ds.Relations.Add(drl); if ((publicbl.M权限 == "4") || (publicbl.M权限 == "7"))
{
//base.btn_Save.Enabled = false;
//this.btn_Save.Enabled = true;
base.btn_Del1.Enabled = false;
base.btn_Del2.Enabled = false;
base.btn_Qz.Enabled = false;
base.btn_Count.Enabled = false;
base.btn_Cg.Text = "入库存档";
}
else
{
base.btn_Cg.Enabled = false;
} if (publicbl.M身份 == "0")
{
btn_Qz.Text = "营销员签字";
}
else
{
btn_Qz.Text = "营销领导签字";
} this.MyDataSource();
if (myDataSet != null)
{
this.MyDataGridView();
}
}
private void MyDataSource()
{
tableName1 = "客户商信息表";
tableName2 = "产品信息表";
strSQL1 = "SELECT * FROM 客户商信息表";
strSQL2 = "SELECT * FROM 产品信息表"; this.myDataSet.Clear();
this.myDataSet = link.RunSelect(strSQL1, tableName1);
this.myDataSet = link.RunSelect(strSQL2, tableName2);
}
private void MyDataGridView()
{
dataGridView1.AutoGenerateColumns = false;
dataGridView2.AutoGenerateColumns = false; dataGridView1.AllowUserToOrderColumns = true;
dataGridView2.AllowUserToOrderColumns = true; dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.InactiveCaptionText;
dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.InactiveCaptionText;
dataGridView1.MultiSelect = false;
dataGridView2.MultiSelect = false; dataGridView1.SelectionMode = DataGridViewSelectionMode.CellSelect;
dataGridView2.SelectionMode = DataGridViewSelectionMode.CellSelect; dataGridView1.RowTemplate.Height = 30;
dataGridView2.RowTemplate.Height = 30; dataGridView1.VirtualMode = true;
dataGridView2.VirtualMode = true; DataGridViewComboBoxColumn col名称 = new DataGridViewComboBoxColumn(); col名称.DataPropertyName = "名称"; col名称.DataSource = myDataSet.Tables["客户商信息表"];
col名称.ValueMember = "名称";
col名称.DisplayMember = "名称";
col名称.HeaderText = "客户商";
col名称.Name = "名称";
col名称.ReadOnly = false;
col名称.Width = 120; dataGridView1.Columns.Add(col名称); DataGridViewTextBoxColumn col销售日期 = new DataGridViewTextBoxColumn(); col销售日期.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; col销售日期.DataPropertyName = "销售日期"; col销售日期.DefaultCellStyle.Format = "yyyy-MM-dd";
col销售日期.HeaderText = "销售日期";
col销售日期.Name = "销售日期";
col销售日期.ReadOnly = true; dataGridView1.Columns.Add(col销售日期); DataGridViewComboBoxColumn col品名 = new DataGridViewComboBoxColumn(); col品名.DataPropertyName = "品名"; col品名.DataSource = myDataSet.Tables["产品信息表"];
col品名.ValueMember = "品名";
col品名.DisplayMember = "品名";
col品名.HeaderText = "品名";
col品名.Name = "品名";
col品名.ReadOnly = false;
col品名.Width = 120; dataGridView2.Columns.Add(col品名); }
protected override void OverName()
{
base.OverName();
sendTableName1 = "销售单";
sendTableName2 = "销售单明细";
sendStrSQL1 = "SELECT * FROM 销售单";
sendStrSQL2 = "SELECT * FROM 销售单明细"; this.Text = "销售合同单窗口";
GBox1.Text = "销售单";
GBox2.Text = "销售单明细";
}
protected override void fzgx()
{
base.fzgx();
parentcol = ds.Tables["销售单"].Columns["销售单号"];
childcol = ds.Tables["销售单明细"].Columns["销售单号"];
}
protected override void qianzi()
{
base.qianzi();
if (publicbl.M身份 == "0")
{
link.UpdateDataBase("Update 销售单 Set 营销员 = '" + publicbl.M姓名 + "'"); }
else
{
link.UpdateDataBase("Update 销售单 Set 领导签字 = '" + publicbl.M姓名 + "'"); } base.DataList();
}
protected override void jsje()
{
base.jsje();
base.jsje(); base.RowNumber1 = dataGridView1.Rows.Count;
base.RowNumber2 = dataGridView2.Rows.Count; this.dataGridView1.CurrentCell = this.dataGridView1[0, 1];
this.dataGridView2.CurrentCell = this.dataGridView2[0, 1];
try
{
for (i = 0; i < RowNumber1 - 1; i++)
{
s = 0.0m;
this.myTable0 = base.ds.Tables[0];
this.myRow0 = myTable0.Rows[i];
M单据号 = (int)myRow0[0]; for (j = 0; j < RowNumber2 - 1; j++)
{
this.myTable1 = base.ds.Tables[1];
this.myRow1 = myTable1.Rows[j];
M单号 = (int)myRow1[1]; M金额 = 0.0m;
if (M单号 == M单据号)
{
M进价 = (decimal)myRow1[4];
M数量 = (int)myRow1[5];
M金额 = M进价 * M数量;
this.dataGridView2.Rows[j].Cells[6].Value = M金额;
}
s = s + M金额;
}
this.dataGridView1.Rows[i].Cells[6].Value = s;
}
base.DataSave();
base.DataList();
}
catch (Exception ex)
{
MessageBox.Show("计算金额失败!原因是 " + ex.Message.ToString(), "请注意!");
}
}
protected override void ckgl()
{
base.ckgl();
if ((publicbl.M权限 == "4") || (publicbl.M权限 == "7"))
{ link.UpdateDataBase("Update 销售单 Set 仓管员 = '" + publicbl.M姓名 + "'");
base.DataList(); if (MessageBox.Show("仓管员签字成功,按确认键办理出库!",
"确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{ base.DataList();
MessageBox.Show("办理成品出库成功,数据表已清空!"); }
catch (Exception ex)
{ MessageBox.Show("办理成品出库手续失败!原因是:" + ex.Message.ToString(), "请注意!");
}
} }
else
{
MessageBox.Show("你无权使用此按钮的操作!");
}
} private void Btn_Save_Click(object sender, EventArgs e)
{
//this.btn_Save.Enabled = true; }
}
}
错误在Frm_合同.Designer.cs这个文件 错误代码如下
我是新手啊不要解释的太深奥了
namespace 生产物流
{
partial class Frm_合同
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.IContainer components = null; /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
/// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
} #region Windows 窗体设计器生成的代码 /// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.SuspendLayout();
//
// Form2
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(292, 269);
this.Name = "Form2";
this.Text = "Form2";
this.Load += new System.EventHandler(this.Form2_Load);
this.ResumeLayout(false); } #endregion
}
}
两个文件的类名称不一样,没有改完全