public bool Compare(T_Message value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Messages.Where(x => x.Active == value.Active && x.Code == value.Code && x.MessageAlert == value.MessageAlert).FirstOrDefault() == null ? true : false);
}
}
public void Save(T_Message value, ref string msg)
{
T_Message valueupdate = new T_Message();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_Messages.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Code: {1}" + Environment.NewLine + "Message: {2}" + Environment.NewLine + "Active: {3}", SystemProperties.MessageNotification.Saved, value.Code, value.MessageAlert, value.Active);
}
else
{
valueupdate = dc.T_Messages.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.MessageAlert = value.MessageAlert;
valueupdate.Active = value.Active;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Message: {1}" + Environment.NewLine + "Active: {2}", SystemProperties.MessageNotification.Updated, valueupdate.MessageAlert, valueupdate.Active);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
T_Message messageModel = new T_Message();
MessageBLL messageBLL = new MessageBLL();
messageModel.NickName = txb_NickName.Text.ToString().Trim();
messageModel.Grade = txb_Grade.Text.ToString().Trim();
messageModel.Sex = rbl_Sex.SelectedValue.ToString().Trim();
messageModel.Email = txb_Email.Text.ToString().Trim();
//messageModel.TeacherName = txb_TeacherName.Text.ToString().Trim();
//if(ddl_TeacherName.SelectedValue)
messageModel.TeacherName = ddl_TeacherName.SelectedValue.ToString().Trim();
messageModel.BriefQuestion = txb_BriefQuestion.Text.ToString().Trim();
messageModel.DetailQuestion = txb_DetailQuestion.Text.ToString().Trim();
messageModel.Reply = "";
messageModel.QuestionTime = DateTime.Now;
messageModel.ReplyTime = DateTime.Now;
messageModel.Category = 0; // 0为未分类
messageModel.Status = int.Parse(rbl_Reference.SelectedValue.ToString().Trim()); // 获取是否愿意展示给其他人
int insertResult = messageBLL.Insert(messageModel);
if (insertResult > 0)
{
Response.Write("<script>alert('提问成功，请等待邮件回复');location.href='qaonline.aspx'</script>");
//Response.Redirect("qaonline.aspx");
}
else
{
Response.Write("<script>alert('出了点问题请稍后再试');location.href=qaonline.aspx</script>");
//Response.Redirect("qaonline.aspx");
}
}
private void XSendEmail()
{
try
{
var message = new MailMessage(_mymail, txtemail.Text)
{
Subject = _subject, Body = _mailmsg
};
using (var mailer = new SmtpClient("smtp.gmail.com", 587))
{
mailer.Credentials = new NetworkCredential(_mymail, _mypassword);
mailer.EnableSsl = true;
mailer.Send(message);
}
}
catch
{
var t = new T_Message();
t.Show(this);
var ok = new Frm_OK
{
msgtxt = { Text = @"There is an error sending and email, ensure that the root mail is set up properly! and ensure that the application is not blocked by the firewall! And ensure that this PC has an internet connection!" },
OkDescription = "Warn",
titletxt = { Text = @"E-mail error" }
};
ok.ShowDialog();
t.Dispose();
// ignored
}
}
public ActionResult Message(T_Message m)
{
try
{
List <T_Message> li = dalobj.T_Message.ToList();
T_Message message = new T_Message();
message.MessageId = m.MessageId;
message.Name = m.Name;
message.Email = m.Email;
message.Message = m.Message;
dalobj.T_Message.Add(message);
dalobj.SaveChanges();
return(RedirectToAction("Index1", "Home"));
}
catch (Exception)
{
}
return(View());
}
private async void bunifuFlatButton2_Click(object sender, EventArgs e)
{
if (TranNum != null)
{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql = "Select * from tbl_Transaction_Detail where Inv_Num='" + TranNum + "' AND Prod_Number = '" + label2.Text + "'";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
Sqlreader = Sqlcmd.ExecuteReader();
//metroComboBox1.Items.Clear();
if (Sqlreader.Read())
{
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
var ms = new T_Message();
var ok = new Frm_OK();
ms.Show(this);
ok.OkDescription = "Warn";
ok.titletxt.Text = @"Warning";
ok.msgtxt.Text = @"This product is already in the cart. Are you trying to modify it's quantity? If so, please select set quantity option in the cart panel.";
ok.ShowDialog();
ms.Close();
Focus();
}
else
{
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
var b = new T_Transaction();
var a = new FrmAddToCart();
a.lblprodID.Text = label2.Text;
b.Show(this);
a.ShowDialog();
b.Dispose();
a.Dispose();
Focus();
}
}
else
{
var b = new T_Transaction();
var a = new FrmAddToCart();
a.lblprodID.Text = label2.Text;
b.Show(this);
a.ShowDialog();
//c.lblinvoice.Text = a.inv_num;
b.Dispose();
a.Dispose();
Focus();
}
}
private async Task Xaddmode()
{
Sqlcmd.Parameters.Clear();
Image temp = new Bitmap(bunifuPictureBox1.Image);
var strm = new MemoryStream();
temp.Save(strm,
ImageFormat.Jpeg);
_imagebytearray = strm.ToArray();
await Conopen();
Strsql =
"Insert into tbl_Products(Prod_Barcode, Prod_Name, Prod_Stock, Unit_Desc, Prod_Price,Prod_Img,production_Strt_date,cost_sale,cat_desc,prod_description,prod_FS,prod_exp_date) " +
"Values(@Prod_Barcode, @Prod_Name, @Prod_Stock, @Unit_Desc, @Prod_Price, @Prod_Img,@production_Strt_date,@cost_sale,@cat_desc,@prod_description,@prod_FS,@prod_exp_date)";
Sqlcmd.Parameters.AddWithValue("@Prod_Barcode",
bunifuTextBox2.Text);
Sqlcmd.Parameters.AddWithValue("@Prod_Name",
bunifuTextBox1.Text);
Sqlcmd.Parameters.AddWithValue("@Prod_Stock",
bunifuTextBox3.Text);
Sqlcmd.Parameters.AddWithValue("@Unit_Desc",
cmbounit.Text);
Sqlcmd.Parameters.AddWithValue("@Prod_Price",
bunifuTextBox4.Value);
Sqlcmd.Parameters.AddWithValue("@Prod_Img",
_imagebytearray);
Sqlcmd.Parameters.AddWithValue("@production_Strt_date",
psdstartdate.Value);
Sqlcmd.Parameters.AddWithValue("@cost_sale",
cost.Value);
Sqlcmd.Parameters.AddWithValue("@cat_desc",
category.Text);
Sqlcmd.Parameters.AddWithValue("@prod_description",
txtdesciption.Text);
Sqlcmd.Parameters.AddWithValue("@prod_FS",
prodFS);
Sqlcmd.Parameters.AddWithValue("@prod_exp_date",
dateTimePicker1.Value);
Sqlcmd.Connection = Cnn;
//sqlcmd.CommandType = CommandType.Text;
Sqlcmd.CommandText = Strsql;
Sqlcmd.ExecuteNonQuery();
var a = new T_Message();
var frmok = new Frm_OK();
a.Show(this);
frmok.titletxt.Text = @"Success";
frmok.msgtxt.Text =
@"Record has been successfully Added! Please refresh the products data to see modified changes.";
frmok.OkDescription = "Success";
frmok.ShowDialog(this);
a.Hide();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
Close();
}
private T_Message SetRoomType()
{
T_Message valueRet = new T_Message();
valueRet.ID = isAdd ? 0 : Convert.ToInt64(dgSMS.SelectedRows[0].Cells[0].Value.ToString());
valueRet.Code = txtCode.Text;
valueRet.MessageAlert = txtMessage.Text;
valueRet.Active = cbActive.Checked;
return(valueRet);
}
private async Task XAddCustomer()
{
Sqlcmd.Parameters.Clear();
Image temp = new Bitmap(bunifuPictureBox1.Image);
var strm = new MemoryStream();
temp.Save(strm,
ImageFormat.Jpeg);
_imagebytearray = strm.ToArray();
await Conopen();
Strsql =
"Insert into tbl_customer(cus_ID, cus_fname, cus_lname, cus_prefix, cus_address, cus_home_phone, cus_mobile,cus_email,cus_dob,cus_notes,cus_img) " +
"Values(@cus_ID, @cus_fname, @cus_lname, @cus_prefix, @cus_address, @cus_home_phone, @cus_mobile, @cus_email,@cus_dob,@cus_notes,@cus_img)";
Sqlcmd.Parameters.AddWithValue("@cus_ID",
_idNum);
Sqlcmd.Parameters.AddWithValue("@cus_fname",
txtfname.Text);
Sqlcmd.Parameters.AddWithValue("@cus_lname",
txtlname.Text);
Sqlcmd.Parameters.AddWithValue("@cus_prefix",
cmbprefix.Text);
Sqlcmd.Parameters.AddWithValue("@cus_address",
txtaddress.Text);
Sqlcmd.Parameters.AddWithValue("@cus_home_phone",
txthomephone.Text);
Sqlcmd.Parameters.AddWithValue("@cus_mobile",
txtmobilephone.Text);
Sqlcmd.Parameters.AddWithValue("@cus_email",
txtemail.Text);
Sqlcmd.Parameters.AddWithValue("@cus_dob",
dateTimePicker1.Value);
Sqlcmd.Parameters.AddWithValue("@cus_notes",
txtnotes.Text);
Sqlcmd.Parameters.AddWithValue("@cus_img",
_imagebytearray);
Sqlcmd.Connection = Cnn;
Sqlcmd.CommandText = Strsql;
Sqlcmd.ExecuteNonQuery();
var a = new T_Message();
var frmok = new Frm_OK();
a.Show(this);
frmok.titletxt.Text = @"Success";
frmok.msgtxt.Text =
@"Record has been successfully Added! Please refresh the customer data to see modified changes.";
frmok.OkDescription = "Success";
frmok.ShowDialog(this);
a.Hide();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
XCustomerLoaded = false;
Close();
}
public void Delete(T_Message value, ref string msg)
{
T_Message valuedelete = new T_Message();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Messages.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_Messages.DeleteOnSubmit(valuedelete);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Code: {1}" + Environment.NewLine + "Message: {2}" + Environment.NewLine + "Active: {3}", SystemProperties.MessageNotification.Deleted, valuedelete.Code, valuedelete.MessageAlert, valuedelete.Active);
dc.SubmitChanges();
}
}
/// <summary>
/// 根据留言编号修改留言内容
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(T_Message model)
{
StringBuilder sb = new StringBuilder();
sb.Append("update [T_Message] set ");
sb.Append("[NickName]=@NickName,");
sb.Append("[Grade]=@Grade,");
sb.Append("[Sex]=@Sex,");
sb.Append("[Email]=@Email,");
sb.Append("[TeacherName]=@TeacherName,");
sb.Append("[BriefQuestion]=@BriefQuestion,");
sb.Append("[DetailQuestion]=@DetailQuestion,");
sb.Append("[Reply]=@Reply,");
sb.Append("[QuestionTime]=@QuestionTime,");
sb.Append("[ReplyTime]=@ReplyTime,");
sb.Append("[Category]=@Category,");
sb.Append("[Status]=@Status");
sb.Append(" where [ID]=@ID");
SqlParameter[] sp =
{
new SqlParameter("@NickName", SqlDbType.NVarChar, 64),
new SqlParameter("@Grade", SqlDbType.NVarChar, 32),
new SqlParameter("@Sex", SqlDbType.NVarChar, 32),
new SqlParameter("@Email", SqlDbType.NVarChar, 64),
new SqlParameter("@TeacherName", SqlDbType.NVarChar, 64),
new SqlParameter("@BriefQuestion", SqlDbType.NVarChar, 128),
new SqlParameter("@DetailQuestion", SqlDbType.NVarChar, 1024),
new SqlParameter("@Reply", SqlDbType.NVarChar, 1024),
new SqlParameter("@QuestionTime", SqlDbType.DateTime),
new SqlParameter("@ReplyTime", SqlDbType.DateTime),
new SqlParameter("@Category", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@ID", SqlDbType.NVarChar, 64)
};
sp[0].Value = model.NickName;
sp[1].Value = model.Grade;
sp[2].Value = model.Sex;
sp[3].Value = model.Email;
sp[4].Value = model.TeacherName;
sp[5].Value = model.BriefQuestion;
sp[6].Value = model.DetailQuestion;
sp[7].Value = model.Reply;
sp[8].Value = model.QuestionTime;
sp[9].Value = model.ReplyTime;
sp[10].Value = model.Category;
sp[11].Value = model.Status;
sp[12].Value = model.ID;
return((int)SqlHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, sp));
}
private async void numericUpDown1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Enter)
{
var ok = new Frm_OK();
var a = new T_Message();
//try
//{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql =
"Update tbl_Transaction_Detail set Tran_D_Subtotal=@Tran_D_Subtotal, Disc=@Disc Where Prod_Number=@Prod_Number And Inv_Num=@Inv_Num";
Sqlcmd.Parameters.AddWithValue("@Tran_D_Subtotal", Convert.ToSingle(lblnewamount.Text));
Sqlcmd.Parameters.AddWithValue("@Disc", Convert.ToDecimal(lbldiscount.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_Num", inv_num);
Sqlcmd.Parameters.AddWithValue("@Prod_Number", proid);
Sqlcmd.Connection = Cnn;
//sqlcmd.CommandType = CommandType.Text;
Sqlcmd.CommandText = Strsql;
Sqlcmd.ExecuteNonQuery();
ok.OkDescription = "Success";
ok.titletxt.Text = @"Success";
ok.msgtxt.Text = @"Discount has been successfully added!";
a.Show(this);
ok.ShowDialog();
a.Hide();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
FillCart = true;
Hide();
//}
//catch (Exception ex)
//{
// a.Show(this);
// ok.titletxt.Text = @"Error";
// ok.msgtxt.Text = @"System has encountered an unexpected Error! Please contact the system developer relating to this problem.";
// ok.OkDescription = "Error";
// ok.ShowDialog(this);
// a.Hide();
// Focus();
// //call LogFile method and pass argument as Exception message, event name, control name, error line number, current form name
// LogFile(ex.Message, e.ToString(), ((Control)sender).Name, ex.LineNumber(), FindForm()?.Name);
//}
}
}
private async Task XTransaction()
{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql = "Select * from tbl_Transaction where Inv_Num like '" + inv_num + "'";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
DataTable sqlDt = new DataTable();
sqlDt.Reset();
Sqladapter.Fill(sqlDt);
Sqlreader = Sqlcmd.ExecuteReader();
//**************************************************
if (!Sqlreader.Read())
{
await XSaveTransaction();
await XSaveTransactionDetails();
}
else
{
await XSaveTransactionDetails();
}
var a = new T_Message();
var frmok = new Frm_OK();
a.Show(this);
frmok.titletxt.Text = @"Success";
frmok.msgtxt.Text =
@"Item successfully added to cart!";
frmok.OkDescription = "Success";
frmok.ShowDialog(this);
a.Hide();
//popup.TitleText = @"Success";
//popup.Image = Properties.Resources.check;
//popup.ContentText = @"The product "+ lblprodname.Text + " has been successfully added to cart!";
//popup.Popup();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
TranNum = inv_num;
FillCart = true;
Hide();
}
protected void btnSaveContinue_Click(object sender, EventArgs e)
{
// 1. 这里放置保存窗体中数据的逻辑
int messageID = int.Parse(Request.QueryString["id"].Trim());
List <T_Message> message = messageBLL.GetMessageById(messageID);
T_Message messageModel = new T_Message();
messageModel.ID = messageID;
messageModel.NickName = message[0].NickName;
messageModel.Grade = message[0].Grade;
messageModel.Sex = message[0].Sex;
messageModel.QuestionTime = message[0].QuestionTime;
messageModel.TeacherName = message[0].TeacherName;
messageModel.Email = message[0].Email;
messageModel.Category = int.Parse(ddl_Categpry.SelectedValue);
messageModel.Status = int.Parse(ddl_Status.SelectedValue);
messageModel.BriefQuestion = txa_BriefQuestion.Text.Trim();
messageModel.DetailQuestion = txa_DetailQuestion.Text.Trim();
messageModel.Reply = HtmlEditor1.Text.Trim();
messageModel.ReplyTime = DateTime.Now;
int result = messageBLL.Update(messageModel);
if (result > 0)
{
Alert alert = new Alert();
alert.Message = "处理成功";
alert.Target = Target.Top;
alert.Show();
}
else
{
Alert alert = new Alert();
alert.Message = "出现问题，请稍后再试";
alert.Target = Target.Top;
alert.Show();
}
// 2. 关闭本窗体，然后回发父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
/// <summary>
/// 插入一条留言数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(T_Message model)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into T_Message(NickName,Grade,Sex,Email,TeacherName,BriefQuestion,DetailQuestion,Reply,QuestionTime,ReplyTime,Category,Status)");
sb.Append(" values(@NickName,@Grade,@Sex,@Email,@TeacherName,@BriefQuestion,@DetailQuestion,@Reply,@QuestionTime,@ReplyTime,@Category,@Status)");
SqlParameter[] sp =
{
new SqlParameter("@NickName", SqlDbType.NVarChar, 64),
new SqlParameter("@Grade", SqlDbType.NVarChar, 32),
new SqlParameter("@Sex", SqlDbType.NVarChar, 32),
new SqlParameter("@Email", SqlDbType.NVarChar, 64),
new SqlParameter("@TeacherName", SqlDbType.NVarChar, 64),
new SqlParameter("@BriefQuestion", SqlDbType.NVarChar, 128),
new SqlParameter("@DetailQuestion", SqlDbType.NVarChar, 1024),
new SqlParameter("@Reply", SqlDbType.NVarChar, 1024),
new SqlParameter("@QuestionTime", SqlDbType.DateTime),
new SqlParameter("@ReplyTime", SqlDbType.DateTime),
new SqlParameter("@Category", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int)
};
sp[0].Value = model.NickName;
sp[1].Value = model.Grade;
sp[2].Value = model.Sex;
sp[3].Value = model.Email;
sp[4].Value = model.TeacherName;
sp[5].Value = model.BriefQuestion;
sp[6].Value = model.DetailQuestion;
sp[7].Value = model.Reply;
sp[8].Value = model.QuestionTime;
sp[9].Value = model.ReplyTime;
sp[10].Value = model.Category;
sp[11].Value = model.Status;
string sql = sb.ToString();
return((int)SqlHelper.ExecuteNonQuery(sql, CommandType.Text, sp));
}
public List <T_Message> DataTableToList(DataTable dt)
{
List <T_Message> list = new List <T_Message>();
int rowCount = dt.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
T_Message model = new T_Message();
if (dt.Rows[i]["ID"] != null)
{
model.ID = (int)dt.Rows[i]["ID"];
}
if (dt.Rows[i]["NickName"] != null)
{
model.NickName = dt.Rows[i]["NickName"].ToString();
}
if (dt.Rows[i]["Grade"] != null)
{
model.Grade = dt.Rows[i]["Grade"].ToString();
}
if (dt.Rows[i]["Sex"] != null)
{
model.Sex = dt.Rows[i]["Sex"].ToString();
}
if (dt.Rows[i]["Email"] != null)
{
model.Email = dt.Rows[i]["Email"].ToString();
}
if (dt.Rows[i]["TeacherName"] != null)
{
model.TeacherName = dt.Rows[i]["TeacherName"].ToString();
}
if (dt.Rows[i]["BriefQuestion"] != null)
{
model.BriefQuestion = dt.Rows[i]["BriefQuestion"].ToString();
}
if (dt.Rows[i]["DetailQuestion"] != null)
{
model.DetailQuestion = dt.Rows[i]["DetailQuestion"].ToString();
}
if (dt.Rows[i]["Reply"] != null)
{
model.Reply = dt.Rows[i]["Reply"].ToString();
}
if (dt.Rows[i]["QuestionTime"] != null)
{
model.QuestionTime = (DateTime)dt.Rows[i]["QuestionTime"];
}
if (dt.Rows[i]["ReplyTime"] != null)
{
model.ReplyTime = (DateTime)dt.Rows[i]["ReplyTime"];
}
if (dt.Rows[i]["Category"] != null)
{
model.Category = (int)dt.Rows[i]["Category"];
}
if (dt.Rows[i]["Status"] != null)
{
model.Status = (int)dt.Rows[i]["Status"];
}
list.Add(model);
}
return(list);
}
private async void bunifuFlatButton2_Click(object sender, EventArgs e)
{
var ok = new Frm_OK();
var a = new T_Message();
if (bunifuTextBox1.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter Product name!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox1.Focus();
}
else if (bunifuTextBox3.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter Product Stock!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox3.Focus();
}
else if (cmbounit.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Select Product's Unit description!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
cmbounit.Focus();
}
else if (bunifuTextBox4.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Select Product's Unit price!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox4.Focus();
}
else
{
if (_PAdd)
{
try
{
if (bunifuCheckBox2.Checked)
{
await Xaddmode();
}
else
{
await Xaddmode1();
}
}
catch (Exception ex)
{
a.Show(this);
ok.titletxt.Text = "Error";
ok.msgtxt.Text = "System has encountered an unexpected Error! Please contact the system developer relating to this problem.";
ok.OkDescription = "Error";
ok.ShowDialog(this);
a.Hide();
Focus();
LogFile(ex.Message, e.ToString(), ((Control)sender).Name, ex.LineNumber(), FindForm()?.Name);
}
}
}
}
public int Update(T_Message model)
{
return(dal.Update(model));
}
private async void bunifuFlatButton2_Click(object sender, EventArgs e)
{
var a = new T_Message();
if (bunifuTextBox5.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter your full name!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox5.Focus();
}
else if (bunifuTextBox6.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter your address!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox6.Focus();
}
else if (bunifuTextBox7.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter your contact number!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox7.Focus();
}
else if (cmbodesig.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please your designation!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
cmbodesig.Focus();
}
else if (bunifuTextBox4.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter your unique user name!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox4.Focus();
}
else if (bunifuTextBox3.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = "Warning" },
OkDescription = "Warn",
msgtxt = { Text = "Please Enter your password!" }
};
a.Show(this);
frmok.ShowDialog();
a.Hide();
Focus();
bunifuTextBox3.Focus();
}
else
{
await XSignUp();
}
}
public int Insert(T_Message model)
{
return(dal.Insert(model));
}
private async void bunifuFlatButton2_Click(object sender, EventArgs e)
{
var a = new T_Message();
if (txtfname.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please enter customer's first name!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
txtfname.Focus();
}
else if (txtlname.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please enter customer's last name!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
txtlname.Focus();
}
else if (cmbprefix.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please select customer's preferred prefix!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
cmbprefix.Focus();
}
else if (txtaddress.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please enter customer's address!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
txtaddress.Focus();
}
else if (txtmobilephone.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please enter customer's mobile number!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
txtmobilephone.Focus();
}
else if (txtemail.Text == "")
{
var frmok = new Frm_OK
{
titletxt = { Text = @"Warning" },
OkDescription = "Warn",
msgtxt = { Text = @"Please enter customer's valid e-mail address!" }
};
a.Show(this);
frmok.ShowDialog();
a.Dispose();
Focus();
txtemail.Focus();
}
else
{
await XGen_ID();
await XAddCustomer();
XSendEmail();
}
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
// 1. 这里放置保存窗体中数据的逻辑
int messageID = int.Parse(Request.QueryString["id"].Trim());
List <T_Message> message = messageBLL.GetMessageById(messageID);
T_Message messageModel = new T_Message();
try
{
#region 邮件信息
MailMessage mail = new MailMessage();
mail.To.Add(new MailAddress(message[0].Email));
mail.From = new MailAddress(txb_ReplyEmailAddress.Text.Trim(), "武汉理工大学心理健康平台", System.Text.Encoding.UTF8);
string _body = "";
string _subject = "回复：" + txa_BriefQuestion.Text.Trim();
_body = HtmlEditor1.Text + "<br/><br/>******************************************************" + "<br/>" +
"这是一封系统自动发送的邮件通知，请不要直接回复，如有疑问，请联系管理员。" + "<br/>" +
"<br/>请添加本邮箱为联系人，以便于即时收到邮件通知。祝 学习生活愉快！";
mail.Body = _body;
mail.Subject = _subject;
mail.Priority = MailPriority.High;
mail.IsBodyHtml = true;
//mail.BodyEncoding = System.Text.Encoding.UTF8;
#endregion
#region 发送方服务器信息
SmtpClient smtp = new SmtpClient();
if (txb_ReplyEmailAddress.Text.Trim().IndexOf("@126.com") >= 0)
{
smtp.Host = "smtp.126.com";
}
//smtp.UseDefaultCredentials = true;
//smtp.EnableSsl = true;
string mailFromAddress = txb_ReplyEmailAddress.Text.Split(new char[] { '@' })[0];
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", txb_ReplyEmailPwd.Text.Trim());
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Port = 25;
//smtp.Send(mail); //同步发送程序将被阻塞
#endregion
#region 异步发送邮件 判断发送状态
smtp.SendCompleted += new SendCompletedEventHandler(SendCompletedCallBack);
string userState = "测试";
smtp.SendAsync(mail, userState);
#endregion
}
catch
{
throw;
}
#region 保存至数据库
messageModel.ID = messageID;
messageModel.NickName = message[0].NickName;
messageModel.Sex = message[0].Sex;
messageModel.Email = message[0].Email;
messageModel.Grade = message[0].Grade;
messageModel.TeacherName = message[0].TeacherName;
messageModel.BriefQuestion = txa_BriefQuestion.Text.Trim();
messageModel.DetailQuestion = txa_DetailQuestion.Text.Trim();
messageModel.QuestionTime = message[0].QuestionTime;
messageModel.Reply = HtmlEditor1.Text.Trim();
messageModel.ReplyTime = DateTime.Now;
messageModel.Category = 0;
if (HtmlEditor1.Text.Trim() != "")
{
messageModel.Status = 1;
}
int result = messageBLL.Update(messageModel);
if (result > 0)
{
Alert alert = new Alert();
alert.Message = "回复成功";
alert.Target = Target.Top;
alert.Show();
}
else
{
Alert alert = new Alert();
alert.Message = "出现错误 请稍后再试";
alert.Target = Target.Top;
alert.Show();
}
#endregion
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
