private void FormZYDAWH_CARD_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
dataGridViewDA.DataSource = dt;
dataGridViewDA.AllowUserToDeleteRows = false;
dataGridViewDA.Columns[0].Visible = false;
dataGridViewDA.Columns[11].Visible = false;
dataGridViewDA.Columns[12].Visible = false;
dataGridViewDA.Columns[4].ReadOnly = false;
dataGridViewDA.Columns[5].ReadOnly = false;
switch (iStyle)
{
case 0: //增加
btnAccept.Text = "增加";
dataGridViewDA.AllowUserToAddRows = true;
break;
case 1: //修改
btnAccept.Text = "修改";
dataGridViewDA.AllowUserToAddRows = false;
break;
default:
break;
}
}
private void FormTMCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
sqlConn.Open();
//sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqlComm.CommandText = "SELECT GETDATE()";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
dateTimePickerS.Value = DateTime.Parse(Convert.ToDateTime(sqldr.GetValue(0).ToString()).Year.ToString() + "-" + Convert.ToDateTime(sqldr.GetValue(0).ToString()).Month.ToString() + "-1");
//dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
}
sqlConn.Close();
dTable.Columns.Add("商品编号", System.Type.GetType("System.String"));
dTable.Columns.Add("商品名称", System.Type.GetType("System.String"));
dTable.Columns.Add("条码", System.Type.GetType("System.String"));
dTable.Columns.Add("日期", System.Type.GetType("System.String"));
dTable.Columns.Add("摘要", System.Type.GetType("System.String"));
dTable.Columns.Add("单据编号", System.Type.GetType("System.String"));
//dataGridViewKCTM.DataSource = dTable;
}
private void FormDataBaseReStore_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
}
private void FormWRKCFX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
int i = 1;
DateTime dtTemp = DateTime.Now;
//得到开始时间
Days[0] = dtTemp;
while (true)
{
if (i >= NUMDAYS)
{
break;
}
dtTemp = dtTemp.AddDays(-1);
if ((int)dtTemp.DayOfWeek != 0 || (int)dtTemp.DayOfWeek != 6) //非周末
{
Days[i] = dtTemp;
i++;
}
}
cGetInformation.getSystemDateTime();
strDT0 = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT0).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormJZSJCX_Load(object sender, EventArgs e)
{
this.Left = 1;
this.Top = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
//得到上次结转
sqlConn.Open();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
if (dSet.Tables.Contains("结转汇总表"))
{
dSet.Tables.Remove("结转汇总表");
}
sqlDA.Fill(dSet, "结转汇总表");
comboBoxJZSJ.DataSource = dSet.Tables["结转汇总表"];
comboBoxJZSJ.DisplayMember = "结算时间";
comboBoxJZSJ.ValueMember = "ID";
sqlConn.Close();
cGetInformation.getSystemDateTime();
labelZDRQ.Text = Convert.ToDateTime(cGetInformation.strSYSDATATIME).ToString("yyyy年M月dd日");
}
private void FormKCSPCS_Load(object sender, EventArgs e)
{
int i;
this.Top = 1;
this.Left = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
if (isSaved)
{
//dataGridViewDJMX.CellValidating -= dataGridViewDJMX_CellValidating;
initDJ();
return;
}
sqlConn.Open();
//初始化员工列表
sqlComm.CommandText = "SELECT ID, 职员编号, 职员姓名 FROM 职员表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("职员表"))
{
dSet.Tables.Remove("职员表");
}
sqlDA.Fill(dSet, "职员表");
comboBoxYWY.DataSource = dSet.Tables["职员表"];
comboBoxYWY.DisplayMember = "职员姓名";
comboBoxYWY.ValueMember = "ID";
comboBoxYWY.Text = strUserName;
//初始化部门列表
comboBoxBM.SelectedIndexChanged -= comboBoxBM_SelectedIndexChanged;
sqlComm.CommandText = "SELECT 部门名称 FROM 部门表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("部门表"))
{
dSet.Tables.Remove("部门表");
}
sqlDA.Fill(dSet, "部门表");
//comboBoxBM.DataSource = dSet.Tables["部门表"];
comboBoxBM.Items.Add("全部");
for (i = 0; i < dSet.Tables["部门表"].Rows.Count; i++)
{
comboBoxBM.Items.Add(dSet.Tables["部门表"].Rows[i][0].ToString().Trim());
}
comboBoxBM.SelectedIndexChanged += comboBoxBM_SelectedIndexChanged;
sqlConn.Close();
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormKCSPCX_Load(object sender, EventArgs e)
{
this.Left = 1;
this.Top = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
sqlConn.Open();
sqlComm.CommandText = "SELECT 公司宣传, 质量目标1, 质量目标2, 质量目标3, 质量目标4, 管理员权限, 总经理权限, 职员权限, 经理权限, 业务员权限 FROM 系统参数表";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
try
{
LIMITACCESS = int.Parse(sqldr.GetValue(6).ToString());
}
catch
{
LIMITACCESS = 18;
}
}
sqldr.Close();
sqlConn.Close();
}
private void FormKFSPJCZ_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//得到上次结转
sqlConn.Open();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
sqldr = sqlComm.ExecuteReader();
if (sqldr.HasRows)
{
sqldr.Read();
iJZID = Convert.ToInt32(sqldr.GetValue(1).ToString());
}
sqldr.Close();
sqlConn.Close();
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormGJZPCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//得到开始时间
sqlConn.Open();
sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
}
sqldr.Close();
sqlConn.Close();
cGetInformation.getSystemDateTime();
string sDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(sDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormKHGXFX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//得到开始时间
sqlConn.Open();
//sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqlComm.CommandText = "SELECT GETDATE()";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
//dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
dateTimePickerS.Value = DateTime.Parse(Convert.ToDateTime(sqldr.GetValue(0).ToString()).Year.ToString() + "-" + Convert.ToDateTime(sqldr.GetValue(0).ToString()).Month.ToString() + "-1");
}
sqldr.Close();
sqlConn.Close();
cGetInformation.getSystemDateTime();
string sDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(sDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
tabControl1.SelectedIndex = 2;
tabControl1.SelectedIndexChanged += tabControl1_SelectedIndexChanged;
}
private void FormYWSJJZ_Load(object sender, EventArgs e)
{
int i;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//if (isSaved)
//{
// initDJ();
// return;
//}
//得到上次结转时间
sqlConn.Open();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
sqldr = sqlComm.ExecuteReader();
if (sqldr.HasRows)
{
sqldr.Read();
sSCJZSJ = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
iJZID = Convert.ToInt32(sqldr.GetValue(1).ToString());
}
sqldr.Close();
if (sSCJZSJ == "") //没有结算
{
sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
sSCJZSJ = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
}
iJZID = 0;
sqldr.Close();
}
labelSCJZRQ.Text = Convert.ToDateTime(sSCJZSJ).ToString("yyyy年M月dd日");
sqlConn.Close();
//initHTDefault();
cGetInformation.getSystemDateTime();
//sBCJZSJ = cGetInformation.strSYSDATATIME;
sBCJZSJ = Convert.ToDateTime(cGetInformation.strSYSDATATIME).AddDays(-1).ToShortDateString();
labelBCJZRQ.Text = Convert.ToDateTime(sBCJZSJ).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
initdataGridViewJXCHZ();
//initdataGridViewCBLRB();
initdataGridViewKF();
initdataGridViewKFHZ();
dataGridViewKF_Click(null, null);
initdataGridViewGJWLHZ();
}
private void FormZBDAWH_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
initDataView();
}
private void FormSCDWCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
toolStripButtonGD_Click(null, null);
}
private void FormSPZJC_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//得到上次结转
sqlConn.Open();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
sqldr = sqlComm.ExecuteReader();
if (sqldr.HasRows)
{
sqldr.Read();
iJZID = Convert.ToInt32(sqldr.GetValue(1).ToString());
}
sqldr.Close();
sqlComm.CommandText = "SELECT 商品表.分类编号, 商品表.商品名称, 商品表.商品编号, 商品表.商品规格, 商品表.库存数量, 商品表.库存成本价, 商品表.库存数量*商品表.库存成本价 AS 库存金额, 结转进销存汇总表1.结转数量, 结转进销存汇总表1.结转单价, 结转进销存汇总表1.结转数量*结转进销存汇总表1.结转单价 AS 结转金额 FROM 商品表 LEFT OUTER JOIN (SELECT * FROM 结转进销存汇总表 WHERE (结转ID = " + iJZID.ToString() + ")) 结转进销存汇总表1 ON 商品表.ID = 结转进销存汇总表1.商品ID WHERE (商品表.beactive = 1) ";
if (dSet.Tables.Contains("商品表"))
{
dSet.Tables.Remove("商品表");
}
sqlDA.Fill(dSet, "商品表");
dataGridViewDJMX.DataSource = dSet.Tables["商品表"];
for (int i = 0; i < dSet.Tables["商品表"].Rows.Count; i++)
{
for (int j = 4; j < dSet.Tables["商品表"].Columns.Count; j++)
{
if (dSet.Tables["商品表"].Rows[i][j].ToString() == "")
{
dSet.Tables["商品表"].Rows[i][j] = 0;
}
}
}
sqlConn.Close();
toolStripButtonGD_Click(null, null);
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormWLDWYEDJ_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
initDataView();
}
private void FormSPZHCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
//得到上次结转
//得到开始时间
sqlConn.Open();
//sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqlComm.CommandText = "SELECT GETDATE()";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
//dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
dateTimePickerS.Value = DateTime.Parse(Convert.ToDateTime(sqldr.GetValue(0).ToString()).Year.ToString() + "-" + Convert.ToDateTime(sqldr.GetValue(0).ToString()).Month.ToString() + "-1");
}
sqldr.Close();
sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
SDTS0 = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
}
sqldr.Close();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
sqldr = sqlComm.ExecuteReader();
if (sqldr.HasRows)
{
sqldr.Read();
iJZID = Convert.ToInt32(sqldr.GetValue(1).ToString());
SDTS1 = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
}
if (iJZID == 0)
{
SDTS1 = SDTS0;
}
sqlConn.Close();
}
private void FormTMHTCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
comboBoxLX.Items.Add("购进");
comboBoxLX.Items.Add("销售");
//comboBoxLX.Items.Add("借物");
comboBoxLX.Text = "购进";
}
private void FormRZCX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
//得到开始时间
sqlConn.Open();
//sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqlComm.CommandText = "SELECT GETDATE()";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
//dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
dateTimePickerS.Value = DateTime.Parse(Convert.ToDateTime(sqldr.GetValue(0).ToString()).Year.ToString() + "-" + Convert.ToDateTime(sqldr.GetValue(0).ToString()).Month.ToString() + "-1");
}
sqldr.Close();
sqlConn.Close();
//初始化员工列表
sqlComm.CommandText = "SELECT ID, 职员编号, 职员姓名 FROM 职员表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("职员表"))
{
dSet.Tables.Remove("职员表");
}
sqlDA.Fill(dSet, "职员表");
object[] OTemp = new object[3];
OTemp[0] = 0;
OTemp[1] = "全部";
OTemp[2] = "全部";
dSet.Tables["职员表"].Rows.Add(OTemp);
comboBoxCZY.DataSource = dSet.Tables["职员表"];
comboBoxCZY.DisplayMember = "职员姓名";
comboBoxCZY.ValueMember = "ID";
comboBoxCZY.SelectedIndex = comboBoxCZY.Items.Count - 1;
sqlConn.Close();
cGetInformation.getSystemDateTime();
string sDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(sDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormWRXSFX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
cGetInformation.getSystemDateTime();
strDT0 = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT0).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormSPKCYZFX_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
string strTTemp = "";
//得到开始时间
sqlConn.Open();
//sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqlComm.CommandText = "SELECT GETDATE()";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
//dateTimePickerS.Value = Convert.ToDateTime(sqldr.GetValue(0).ToString());
//dateTimePickerS.Value = DateTime.Parse(Convert.ToDateTime(sqldr.GetValue(0).ToString()).Year.ToString() + "-" + Convert.ToDateTime(sqldr.GetValue(0).ToString()).Month.ToString() + "-1");
dateTimePickerS.Value = DateTime.Parse(sqldr.GetValue(0).ToString()).AddDays(-30);
}
sqldr.Close();
sqlConn.Close();
cGetInformation.getSystemDateTime();
strDT0 = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT0).ToString("yyyy年M月dd日");
strDT0 = dateTimePickerE.Value.ToShortDateString();
strTTemp = dateTimePickerS.Value.ToShortDateString();
strDT1 = Convert.ToDateTime(strDT0).AddDays(-5).ToShortDateString();
if (Convert.ToDateTime(strDT1) < Convert.ToDateTime(strTTemp))
{
strDT1 = strTTemp;
}
strDT2 = Convert.ToDateTime(strDT0).AddDays(-10).ToShortDateString();
if (Convert.ToDateTime(strDT2) < Convert.ToDateTime(strTTemp))
{
strDT2 = strTTemp;
}
strDT3 = Convert.ToDateTime(strDT0).AddDays(-30).ToShortDateString();
if (Convert.ToDateTime(strDT3) < Convert.ToDateTime(strTTemp))
{
strDT3 = strTTemp;
}
labelCZY.Text = strUserName;
}
private void FormDWDAWH_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
sqlConn.Open();
//初始化地区
sqlComm.CommandText = "SELECT 地区 FROM 地区表 ORDER BY 地区";
if (dSet.Tables.Contains("地区名称"))
{
dSet.Tables.Remove("地区名称");
}
sqlDA.Fill(dSet, "地区名称");
comboBoxDQ.DataSource = dSet.Tables["地区名称"];
comboBoxDQ.DisplayMember = "地区";
sqlComm.CommandText = "SELECT ID, 单位编号, 单位名称, 助记码, 是否进货, 是否销售, 税号, 电话, 开户银行, 银行账号, 联系人, 地址, 地区名称, 行业名称, 传真, 邮编, 备注, 登录日期, 联系地址, 收货人, 业务员, 到站名称, 部门ID, 开票电话, 收货电话 FROM 单位表 WHERE (BeActive = 1) ORDER BY 单位编号";
if (dSet.Tables.Contains("单位表"))
{
dSet.Tables["单位表"].Clear();
}
sqlDA.Fill(dSet, "单位表");
sqlComm.CommandText = "SELECT ID, 单位编号, 单位名称, 助记码, 是否进货, 是否销售, 税号, 电话, 开户银行, 银行账号, 联系人, 地址, 地区名称, 行业名称, 传真, 邮编, 备注, 登录日期, 联系地址, 收货人, 业务员, 到站名称, 部门ID, 开票电话, 收货电话 FROM 单位表 WHERE (ID = 0) ORDER BY 单位编号";
if (dSet.Tables.Contains("单位表1"))
{
dSet.Tables.Remove("单位表1");
}
sqlDA.Fill(dSet, "单位表1");
dvSelect = new DataView(dSet.Tables["单位表"]);
dataGridViewDJMX.DataSource = dvSelect;
dataGridViewDJMX.Columns[0].Visible = false;
dataGridViewDJMX.Columns[22].Visible = false;
setSTAUS();
sqlConn.Close();
//initDataView();
}
private void FormDQSPCRKHZCX_Load(object sender, EventArgs e)
{
this.Top = 1;
this.Left = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
intCommID = 0;
textBoxSPMC.Text = "";
textBoxSPBH.Text = "";
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
//得到上次结转
//得到开始时间
sqlConn.Open();
sqlComm.CommandText = "SELECT 开始时间 FROM 系统参数表";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
SDTS0 = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
}
sqldr.Close();
sqlComm.CommandText = "SELECT 结算时间,ID FROM 结转汇总表 ORDER BY 结算时间 DESC";
sqldr = sqlComm.ExecuteReader();
if (sqldr.HasRows)
{
sqldr.Read();
iJZID = Convert.ToInt32(sqldr.GetValue(1).ToString());
SDTS1 = Convert.ToDateTime(sqldr.GetValue(0).ToString()).ToShortDateString();
}
if (iJZID == 0)
{
SDTS1 = SDTS0;
}
sqlConn.Close();
}
private void FormXFSPZL_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
toolStripComboBoxLB.SelectedIndex = 0;
toolStripButtonGD_Click(null, null);
}
private void FormFPZF_Load(object sender, EventArgs e)
{
int i;
this.Top = 1;
this.Left = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
comboBoxStyle.SelectedIndex = 0;
}
private void FormYJXSCX_Load(object sender, EventArgs e)
{
this.Left = 1;
this.Top = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
numericUpDownND.Value = Convert.ToDateTime(strDT).Year;
numericUpDownQSYF.Maximum = decimal.Parse(Convert.ToDateTime(strDT).Month.ToString());
}
private void FormBMZLCX_Load(object sender, EventArgs e)
{
int i;
this.Left = 1;
this.Top = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
sqlConn.Open();
//初始化部门列表
sqlComm.CommandText = "SELECT ID, 部门名称 FROM 部门表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("部门表"))
{
dSet.Tables.Remove("部门表");
}
sqlDA.Fill(dSet, "部门表");
comboBoxBM.DataSource = dSet.Tables["部门表"];
comboBoxBM.DisplayMember = "部门名称";
comboBoxBM.ValueMember = "ID";
comboBoxBM.SelectedIndex = 0;
sqlConn.Close();
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormSelectGD_Load(object sender, EventArgs e)
{
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
dvSelect = new DataView(dtSelect);
dataGridViewLB.DataSource = dvSelect;
switch (iSelectStyle)
{
case 1: //按单据勾兑
dataGridViewLB.Columns[7].Visible = false;
dataGridViewLB.Columns[8].Visible = false;
dataGridViewLB.Columns[1].ReadOnly = true;
dataGridViewLB.Columns[2].ReadOnly = true;
dataGridViewLB.Columns[3].ReadOnly = true;
dataGridViewLB.Columns[4].ReadOnly = true;
dataGridViewLB.Columns[6].ReadOnly = true;
dataGridViewLB.Columns[9].ReadOnly = true;
dataGridViewLB.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.ShowCellErrors = true;
textBoxLB.Enabled = false;
textBoxMC.Enabled = false;
this.Text = "按单据勾兑";
break;
case 2: //按明细勾兑
dataGridViewLB.Columns[11].Visible = false;
dataGridViewLB.Columns[12].Visible = false;
dataGridViewLB.Columns[13].Visible = false;
dataGridViewLB.Columns[14].Visible = false;
dataGridViewLB.Columns[15].Visible = false;
dataGridViewLB.Columns[16].Visible = false;
dataGridViewLB.Columns[1].ReadOnly = true;
dataGridViewLB.Columns[2].ReadOnly = true;
dataGridViewLB.Columns[3].ReadOnly = true;
dataGridViewLB.Columns[4].ReadOnly = true;
dataGridViewLB.Columns[6].ReadOnly = true;
dataGridViewLB.Columns[7].ReadOnly = true;
dataGridViewLB.Columns[8].ReadOnly = true;
dataGridViewLB.Columns[10].ReadOnly = true;
dataGridViewLB.Columns[17].ReadOnly = true;
dataGridViewLB.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[10].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[17].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.ShowCellErrors = true;
this.Text = "按进货明细勾兑";
break;
case 3: //按明细数量勾兑
dataGridViewLB.Columns[14].Visible = false;
dataGridViewLB.Columns[15].Visible = false;
dataGridViewLB.Columns[16].Visible = false;
dataGridViewLB.Columns[17].Visible = false;
dataGridViewLB.Columns[18].Visible = false;
dataGridViewLB.Columns[19].Visible = false;
dataGridViewLB.Columns[1].ReadOnly = true;
dataGridViewLB.Columns[2].ReadOnly = true;
dataGridViewLB.Columns[3].ReadOnly = true;
dataGridViewLB.Columns[4].ReadOnly = true;
dataGridViewLB.Columns[6].ReadOnly = true;
dataGridViewLB.Columns[7].ReadOnly = true;
dataGridViewLB.Columns[9].ReadOnly = true;
dataGridViewLB.Columns[10].ReadOnly = true;
dataGridViewLB.Columns[11].ReadOnly = true;
dataGridViewLB.Columns[12].ReadOnly = true;
dataGridViewLB.Columns[13].ReadOnly = true;
dataGridViewLB.Columns[20].ReadOnly = true;
dataGridViewLB.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[10].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[11].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[12].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[13].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.Columns[20].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewLB.ShowCellErrors = true;
this.Text = "按进货明细数量勾兑";
break;
default:
this.Dispose();
return;
}
}
private void FormKCSPPD2_Load(object sender, EventArgs e)
{
int i;
this.Top = 1;
this.Left = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
if (isSaved)
{
//dataGridViewDJMX.CellValidating -= dataGridViewDJMX_CellValidating;
initDJ();
return;
}
sqlConn.Open();
//初始化员工列表
sqlComm.CommandText = "SELECT ID, 职员编号, 职员姓名 FROM 职员表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("职员表"))
{
dSet.Tables.Remove("职员表");
}
sqlDA.Fill(dSet, "职员表");
comboBoxYWY.DataSource = dSet.Tables["职员表"];
comboBoxYWY.DisplayMember = "职员姓名";
comboBoxYWY.ValueMember = "ID";
comboBoxYWY.Text = strUserName;
//初始化部门列表
sqlComm.CommandText = "SELECT 部门名称 FROM 部门表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("部门表"))
{
dSet.Tables.Remove("部门表");
}
sqlDA.Fill(dSet, "部门表");
//comboBoxBM.DataSource = dSet.Tables["部门表"];
comboBoxBM.Items.Add("全部");
for (i = 0; i < dSet.Tables["部门表"].Rows.Count; i++)
{
comboBoxBM.Items.Add(dSet.Tables["部门表"].Rows[i][0].ToString().Trim());
}
//明细
sqlComm.CommandText = "SELECT 库存盘点定义表.记录选择, 商品表.商品编号, 商品表.商品名称, 商品表.商品规格, 库存盘点明细表.实盘数量, 库存盘点明细表.结存数量, 库存盘点明细表.结存金额, 库存盘点定义表.盘损数量, 库存盘点定义表.盘损金额, 库存盘点明细表.备注, 库存盘点明细表.ID, 库存盘点明细表.商品ID FROM 库存盘点明细表 INNER JOIN 商品表 ON 库存盘点明细表.商品ID = 商品表.ID CROSS JOIN 库存盘点定义表 WHERE (库存盘点明细表.单据ID = 0)";
if (dSet.Tables.Contains("单据表"))
{
dSet.Tables.Remove("单据表");
}
sqlDA.Fill(dSet, "单据表");
dataGridViewDJMX.DataSource = dSet.Tables["单据表"];
dataGridViewDJMX.Columns[6].Visible = false;
dataGridViewDJMX.Columns[8].Visible = false;
dataGridViewDJMX.Columns[10].Visible = false;
dataGridViewDJMX.Columns[11].Visible = false;
dataGridViewDJMX.Columns[1].ReadOnly = true;
dataGridViewDJMX.Columns[2].ReadOnly = true;
dataGridViewDJMX.Columns[3].ReadOnly = true;
dataGridViewDJMX.Columns[5].ReadOnly = true;
dataGridViewDJMX.Columns[6].ReadOnly = true;
dataGridViewDJMX.Columns[7].ReadOnly = true;
dataGridViewDJMX.Columns[8].ReadOnly = true;
dataGridViewDJMX.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
sqlConn.Close();
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormTJTZD1_Load(object sender, EventArgs e)
{
int i;
this.Left = 1;
this.Top = 1;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
if (isSaved)
{
dataGridViewDJMX.CellValidating -= dataGridViewDJMX_CellValidating;
initDJ();
return;
}
sqlConn.Open();
//初始化员工列表
sqlComm.CommandText = "SELECT ID, 职员编号, 职员姓名 FROM 职员表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("职员表"))
{
dSet.Tables.Remove("职员表");
}
sqlDA.Fill(dSet, "职员表");
comboBoxYWY.DataSource = dSet.Tables["职员表"];
comboBoxYWY.DisplayMember = "职员姓名";
comboBoxYWY.ValueMember = "ID";
comboBoxYWY.Text = strUserName;
//初始化部门列表
comboBoxBM.SelectedIndexChanged -= comboBoxBM_SelectedIndexChanged;
sqlComm.CommandText = "SELECT 部门名称 FROM 部门表 WHERE (beactive = 1)";
if (dSet.Tables.Contains("部门表"))
{
dSet.Tables.Remove("部门表");
}
sqlDA.Fill(dSet, "部门表");
//comboBoxBM.DataSource = dSet.Tables["部门表"];
comboBoxBM.Items.Add("全部");
for (i = 0; i < dSet.Tables["部门表"].Rows.Count; i++)
{
comboBoxBM.Items.Add(dSet.Tables["部门表"].Rows[i][0].ToString().Trim());
}
comboBoxBM.SelectedIndexChanged += comboBoxBM_SelectedIndexChanged;
//初始化商品列表
sqlComm.CommandText = "SELECT 调价通知单明细表.ID, 商品表.商品名称, 商品表.商品编号, 商品表.商品规格, 商品表.最小计量单位 AS 单位, 调价通知单明细表.原进价, 调价通知单明细表.进价, 调价通知单明细表.原批发价, 调价通知单明细表.批发价, 调价通知单明细表.商品ID FROM 调价通知单明细表 INNER JOIN 商品表 ON 调价通知单明细表.商品ID = 商品表.ID WHERE (调价通知单明细表.ID = 0)";
if (dSet.Tables.Contains("商品表"))
{
dSet.Tables.Remove("商品表");
}
sqlDA.Fill(dSet, "商品表");
dataGridViewDJMX.DataSource = dSet.Tables["商品表"];
dataGridViewDJMX.Columns[0].Visible = false;
dataGridViewDJMX.Columns[9].Visible = false;
dataGridViewDJMX.Columns[3].ReadOnly = true;
dataGridViewDJMX.Columns[4].ReadOnly = true;
dataGridViewDJMX.Columns[5].ReadOnly = true;
dataGridViewDJMX.Columns[7].ReadOnly = true;
dataGridViewDJMX.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.ShowCellErrors = true;
sqlConn.Close();
//initHTDefault();
string strDT;
cGetInformation.getSystemDateTime();
strDT = cGetInformation.strSYSDATATIME;
labelZDRQ.Text = Convert.ToDateTime(strDT).ToString("yyyy年M月dd日");
labelCZY.Text = strUserName;
}
private void FormJHRKYHD_EDIT_Load(object sender, EventArgs e)
{
int i;
sqlConn.ConnectionString = strConn;
sqlComm.Connection = sqlConn;
sqlDA.SelectCommand = sqlComm;
cGetInformation = new ClassGetInformation(strConn);
this.Top = 1;
this.Left = 1;
if (intDJID == 0)
{
return;
}
this.Text += ":单据冲红";
sqlConn.Open();
sqlComm.CommandText = "SELECT 进货入库汇总表.单据编号, 进货入库汇总表.日期, [职员表_1].职员姓名 AS 操作员, 职员表.职员姓名 AS 业务员, 单位表.单位编号, 单位表.单位名称, 进货入库汇总表.发票号, 进货入库汇总表.支票号, 进货入库汇总表.合同号, 进货入库汇总表.价税合计, 进货入库汇总表.备注, 单位表.ID,进货入库汇总表.业务员ID, 进货入库汇总表.部门ID FROM 进货入库汇总表 INNER JOIN 职员表 ON 进货入库汇总表.业务员ID = 职员表.ID INNER JOIN 职员表 [职员表_1] ON 进货入库汇总表.操作员ID = [职员表_1].ID INNER JOIN 单位表 ON 进货入库汇总表.单位ID = 单位表.ID WHERE (进货入库汇总表.ID = " + intDJID.ToString() + ") AND (进货入库汇总表.BeActive<>0)";
sqldr = sqlComm.ExecuteReader();
if (!sqldr.HasRows)
{
isSaved = true;
sqldr.Close();
sqlConn.Close();
return;
}
while (sqldr.Read())
{
if (sqldr.GetValue(13).ToString() != "")
{
try
{
iBM = int.Parse(sqldr.GetValue(13).ToString());
}
catch
{
iBM = 0;
}
}
labelZDRQ.Text = Convert.ToDateTime(sqldr.GetValue(1).ToString()).ToString("yyyy年M月dd日");
labelDJBH.Text = sqldr.GetValue(0).ToString();
labelCZY.Text = sqldr.GetValue(2).ToString();
comboBoxYWY.Text = sqldr.GetValue(3).ToString();
textBoxDWBH.Text = sqldr.GetValue(4).ToString();
textBoxDWMC.Text = sqldr.GetValue(5).ToString();
textBoxFPH.Text = sqldr.GetValue(6).ToString();
textBoxZPH.Text = sqldr.GetValue(7).ToString();
textBoxHTH.Text = sqldr.GetValue(8).ToString();
textBoxBZ.Text = sqldr.GetValue(10).ToString();
iSupplyCompany = Convert.ToInt32(sqldr.GetValue(11).ToString());
iYWY = Convert.ToInt32(sqldr.GetValue(12).ToString());
}
sqldr.Close();
if (iBM != 0)
{
sqlComm.CommandText = "SELECT 部门名称 FROM 部门表 WHERE (ID = " + iBM.ToString() + ")";
sqldr = sqlComm.ExecuteReader();
while (sqldr.Read())
{
comboBoxBM.Items.Add(sqldr.GetValue(0).ToString());
comboBoxBM.Text = sqldr.GetValue(0).ToString();
break;
}
sqldr.Close();
}
sqlComm.CommandText = "SELECT 购进商品制单明细定义表.到货, 进货入库汇总表.单据编号, 商品表.商品编号, 商品表.商品名称, 商品表.商品规格, 商品表.最小计量单位 AS 单位, 库房表.库房编号, 库房表.库房名称, 进货入库明细表.数量, 进货入库明细表.单价, 进货入库明细表.金额, 进货入库明细表.扣率, 进货入库明细表.实计金额, 商品表.库存数量, 进货入库明细表.商品ID, 进货入库明细表.库房ID, 进货入库明细表.ID, 进货入库明细表.赠品, 进货入库汇总表.ID AS Expr1, 进货入库明细表.原单据明细ID, 进货入库明细表.原单据ID FROM 进货入库明细表 INNER JOIN 商品表 ON 进货入库明细表.商品ID = 商品表.ID INNER JOIN 库房表 ON 进货入库明细表.库房ID = 库房表.ID INNER JOIN 进货入库汇总表 ON 进货入库明细表.单据ID = 进货入库汇总表.ID CROSS JOIN 购进商品制单明细定义表 WHERE (进货入库明细表.单据ID = " + intDJID.ToString() + ")";
if (dSet.Tables.Contains("单据表"))
{
dSet.Tables.Remove("单据表");
}
sqlDA.Fill(dSet, "单据表");
dataGridViewDJMX.DataSource = dSet.Tables["单据表"];
sqlConn.Close();
dataGridViewDJMX.Columns[0].Visible = false;
dataGridViewDJMX.Columns[8].Visible = false;
dataGridViewDJMX.Columns[13].Visible = false;
dataGridViewDJMX.Columns[14].Visible = false;
dataGridViewDJMX.Columns[15].Visible = false;
dataGridViewDJMX.Columns[16].Visible = false;
dataGridViewDJMX.Columns[18].Visible = false;
dataGridViewDJMX.Columns[19].Visible = false;
dataGridViewDJMX.Columns[20].Visible = false;
dataGridViewDJMX.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[10].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[11].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[12].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[13].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewDJMX.Columns[17].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
countAmount();
}
