internal bool DeleteWcsMenu(WcsMenu menu) { string sql = string.Format("DELETE FROM wcs_menu where id = '{0}'", menu.id); int row = mSql.ExcuteSql(sql); return(row >= 1); }
internal bool AddWcsMenu(WcsMenu menu) { string str = "INSERT INTO `wcs_menu`(`id`, `name`, `prior`, `memo`) VALUES ({0}, '{1}', {2}, '{3}')"; string sql = string.Format(@str, menu.id, menu.name, menu.prior, menu.memo); int row = mSql.ExcuteSql(sql); return(row >= 1); }
internal bool EditWcsMenu(WcsMenu menu) { string sql = "UPDATE `goods` SET `name` = '{0}' WHERE `id` = '{1}'"; sql = string.Format(sql); int row = mSql.ExcuteSql(sql); return(row >= 1); }