基本信息
源码名称：手机扫码实现鼎捷ERP工序转移,出入库,盘点等
源码大小：6.80M
文件格式：.rar
开发语言：C#
更新时间：2026-01-16
友情提示：（无需注册或充值，赞助后即可获取资源下载链接）
嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559
本次赞助数额为： 10 元×
微信扫码支付：10 元
×
请留下您的邮箱，我们将在2小时内将文件发到您的邮箱
源码介绍
手机扫码实现鼎捷工序转移，入库，库存盘点
SqlConnection conn2 = BaseClass.DBCon();
conn2.Open();
SqlCommand cmd = new SqlCommand("select YCDDM,YRDDM from MZCZZY a1 WHERE a1.LB=(select MIN(a2.LB) from MZCZZY a2 ) ", conn2);
SqlCommand cmd6 = new SqlCommand("select * from MZCZZY WHERE GDDB='" textBox1.Text.ToString() "' AND GDDH='" textBox2.Text.ToString() "' AND PH='" textBox15.Text.ToString() "' ", conn2);
int i = Convert.ToInt32(cmd.ExecuteScalar());
int i1 = Convert.ToInt32(cmd6.ExecuteScalar());
if (i > 0)
{
SqlDataReader sdr1 = cmd.ExecuteReader();
sdr1.Read();
textBox3.Text = sdr1["YCDDM"].ToString().Trim();
textBox4.Text = sdr1["YRDDM"].ToString().Trim();
conn2.Close();
cmd.Dispose();
cmd = null;
conn2.Dispose();
}
string strSQL = "";
if (i == 0)
{
if (textBox1.Text.Trim() != "" && textBox5.Text.Trim() != "" && textBox9.Text.Trim() != "" && textBox10.Text.Trim() != "" && textBox19.Text.Trim() != "" && textBox18.Text.Trim() != "")
{
SqlConnection conn = BaseClass.DBCon();
conn.Open();
strSQL = "INSERT INTO MZCZZY VALUES ('" textBox1.Text.ToString().Trim() "','" textBox2.Text.ToString().Trim() "','" textBox5.Text.ToString().Trim() "','" textBox6.Text.ToString().Trim() "','" textBox7.Text.ToString().Trim() "','" textBox8.Text.ToString().Trim() "','" textBox9.Text.ToString().Trim() "','" textBox10.Text.ToString().Trim() "','" textBox11.Text.ToString().Trim() "','" textBox12.Text.ToString().Trim() "','" textBox13.Text.ToString().Trim() "','" textBox14.Text.ToString().Trim() "','" textBox15.Text.ToString().Trim() "','" textBox16.Text.ToString().Trim() "','" textBox17.Text.ToString().Trim() "','" textBox19.Text.ToString().Trim() "','" textBox20.Text.ToString().Trim() "','" textBox21.Text.ToString().Trim() "','" textBox18.Text.ToString().Trim() "','" textBox26.Text.ToString().Trim() "','" textBox24.Text.ToString().Trim() "','" textBox25.Text.ToString().Trim() "','" textBox27.Text.ToString().Trim() "','" textBox28.Text.ToString().Trim() "','" textBox29.Text.ToString().Trim() "','" textBox30.Text.ToString().Trim() "' )";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
conn.Dispose();
da.Dispose();
ds.Dispose();
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
Toast("数据已保存1！！");
return;
}
else
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据不全或单据已扫，不能保存，请确保信息准确！！！");
}
}
else if (i > 0 && textBox3.Text.Trim() == textBox5.Text.Trim() && textBox4.Text.Trim() == textBox7.Text.Trim() && i1 ==0 )
{
if (textBox1.Text.Trim() != "" && textBox5.Text.Trim() != "" && textBox9.Text.Trim() != "" && textBox10.Text.Trim() != "" && textBox19.Text.Trim() != "" && textBox18.Text.Trim() != "" && textBox5.Text.Trim() == textBox3.Text.Trim() && textBox7.Text.Trim() == textBox4.Text.Trim())
{
SqlConnection conn = BaseClass.DBCon();
conn.Open();
strSQL = "INSERT INTO MZCZZY VALUES ('" textBox1.Text.ToString().Trim() "','" textBox2.Text.ToString().Trim() "','" textBox5.Text.ToString().Trim() "','" textBox6.Text.ToString().Trim() "','" textBox7.Text.ToString().Trim() "','" textBox8.Text.ToString().Trim() "','" textBox9.Text.ToString().Trim() "','" textBox10.Text.ToString().Trim() "','" textBox11.Text.ToString().Trim() "','" textBox12.Text.ToString().Trim() "','" textBox13.Text.ToString().Trim() "','" textBox14.Text.ToString().Trim() "','" textBox15.Text.ToString().Trim() "','" textBox16.Text.ToString().Trim() "','" textBox17.Text.ToString().Trim() "','" textBox19.Text.ToString().Trim() "','" textBox20.Text.ToString().Trim() "','" textBox21.Text.ToString().Trim() "','" textBox18.Text.ToString().Trim() "','" textBox26.Text.ToString().Trim() "','" textBox24.Text.ToString().Trim() "','" textBox25.Text.ToString().Trim() "','" textBox27.Text.ToString().Trim() "','" textBox28.Text.ToString().Trim() "','" textBox29.Text.ToString().Trim() "','" textBox30.Text.ToString().Trim() "' )";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
conn.Dispose();
da.Dispose();
ds.Dispose();
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
Toast("数据已保存！！");
return;
}
else
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
// textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据不全，不能保存，请确保信息准确！！");
}
}
else if (i > 0 && (textBox3.Text.Trim() != textBox5.Text.Trim() || textBox4.Text.Trim() != textBox7.Text.Trim()))
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("移出（入）地不同，不能保存！！！");
}
else if (i > 0 && textBox3.Text.Trim() == textBox5.Text.Trim() && textBox4.Text.Trim() == textBox7.Text.Trim() && i1 > 0)
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据已扫，不能保存！！！");
}
SqlConnection conn1 = BaseClass.DBCon();
conn1.Open();
string SQL1 = " select * from MZCZZY ";
SqlDataAdapter sda = new SqlDataAdapter(SQL1, conn1);
DataSet ds1 = new DataSet();
sda.Fill(ds1, "AA11");
tableView1.DataSource = ds1.Tables["AA11"];
tableView1.DataBind();
conn1.Close();
conn1.Dispose();
sda.Dispose();
ds1.Dispose();
手机扫码实现鼎捷工序转移，入库，库存盘点
SqlConnection conn2 = BaseClass.DBCon();
conn2.Open();
SqlCommand cmd = new SqlCommand("select YCDDM,YRDDM from MZCZZY a1 WHERE a1.LB=(select MIN(a2.LB) from MZCZZY a2 ) ", conn2);
SqlCommand cmd6 = new SqlCommand("select * from MZCZZY WHERE GDDB='" textBox1.Text.ToString() "' AND GDDH='" textBox2.Text.ToString() "' AND PH='" textBox15.Text.ToString() "' ", conn2);
int i = Convert.ToInt32(cmd.ExecuteScalar());
int i1 = Convert.ToInt32(cmd6.ExecuteScalar());
if (i > 0)
{
SqlDataReader sdr1 = cmd.ExecuteReader();
sdr1.Read();
textBox3.Text = sdr1["YCDDM"].ToString().Trim();
textBox4.Text = sdr1["YRDDM"].ToString().Trim();
conn2.Close();
cmd.Dispose();
cmd = null;
conn2.Dispose();
}
string strSQL = "";
if (i == 0)
{
if (textBox1.Text.Trim() != "" && textBox5.Text.Trim() != "" && textBox9.Text.Trim() != "" && textBox10.Text.Trim() != "" && textBox19.Text.Trim() != "" && textBox18.Text.Trim() != "")
{
SqlConnection conn = BaseClass.DBCon();
conn.Open();
strSQL = "INSERT INTO MZCZZY VALUES ('" textBox1.Text.ToString().Trim() "','" textBox2.Text.ToString().Trim() "','" textBox5.Text.ToString().Trim() "','" textBox6.Text.ToString().Trim() "','" textBox7.Text.ToString().Trim() "','" textBox8.Text.ToString().Trim() "','" textBox9.Text.ToString().Trim() "','" textBox10.Text.ToString().Trim() "','" textBox11.Text.ToString().Trim() "','" textBox12.Text.ToString().Trim() "','" textBox13.Text.ToString().Trim() "','" textBox14.Text.ToString().Trim() "','" textBox15.Text.ToString().Trim() "','" textBox16.Text.ToString().Trim() "','" textBox17.Text.ToString().Trim() "','" textBox19.Text.ToString().Trim() "','" textBox20.Text.ToString().Trim() "','" textBox21.Text.ToString().Trim() "','" textBox18.Text.ToString().Trim() "','" textBox26.Text.ToString().Trim() "','" textBox24.Text.ToString().Trim() "','" textBox25.Text.ToString().Trim() "','" textBox27.Text.ToString().Trim() "','" textBox28.Text.ToString().Trim() "','" textBox29.Text.ToString().Trim() "','" textBox30.Text.ToString().Trim() "' )";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
conn.Dispose();
da.Dispose();
ds.Dispose();
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
Toast("数据已保存1！！");
return;
}
else
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据不全或单据已扫，不能保存，请确保信息准确！！！");
}
}
else if (i > 0 && textBox3.Text.Trim() == textBox5.Text.Trim() && textBox4.Text.Trim() == textBox7.Text.Trim() && i1 ==0 )
{
if (textBox1.Text.Trim() != "" && textBox5.Text.Trim() != "" && textBox9.Text.Trim() != "" && textBox10.Text.Trim() != "" && textBox19.Text.Trim() != "" && textBox18.Text.Trim() != "" && textBox5.Text.Trim() == textBox3.Text.Trim() && textBox7.Text.Trim() == textBox4.Text.Trim())
{
SqlConnection conn = BaseClass.DBCon();
conn.Open();
strSQL = "INSERT INTO MZCZZY VALUES ('" textBox1.Text.ToString().Trim() "','" textBox2.Text.ToString().Trim() "','" textBox5.Text.ToString().Trim() "','" textBox6.Text.ToString().Trim() "','" textBox7.Text.ToString().Trim() "','" textBox8.Text.ToString().Trim() "','" textBox9.Text.ToString().Trim() "','" textBox10.Text.ToString().Trim() "','" textBox11.Text.ToString().Trim() "','" textBox12.Text.ToString().Trim() "','" textBox13.Text.ToString().Trim() "','" textBox14.Text.ToString().Trim() "','" textBox15.Text.ToString().Trim() "','" textBox16.Text.ToString().Trim() "','" textBox17.Text.ToString().Trim() "','" textBox19.Text.ToString().Trim() "','" textBox20.Text.ToString().Trim() "','" textBox21.Text.ToString().Trim() "','" textBox18.Text.ToString().Trim() "','" textBox26.Text.ToString().Trim() "','" textBox24.Text.ToString().Trim() "','" textBox25.Text.ToString().Trim() "','" textBox27.Text.ToString().Trim() "','" textBox28.Text.ToString().Trim() "','" textBox29.Text.ToString().Trim() "','" textBox30.Text.ToString().Trim() "' )";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
conn.Dispose();
da.Dispose();
ds.Dispose();
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
Toast("数据已保存！！");
return;
}
else
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
// textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据不全，不能保存，请确保信息准确！！");
}
}
else if (i > 0 && (textBox3.Text.Trim() != textBox5.Text.Trim() || textBox4.Text.Trim() != textBox7.Text.Trim()))
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("移出（入）地不同，不能保存！！！");
}
else if (i > 0 && textBox3.Text.Trim() == textBox5.Text.Trim() && textBox4.Text.Trim() == textBox7.Text.Trim() && i1 > 0)
{
textBox7.Text = "";
textBox8.Text = "";
textBox10.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = DateTime.Now.ToString("yyyyMMdd");
textBox19.Text = "";
textBox24.Text = "";
textBox25.Text = "";
//textBox21.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox22.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox27.Text = "";
textBox28.Text = "";
MessageBox.Show("数据已扫，不能保存！！！");
}
SqlConnection conn1 = BaseClass.DBCon();
conn1.Open();
string SQL1 = " select * from MZCZZY ";
SqlDataAdapter sda = new SqlDataAdapter(SQL1, conn1);
DataSet ds1 = new DataSet();
sda.Fill(ds1, "AA11");
tableView1.DataSource = ds1.Tables["AA11"];
tableView1.DataBind();
conn1.Close();
conn1.Dispose();
sda.Dispose();
ds1.Dispose();