// GET: api/TestTour/5
public Tour Get(string ToursType, string Country = "TW", int?LineLevel = 0, string BuType = "T", int ShowType = 1, string LineID = "", string TravelID = "", string WebAreaID = "", int PageStart = 0, int PageCount = 0)
{
string strLine = string.Empty;
string strwhere = string.Empty;
if (ToursType == TT.NEW.ToString())
{
strwhere = "and hspd10_line <> 9";
}
if (ToursType == TT.NEWDOM.ToString())
{
strwhere = "and hspd10_line=9";
}
DynamicParameters sqlParm = new DynamicParameters();
sqlParm.Add("@Country", Country);
sqlParm.Add("@BuType", BuType);
string sqlQuery = @"select hspd10_line AS LineID,hspd10_line_nm AS LineName,hspd10_travel AS TravelID,hspd10_travel_nm AS TravelName,hspd10_webarea AS WebAreaID, hspd10_warea_nm AS WebAreaName from [dbo].[hspdm10] where hspd10_bu=@BuType and hspd10_country=@Country {0} ";
using (var conn = SQLFunc.OpenConnection(DBList.LionAction))
{
sqlQuery = string.Format(sqlQuery, strwhere);
return(conn.Query <Tour>(sqlQuery, sqlParm).FirstOrDefault());
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
//測試用
//txt_Sentence.Text = "我相信已有不少台中市民反應過這個問題。";
string sentence = txt_Sentence.Text;
string DM_ID = hid_DM_ID.Value;
string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
if (!string.IsNullOrEmpty(sentence))
{
dialogHelper.Get_Dialog_Detail(DM_ID, sentence, now_date);
}
JiebaExecute jiebaExecute = new JiebaExecute();
jiebaExecute.Get_Dialog_Detail_to_Jieba(DM_ID);
DataTable dt = SQLFunc.Get_DIALOG_MAIN(DM_ID);
Page_Bind(dt);
txt_Sentence.Text = "";
lv_Dialog.DataBind();
}
public IEnumerable <Product> GetAllProducts()
{
string sqlExecute = string.Empty;
List <Product> ProductList = new List <Product>();
try
{
#region SQL 語法
sqlExecute = @"select * from Product ";
#endregion SQL 語法
#region SQL 執行
using (var conn = SQLFunc.OpenConnection(DBList.Test))
{
ProductList = conn.Query <Product>(sqlExecute).ToList();
}
var builder = new ODataConventionModelBuilder()
{
Namespace = "Default"
};
builder.EntitySet <Product>("Products");
var model = builder.GetEdmModel();
return(ProductList.AsQueryable());
#endregion
}
catch (Exception ex)
{
}
return(ProductList.AsQueryable());
}
protected void Page_Load(object sender, EventArgs e)
{
//測試用
//DIALOG_USER data_User = SQLFunc.Get_DIALOG_USER("1", "Athena", "192.168.7.127", "2017-03-23 14:29:15.647");
//Session["DIALOG_USER"] = data_User;
if (!IsPostBack)
{
txt_Sentence.Attributes.Add("onkeydown", "if(event.keyCode == 13) {document.getElementById('" + btn_Submit.ClientID + "').click(); return false;}");
}
if (Session["DIALOG_USER"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
MotionClass.DIALOG_USER DIALOG_USER = (MotionClass.DIALOG_USER)Session["DIALOG_USER"];
if (Request["DM_ID"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
string DM_ID = Request["DM_ID"].ToString();
DataTable dt = SQLFunc.Get_DIALOG_MAIN(DM_ID);
Page_Bind(dt);
ll_Name.Text = DIALOG_USER.U_Name;
}
}
//ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "scrollTo", "window.scrollTo(0,document.body.scrollHeight);alert('aa');", true);
}
private void jieba_execute(string sentence, string DD_ID, string DM_ID)
{
var data_detail = Get_Motion_DialogDetail(sentence, DD_ID);
var data_main = Get_Motion_DialogMain(DM_ID, data_detail);
//更新對話內容
SQLFunc.Upd_DIALOG_DETAIL(data_detail);
SQLFunc.Upd_DIALOG_MAIN(data_main);
}
public void Get_Dialog_Detail_to_Jieba(string DM_ID)
{
DataTable dt_DD = SQLFunc.Get_DIALOG_DETAIL_By_DD_Type("0");
if (dt_DD.Rows.Count > 0)
{
for (int i = 0; i < dt_DD.Rows.Count; i++)
{
jieba_execute(dt_DD.Rows[i]["DD_Sentence"].ToString(), dt_DD.Rows[i]["DD_ID"].ToString(), DM_ID);
}
}
}
public DepositRateDecrease(SQLFunc sql, Hashtable TblData)
{
InitializeComponent();
List <SQLFunc.SubResults> data = sql.GetData(TblData["pCur"].ToString(), "*");
for (int i = 0; i < data.Count; i++)
{
currencyBox.Items.Add(data[i]._SubResults[0].ToString());
}
this.sql = sql;
this.DecreaseRateTable = TblData["DepositRateDecrease"].ToString();
}
protected void On_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e)
{
var cmd = e.CommandName;
var arg = e.CommandArgument.ToString();
string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string DF_ID = "";
string DF_DDID = cmd;
string DF_Type = arg;
MotionClass.DIALOG_FEEDBACK data_DF = SQLFunc.Get_DIALOG_FEEDBACK(DF_ID, DF_DDID, DF_Type, now_date);
SQLFunc.Add_DIALOG_FEEDBACK(data_DF);
lv_Dialog.DataBind();
}
private void validateBtn_Click(object sender, EventArgs e)
{
SQLFunc mySql = new SQLFunc(ServerAddress, Database);
mySql.Err += MySql_Err;
mySql.Connect();
SQLFunc.SubResults myData = mySql.Get1Data("Login", "Password", "Login='******'");
if (myData == null || myData._SubResults.Count == 0)
{
MessageBox.Show("Wrong Login");
NbMissed++;
if (NbMissed == 3)
{
Random _check = new Random();
Result = Result = (int)Math.Round((double)_check.Next(1000), 0);
this.Hide();
}
}
else
{
string pwd = (string)myData._SubResults[0];
if (!pwd.Equals(passwordBox.Text))
{
MessageBox.Show("Wrong Password");
NbMissed++;
if (NbMissed == 3)
{
Random _check = new Random();
Result = (int)Math.Round((double)_check.Next(1000), 0);
this.Hide();
}
}
else
{
Result = Thread.CurrentThread.ManagedThreadId;
this.Hide();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = SQLFunc.Get_FB_Message_List("0");
JiebaExecute jiebaExecute = new JiebaExecute();
string DM_ID = "1";
string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
for (int i = 0; i < dt.Rows.Count; i++)
{
string sentence = jiebaExecute.MakePlainText(dt.Rows[i]["Message"].ToString());
string id = dt.Rows[i]["id"].ToString();
dialogHelper.Get_Dialog_Detail(DM_ID, sentence, now_date);
jiebaExecute.Get_Dialog_Detail_to_Jieba(DM_ID);
SQLFunc.Update_FB_Message_Dialog_Chk(id);
}
}
public ChangeDBParam(string TPTbl, SQLFunc sql, ParameterToChange param, string CountryTbl = "", string SectorTbl = "", string SubSectorTbl = "")
{
InitializeComponent();
this.TPTbl = TPTbl;
this.sql = sql;
this.sql.Err += Sql_Err;
switch (param)
{
case ParameterToChange.ThirdParty:
this.Text = "Change Third Party data";
break;
case ParameterToChange.Auditor:
this.Text = "Change Auditor data";
break;
case ParameterToChange.CoinParams:
this.Text = "Change Coin Params";
dataGrid.AllowUserToAddRows = false;
dataGrid.AllowUserToDeleteRows = false;
IsCoinParams = true;
break;
case ParameterToChange.RiskTests:
this.Text = "Change Risk Tests";
dataGrid.CellValueChanged += DataGrid_CellValueChanged;
dataGrid.RowsAdded += DataGrid_RowsAdded;
IsRiskTests = true;
break;
}
this.CountryTbl = CountryTbl;
this.SectorTbl = SectorTbl;
this.SubSectorTbl = SubSectorTbl;
SetGrid();
GetTblData();
}
public MainWdw()
{
CultureInfo.DefaultThreadCurrentCulture = CultureInfo.GetCultureInfo("en-US");
InitializeComponent();
/*Thread myThread = Thread.CurrentThread;
*
* LoginWdw login = new LoginWdw(ServerAddress, Database);
* login.ShowDialog();
*
* if(login == null || login.Result != myThread.ManagedThreadId) { LoginFailed = true; }*/
mySQL = new SQLFunc(ServerAddress, Database);
mySQL.Err += MySQL_Err;
mySQL.Connect();
SetTables();
SetCoinParams();
UpdateProjectInScope();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txt_Name.Attributes.Add("onkeydown", "if(event.keyCode == 13) {document.getElementById('" + btn_Save.ClientID + "').click(); return false;}");
string ip_string = GetClientIP();
lb_IP.Text = ip_string;
DataTable dt = SQLFunc.Get_DIALOG_USER(ip_string);
if (dt.Rows.Count > 0)
{
txt_Name.Text = dt.Rows[0]["U_Name"].ToString();
hid_U_ID.Value = dt.Rows[0]["U_ID"].ToString();
MotionClass.DIALOG_USER data = SQLFunc.Get_DIALOG_USER(dt.Rows[0]["U_ID"].ToString(), dt.Rows[0]["U_Name"].ToString(), dt.Rows[0]["U_IP"].ToString(), dt.Rows[0]["U_CreateTime"].ToString());
Session["DIALOG_USER"] = data;
}
else
{
Session.Clear();
}
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
MotionClass.DIALOG_USER data = null;
string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string name = txt_Name.Text;
if (string.IsNullOrEmpty(name))
{
Alert_msg("交出名字，饒你一命");
}
else
{
if (name == "gis@5200")
{
data = SQLFunc.Get_DIALOG_USER("", "Manager", lb_IP.Text, now_date);
Session["DIALOG_USER"] = data;
Response.Redirect("~/Page/Summary.aspx");
}
else
{
if (Session["DIALOG_USER"] == null)
{
data = SQLFunc.Get_DIALOG_USER("", name, lb_IP.Text, now_date);
string U_ID = SQLFunc.Add_DIALOG_USER(data);
data = SQLFunc.Get_DIALOG_USER(U_ID, name, lb_IP.Text, now_date);
Session["DIALOG_USER"] = data;
}
MotionClass.DIALOG_USER data_USER = (MotionClass.DIALOG_USER)Session["DIALOG_USER"];
MotionClass.DIALOG_MAIN data_Main = SQLFunc.Get_DIALOG_MAIN(data_USER.U_ID, "0", now_date);
string DM_ID = SQLFunc.Add_DIALOG_MAIN(data_Main);
//string DM_ID = "1";
Response.Redirect("Page/Dialog.aspx?DM_ID=" + DM_ID);
}
}
}
private MotionClass.DIALOG_DETAIL.REPLY Get_Motion_DialogDetail(string sentence, string DD_ID)
{
//正面辭典
Dictionary <string, int> HappyDic = new Dictionary <string, int>();
//負面辭典
Dictionary <string, int> SadDict = new Dictionary <string, int>();
//正面分數
int GoodVal = 0;
//負面分數
int BadVal = 0;
List <MotionClass.MotionWords> GoodList = new List <MotionClass.MotionWords>();
List <MotionClass.MotionWords> BadList = new List <MotionClass.MotionWords>();
MotionClass.MotionResult results = new MotionClass.MotionResult();
var segmenter = new JiebaSegmenter();
var userDictPath = ConfigurationManager.AppSettings["UserDictFile"];
segmenter.LoadUserDict(userDictPath);
//segmenter.LoadUserDict(@"D:\\Practise\\Study\\Jieba.dict\\new_dict.txt");
// ============== 正面用語 =================
DataTable feelGood = SQLFunc.Get_Sort_Good(); //Get_Excel("Sort_Good");
for (int i = 0; i < feelGood.Rows.Count; i++)
{
HappyDic.Add(feelGood.Rows[i]["S_Word"].ToString(), int.Parse(feelGood.Rows[i]["S_Score"].ToString()));
}
// ============== 負面用語 =================
DataTable feelBad = SQLFunc.Get_Sort_Bad(); //Get_Excel("Sort_Bad");
for (int i = 0; i < feelBad.Rows.Count; i++)
{
SadDict.Add(feelBad.Rows[i]["S_Word"].ToString(), int.Parse(feelBad.Rows[i]["S_Score"].ToString()));
}
var tokens = segmenter.Cut(sentence);
foreach (var token in tokens)
{
if (HappyDic.ContainsKey(token))
{
int ss = HappyDic[token];
MotionClass.MotionWords wg = new MotionClass.MotionWords();
wg.Terms = token;
wg.Scores = ss;
GoodList.Add(wg);
GoodVal += ss;
}
if (SadDict.ContainsKey(token))
{
int ss = SadDict[token];
MotionClass.MotionWords wg = new MotionClass.MotionWords();
wg.Terms = token;
wg.Scores = ss;
BadList.Add(wg);
BadVal += ss;
}
}
if (GoodVal > BadVal)
{
results.Judgment = "正面";
}
else if (BadVal > GoodVal)
{
results.Judgment = "負面";
}
else
{
results.Judgment = "中立";
}
results.Good = GoodVal;
results.Bad = BadVal;
results.Good_Term = GoodList;
results.Bad_Term = BadList;
string jsonData = JsonParse.Json(results);
string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
float score = GoodVal - BadVal;
MotionClass.DIALOG_DETAIL.REPLY data = new MotionClass.DIALOG_DETAIL.REPLY();
data.DD_ID = DD_ID;
data.DD_Type = "3";
data.DD_Motion = (score).ToString();
data.DD_Reply = jsonData;
data.DD_Bad = results.Bad.ToString();
data.DD_Bad_Term = JsonParse.Json_word(results.Bad_Term);
data.DD_Good = results.Good.ToString();
data.DD_Good_Term = JsonParse.Json_word(results.Good_Term);
data.DD_Judgment = results.Judgment;
data.DD_UpdateTime = now_date;
return(data);
}
public void Get_Dialog_Detail(string DM_ID, string sentence, string now_date)
{
MotionClass.DIALOG_DETAIL.ASK data_ask = SQLFunc.Get_DIALOG_DETAIL(DM_ID, "0", sentence, now_date, now_date);
SQLFunc.Add_DIALOG_DETAIL(data_ask);
}
//用int 參數 串入 where in(SqlCommand 方式用)
public string GetCommand(int d)
{
CommittableTransaction ct = new CommittableTransaction();
string outString = string.Empty;
try
{
SqlCommand cmd = new SqlCommand();
//加入 System.Transactions.dll, v4.0.0.0 參考
string strQuery = string.Empty;
string strIn = string.Empty;
#region SQL 執行
using (var con = SQLFunc.OpenConnection(DBList.LionExAPIDB))
{
string dd = "1,2,3";
con.EnlistTransaction(ct);
cmd.Connection = con;
List <string> list = new List <string>();
int intN = 0;
foreach (string item in dd.Split(','))
{
//SqlParameter parameter = new SqlParameter("@dd" + intN, SqlDbType.Int, 50, item);
//parameter.IsNullable = true;
//parameter.Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@dd" + intN, System.Data.DbType.Int32).Value = item;
strIn += "@dd" + intN;
cmd.Parameters.Add(strIn, SqlDbType.Int).Value = item;
list.Add(item);
intN++;
}
strQuery = string.Format("select createname from [dbo].[Application] where id in ({0});", string.Join(",", list.ToArray()));
cmd.CommandText = strQuery;
var Data = cmd.ExecuteReader();
while ((Data.Read()))
{
//5.判斷資料列是否為空
if (!Data[0].Equals(DBNull.Value))
{
outString = Data[0].ToString();
}
}
}
#endregion
ct.Commit();
}
catch (Exception e)
{ ct.Rollback(); }
return(outString);
}
