public int KcGoodsDelete(getKucun KcGoods) { int intFalg = 0; try { string str_Del = "delete from KcGoods where KcID='" + KcGoods.getKcID + "'"; getSqlConnection getConnection = new getSqlConnection(); conn = getConnection.GetCon(); cmd = new SqlCommand(str_Del, conn); intFalg = cmd.ExecuteNonQuery(); conn.Dispose(); return(intFalg); } catch (Exception ee) { MessageBox.Show(ee.ToString()); return(intFalg); } }
public int KcGoodsUpdate(getKucun kcGood) { int intFalg = 0; try { string str_Update = "update KcGoods set "; str_Update += "KcID='" + kcGood.getKcID + "',KcGoodsName='" + kcGood.getKcGoodsName + "',"; str_Update += "KcNum='" + kcGood.getKcNum + "',KcDeptName='" + kcGood.getKcDeptName + "' where KcID='" + kcGood.getKcID + "'"; getSqlConnection getConnection = new getSqlConnection(); conn = getConnection.GetCon(); cmd = new SqlCommand(str_Update, conn); intFalg = cmd.ExecuteNonQuery(); conn.Dispose(); return(intFalg); } catch (Exception ee) { MessageBox.Show(ee.ToString()); return(intFalg); } }
public int KcGoodsAdd(getKucun kcGood) { int intFalg = 0; try { string str_Add = "insert into KcGoods(KcID,KcGoodsName,KcNum,KcDeptName) values( "; str_Add += "'" + kcGood.getKcID + "','" + kcGood.getKcGoodsName + "',"; str_Add += "'" + kcGood.getKcNum + "','" + kcGood.getKcDeptName + "')"; getSqlConnection getConnection = new getSqlConnection(); conn = getConnection.GetCon(); cmd = new SqlCommand(str_Add, conn); intFalg = cmd.ExecuteNonQuery(); conn.Dispose(); return(intFalg); } catch (Exception ee) { MessageBox.Show(ee.ToString()); return(intFalg); } }
public void KcGoodsFind(object DataObject, int intFalg, getKucun kcGood) { string strSecar = null; try { switch (intFalg) { case 1: strSecar = "select * from KcGoods where KcID like '%" + kcGood.getGoodsID + "%'"; break; case 2: strSecar = "select * from KcGoods where KcGoodsName like '%" + kcGood.getKcGoodsName + "%'"; break; case 4: strSecar = "select * from KcGoods "; break; } getSqlConnection getConnection = new getSqlConnection(); conn = getConnection.GetCon(); cmd = new SqlCommand(strSecar, conn); int ii = 0; hs = cmd.ExecuteReader(); while (hs.Read()) { ii++; } hs.Close(); System.Windows.Forms.DataGridView dv = (DataGridView)DataObject; if (ii != 0) { int i = 0; dv.RowCount = ii; hs = cmd.ExecuteReader(); while (hs.Read()) { dv[0, i].Value = hs[0].ToString(); dv[1, i].Value = hs[1].ToString(); dv[2, i].Value = hs[2].ToString(); dv[3, i].Value = hs[3].ToString(); i++; } hs.Close(); } else { if (dv.RowCount != 0) { int i = 0; do { dv[0, i].Value = ""; dv[1, i].Value = ""; dv[2, i].Value = ""; dv[3, i].Value = ""; i++; } while (i < dv.RowCount); } } } catch (Exception ee) { MessageBox.Show(ee.ToString()); } }