/// <summary> /// 删除一个地点 /// 返回 true 表示成功 /// 返回 false 表示数据不存在 /// </summary> /// <param name="_local"></param> /// <returns></returns> public bool DeleteData(Renting_Management_System.Models.LocalMod _local) { local = new Renting_Management_System.Models.LocalMod(); local = SelectData(_local.LocalCode); if (local != null) { da = new DBConnection(); StringBuilder deleteStr = new StringBuilder(); deleteStr.Append("Delete From [Local] "); deleteStr.Append("Where 地点代码 = '"); deleteStr.Append(_local.LocalCode); deleteStr.Append("'"); da.DeleteQuery(deleteStr.ToString()); return true; } else return false; }
/// <summary> /// 添加一个地点 /// 返回 true 表示成功 /// 返回 false 表示数据已存在 /// </summary> /// <param name="_local"></param> /// <returns></returns> public bool AddData(Renting_Management_System.Models.LocalMod _local) { local = new Renting_Management_System.Models.LocalMod(); local = SelectData(_local.LocalCode); if (local == null) { da = new DBConnection(); StringBuilder insertStr = new StringBuilder(); insertStr.Append("Insert Into [Local] (地点代码,地点名称) "); insertStr.Append("Values ('"); insertStr.Append(_local.LocalCode + "','"); insertStr.Append(_local.LocalName); insertStr.Append("')"); da.InsertQuery(insertStr.ToString()); return true; } else return false; }
/// <summary> /// 修改一个地点名称 /// 返回 true 表示成功 /// 返回 false 表示数据不存在 /// </summary> /// <param name="_local"></param> /// <returns></returns> public bool ModifyData(Renting_Management_System.Models.LocalMod _local) { local = new Renting_Management_System.Models.LocalMod(); local = SelectData(_local.LocalCode); if (local != null) { da = new DBConnection(); StringBuilder modifyStr = new StringBuilder(); modifyStr.Append("Update [Local]"); modifyStr.Append("Set 地点名称 = '"); modifyStr.Append(_local.LocalName); modifyStr.Append("'"); modifyStr.Append("Where 地点代码 = '"); modifyStr.Append(_local.LocalCode); modifyStr.Append("'"); da.UpdateQuery(modifyStr.ToString()); return true; } else return false; }
/// <summary> /// 获取一个地点 /// _localCode 为地点代码 /// </summary> /// <param name="_localCode"></param> /// <returns></returns> public Renting_Management_System.Models.LocalMod SelectData(string _localCode) { da = new DBConnection(); DataSet ds = new DataSet(); StringBuilder selectStr = new StringBuilder(); selectStr.Append("Select * From [Local]"); selectStr.Append("Where 地点代码 = '"); selectStr.Append(_localCode); selectStr.Append("'"); ds = da.SelectQuery(selectStr.ToString()); if (ds.Tables[0].Rows.Count == 0) { return null; } else { local = new Renting_Management_System.Models.LocalMod(); local.LocalCode = ds.Tables[0].Rows[0][0].ToString().Trim(); local.LocalName = ds.Tables[0].Rows[0][1].ToString().Trim(); return local; } }