private void SimpleButton_Click(object sender, RoutedEventArgs e)
{
var btn = sender as SimpleButton;
switch (btn.Uid)
{
case "0":
GetDefaultData();
break;
case "1":
try
{
SetDefaultData();
}
catch (Exception ex)
{
Log4Helper.Error(GetType(), "设置数据异常！", ex);
throw;
}
break;
case "2":
string log = MySqlHelperClass.ConnectTest(ServerIP.Text, ServerPort.Text, Database.Text, User.Text, Password.Text);
DXMessageBox.Show(log == null ? "连接成功！" : log, "提示", MessageBoxButton.OK, MessageBoxImage.Information);
break;
default:
break;
}
}
/// <summary>
/// 创建故障单
/// </summary>
/// <param name="fdm"></param>
/// <returns></returns>
public static bool CreateOrder(FaultDataModel fdm, FaultType _type, bool _IsInsert)
{
string sql = string.Empty;
int rows = 0;
//只有当未接听的时候才插入，否则都是更新
#region postgreSQL
/*
* if (_IsInsert)
* {
* sql = "insert into call_log(date,start_time,during_time,phone,note,file_path,line_no,chan_id,user_id,asset_type_id,breakdown_categ,company_id,address,state,work_property,department_id,knowledge_id,note_result,source_id)" +
* " values(@date,@start_time,@during_time,@phone,@note,@file_path,@line_no,@chan_id,@user_id,@asset_type_id,@breakdown_categ,@company_id,@address,@state,@work_property,@department_id,@knowledge_id,@note_result,@source_id)";
* NpgsqlParameter[] para = {
* new NpgsqlParameter("@date", NpgsqlDbType.Date),
* new NpgsqlParameter("@start_time",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@during_time", NpgsqlDbType.Varchar),
* new NpgsqlParameter("@phone",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@note", NpgsqlDbType.Varchar),
* new NpgsqlParameter("@file_path", NpgsqlDbType.Varchar),
* new NpgsqlParameter("@line_no", NpgsqlDbType.Varchar),
* new NpgsqlParameter("@chan_id",NpgsqlDbType.Integer),
* new NpgsqlParameter("@user_id", NpgsqlDbType.Integer),
* new NpgsqlParameter("@asset_type_id",NpgsqlDbType.Integer),
* new NpgsqlParameter("@breakdown_categ",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@company_id",NpgsqlDbType.Integer),
* new NpgsqlParameter("@address",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@state",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@work_property",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@department_id",NpgsqlDbType.Integer),
* new NpgsqlParameter("@knowledge_id",NpgsqlDbType.Integer),
* new NpgsqlParameter("@note_result",NpgsqlDbType.Varchar),
* new NpgsqlParameter("@source_id",NpgsqlDbType.Integer),
* };
* para[0].Value = fdm.StartDate;
* para[1].Value = fdm.StartTime;
* para[2].Value = fdm.DuringTime;
* para[3].Value = fdm.CallerID;
* para[4].Value = fdm.note;
* para[5].Value = fdm.WaveFilePath;
* para[6].Value = fdm.LineID;
* para[7].Value = fdm.Chan;
* para[8].Value = fdm.user_id;
* para[9].Value = fdm.asset_type_id;
* para[10].Value = fdm.breakdown_categ;
* para[11].Value = fdm.company_id;
* para[12].Value = fdm.address;
* para[13].Value = GetState(_type);
* para[14].Value = fdm.work_property;
* para[15].Value = fdm.department_id;
* para[16].Value = fdm.knowledge_id;
* para[17].Value = fdm.note_result;
* para[18].Value = fdm.ID;
*
* rows = PostgresqlHelper.ExecuteNonQuery(sql, para);
* }
* else
* {
* sql = "update call_log set note=@note,user_id=@user_id,asset_type_id=@asset_type_id,breakdown_categ=@breakdown_categ,company_id=@company_id,address=@address,state=@state,"
+ "work_property=@work_property,department_id=@department_id,knowledge_id=@knowledge_id,note_result=@note_result where source_id=@source_id and phone=@phone";
+ NpgsqlParameter[] para = {
+
+ new NpgsqlParameter("@phone",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@note", NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@user_id", NpgsqlDbType.Integer),
+ new NpgsqlParameter("@asset_type_id",NpgsqlDbType.Integer),
+ new NpgsqlParameter("@breakdown_categ",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@company_id",NpgsqlDbType.Integer),
+ new NpgsqlParameter("@address",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@state",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@work_property",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@department_id",NpgsqlDbType.Integer),
+ new NpgsqlParameter("@knowledge_id",NpgsqlDbType.Integer),
+ new NpgsqlParameter("@note_result",NpgsqlDbType.Varchar),
+ new NpgsqlParameter("@source_id",NpgsqlDbType.Integer),
+ };
+ para[0].Value = fdm.CallerID;
+ para[1].Value = fdm.note;
+ para[2].Value = fdm.user_id;
+ para[3].Value = fdm.asset_type_id;
+ para[4].Value = fdm.breakdown_categ;
+ para[5].Value = fdm.company_id;
+ para[6].Value = fdm.address;
+ para[7].Value = GetState(_type);
+ para[8].Value = fdm.work_property;
+ para[9].Value = fdm.department_id;
+ para[10].Value = fdm.knowledge_id;
+ para[11].Value = fdm.note_result;
+ para[12].Value = fdm.ID;
+
+ rows = PostgresqlHelper.ExecuteNonQuery(sql, para);
+ }*/
#endregion
//sqlserver
if (_IsInsert)
{
sql = "insert into call_log(date,start_time,during_time,phone,note,file_path,line_no,chan_id,user_id,asset_type_id,breakdown_categ,company_id,address,state,work_property,department_id,knowledge_id,note_result,source_id)" +
" values(@date,@start_time,@during_time,@phone,@note,@file_path,@line_no,@chan_id,@user_id,@asset_type_id,@breakdown_categ,@company_id,@address,@state,@work_property,@department_id,@knowledge_id,@note_result,@source_id)";
MySqlParameter[] para =
{
new MySqlParameter("@date", MySqlDbType.Date),
new MySqlParameter("@start_time", MySqlDbType.VarChar),
new MySqlParameter("@during_time", MySqlDbType.VarChar),
new MySqlParameter("@phone", MySqlDbType.VarChar),
new MySqlParameter("@note", MySqlDbType.VarChar),
new MySqlParameter("@file_path", MySqlDbType.VarChar),
new MySqlParameter("@line_no", MySqlDbType.VarChar),
new MySqlParameter("@chan_id", MySqlDbType.Int32),
new MySqlParameter("@user_id", MySqlDbType.Int32),
new MySqlParameter("@asset_type_id", MySqlDbType.Int32),
new MySqlParameter("@breakdown_categ", MySqlDbType.VarChar),
new MySqlParameter("@company_id", MySqlDbType.Int32),
new MySqlParameter("@address", MySqlDbType.VarChar),
new MySqlParameter("@state", MySqlDbType.VarChar),
new MySqlParameter("@work_property", MySqlDbType.VarChar),
new MySqlParameter("@department_id", MySqlDbType.Int32),
new MySqlParameter("@knowledge_id", MySqlDbType.Int32),
new MySqlParameter("@note_result", MySqlDbType.VarChar),
new MySqlParameter("@source_id", MySqlDbType.Int32),
};
para[0].Value = fdm.StartDate;
para[1].Value = fdm.StartTime;
para[2].Value = fdm.DuringTime;
para[3].Value = fdm.CallerID;
para[4].Value = fdm.note;
para[5].Value = fdm.WaveFilePath;
para[6].Value = fdm.LineID;
para[7].Value = fdm.Chan;
para[8].Value = fdm.user_id;
para[9].Value = fdm.asset_type_id;
para[10].Value = fdm.breakdown_categ;
para[11].Value = fdm.company_id;
para[12].Value = fdm.address;
para[13].Value = GetState(_type);
para[14].Value = fdm.work_property;
para[15].Value = fdm.department_id;
para[16].Value = fdm.knowledge_id;
para[17].Value = fdm.note_result;
para[18].Value = fdm.ID;
rows = MySqlHelperClass.ExecuteNonQuery(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, sql, para);
}
else
{
sql = "update call_log set note=@note,user_id=@user_id,asset_type_id=@asset_type_id,breakdown_categ=@breakdown_categ,company_id=@company_id,address=@address,state=@state,"
+ "work_property=@work_property,department_id=@department_id,knowledge_id=@knowledge_id,note_result=@note_result where source_id=@source_id and phone=@phone";
MySqlParameter[] para =
{
new MySqlParameter("@phone", MySqlDbType.VarChar),
new MySqlParameter("@note", MySqlDbType.VarChar),
new MySqlParameter("@user_id", MySqlDbType.Int32),
new MySqlParameter("@asset_type_id", MySqlDbType.Int32),
new MySqlParameter("@breakdown_categ", MySqlDbType.VarChar),
new MySqlParameter("@company_id", MySqlDbType.Int32),
new MySqlParameter("@address", MySqlDbType.VarChar),
new MySqlParameter("@state", MySqlDbType.VarChar),
new MySqlParameter("@work_property", MySqlDbType.VarChar),
new MySqlParameter("@department_id", MySqlDbType.Int32),
new MySqlParameter("@knowledge_id", MySqlDbType.Int32),
new MySqlParameter("@note_result", MySqlDbType.VarChar),
new MySqlParameter("@source_id", MySqlDbType.Int32),
};
para[0].Value = fdm.CallerID;
para[1].Value = fdm.note;
para[2].Value = fdm.user_id;
para[3].Value = fdm.asset_type_id;
para[4].Value = fdm.breakdown_categ;
para[5].Value = fdm.company_id;
para[6].Value = fdm.address;
para[7].Value = GetState(_type);
para[8].Value = fdm.work_property;
para[9].Value = fdm.department_id;
para[10].Value = fdm.knowledge_id;
para[11].Value = fdm.note_result;
para[12].Value = fdm.ID;
rows = MySqlHelperClass.ExecuteNonQuery(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, sql, para);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static DataTable GetOrder(int _accessID, string _callerID)
{
string strsql = string.Format("select * from call_log where source_id={0} and phone='{1}'", _accessID, _callerID);
return(MySqlHelperClass.GetDataSet(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, strsql, null).Tables[0]);
}
public static DataTable GetKnowledge()
{
string strsql = "select id,name,note_result from knowledge_case ";
return(MySqlHelperClass.GetDataSet(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, strsql, null).Tables[0]);
}
public static DataTable GetCompany()
{
string strsql = "select id,name from res_company ";
return(MySqlHelperClass.GetDataSet(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, strsql, null).Tables[0]);
}
public static DataTable GetDepartment()
{
string strsql = "select id,code,name from hr_department ";
return(MySqlHelperClass.GetDataSet(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, strsql, null).Tables[0]);
}
public static DataTable GetUser()
{
string strsql = "select a.id,a.login,a.username,a.department_id,b.name as department_name from res_users a left join hr_department b on a.department_id=b.id";
return(MySqlHelperClass.GetDataSet(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, strsql, null).Tables[0]);
}
