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);
}
