public string addSwallet(SWallet s)
{
string connectionString = this.Connect();
string str2 = "";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO search_wallet (mark_infoID,search_str,search_cri,xclass,log_officer,reg_date,visible) VALUES (@mark_infoID,@search_str,@search_cri,@xclass,@log_officer,@reg_date,@visible) SELECT SCOPE_IDENTITY()";
connection.Open();
command.Parameters.Add("@mark_infoID", SqlDbType.NVarChar);
command.Parameters.Add("@search_str", SqlDbType.Text);
command.Parameters.Add("@search_cri", SqlDbType.Text);
command.Parameters.Add("@xclass", SqlDbType.NVarChar, 50);
command.Parameters.Add("@log_officer", SqlDbType.NVarChar, 50);
command.Parameters.Add("@reg_date", SqlDbType.NVarChar, 50);
command.Parameters.Add("@visible", SqlDbType.NVarChar, 1);
command.Parameters["@mark_infoID"].Value = s.mark_infoID;
command.Parameters["@search_str"].Value = s.search_str;
command.Parameters["@search_cri"].Value = s.search_cri;
command.Parameters["@xclass"].Value = s.xclass;
command.Parameters["@log_officer"].Value = s.log_officer;
command.Parameters["@reg_date"].Value = s.reg_date;
command.Parameters["@visible"].Value = s.visible;
str2 = command.ExecuteScalar().ToString();
connection.Close();
return str2;
}
public SWallet getSwalletByID(string ID)
{
SWallet wallet = new SWallet();
SqlConnection connection = new SqlConnection(this.Connect());
SqlCommand command = new SqlCommand("SELECT * FROM search_wallet WHERE mark_infoID='" + ID + "' ", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
wallet.ID = Convert.ToInt64(reader["ID"]).ToString();
wallet.mark_infoID = reader["mark_infoID"].ToString();
wallet.search_cri = reader["search_cri"].ToString();
wallet.search_str = reader["search_str"].ToString();
wallet.xclass = reader["xclass"].ToString();
wallet.log_officer = reader["log_officer"].ToString();
wallet.reg_date = reader["reg_date"].ToString();
wallet.visible = reader["visible"].ToString();
}
reader.Close();
return wallet;
}
