public static Dictionary <int, DateTime> Get_DateTime_values(List <int> detailID_list, string colName)
{
Dictionary <int, DateTime> dic = new Dictionary <int, DateTime>();
if (detailID_list == null || detailID_list.Count < 1)
{
return(dic);
}
if (string.IsNullOrEmpty(colName))
{
return(dic);
}
List <List <int> > splited_list = new List <List <int> >();//split detailID_list into small lists
List <int> tempList = new List <int>();
foreach (int ID in detailID_list)
{
tempList.Add(ID);
if (tempList.Count >= 100)
{
splited_list.Add(tempList);
tempList = new List <int>();
}
}
if (tempList.Count > 0)
{
splited_list.Add(tempList);
}
CmdTemplate cmdTp = new CmdTemplate();//create template for DB
cmdTp.tableName = DividendDetail_master.Detail_tableName;
cmdTp.AddColumn(DividendDetail_master.Detail_PK_colName);
cmdTp.AddColumn(colName);
DB_select selt = new DB_select(cmdTp);
foreach (List <int> list in splited_list)
{
SQL_relation rela = new SQL_relation(DividendDetail_master.Detail_PK_colName, true, list);
selt.SetCondition(rela);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
int detailID = reader.GetInt(DividendDetail_master.Detail_PK_colName);
DateTime dt = reader.GetDateTime(colName);
dic[detailID] = dt;
}
reader.Close();
}
return(dic);
}
private HashSet <int> Get_currFX_ID_set(string taskName)
{
HashSet <int> hs = new HashSet <int>();
CmdTemplate tp = new CmdTemplate();
tp.schema = "Task";
tp.tableName = "Task_Detail";
tp.AddColumn("SourceID");
DB_select selt = new DB_select(tp);
SQL_relation rel0 = new SQL_relation("TaskID", RelationalOperator.Equals, Task20_master.TaskID_20);
SQL_relation rel1 = new SQL_relation("TaskName", RelationalOperator.Equals, taskName);
SQL_condition cond0 = new SQL_condition(rel0), cond1 = new SQL_condition(rel1);
SQL_condition cond = new SQL_condition(cond0, ConditionalOperator.And, cond1);
selt.SetCondition(cond);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
int tempInt = -1;
string tempStr = reader.GetString("SourceID");
if (int.TryParse(tempStr, out tempInt))
{
hs.Add(tempInt);
}
}
reader.Close();
return(hs);
}
public static int UpdateDetail_singleValue(int detailID, string colName, DateTime dt)
{
if (string.IsNullOrEmpty(colName))
{
return(-5);
}
if (dt < Utility.MinDate)
{
return(-6);
}
CmdTemplate cmdTp = new CmdTemplate();//create template for DB
cmdTp.tableName = DividendDetail_master.Detail_tableName;
cmdTp.AddColumn(DividendDetail_master.Detail_PK_colName);
cmdTp.AddColumn(colName);
DB_update upd = new DB_update(cmdTp);
upd.AddValue(colName, dt);
SQL_relation rela = new SQL_relation(DividendDetail_master.Detail_PK_colName, RelationalOperator.Equals, detailID);
upd.SetCondition(rela);
if (colName.Contains(" ") || colName.Contains("-"))
{
Helper_SQLserver.SetTriger(DividendDetail_master.Detail_tableName, "TR_Dividend_Detail_Audit_History", false, Utility.Get_DRWIN_hDB());
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
Helper_SQLserver.SetTriger(DividendDetail_master.Detail_tableName, "TR_Dividend_Detail_Audit_History", true, Utility.Get_DRWIN_hDB());
return(count);
}
else
{
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
return(count);
}
}
public static bool Check_ID_exist(string id, string tableName, string columnName, string schema = "dbo")
{
CmdTemplate tp = new CmdTemplate();
tp.schema = schema;
tp.tableName = tableName;
tp.AddColumn(columnName);
DB_select selt = new DB_select(tp);
SQL_relation rela = new SQL_relation(columnName, RelationalOperator.Equals, id);
selt.SetCondition(rela);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
bool flag = reader.Read();
reader.Close();
return(flag);
}
public static Dividend GetDividend_XBRL_refNum(string XBRL_ReferenceNumber, DividendTable_option table = DividendTable_option.Dividend_Control_Approved)
{
if (string.IsNullOrEmpty(XBRL_ReferenceNumber))
{
return(null);
}
CmdTemplate tp = new CmdTemplate();
tp.tableName = "Dividend_XBRL";
tp.AddColumn("DividendIndex");
DB_select selt = new DB_select(tp);
SQL_relation rela = new SQL_relation("XBRL_ReferenceNumber", RelationalOperator.Equals, XBRL_ReferenceNumber);
selt.SetCondition(rela);
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
int dividendIndex = -1;
if (reader.Read())
{
dividendIndex = reader.GetInt("DividendIndex");
}
reader.Close();
if (dividendIndex < 0)
{
return(null);
}
Dividend dvd = new Dividend(dividendIndex);
dvd.Init_from_DB(table);
return(dvd);
}
