/// <summary> /// 删除 /// </summary> /// <param name="model"></param> /// <returns>成功返回true</returns> public static bool DeleteCascading(Cascading model) { if (model != null) { var con = SqLiteHelper.Open(_dbPath); try { string mysqlString = "delete from ipvt_cascadingtable where CascadingID=?id"; var param = new MySqlParameter("?id", model.Id); CustomMySqlHelper.ExecuteNonQuery(mysqlString, param); string sqliteSql = string.Format("delete from db_data where RowID={0}", model.RowId); SqLiteHelper.ExecuteNonquery(con, sqliteSql); return(true); } catch (Exception ex) { LogHelper.MainLog(ex.ToString()); } finally { if (con != null) { con.Close(); } } } return(false); }
public ActionResult Deneme() { Cascading cs = new Cascading(); cs.Kategoriler = new SelectList(c.Kategoris, "Id", "KategoriAdi"); cs.Urunler = new SelectList(c.Uruns, "Id", "Ad"); return(View(cs)); }
public ActionResult Cascading() { Cascading cs = new Cascading(); cs.Kategoriler = new SelectList(C.Kategoris, "KategoriId", "KategoriAd"); cs.Urunler = new SelectList(C.Uruns, "UrunId", "UrunAD"); return(View(cs)); }
public ActionResult Cascading() { Cascading cs = new Cascading(); cs.Kategoriler = new SelectList(c.Kategoris, "KATEGORIID", "KATEGORIAD"); cs.Urunler = new SelectList(c.Urunlers, "URUNID", "URUNAD"); return(View(cs)); }
/// <summary> /// 获取级联集合 /// </summary> /// <returns></returns> public static void GetCascadings(out List <Cascading> list) { list = new List <Cascading>(); string mysql = "select CascadingID,Data_key,Data,Remark from ipvt_cascadingtable"; MySqlDataReader reader = null; try { reader = CustomMySqlHelper.ExecuteDataReader(mysql); while (reader != null && reader.Read()) { var model = new Cascading(); model.Id = EvaluationHelper.ObjectToInt(reader["CascadingID"]); model.Key = reader["Data_key"].ToString(); model.Ip = reader["Data"].ToString(); model.Remark = reader["Remark"].ToString(); var con = SqLiteHelper.Open(_dbPath); string sql = string.Format( "select RowID from db_data where realm='hy_extern_domain' and data_key='{0}' and data='{1}'", model.Key, model.Ip); model.RowId = EvaluationHelper.ObjectToInt(SqLiteHelper.ExecuteScalar(con, sql)); list.Add(model); con.Close(); } } catch (Exception ex) { LogHelper.MainLog(ex.ToString()); } finally { if (reader != null) { reader.Close(); } } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns>成功返回true</returns> public static bool UpdataCascading(Cascading model) { if (model != null && model.Id != 0) { var con = SqLiteHelper.Open(_dbPath); try { string mysqlString = "update ipvt_cascadingtable set Data_key=?key,Data=?data,Remark=?remark where CascadingID=?id"; var ps = new MySqlParameter[4]; ps[0] = new MySqlParameter("?key", model.Key); ps[1] = new MySqlParameter("?data", model.Ip); ps[2] = new MySqlParameter("?remark", model.Remark); ps[3] = new MySqlParameter("?id", model.Id); CustomMySqlHelper.ExecuteNonQuery(mysqlString, ps); //更新 string sqliteString = string.Format("update db_data set data_key='{0}',data='{1}' where RowID={2}", model.Key, model.Ip, model.RowId); SqLiteHelper.ExecuteNonquery(con, sqliteString); //SQLite更新 return(true); } catch (Exception ex) { LogHelper.MainLog(ex.ToString()); } finally { if (con != null) { con.Close(); } } } return(false); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns>成功返回true</returns> public static bool InsertCascading(Cascading model) { if (model != null) { var con = SqLiteHelper.Open(_dbPath); try { string mysqlString = "insert into ipvt_cascadingtable(Data_key,Data,Remark) values(?key,?data,?remark)"; var ps = new MySqlParameter[3]; ps[0] = new MySqlParameter("?key", model.Key); ps[1] = new MySqlParameter("?data", model.Ip); ps[2] = new MySqlParameter("?remark", model.Remark); CustomMySqlHelper.ExecuteNonQuery(mysqlString, ps);//插入 string sqliteString = string.Format("insert into db_data(realm,data_key,data) values('hy_extern_domain','{0}','{1}')", model.Key, model.Ip); SqLiteHelper.ExecuteNonquery(con, sqliteString);//SQLite插入 return(true); } catch (Exception ex) { LogHelper.MainLog(ex.ToString()); } finally { if (con != null) { con.Close(); } } } return(false); }