Beispiel #1
0
 public void Updatecktj(ckb c)
 {
     db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
     db.AddParameters("@xh", SqlDbType.VarChar, c.xh);
     db.AddParameters("@sl", SqlDbType.Int, c.sl);
     db.Update("update spxxb set sl=sl-@sl where spbh=@spbh and xh=@xh");
 }
Beispiel #2
0
 public void DataBindingCmbckSpxh(ComboBox cmbxh, ckb c)
 {
     //组合框的绑定
     db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
     dtxh = db.Select("select xh from hjxxb where spbh=@spbh and sl>0");
     bd.bd(cmbxh, dtxh, "xh", "xh");
 }
Beispiel #3
0
        public int dgvCellContentClickrk(ckb c)
        {
            DataTable dt = new DataTable();

            db.AddParameters("@spm", SqlDbType.Char, c.spm);
            db.AddParameters("@xh", SqlDbType.Char, c.xh);
            db.AddParameters("@hjbh", SqlDbType.Char, c.cfhj);
            dt = db.Select("SELECT dbo.hjxxb.sl FROM dbo.hjxxb INNER JOIN dbo.spb ON dbo.hjxxb.spbh = dbo.spb.spbh where spm=@spm and xh=@xh and hjbh=@hjbh");
            if (int.Parse(dt.Rows[0]["sl"].ToString()) < c.sl)
            {
                MessageBox.Show("数量不足");
                return(1);
            }
            else
            {
                db.AddParameters("@ckbh", SqlDbType.Int, c.ckbh);
                db.AddParameters("@spm", SqlDbType.Char, c.spm);
                db.AddParameters("@xh", SqlDbType.Char, c.xh);
                db.AddParameters("@sl", SqlDbType.Char, c.sl);
                db.AddParameters("@chr", SqlDbType.Char, c.chr);
                db.AddParameters("@shr", SqlDbType.Char, c.shr);
                db.AddParameters("@cfhj", SqlDbType.Char, c.cfhj);
                db.Update("update ckb set yz=0 where ckbh=@ckbh");
                return(2);
            }
        }
Beispiel #4
0
 public void DataBindingCmbckcfhj(ComboBox cmbcfhj, ckb c)
 {
     //组合框的绑定
     db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
     db.AddParameters("@xh", SqlDbType.VarChar, c.xh);
     dthj = db.Select("select hjbh from hjxxb where spbh=@spbh and xh=@xh");
     bd.bd(cmbcfhj, dthj, "hjbh", "hjbh");
 }
Beispiel #5
0
 public void DataBindingDataGridView(DataGridView dgvck, int num, ckb c, khb k)
 {
     dgvck.Rows.Add();
     dgvck.Rows[num].Cells[0].Value = c.spm;
     dgvck.Rows[num].Cells[1].Value = c.xh;
     dgvck.Rows[num].Cells[2].Value = c.sl;
     dgvck.Rows[num].Cells[3].Value = c.cfhj;
     dgvck.Rows[num].Cells[4].Value = k.kh;
 }
Beispiel #6
0
        public void Insertckhj(ckb c)
        {
            DataTable dthj = new DataTable();

            db.AddParameters("@hjbh", SqlDbType.Char, c.cfhj);
            db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
            db.AddParameters("@xh", SqlDbType.VarChar, c.xh);
            db.AddParameters("@sl", SqlDbType.Int, c.sl);
            db.Update("update hjxxb set sl=sl-@sl where hjbh=@hjbh and spbh=@spbh and xh=@xh");
        }
Beispiel #7
0
 public void dgvCellContentClickth(ckb c)
 {
     db.AddParameters("@ckbh", SqlDbType.Int, c.ckbh);
     db.AddParameters("@spm", SqlDbType.NChar, c.spm);
     db.AddParameters("@xh", SqlDbType.Char, c.xh);
     db.AddParameters("@sl", SqlDbType.Char, c.sl);
     db.AddParameters("@chr", SqlDbType.Char, c.chr);
     db.AddParameters("@shr", SqlDbType.Char, c.shr);
     db.AddParameters("@cfhj", SqlDbType.Char, c.cfhj);
     db.Update("update ckb set yz=-1 where ckbh=@ckbh");
 }
Beispiel #8
0
 public void Insertrktj(ckb c)
 {
     db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
     db.AddParameters("@spm", SqlDbType.Char, c.spm);
     db.AddParameters("@xh", SqlDbType.VarChar, c.xh);
     db.AddParameters("@sl", SqlDbType.Int, c.sl);
     db.AddParameters("@chr", SqlDbType.VarChar, c.chr);
     db.AddParameters("@shr", SqlDbType.Int, c.shr);
     db.AddParameters("@cfhj", SqlDbType.Char, c.cfhj);
     db.Insert("insert into ckb (spbh,spm,xh,sl,chr,shr,cfhj,cksj,yz)values(@spbh,@spm,@xh,@sl,@chr,@shr,@cfhj,GETDATE(),1)");
 }
Beispiel #9
0
 public void DataBindingCmbcksl(ckb c)
 {
     db.AddParameters("@spbh", SqlDbType.Int, c.spbh);
     db.AddParameters("@xh", SqlDbType.VarChar, c.xh);
     db.AddParameters("@hjbh", SqlDbType.VarChar, c.cfhj);
     dtrksl = db.Select2("select sl from hjxxb where hjbh=@hjbh and spbh=@spbh and xh=@xh");
     while (dtrksl.Read())//每次读取一行,记录会自动下移至下一条记录,反复读取,直到读完记录
     {
         c.sl = int.Parse(dtrksl[0].ToString());
     }
     db.close();
 }