110,534
社区成员
发帖
与我相关
我的任务
分享
class DataBase {
private SQLiteDataAdapter Client_Adapter = new SQLiteDataAdapter();
private string Client_InsertCmd=@"
INSERT INTO Client_V (
City, Unit, Name,
Arrear, Disable, Note
)
VALUES (
@City, @Unit, @Name,
@Arrear, @Disable, @Note
);";
// 构造函数
public DataBase()
{
Client_Adapter.InsertCommand = new SQLiteCommand(Client_InsertCmd, Connection);
SQLiteParameter p;
p = new SQLiteParameter("@City", DbType.String);
p.SourceColumn = "City";
Client_Adapter.InsertCommand.Parameters.Add(p);
p = new SQLiteParameter("@Unit", DbType.String);
p.SourceColumn = "Unit";
Client_Adapter.InsertCommand.Parameters.Add(p);
p = new SQLiteParameter("@Name", DbType.String);
p.SourceColumn = "Name";
Client_Adapter.InsertCommand.Parameters.Add(p);
p = new SQLiteParameter("@Arrear", DbType.Int64);
p.SourceColumn = "Arrear";
Client_Adapter.InsertCommand.Parameters.Add(p);
p = new SQLiteParameter("@Disable", DbType.Boolean);
p.SourceColumn = "Disable";
Client_Adapter.InsertCommand.Parameters.Add(p);
p = new SQLiteParameter("@Note", DbType.String);
p.SourceColumn = "Note";
Client_Adapter.InsertCommand.Parameters.Add(p);
}
// 插入行,成功返回 null ,否则返回错误消息
public string Client_Insert(
string city, string unit, string name,
Int64 arrear, bool disable, string note)
{
if (city == "" || unit == "" || name == "")
return "城市、单位、姓名缺一不可!";
if (Client_GetId(city, unit, name) != -1) return "该客户早已存在!";
var row = Client_Table.NewRow();
row.BeginEdit();
row["City"] = city;
row["Unit"] = unit;
row["Name"] = name;
row["Arrear"] = arrear;
row["Disable"] = disable;
row["Note"] = note;
row.EndEdit(); // 行状态 Detached
try {
Client_Adapter.Update(new DataRow[] { row }); // 失败
} // 行状态依然 Detached
catch { return "未知错误!"; }
return null;
}
}