public EDCAgentService()
{
int port = int.Parse(ConfigurationManager.AppSettings[kConfKeyListenPort]);
string connectString = ConfigurationManager.AppSettings[kConfKeyConnectionString];
string logConfFile = ConfigurationManager.AppSettings[kConfKeyLog4NetConfFile];
InitializeComponent();
logger = new EDCLogger.EDCLogger(kModuleName, logConfFile);
agent = new EDCAgent(logger, port, connectString);
logger.Info("EDCAgentService Initialized");
}
public EDCAgentService()
{
int port = int.Parse(ConfigurationManager.AppSettings[kConfKeyListenPort]);
string connectString = ConfigurationManager.AppSettings[kConfKeyConnectionString];
string logConfFile = ConfigurationManager.AppSettings[kConfKeyLog4NetConfFile];
InitializeComponent();
logger = new EDCLogger.EDCLogger(kModuleName, logConfFile);
agent = new EDCAgent(logger, port, connectString);
logger.Info("EDCAgentService Initialized");
}
protected override void OnStart(string[] args)
{
agent.Start();
logger.Info("EDCAgent start success");
}
private string getEmployeeDelta(string[] plist)
{
StringBuilder emp_list = new StringBuilder();
using (SqlConnection sql_conn = new SqlConnection(this.sqlConnStr))
{
sql_conn.Open();
//20150601, For debug, show what is it in DB in this moment.
using (SqlCommand sql_cmd = new SqlCommand(SPSyncEDCInfo, sql_conn))
{
sql_cmd.CommandTimeout = 0;
sql_cmd.CommandType = CommandType.Text;
sql_cmd.CommandText = "SELECT * FROM Sync_EDC_Employee WHERE [EDCNO] == @EDC";
sql_cmd.Parameters.AddWithValue("NAME", plist[1]);
using (SqlDataReader sql_reader = sql_cmd.ExecuteReader())
{
while (sql_reader.Read())
{
emp_list.Append("{");
emp_list.Append(sql_reader["SEQ"]);
emp_list.Append(",");
emp_list.Append(sql_reader["EDCNO"]);
emp_list.Append(",");
emp_list.Append(sql_reader["UserNumber"]);
emp_list.Append(",");
emp_list.Append(sql_reader["StatusType"]);
emp_list.Append(",");
emp_list.Append(sql_reader["SyncFlag"]);
emp_list.Append(",");
emp_list.Append(sql_reader["LatestDT"]);
emp_list.Append("},");
}
}
logger.Info(string.Format("Sync_EDC_Employee, EDC NO: {0}, data: {1}", plist[1], emp_list.ToString()));
}
emp_list.Clear();
using (SqlCommand sql_cmd = new SqlCommand(SPSyncEDCInfo, sql_conn))
{
sql_cmd.CommandTimeout = 0;
sql_cmd.CommandType = CommandType.StoredProcedure;
sql_cmd.Parameters.Add("@state", SqlDbType.VarChar, 20).Value = "get_sync_emp";
sql_cmd.Parameters.Add("@EDCNO", SqlDbType.VarChar, 50).Value = plist[1];
using (SqlDataReader sql_reader = sql_cmd.ExecuteReader())
{
while (sql_reader.Read())
{
emp_list.Append(sql_reader["DepartmentName"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["DepartmentNo"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["UserNumber"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["CardNumber"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["IniQuota"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["NowQuota"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["IsColorPrint"]);
emp_list.Append("\t");
emp_list.Append(sql_reader["StatusType"]);
emp_list.Append("\n");
}
emp_list.Insert(0, emp_list.Length.ToString() + "|");
}
}
}
return(emp_list.ToString());
}
