/// <summary>
/// 添加简历
/// </summary>
/// <param name="resume"></param>
/// <returns></returns>
public static bool AddResume(Resume resume)
{
if (resume == null)
{
return(false);
}
StringBuilder sb = new StringBuilder();
sb.Append("insert into resume (name,mobile,email,school,education,workyear,companynow,positionnow,area,position,summary,posttime)");
sb.Append(" values (@name,@mobile,@email,@school,@education,@workyear,@companynow,@positionnow,@area,@position,@summary,@posttime)");
SqlParameter[] para =
{
new SqlParameter("@name", resume.Name),
new SqlParameter("@mobile", resume.Mobile),
new SqlParameter("@email", resume.Email),
new SqlParameter("@school", resume.School),
new SqlParameter("@education", resume.Education),
new SqlParameter("@workyear", resume.WorkYear),
new SqlParameter("@companynow", resume.CompanyNow),
new SqlParameter("@positionnow", resume.PositionNow),
new SqlParameter("@area", resume.Area),
new SqlParameter("@position", resume.Position),
new SqlParameter("@summary", resume.Summary),
new SqlParameter("@posttime", resume.PostTime)
};
int n = MsSQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, para);
if (n == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 判断是否有发送记录
/// </summary>
/// <param name="dt">农历日期</param>
/// <returns>True:有，false：无</returns>
public static bool CheckHasSend(DateTime dt)
{
string d = dt.Year + "/" + string.Format("{0:00}", dt.Month) + "/" + string.Format("{0:00}", dt.Day);
string sb = "select count(*) from logs where CONVERT(VARCHAR(32),sendtime,111) like '" + d + "%'";
int n = Convert.ToInt32(MsSQLHelper.ExecuteScalar(sb));
if (n > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 添加发送日志到数据库
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static bool Add()
{
Model.Log log = new Model.Log();
StringBuilder sb = new StringBuilder();
sb.Append("insert into logs (sendtime) values (@sendtime)");
SqlParameter[] paras =
{
new SqlParameter("@sendtime", log.SendTime)
};
int n = MsSQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, paras);
if (n == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 获取发送记录列表
/// </summary>
/// <returns></returns>
public static DataTable GetLogList()
{
StringBuilder sb = new StringBuilder();
sb.Append("select id,sendtime,remark from logs");
DataTable dt = MsSQLHelper.ExecuteDataTable(sb.ToString());
//不知道当时为什么要写成字典，现在改回来 --20161114
//Dictionary<int, DateTime> dict = new Dictionary<int, DateTime>();
//if (dt.Rows.Count > 0) {
// foreach (DataRow item in dt.Rows) {
// dict.Add(Convert.ToInt32(item["id"]), Convert.ToDateTime(item["sendtime"]));
// }
// return dict;
//}
if (dt.Rows.Count > 0)
{
return(dt);
}
return(null);
}
