📄 formjhrk.cs
字号:
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.IO;
using System.Windows.Forms;
namespace _10901BS
{
public partial class formJhrk : Form
{
//常用变量
int pp = 0;
SqlCaoZuo cz = new SqlCaoZuo();
SqlDataReader dr;
SqlDataReader dr1;
SqlDataAdapter rkadp1;
SqlDataAdapter rkadp2;
SqlDataAdapter rkadp3;
SqlCommandBuilder rksqlcb1;
SqlCommandBuilder rksqlcb2;
DataTable rkTable1;
DataTable rkTable2;
DataTable rkTable3;
formSpKcRl fkc;
ArrayList aa11 = new ArrayList();
string spIDstr;
string selectstr;
string str,str1,str2,str3,str4;
string dqrq = DateTime.Now.Date.ToShortDateString();
string year1 = DateTime.Now.Date.Year.ToString();
string month1 = DateTime.Now.Month.ToString().PadLeft(2,'0');
string date1 = DateTime.Now.Day.ToString();
int bianhao = 0, xiugai = 0;
decimal danSum, i = 0.00M;
//formJhrk构造函数
public formJhrk()
{
InitializeComponent();
}
#region 窗体加载事件
//---------------------------------------------^^---------------窗体加载-------------^^----------------------------
//窗体加载事件
private void formJhrk_Load(object sender, EventArgs e)
{
fkc= new formSpKcRl();
str1 = "select distinct jhxqBiao.jhDjID as '进货单据编号',jhxqBiao.spID as '商品编号' ";
str = "from jhxqBiao,";
str += "(select distinct jhDjID ";
str += "from jhxqBiao,djCzBiao ";
str += "where jhDjID=djID and shZt != (0)) as aa ";
str += "where aa.jhDjID=jhxqBiao.jhDjID ";
str += "and jhxqBiao.jhDjID not in ";
str += "(select distinct jhDjID from rkxqBiao where rksl>0) ";
selectstr = str1 + str+"order by 进货单据编号 , 商品编号 ";//查找需要入库的进货单据编号的语句
str2 = "select distinct jhxqBiao.spID ";
str3 = str2 + str;//查找需要入库的进货商品编号的语句
str4 = "select distinct jhxqBiao.jhDjID ";
//888888888888888888888888888888888888888888888888888888888888888888888888888888888888
//lb显示数据
this.tsJhrkGjl.Dock = DockStyle.None;
this.lb_spJhje.Text = i.ToString();
this.lb_Zdrq.Text =dqrq;
this.lb_Zdr.Text = "userName";
this.crystalReportViewer1.Visible = false;
//;;;;;;;;;;;;;;;;;;;;;-----判断是否可以新增-----;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
dr1 = cz.SqlDr(selectstr);
if (dr1.Read() == true) { this.tsb_XinZeng.Enabled = true; }
else { this.tsb_XinZeng.Enabled = false; }
dr1.Close();
//;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
}
#endregion
//-----------------------------------------^^--------------开始编辑-----------^^-----------------------------------------------
//网格中单元格编辑事件
private void dgv_rkDan_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
this.dgv_rkDan.CurrentRow.HeaderCell.Value = Convert.ToString((this.dgv_rkDan.CurrentRow.Index+1));
}
//------------------------------------------^^--------------结束编辑--------------^^-----------------------------------------
//网格中单元格编辑完成后触发的事件
private void dgv_rkDan_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
// 使保存功能可用
this.tsb_Baocun.Enabled = true;
}
//------------------------------------------------^^-----------新增功能-------------^^---------------------------------------
//实现新增功能
private void tsb_XinZeng_Click(object sender, EventArgs e)
{
this.tb_djName.Show();
this.groupBox1.Show();
this.groupBox4.Show();
this.crystalReportViewer1.Visible = false;
xiugai = 0;
//+++++++++++++++++++++++++++++++++++++++++++++++++--入库单号--+++++++++++++++++++++++++++++++++++++++++++++++++++++++
//变量dr为DATAREADER对数据库数据进行比较
//判断入库单据编号
dr = cz.SqlDr("select djID from djczBiao where djID like 'RK" + year1+month1+date1 + "%' ");
if (dr.Read() == true)
{
string s1 = cz.sqlComCell("select max(djID) from djczBiao where djID like'RK" + year1+month1+date1 + "%' and djName like '%入库%' group by djName");
int i = Convert.ToInt16(s1.Substring(10, 4)), j;
j = i+1;
this.lb_Djbh.Text = "RK"+year1+month1+date1+j.ToString().PadLeft(4,'0');
}
else
{
this.lb_Djbh.Text = "RK"+year1+month1+date1+bianhao.ToString().PadLeft(4,'0');
}
dr.Close();
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&--网格数据--&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
//网格进行数据绑定加载适配器
try
{
rkadp1 = new SqlDataAdapter("select jhDjID as '进货单据编号', spID as '商品编号', rkSl as '商品入库数量', rkZje as '商品入库总金额', beiZhu as '备注', shKcSl, rkDjID from rkxqBiao where rkDjID = '" + this.lb_Djbh.Text + "' ", cz.sqlCon());
rkTable1 = new DataTable();
rkadp1.Fill(rkTable1);
rkTable2 = new DataTable();
rkadp2 = new SqlDataAdapter("select jhDjID as '进货单据编号', spID as '商品编号', rkSl as '商品入库数量', rkZje as '商品入库总金额', beiZhu as '备注', shKcSl, rkDjID from rkxqBiao where rkDjID = '" + this.lb_Djbh.Text + "' ", cz.sqlCon());
rkadp2.Fill(rkTable2);
dr1 = cz.SqlDr(selectstr);
if (dr1.Read() == true)
{
//有已入库的进货单的未完全入库的商品信息
rkadp2 = new SqlDataAdapter(selectstr, cz.sqlCon());
rkadp2.Fill(rkTable2);
}
else
{
//未入库的进货单商品信息
rkadp2 = new SqlDataAdapter("select jhxqBiao.jhDjID as '进货单据编号',jhxqBiao.spID as '商品编号' from jhxqBiao,djCzBiao where jhxqBiao.jhDjID=djCzBiao.djID and djCzBiao.shZt != (0)", cz.sqlCon());
rkadp2.Fill(rkTable2);
}
dr1.Close();
}
catch (Exception ex)
{
MessageBox.Show("错误：" + ex, "错误提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
finally
{
if (cz.sqlCon().State == ConnectionState.Open)
{
cz.sqlCon().Close();
cz.sqlCon().Dispose();
}
}
//&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
//其他功能启用
//网格设置---------------------------------
this.dgv_rkDan.Columns.Clear();
this.dgv_rkDan.DataSource = rkTable2;
this.dgv_rkDan.RowHeadersWidth = 50;
this.dgv_rkDan.Columns[0].Width = 100;
this.dgv_rkDan.Columns[0].ReadOnly = true;
this.dgv_rkDan.Columns[1].Width = 80;
this.dgv_rkDan.Columns[1].ReadOnly = true;
this.dgv_rkDan.Columns[2].Width = 100;
this.dgv_rkDan.Columns[3].Width = 100;
this.dgv_rkDan.Columns[4].Width = 172;
this.dgv_rkDan.Columns[5].Visible = false;
this.dgv_rkDan.Columns[6].Visible = false;
this.dgv_rkDan.Enabled = true;
this.dgv_rkDan.Focus().Equals(false);
//-----------------------------------------
this.bt_Tj.Enabled = true;
this.tsb_Dayin.Enabled = true;
this.tsb_XinZeng.Enabled = false;
this.tb_Bz.ReadOnly = false;
//----------------------------------------
foreach (DataGridViewRow row in this.dgv_rkDan.Rows)
{
row.HeaderCell.Value = (row.Index+1).ToString();
}
}
//----------------------------------------^^------------保存功能--------------^^-----------------------------------------
//实现保存功能
private void tsb_Baocun_Click(object sender, EventArgs e)
{
this.tb_djName.Show();
this.groupBox1.Show();
this.groupBox4.Show();
this.crystalReportViewer1.Visible = false;
if (xiugai == 0)
{
//将绑定到网格上的数据加到真正适配的表格中
foreach (DataRow row in rkTable2.Rows)
{
if (row.RowState != DataRowState.Deleted)
{
if (row.IsNull(0) == false && row.IsNull(1) == false && row.IsNull(2) == false)
{
rkTable1.Rows.Add(row.ItemArray[0], row.ItemArray[1], row.ItemArray[2], row.ItemArray[3], row.ItemArray[4], row.ItemArray[5], row.ItemArray[6]);
}
}
}
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--对于djCzBiao--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//变量dr为DATAREADER对数据库数据进行比较
//向单据操作表中添 加数据
dr = cz.SqlDr("select djID from djczBiao where djID like '"+this.lb_Djbh.Text+"' ");
if (dr.Read() != true)
{
string ss = "insert into djCzBiao values ('" + this.lb_Djbh.Text + "','" + this.tb_djName.Text + "','UsID','" + this.lb_Zdrq.Text + "','','','','','" + DateTime.Now.ToShortTimeString() + "','" + this.tb_Bz.Text + "')";
cz.sqlCom(ss);
}
dr.Close();
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//将网格中的操作反射到数据库中
rksqlcb1 = new SqlCommandBuilder(rkadp1);
this.rkadp1.Update(rkTable1);
//-------------------------------
this.dgv_rkDan.DataSource = rkTable1;
this.tsb_Baocun.Enabled = false;
this.tsb_XiuGai.Enabled = true;
this.bt_Tj.Enabled = false;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -