/// <summary>
/// 添加一个客户
/// 返回 true 表示成功，否侧数据已存在
/// </summary>
/// <param name="_customer"></param>
/// <returns></returns>
public bool AddData(Renting_Management_System.Models.CustomerMod _customer)
{
customer = new Renting_Management_System.Models.CustomerMod();
customer = SelectByID(_customer.CustomerID);
if (customer == null)
{
StringBuilder insertStr = new StringBuilder();
insertStr.Append("Insert Into [Customer]");
insertStr.Append("(客户编号,客户类代码,客户名称,性别,出生日期,证件类代码,证件号码,客户地址,联系方式,客户状态,客户描述,客户拒绝)");
insertStr.Append("Values ('");
insertStr.Append(_customer.CustomerID + "','");
insertStr.Append(_customer.CustomerTypeCode + "','");
insertStr.Append(_customer.CustomerName + "','");
insertStr.Append(_customer.Sex + "','");
insertStr.Append(_customer.BirthDate.ToShortDateString() + "','");
insertStr.Append(_customer.CertificateTypeCode + "','");
insertStr.Append(_customer.CertificateNumber + "','");
insertStr.Append(_customer.CustomerAddress + "','");
insertStr.Append(_customer.CustomerContact + "','");
insertStr.Append(_customer.CustomerState + "','");
insertStr.Append(_customer.CustomerDescription + "','");
insertStr.Append(_customer.CustomerDeny.ToString());
insertStr.Append("')");
da = new DBConnection();
da.InsertQuery(insertStr.ToString());
return true;
}
else
{ return false; }
}
/// <summary>
/// 删除一个客户
/// 返回 true 表示成功，否侧数据不存在
/// </summary>
/// <param name="_customer"></param>
/// <returns></returns>
public bool DeleteData(Renting_Management_System.Models.CustomerMod _customer)
{
customer = new Renting_Management_System.Models.CustomerMod();
customer = SelectByID(_customer.CustomerID);
if (customer != null)
{
StringBuilder deleteStr = new StringBuilder();
deleteStr.Append("Delete From [Customer]");
deleteStr.Append("Where 客户编号 = '");
deleteStr.Append(_customer.CustomerID);
deleteStr.Append("'");
da = new DBConnection();
da.DeleteQuery(deleteStr.ToString());
return true;
}
else
{ return false; }
}
/// <summary>
/// 通过客户名称获取一个客户，null 表示数据不存在
/// </summary>
/// <param name="_customerName"></param>
/// <returns></returns>
public Renting_Management_System.Models.CustomerMod SelectByName(string _customerName)
{
StringBuilder selectStr = new StringBuilder();
selectStr.Append("Select * from [Customer]");
selectStr.Append("Where 客户名称 = '");
selectStr.Append(_customerName);
selectStr.Append("'");
da = new DBConnection();
DataSet ds = new DataSet();
ds = da.SelectQuery(selectStr.ToString());
if (ds.Tables[0].Rows.Count != 0)
{
customer = new Renting_Management_System.Models.CustomerMod();
customer.CustomerID = ds.Tables[0].Rows[0]["客户编号"].ToString().Trim();
customer.CustomerTypeCode = ds.Tables[0].Rows[0]["客户类代码"].ToString().Trim();
customer.CustomerName = ds.Tables[0].Rows[0]["客户名称"].ToString().Trim();
customer.Sex = char.Parse(ds.Tables[0].Rows[0]["性别"].ToString().Trim());
customer.BirthDate = DateTime.Parse(ds.Tables[0].Rows[0]["出生日期"].ToString().Trim());
customer.CertificateTypeCode = ds.Tables[0].Rows[0]["证件类代码"].ToString().Trim();
customer.CertificateNumber = ds.Tables[0].Rows[0]["证件号码"].ToString().Trim();
customer.CustomerAddress = ds.Tables[0].Rows[0]["客户地址"].ToString().Trim();
customer.CustomerContact = ds.Tables[0].Rows[0]["联系方式"].ToString().Trim();
customer.CustomerState = ds.Tables[0].Rows[0]["客户状态"].ToString().Trim();
customer.CustomerDescription = ds.Tables[0].Rows[0]["客户描述"].ToString().Trim();
customer.CustomerDeny = bool.Parse(ds.Tables[0].Rows[0]["客户拒绝"].ToString().Trim());
return customer;
}
else
{ return null; }
}
/// <summary>
/// 修改一个客户的记录
/// 返回 true 表示成功，否侧表示数据不存在
/// </summary>
/// <param name="_customer"></param>
/// <returns></returns>
public bool ModifyData(Renting_Management_System.Models.CustomerMod _customer)
{
customer = new Renting_Management_System.Models.CustomerMod();
customer = SelectByID(_customer.CustomerID);
if (customer != null)
{
StringBuilder updateStr = new StringBuilder();
updateStr.Append("Update [Customer] ");
updateStr.Append("Set ");
updateStr.Append("客户类代码 = '");
updateStr.Append(_customer.CustomerTypeCode + "'");
updateStr.Append(",客户名称 = '");
updateStr.Append(_customer.CustomerName + "'");
updateStr.Append(",性别 = '");
updateStr.Append(_customer.Sex + "'");
updateStr.Append(",出生日期 = '");
updateStr.Append(_customer.BirthDate.ToShortDateString());
updateStr.Append("',证件类代码 = '");
updateStr.Append(_customer.CertificateTypeCode + "'");
updateStr.Append(",证件号码 = '");
updateStr.Append(_customer.CertificateNumber + "'");
updateStr.Append(",客户地址 = '");
updateStr.Append(_customer.CustomerAddress + "'");
updateStr.Append(",联系方式 = '");
updateStr.Append(_customer.CustomerContact + "'");
updateStr.Append(",客户状态 = '");
updateStr.Append(_customer.CustomerState + "'");
updateStr.Append(",客户描述 = '");
updateStr.Append(_customer.CustomerDescription + "'");
updateStr.Append(",客户拒绝 = '");
updateStr.Append(_customer.CustomerDeny.ToString() + "'");
updateStr.Append("Where 客户编号 = '");
updateStr.Append(_customer.CustomerID + "'");
da = new DBConnection();
da.UpdateQuery(updateStr.ToString());
return true;
}
else
{ return false; }
}
