/// <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;
}
}
