public ObservableCollection <AcquisitionBaseData> SelectBy(string _colname, string _value, bool _isdesc)
{
string connstr = "Data Source=ZNCPlatform.db;Version=3;";
var col = "ID";//默认为ID
var sort = _isdesc ? "desc" : "asc";
if (_colname != "")
{
col = _colname;
}
var collection = new ObservableCollection <AcquisitionBaseData>();
var sql = "SELECT * FROM [AcquisitionBaseData] WHERE " + col + " = " + _value + " order by ID " + _isdesc;
var conn = new SQLiteConnection(connstr);
var ds = SqLiteHelper.ExecuteDataSet(conn, sql, null);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
var resource = new AcquisitionBaseData();
resource.ID = int.Parse(dr["FloorID"].ToString());
resource.Code = int.Parse(dr["FloorName"].ToString());
resource.Confidence = int.Parse(dr["BuildingID"].ToString());
resource.Name = dr["Invalid"].ToString();
resource.Remark = dr["Remark"].ToString();
collection.Add(resource);
}
}
return(collection);
}
public int Delete(AcquisitionBaseData model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
//var sql = "DELETE FROM [AcquisitionBaseData] WHERE [Id]=@Id";
//var conn = new SQLiteConnection(connstr);
//object[] para = { new SQLiteParameter("@Id", model.Id) };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
public int Insert(AcquisitionBaseData model)
{
return(CommonAccess.ComSQLiteInsert(model));
//var sql = "INSERT INTO [AcquisitionBaseData] ([Code],[Confidence],[Remark],[Name],[Value]) VALUES (@Code,@Confidence,@Remark,@Name,@Value)";
//var conn = new SQLiteConnection(connstr);
//object[] para = {
// new SQLiteParameter("@Code", model.Code),
// new SQLiteParameter("@Confidence", model.Confidence),
// new SQLiteParameter("@Remark", model.Remark),
// new SQLiteParameter("@Name", model.Name),
// new SQLiteParameter("@Value", model.Value)
// };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
public int Update(AcquisitionBaseData model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
//var sql = "Update [AcquisitionBaseData] set [Code] = @Code,[Confidence]=@Confidence,[Remark] = @Remark,[Name]=@Name,[Value]=@Value WHERE [Id] = @Id";
//var conn = new SQLiteConnection(connstr);
//object[] para = {
// new SQLiteParameter("@Code",model.Code),
// new SQLiteParameter("@Confidence",model.Confidence),
// new SQLiteParameter("@Remark",model.Remark),
// new SQLiteParameter("@Name",model.Name),
// new SQLiteParameter("@Value",model.Value),
// new SQLiteParameter("@Id",model.Id)
// };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
private void BtnDelete_Click()
{
if (View.DGSelect.SelectedItem == null)
{
MessageBox.Show("请选择要删除记录！");
return;
}
foreach (var item in View.DGSelect.SelectedItems)
{
AcquisitionBaseData row = item as AcquisitionBaseData;
var success = new AcquisitionBaseDataBIZ().delete(row) > 0;
if (success == false)
{
MessageBox.Show("删除失败！");
break;
}
}
MessageBox.Show("删除成功！");
BtnSearch_Click();
}
public int delete(AcquisitionBaseData _model)
{
return(dal.Delete(_model));
}
public int InsertOrUpdateBy(AcquisitionBaseData _model, string _identity)
{
return(_model.ID == 0 ? dal.Insert(_model) : dal.Update(_model, _identity));
}
public int UpdateBy(AcquisitionBaseData _model, string _identity)
{
return(dal.Update(_model, _identity));
}
public int Update(AcquisitionBaseData _model)
{
return(dal.Update(_model, "ID"));
}
public int Insert(AcquisitionBaseData _model)
{
return(dal.Insert(_model));
}
