private void kiemtra_nhap() { Cursor = Cursors.WaitCursor; string user = d.user, sql; d.execute_data("update " + user + mmyy + ".d_tonkhoct set slnhap=0 where makho in (select id from " + user + ".d_dmkho where nhom=" + i_nhom + ")"); sql = "select id,makho,manguon,nhomcc from " + user + mmyy + ".d_nhapll where nhom=" + i_nhom; decimal sttt = 0; bool bFound = false; foreach (DataRow r in d.get_data(sql).Tables[0].Rows) { sql = "select stt,mabd,handung,losx,soluong,dongia,giaban,giamua,namsx,baohanh,nguongoc,tinhtrang,sothe,tyle_ggia,st_ggia"; sql += " from " + user + mmyy + ".d_nhapct where id=" + decimal.Parse(r["id"].ToString()); foreach (DataRow r1 in d.get_data(sql).Tables[0].Rows) { sql = "select * from " + user + mmyy + ".d_tonkhoct where idn=" + decimal.Parse(r["id"].ToString()) + " and sttn=" + decimal.Parse(r1["stt"].ToString()); sttt = 0; foreach (DataRow r2 in d.get_data(sql).Tables[0].Rows) { sttt = decimal.Parse(r2["stt"].ToString()); } bFound = sttt != 0; if (sttt == 0) { sttt = d.getidyymmdd(9); } d.upd_theodoi(mmyy, sttt, int.Parse(r1["mabd"].ToString()), int.Parse(r["manguon"].ToString()), int.Parse(r["nhomcc"].ToString()), r1["handung"].ToString(), r1["losx"].ToString(), r1["sothe"].ToString(), r1["namsx"].ToString(), r1["namsx"].ToString(), int.Parse(r1["baohanh"].ToString()), int.Parse(r1["nguongoc"].ToString()), int.Parse(r1["tinhtrang"].ToString()), decimal.Parse(r1["giamua"].ToString()), decimal.Parse(r1["giaban"].ToString()), decimal.Parse(r1["dongia"].ToString()), decimal.Parse(r1["tyle_ggia"].ToString()), decimal.Parse(r1["st_ggia"].ToString())); if (bFound) { d.execute_data("update " + user + mmyy + ".d_tonkhoct set slnhap=slnhap+" + decimal.Parse(r1["soluong"].ToString()) + " where idn=" + decimal.Parse(r["id"].ToString()) + " and sttn=" + decimal.Parse(r1["stt"].ToString()) + " and makho=" + int.Parse(r["makho"].ToString())); } else { d.execute_data("insert into " + user + mmyy + ".d_tonkhoct(makho,stt,idn,sttn,mabd,tondau,slnhap,slxuat) values (" + int.Parse(r["makho"].ToString()) + "," + sttt + "," + decimal.Parse(r["id"].ToString()) + "," + decimal.Parse(r1["stt"].ToString()) + "," + decimal.Parse(r1["mabd"].ToString()) + ",0," + decimal.Parse(r1["soluong"].ToString()) + ",0)"); } } } d.upd_tonkho(i_nhom, mmyy); Cursor = Cursors.Default; MessageBox.Show(lan.Change_language_MessageText("Đã kiểm tra số liệu tồn kho !"), d.Msg); }