/// <summary>
/// 返回客户
/// </summary>
/// <param name="rel"></param>
/// <returns></returns>
public Model.tab_relatives getRelative(Model.tab_relatives rel)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from tab_relatives where ");
strsql.AppendFormat("relativeID='{0}'", rel.relativeID);
//strsql.AppendFormat(" or relativeEmail='{0}'", rel.relativeEmail);
DataTable dt = sql.ExecuteDataSet(strsql.ToString()).Tables[0];
Model.tab_relatives relative = new Model.tab_relatives();
relative.relativeName = dt.Rows[0]["relativeName"].ToString();
relative.relativeEmail = dt.Rows[0]["relativeEmail"].ToString();
relative.relativeMobile = dt.Rows[0]["relativeMobile"].ToString();
relative.relativeProvince = dt.Rows[0]["relativeProvince"].ToString();
relative.relativeCity = dt.Rows[0]["relativeCity"].ToString();
relative.relativeAddress = dt.Rows[0]["relativeAddress"].ToString();
relative.relativeGender = dt.Rows[0]["relativeGender"].ToString();
relative.relativeMarriageStatus = dt.Rows[0]["relativeMarriageStatus"].ToString();
relative.relativeDOB = dt.Rows[0]["relativeDOB"].ToString() == "" ? baddate : DateTime.Parse(dt.Rows[0]["relativeDOB"].ToString());
relative.relativeNation = dt.Rows[0]["relativeNation"].ToString();
relative.relativeIDcard = dt.Rows[0]["relativeIDcard"].ToString();
relative.relativeCustomer = int.Parse(dt.Rows[0]["relativeCustomer"].ToString());
relative.relativeRelationship = dt.Rows[0]["relativeRelationship"].ToString();
relative.relativeID = int.Parse(dt.Rows[0]["relativeID"].ToString());
return(relative);
}
/// <summary>
/// 客户表的查找
/// </summary>
/// <param name="rel"></param>
/// <returns></returns>
public System.Data.DataTable RelativeSelect(Model.tab_relatives rel)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from tab_relatives where ");
strsql.AppendFormat("relativeID='{0}'", rel.relativeID);
strsql.AppendFormat(" or relativeEmail='{0}'", rel.relativeEmail);
return(sql.ExecuteDataSet(strsql.ToString()).Tables[0]);
}
/// <summary>
/// 修改客户的信息
/// </summary>
/// <param name="rel"></param>
/// <returns></returns>
public int update(Model.tab_relatives rel)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("update tab_relatives set ");
strsql.AppendFormat(" relativeName =N'{0}',", rel.relativeName);
strsql.AppendFormat(" relativeEmail ='{0}',", rel.relativeEmail);
strsql.AppendFormat(" relativeProvince =N'{0}',", rel.relativeProvince);
strsql.AppendFormat(" relativeCity =N'{0}',", rel.relativeCity);
strsql.AppendFormat(" relativeAddress =N'{0}',", rel.relativeAddress);
strsql.AppendFormat(" relativeGender =N'{0}',", rel.relativeGender);
strsql.AppendFormat(" relativeMarriageStatus =N'{0}',", rel.relativeMarriageStatus);
strsql.AppendFormat(" relativeDOB ={0},", rel.relativeDOB == baddate ? "null" : "'" + rel.relativeDOB.ToString() + "'");
strsql.AppendFormat(" relativeNation =N'{0}',", rel.relativeNation);
strsql.AppendFormat(" relativeIDcard ='{0}',", rel.relativeIDcard);
strsql.AppendFormat(" relativeMobile ='{0}',", rel.relativeMobile);
strsql.AppendFormat(" relativeCustomer ={0},", rel.relativeCustomer);
strsql.AppendFormat(" relativeRelationship =N'{0}'", rel.relativeRelationship);
strsql.AppendFormat(" where relativeID={0}", rel.relativeID);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public int RelativeAdd(Model.tab_relatives relative)
{
//DateTime baddate = DateTime.Parse("1900-01-01");
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into tab_relatives values (");
strsql.AppendFormat("N'{0}',", relative.relativeName);
strsql.AppendFormat("'{0}',", relative.relativeEmail);
strsql.AppendFormat("'{0}',", relative.relativeMobile);
strsql.AppendFormat("N'{0}',", relative.relativeProvince);
strsql.AppendFormat("N'{0}',", relative.relativeCity);
strsql.AppendFormat("N'{0}',", relative.relativeAddress);
strsql.AppendFormat("N'{0}',", relative.relativeGender);
strsql.AppendFormat("N'{0}',", relative.relativeMarriageStatus);
strsql.AppendFormat("{0},", relative.relativeDOB == baddate ? "null" : "'" + relative.relativeDOB.ToString() + "'");
strsql.AppendFormat("N'{0}',", relative.relativeNation);
strsql.AppendFormat("'{0}',", relative.relativeIDcard);
strsql.AppendFormat("'{0}',", relative.relativeCustomer);
strsql.AppendFormat("N'{0}'", relative.relativeRelationship);
strsql.Append(") select SCOPE_IDENTITY()");
return(Convert.ToInt32(sql.ExecuteSc(strsql.ToString())));
//return sql.ExecuteNonQuery(strsql.ToString());
}
/// <summary>
/// 客户表的修改
/// </summary>
/// <param name="rel"></param>
/// <returns></returns>
public int update(Model.tab_relatives rel)
{
return(itu.update(rel));
}
public Model.tab_relatives getRelative(Model.tab_relatives rel)
{
return(itu.getRelative(rel));
}
/// <summary>
/// 注册新用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
//public static bool Register(Model.tab_relatives relative)
//{
// if (LoginIdExists(user.LoginId))
// {
// return false;
// }
// else
// {
// itu.RelativeAdd(relative);
// return true;
// }
//}
/// <summary>
/// 根据条件客户表的查寻
/// </summary>
/// <param name="rel"></param>
/// <returns></returns>
public DataTable RelativeSelect(Model.tab_relatives rel)
{
return(itu.RelativeSelect(rel));
}
/// <summary>
/// 客户表的添加
/// </summary>
/// <param name="relative"></param>
/// <returns></returns>
public int RelativeAdd(Model.tab_relatives relative)
{
return(itu.RelativeAdd(relative));
}
