public string GanCongMa(string code, string YearMonth, int Date)
{
string GanCong = "";
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select B" + Date.ToString());
stringBuilder.Append(@" from dbo.Kq_PaiBan a
left join S_Session b on a.SessionID = b.ID
left join ZlEmployee e on a.EmpID = e.ID
where 1=1 ");
stringBuilder.Append(" and e.Code ='" + code + "'");
stringBuilder.Append(" and b.Memo like '%" + YearMonth + "%'");
SqlHR sqlHR = new SqlHR();
GanCong = sqlHR.sqlExecuteScalarString(stringBuilder.ToString());
if (GanCong != "")
{
GanCong = GanCong.Trim();
}
}
catch (Exception)
{
throw;
}
return(GanCong);
}
public static int GetsessionID(DateTime dtGet)
{
int intSessionID = 0;
DateTime firstDay = new DateTime(dtGet.Year, dtGet.Month, 1);
DateTime LastDate = new DateTime(dtGet.Year, dtGet.Month, DateTime.DaysInMonth(dtGet.Year, dtGet.Month));
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select ID from S_Session where 1=1 ");
stringBuilder.Append(" and CAST(Date0 as datetime) >= '" + firstDay.ToString("yyyyMMdd") + "' ");
stringBuilder.Append(" and CAST(Date0 as datetime) <= '" + LastDate.ToString("yyyyMMdd") + "' ");
SqlHR sqlHR = new SqlHR();
string strGet = sqlHR.sqlExecuteScalarString(stringBuilder.ToString());
if (strGet != "")
{
intSessionID = int.Parse(strGet);
}
return(intSessionID);
}
public int GetSessionID(DateTime date)
{
int SessionID = -1;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select ID from S_Session where 1 = 1 ");
stringBuilder.Append(" and (CAST('" + date.ToString("yyyy-MM-dd") + "' as datetime)) BETWEEN CAST(Date0 as datetime) and CAST(Date1 as datetime)");
SqlHR sqlHR = new SqlHR();
string value = sqlHR.sqlExecuteScalarString(stringBuilder.ToString());
try
{
SessionID = int.Parse(value);
}
catch (Exception)
{
SessionID = -1;
}
return(SessionID);
}
