static void Main(string[] args)
{
var floorArea = new FloorAreaRecord()
{
ID = 1, AreaLevel = 2, AreaParentID = 3, AreaName = "测试"
};
new SqlTester().SQLAddFloorAreaRecord(floorArea);
floorArea.AreaName = "ceshi2";
new SqlTester().SQLChangeFloorAreaRecord(floorArea);
new SqlTester().SQLDeleteFloorAreaRecord(floorArea);
}
public void SQLDeleteFloorAreaRecord(FloorAreaRecord record)
{
SqlConnection databaseConnection = new SqlConnection(_sqlConnectionProjectString);
SqlCommand command = new SqlCommand(_deleteStatement, databaseConnection);
command.CommandType = CommandType.Text;
SetParameters(record, command);
try {
databaseConnection.Open();
int NumRows = command.ExecuteNonQuery();
//if (NumRows == 0) {
// MessageBox.Show("数据删除出错，请检查！");
//}
} catch (Exception e) {
var message = e;
} finally {
databaseConnection.Close();
}
}
static void SetParameters(FloorAreaRecord record, SqlCommand command)
{
var parameterName = string.Format("@{0}", ColumnAreaID);
command.Parameters.Add(parameterName, SqlDbType.Int);
command.Parameters[parameterName].Value = record.ID;
parameterName = string.Format("@{0}", ColumnAreaName);
command.Parameters.Add(parameterName, SqlDbType.NVarChar);
command.Parameters[parameterName].Value = record.AreaName;
parameterName = string.Format("@{0}", ColumnAreaParentID);
command.Parameters.Add(parameterName, SqlDbType.Int);
command.Parameters[parameterName].Value = record.AreaParentID;
parameterName = string.Format("@{0}", ColumnAreaLevel);
command.Parameters.Add(parameterName, SqlDbType.Int);
command.Parameters[parameterName].Value = record.AreaLevel;
}
public void SQLAddFloorAreaRecord(FloorAreaRecord record)
{
SqlConnection databaseConnection = new SqlConnection(_sqlConnectionProjectString);
SqlCommand command = new SqlCommand(_addStatement, databaseConnection);
command.CommandType = CommandType.Text;
SetParameters(record, command);
try {
databaseConnection.Open();
int NumRows = command.ExecuteNonQuery();
if (NumRows == 0)
{
var message = "数据记录为空，请检查！";
}
} catch (Exception e) {
var message = e;
} finally {
databaseConnection.Close();
}
}
