/// <summary>
/// 根据ID查询所对应的回访记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Tz888.Model.Visit.VisitInfoModel SelVisit(string name)
{
Tz888.Model.Visit.VisitInfoModel visit = new Tz888.Model.Visit.VisitInfoModel();
string sql = "select Valid,Mobile,Email,Disposition,Caption,Remark,VisitNew,VisitTime from VisitInfoTab where LoginName=@name";
SqlParameter[] para =
{
new SqlParameter("@name", SqlDbType.VarChar, 20)
};
para[0].Value = name;
DataSet ds = DbHelperSQL.Query(sql, para);
if (ds != null & ds.Tables[0].Rows.Count > 0)
{
visit.Valid = Convert.ToInt32(ds.Tables[0].Rows[0]["Valid"].ToString());
visit.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
visit.Email = ds.Tables[0].Rows[0]["Email"].ToString();
visit.Disposition = ds.Tables[0].Rows[0]["Disposition"].ToString();
visit.Caption = ds.Tables[0].Rows[0]["Caption"].ToString();
visit.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
visit.VisitNew = Convert.ToInt32(ds.Tables[0].Rows[0]["VisitNew"].ToString());
visit.VisitTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["VisitTime"].ToString());
}
return(visit);
}
/// <summary>
/// 修改回访记录
/// </summary>
/// <param name="visit"></param>
/// <param name="id"></param>
/// <returns></returns>
public int ModfiyVisit(Tz888.Model.Visit.VisitInfoModel visit, string name)
{
string sql = "update VisitInfoTab set Valid=@Valid,Mobile=@Mobile,Email=@Email,Disposition=@Disposition,Caption=@Caption,"
+ "Remark=@Remark,VisitNew=@VisitNew,VisitTime=@VisitTime where LoginName=@name";
SqlParameter[] para =
{
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@Valid", SqlDbType.Int, 10),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Disposition", SqlDbType.VarChar, 20),
new SqlParameter("@Caption", SqlDbType.VarChar, 5000),
new SqlParameter("@Remark", SqlDbType.VarChar, 5000),
new SqlParameter("@VisitNew", SqlDbType.Int, 4),
new SqlParameter("VisitTime", SqlDbType.DateTime, 50)
};
para[0].Value = name;
name = visit.LoginName;
para[1].Value = visit.Valid;
para[2].Value = visit.Mobile;
para[3].Value = visit.Email;
para[4].Value = visit.Disposition;
para[5].Value = visit.Caption;
para[6].Value = visit.Remark;
para[7].Value = visit.VisitNew;
para[8].Value = visit.VisitTime;
object num = DbHelperSQL.GetSingle(sql, para);
if (num == null)
{
return(0);
}
else
{
return(Convert.ToInt32(num));
}
}
/// <summary>
/// 添加回访记录
/// </summary>
/// <param name="visit"></param>
/// <returns></returns>
public int AddVisit(Tz888.Model.Visit.VisitInfoModel visit)
{
string sql = "insert into VisitInfoTab(LoginName,Valid,Mobile,Email,Disposition,Caption,Remark,VisitNew,VisitTime) values "
+ "(@LoginName,@Valid,@Mobile,@Email,@Disposition,@Caption,@Remark,@VisitNew,@VisitTime)";
SqlParameter[] para =
{
new SqlParameter("@LoginName", SqlDbType.VarChar, 20),
new SqlParameter("@Valid", SqlDbType.Int, 4),
new SqlParameter("@Mobile", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Disposition", SqlDbType.VarChar, 20),
new SqlParameter("@Caption", SqlDbType.VarChar, 5000),
new SqlParameter("@Remark", SqlDbType.VarChar, 5000),
new SqlParameter("@VisitNew", SqlDbType.Int, 4),
new SqlParameter("@VisitTime", SqlDbType.DateTime, 100)
};
para[0].Value = visit.LoginName;
para[1].Value = visit.Valid;
para[2].Value = visit.Mobile;
para[3].Value = visit.Email;
para[4].Value = visit.Disposition;
para[5].Value = visit.Caption;
para[6].Value = visit.Remark;
para[7].Value = visit.VisitNew;
para[8].Value = visit.VisitTime;
object name = DbHelperSQL.GetSingle(sql, para);
if (name == null)
{
return(0);
}
else
{
return(Convert.ToInt32(name));
}
}
/// <summary>
/// 添加回访记录
/// </summary>
/// <param name="visit"></param>
/// <returns></returns>
public int AddVisit(Tz888.Model.Visit.VisitInfoModel visit)
{
return(dal.AddVisit(visit));
}
/// <summary>
/// 修改回访记录
/// </summary>
/// <param name="visit"></param>
/// <param name="id"></param>
/// <returns></returns>
public int ModfiyVisit(Tz888.Model.Visit.VisitInfoModel visit, string name)
{
return(dal.ModfiyVisit(visit, name));
}