protected override void BuildParameters() { base.BuildParameters(); SQLParam sqlparam = new SQLParam(); sqlparam.Name = "@UserID"; sqlparam.Type = System.Data.SqlDbType.Int; sqlparam.Value = UserId.ToString(); sqlparam.IntValue = UserId; sqlparam.ColumnName = "UserID"; m_sql.parameters.Add(sqlparam); sqlparam = new SQLParam(); sqlparam.Name = "@SignInDate"; sqlparam.Type = SqlDbType.Date; sqlparam.Value = SignInDate.ToString("yyyy-mm-dd"); sqlparam.dtValue = SignInDate; sqlparam.ColumnName = "SignInDate"; sqlparam.IncludeInModDT = true; m_sql.parameters.Add(sqlparam); sqlparam = new SQLParam(); sqlparam.Name = "@SignedIn"; sqlparam.Type = SqlDbType.Bit; sqlparam.Value = SignedIn.ToString(); if (SignedIn) { sqlparam.IntValue = 1; } else { sqlparam.IntValue = 0; } sqlparam.ColumnName = "SignedIn"; sqlparam.IncludeInModDT = false; m_sql.parameters.Add(sqlparam); sqlparam = new SQLParam(); sqlparam.Name = "@InTime"; sqlparam.Type = SqlDbType.DateTime; sqlparam.Value = InTime.ToString(); sqlparam.dtValue = InTime; sqlparam.ColumnName = "InTime"; sqlparam.IncludeInModDT = false; m_sql.parameters.Add(sqlparam); sqlparam = new SQLParam(); sqlparam.Name = "@OutTime"; sqlparam.Type = SqlDbType.DateTime; sqlparam.Value = OutTime.ToString(); sqlparam.dtValue = OutTime; sqlparam.ColumnName = "OutTime"; sqlparam.IncludeInModDT = false; m_sql.parameters.Add(sqlparam); if (m_IncludeIDInParameters) { sqlparam = new SQLParam(); sqlparam.Name = "@ID"; sqlparam.Type = SqlDbType.Int; sqlparam.Value = Convert.ToString(ID); sqlparam.IntValue = ID; sqlparam.ColumnName = m_primarykey; sqlparam.IsPrimaryKey = true; sqlparam.IncludeInModDT = true; m_sql.parameters.Add(sqlparam); } }
public string GetRawKey() { return(SignInDate.StorageString()); }