public static int updateYctMode(YctMode m) { LogMode l = new LogMode(m.getModeStr()); int i = -1; try { conn = DbUtil.getConn(); conn.Open(); string sql = "update yct set [shop] = '" + m.shop + "', [phone] = '" + m.phone + "', [money] = '" + m.money + "', [time] = '" + m.time + "', [mark] = '" + m.mark + "' where id = " + m.id; l = new LogMode(sql); cmd = new OleDbCommand(sql, conn); i = cmd.ExecuteNonQuery(); Const.info = "更新:" + i; l.act = "ok\t" + l.act; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (conn != null) { conn.Close(); } } insertLogMode(l); return(i); }
public static int insertYctMode(YctMode m) { LogMode l = new LogMode(m.getModeStr()); int i = -1; try { conn = DbUtil.getConn(); conn.Open(); string sql = "insert into yct([shop], [phone], [money], [time], [mark]) values('" + m.shop + "','" + m.phone + "','" + m.money + "','" + m.time + "','" + m.mark + "')"; l = new LogMode(sql); cmd = new OleDbCommand(sql, conn); i = cmd.ExecuteNonQuery(); Const.info = "插入:1"; l.act = "ok\t" + l.act; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (conn != null) { conn.Close(); } } insertLogMode(l); return(i); }
private void addToolStripMenuItem_Click(object sender, EventArgs e) { YctMode mode = new YctMode(); mode.shop = Const.userName; YctForm yf = new YctForm("新增", mode); yf.ShowDialog(); showStatus(Const.info); searchBtn_Click(sender, e); }
private void addToolStripMenuItem_Click(object sender, EventArgs e) { YctMode mode = new YctMode(); mode.shop = Const.userName; YctForm yf = new YctForm("新增", mode); yf.ShowDialog(); showStatus(Const.info); searchBtn_Click(sender, e); }
private YctMode getModeFromNowRow() { YctMode mode = new YctMode(); DataGridViewRow r = dataGridView.SelectedRows[0]; mode.id = int.Parse(r.Cells[0].Value.ToString()); mode.shop = r.Cells[1].Value.ToString(); mode.phone = r.Cells[2].Value.ToString(); mode.money = r.Cells[3].Value.ToString(); mode.time = Convert.ToDateTime(r.Cells[4].Value); mode.mark = r.Cells[5].Value.ToString(); return(mode); }
public static List <YctMode> getYctModes(string sql) { LogMode l = new LogMode(sql); List <YctMode> modes = new List <YctMode>(); try { conn = DbUtil.getConn(); cmd = new OleDbCommand(sql, conn); conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { YctMode m = new YctMode(); m.id = (int)reader["id"]; m.shop = reader["shop"].ToString(); m.money = reader["money"].ToString(); m.phone = reader["phone"].ToString(); m.time = (DateTime)reader["time"]; m.mark = reader["mark"].ToString(); modes.Add(m); } l.act = "ok\t" + l.act; reader.Close(); Const.info = "查询:" + modes.Count; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (reader != null) { reader.Close(); } if (conn != null) { conn.Close(); } } insertLogMode(l); return(modes); }
private void delToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("删除后不可恢复,确定删除?", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { YctMode mode = getModeFromNowRow(); if (mode == null) { MessageBox.Show("请选中一行进行删除操作。"); return; } string sql = "delete * from yct where id = " + mode.id; YctOrm.exeSql(sql); showStatus(Const.info); } }
private void updateToolStripMenuItem_Click(object sender, EventArgs e) { YctMode mode = getModeFromNowRow(); if (mode == null) { MessageBox.Show("请选中一行进行修改操作。"); return; } YctForm yf = new YctForm("修改", mode); yf.ShowDialog(); showStatus(Const.info); searchBtn_Click(sender, e); }
public YctForm(string act, YctMode mode) { this.act = act; this.mode = mode; InitializeComponent(); }
private YctMode getModeFromNowRow() { YctMode mode = new YctMode(); DataGridViewRow r = dataGridView.SelectedRows[0]; mode.id = int.Parse( r.Cells[0].Value.ToString()); mode.shop = r.Cells[1].Value.ToString(); mode.phone = r.Cells[2].Value.ToString(); mode.money = r.Cells[3].Value.ToString(); mode.time = Convert.ToDateTime(r.Cells[4].Value); mode.mark = r.Cells[5].Value.ToString(); return mode; }
public static int updateYctMode(YctMode m) { LogMode l = new LogMode(m.getModeStr()); int i = -1; try { conn = DbUtil.getConn(); conn.Open(); string sql = "update yct set [shop] = '" + m.shop + "', [phone] = '" + m.phone + "', [money] = '" + m.money + "', [time] = '" + m.time + "', [mark] = '" + m.mark + "' where id = " + m.id; l = new LogMode(sql); cmd = new OleDbCommand(sql, conn); i = cmd.ExecuteNonQuery(); Const.info = "更新:" + i; l.act = "ok\t" + l.act; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (conn != null) { conn.Close(); } } insertLogMode(l); return i; }
public static int insertYctMode(YctMode m) { LogMode l = new LogMode(m.getModeStr()); int i = -1; try { conn = DbUtil.getConn(); conn.Open(); string sql = "insert into yct([shop], [phone], [money], [time], [mark]) values('" + m.shop + "','" + m.phone + "','" + m.money + "','" + m.time + "','" + m.mark + "')"; l = new LogMode(sql); cmd = new OleDbCommand(sql, conn); i = cmd.ExecuteNonQuery(); Const.info = "插入:1"; l.act = "ok\t" + l.act; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (conn != null) { conn.Close(); } } insertLogMode(l); return i; }
public static List<YctMode> getYctModes(string sql) { LogMode l = new LogMode(sql); List<YctMode> modes = new List<YctMode>(); try { conn = DbUtil.getConn(); cmd = new OleDbCommand(sql, conn); conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { YctMode m = new YctMode(); m.id = (int)reader["id"]; m.shop = reader["shop"].ToString(); m.money = reader["money"].ToString(); m.phone = reader["phone"].ToString(); m.time = (DateTime)reader["time"]; m.mark = reader["mark"].ToString(); modes.Add(m); } l.act = "ok\t" + l.act; reader.Close(); Const.info = "查询:" + modes.Count; } catch (Exception e) { Const.info = e.Message; l.act = "fail:" + e.Message + "\t" + l.act; } finally { if (reader != null) { reader.Close(); } if (conn != null) { conn.Close(); } } insertLogMode(l); return modes; }
public YctForm(string act, YctMode mode) { this.act = act; this.mode = mode; InitializeComponent(); }