public static void Update(Hashtable has)
{
string set = "";
string where = "";
foreach (DictionaryEntry de in has)
{
if (de.Key.ToString() != "id")
{
set += "" + de.Key + "= @" + de.Key + ",";
}
else
{
where += "" + de.Key + "= @" + de.Key + "";
}
}
string sql = string.Format("update " + tbname + " set {0} where {1}", set.Substring(0, set.Length - 1), where);
DBUtil.Execute(sql, has);
//更新datamain
string sql_mian = "UPDATE T_DataMain SET [FNumber]='" + has["FNumber"].ToString() + "' WHERE [FPumpID]='" + has["FPumpID"].ToString() + "' ";
DBUtil.Execute(sql_mian);
}
public static void Delete(string id)
{
Hashtable has = new Hashtable();
has["id"] = id;
DBUtil.Execute("delete from " + tbname + " where id = @id", has);
}
public static void Delete(string id)
{
Hashtable has = new Hashtable();
has["id"] = id;
DBUtil.Execute("delete from " + tbname + " where id = @id", has);
//删除datamain
string sql_mian = "DELETE FROM T_DataMain WHERE [FPumpID]='" + has["FPumpID"].ToString() + "' ";
DBUtil.Execute(sql_mian);
}
public static string InsertYALI_MAIN(Hashtable has)
{
string id = (has["id"] == null || has["id"].ToString() == "") ? Guid.NewGuid().ToString() : has["id"].ToString();
has["id"] = id;
string columns = "";
string values = "";
foreach (DictionaryEntry de in has)
{
columns += "" + de.Key + ",";
values += "@" + de.Key + ",";
}
string sql = string.Format("insert into DATA_YALI_MAIN ( {0} ) values( {1} )", columns.Substring(0, columns.Length - 1), values.Substring(0, values.Length - 1));
DBUtil.Execute(sql, has);
return(id);
}
public static void Update(Hashtable has)
{
string set = "";
string where = "";
foreach (DictionaryEntry de in has)
{
if (de.Key.ToString() != "id")
{
set += "" + de.Key + "= @" + de.Key + ",";
}
else
{
where += "" + de.Key + "= @" + de.Key + "";
}
}
string sql = string.Format("update " + tbname + " set {0} where {1}", set.Substring(0, set.Length - 1), where);
DBUtil.Execute(sql, has);
}
public static string Insert(Hashtable has)
{
string id = (has["id"] == null || has["id"].ToString() == "") ? Guid.NewGuid().ToString() : has["id"].ToString();
//has["id"] = id;
has.Remove("id");
string columns = "";
string values = "";
foreach (DictionaryEntry de in has)
{
columns += "" + de.Key + ",";
values += "@" + de.Key + ",";
}
string sql = string.Format("insert into " + tbname + " ( {0} ) values( {1} ) ;SELECT @@Identity", columns.Substring(0, columns.Length - 1), values.Substring(0, values.Length - 1));
DbConnection con = DBUtil.getConn();
SqlCommand cmd = new SqlCommand(sql, (SqlConnection)con);
if (has != null)
{
DBUtil.SetArgs(sql, has, cmd);
}
id = cmd.ExecuteScalar().ToString();
//插入datamain
if (has["FNumber"] != null || has["FNumber"].ToString() != "")
{
string sql_mian = "INSERT INTO T_DataMain ([FPumpID],[FNumber]) VALUES ('" + id + "','" + has["FNumber"].ToString() + "')";
DBUtil.Execute(sql_mian);
}
return(id);
}
public static void DeleteMarker(int FType, string idList)
{
string delSql = @"update a set a.FIsDelete=1 from Map_Marker a,Map_MarkerProperty b where a.ID=b.FMarkerID and a.FIsDelete=0 and FType=" + FType + " and b.FMID in (" + idList + ")";
DBUtil.Execute(delSql);
}
public static void DeleteAreaOverlay(string FMapOverlayID, string FMapTempID)
{
string sql = string.Format("delete Map_Area_Overlay where FMapOverlayID='{0}' AND FMapTempID='{1}'", FMapOverlayID, FMapTempID);
DBUtil.Execute(sql);
}