private static int SelectCountByEmail(string Email)
{
var sql = $@"select count(*) from AskForm_EmailSendList where Recipient='{Email}' and IsDeleted=0 and FormID={setting.FormID}";
return(Convert.ToInt32(DB.ExecuteScalar(sql, true)));
}
/// <summary>
/// 为EntryText添加数据 根据EntryID、FieldID、Value
/// </summary>
/// <param name="EntryID"></param>
/// <param name="FieldID"></param>
/// <param name="Value"></param>
private static void AddValueForFieldName(long EntryID, long FieldID, string Value)
{
DB.ExecuteNonQuery($@"Insert Into AskForm_EntryText(EntryID, FieldID, Value, Point, FormID, FormApplicationID, CompanyID, IsDeleted, CreatedDate, ModifiedDate, CreatedUserID, ModifiedUserID)
Values({EntryID},{FieldID},'{Value}',0,{setting.FormID},{setting.FormApplicationID},{setting.CompanyID},0,getdate(),getdate(),0,0)");
}
/// <summary>
/// 重新发送邮件
/// </summary>
/// <param name="Email"></param>
private static void UpdateEmailToSending(string Email)
{
var sql = $@"update AskForm_EmailSendList set Status=1 where Recipient='{Email}' and IsDeleted=0 and FormID={setting.FormID}";
DB.ExecuteNonQuery(sql, true);
}