public void saveReport(string savePath, int year, int month)
{
Workbook wk = new Workbook();
TB_User[] sales = UserBusiness.getAllSalersAndWrite(); //获取所有销售渠道和完工录入信息
if (Global.g_usergroupid != (int)EnmUserRole.财务 && Global.g_usergroupid != (int)EnmUserRole.全部 && Global.g_usergroupid != (int)EnmUserRole.销售总监)
{
TB_User u = UserBusiness.findUserById(Global.g_userid);
List <TB_User> list = new List <TB_User>();
list.Add(u);
sales = list.ToArray();
}
string str = year.ToString() + "-" + month.ToString() + "-01";
DateTime startdate = DateTime.Parse(str).Date;
DateTime enddate = DateTime.Parse(str).AddMonths(1).AddDays(-1).Date;
for (int i = 0; i < sales.Length; i++)
{
DataTable salesData = ScoreBusiness.makeActualScore(startdate, enddate, "", sales[i].Id, "");
if (salesData.Rows.Count > 0)
{
writeSalesReport(wk, i, salesData, year, month, sales[i].USER_NAME);
try
{
wk.Password = DES.Decode(sales[i].PASSWORD, Global.DB_PWDKEY);
wk.Save(savePath + "//" + sales[i].USER_NAME + " " + year + "-" + month + "月度提成清单1.xls");
}
catch (Exception ex)
{
MessageHelper.ShowMessage("E999", "错误" + ex.Message + "\n此文件导出失败，其他文件仍将被导出到所选目录。");
}
}
}
MessageHelper.ShowMessage("I007");
}
public ActionResult ValidEmail(string code = "")
{
if (string.IsNullOrEmpty(code))
{
if (CurrentUserInfo == null)//无用户信息
{
return(RedirectToAction("Login"));
}
else
{
Session["UserInfo"] = db.FirstOrDefault <TB_User>("where Id=@0", CurrentUserInfo.Id);
if (CurrentUserInfo.EmailValid)//刷新页面，重新获取用户信息，已验证邮箱则跳回首页。
{
return(Redirect("/Home/Index"));
}
}
return(View());
}
else
{
var message = "";
TB_User user = null;
if (!VerifyUtil.CheckEmailVerfyCode(code, out user, out message))
{
return(Content(message));
}
Session["UserInfo"] = user;
return(RedirectToAction("Recharge"));
}
}
private void bindProjectData()
{
try
{
//mProj
this.txtOBJECTNAME.Text = mProj.OBJECTNAME;
this.txtCONTRACTNO.Text = mProj.CONTRACTNO;
this.txtCOMPANYNAME.Text = mProj.COMPANYNAME;
this.txtADDRESS.Text = mProj.ADDRESS;
this.dtpBeginDate.DateTime = mProj.BEGINDATE;
this.dtpEndDate.DateTime = mProj.ENDDATE;
if (mProj.OBJECTTYPENAME != null)
{
setProjIdentity(mProj.OBJECTTYPENAME);
}
this.txtMoney.Text = mProj.MONEY.ToString();
if (mProj.BILLSTATUS == "已结算")
{
this.chkBillStatus.IsChecked = true;
}
if (!string.IsNullOrEmpty(mProj.TEAMLEDER))
{
TB_User leader = TB_UserDao.FindFirst(new EqExpression("USER_CODE", mProj.TEAMLEDER));
this.txtleder.Text = leader.USER_NAME;
this.txtleder.Tag = leader;
}
//绑定组员
string menbers = mProj.TEAMMEMBER;
if (!string.IsNullOrEmpty(menbers))
{
string[] arr = menbers.Split('|');
if (arr.Length > 0)
{
for (int i = 0; i < arr.Length; i++)
{
TB_User user = TB_UserDao.FindFirst(new EqExpression("USER_CODE", arr[i]));
uc_user uc = new uc_user(user);
uc.DelSelectUser += uc_DelSelectUser;
this.warp.Children.Add(uc);
}
}
TB_BILL[] arr_bills = TB_BILLDAO.FindAll(new EqExpression("PROJECTID", mProj.Id), new EqExpression("STATUS", 1));
if (arr_bills.Length > 0)
{
//绑定发票信息
for (int i = 0; i < arr_bills.Length; i++)
{
uc_bill uc = new uc_bill(arr_bills[i]);
uc.DelSelectBill += uc_DelSelectBill;
this.warp2.Children.Add(uc);
}
}
this.txtMemo.Text = mProj.MEMO;
}
}
catch (Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
public void Login(WD001ViewModel model)
{
if (string.IsNullOrWhiteSpace(model.UserId) || string.IsNullOrWhiteSpace(model.PassWord))
{
return;
}
using (EntityDao db = new EntityDao())
{
List <MySqlParameter> para = new List <MySqlParameter>();
StringBuilder sql = new StringBuilder();
sql.AppendLine("select * from tb_user");
para.Add(new MySqlParameter("CD", model.UserId));
sql.AppendLine("where CD = @CD");
para.Add(new MySqlParameter("Password", model.PassWord));
sql.AppendLine(" and Password = md5(@Password)");
sql.AppendLine(" and DateStart <= CURDATE()");
sql.AppendLine(" and CURDATE() <= DateEnd");
sql.AppendLine(" and DelFlg = '0'");
TB_User user = db.FindSingle <TB_User>(sql.ToString(), para);
if (user != null)
{
App.LoginUser = user;
model.UserName = user.Name;
}
else
{
}
}
}
public TB_User Login(TB_User user, OleDbConnection db)
{
string pwd = Security.DesEncriptar(user.password);
DataSet dataSet = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select * from TB_User where Login='******'and Password ='******';", db);;
da.Fill(dataSet);
db.Close();
DataTable dt = dataSet.Tables[0];
TB_User _User = null;
foreach (DataRow rows in dt.Rows)
{
_User = new TB_User(
int.Parse(rows["Id"].ToString()),
rows["Login"].ToString(),
rows["Password"].ToString(),
int.Parse(rows["TypeUserId"].ToString()),
rows["NameUser"].ToString(),
rows["Lastname"].ToString(),
rows["DNI"].ToString());
}
return(_User);
}
/// <summary>
/// 编辑用户信息
/// </summary>
/// <param name="tb_User"></param>
/// <param name="lstDormAreaID"></param>
/// <returns></returns>
public string Edit(TB_User tb_User, List <int> lstDormAreaID)
{
string strErrMsg = string.Empty;
TB_User mTB_User = null;
mTB_User = _mTB_UserDAL.GetUserInfo(tb_User.ADAccount);
//编辑
if (tb_User.ID > 0)
{
if (mTB_User != null && mTB_User.ID != tb_User.ID)
{
strErrMsg = "该用户添加！";
return(strErrMsg);
}
this.Update(tb_User, lstDormAreaID);
}
//添加
else
{
if (mTB_User != null)
{
strErrMsg = "该用户添加！";
return(strErrMsg);
}
this.Add(tb_User, lstDormAreaID);
}
return(strErrMsg);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string strErrorMsg = string.Empty;;
UserBLL mUserBLL = new UserBLL();
List <int> lstDormAreaID = new List <int>();
for (int i = 0; i < gdvRight.Rows.Count; i++)
{
lstDormAreaID.Add(Convert.ToInt32(gdvRight.DataKeys[i].Value.ToString()));
}
TB_User mTB_User = new TB_User();
mTB_User.ID = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"]);
mTB_User.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_User.Creator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.ADAccount);
mTB_User.ADAccount = this.txtADAccount.Text.Trim();
mTB_User.CName = this.txtCName.Text.Trim();
mTB_User.EName = this.txtEName.Text.Trim();
mTB_User.EmployeeNo = this.txtEmployeeNo.Text.Trim();
mTB_User.RoleID = Convert.ToInt32(this.ddlRole.SelectedValue);
strErrorMsg = mUserBLL.Edit(mTB_User, lstDormAreaID);
if (string.IsNullOrEmpty(strErrorMsg))
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>saveComplete();</script>");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "message", "<script>alert('" + strErrorMsg + "');</script>");
}
}
catch (Exception ex)
{
LogManager.GetInstance().ErrorLog(ex.Message);
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tb_User"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetPagerData(TB_User tb_User, ref Pager pager)
{
DataTable dt = _mTB_UserDAL.GetTable(tb_User, ref pager);
//DataTable dtNew = dt.Clone();
//DataRow[] drFilter = null;
//foreach (DataRow dr in dt.Rows)
//{
// DataRow drNew = dtNew.NewRow();
// drFilter = dtNew.Select("[ADAccount]='" + dr[TB_User.col_ADAccount] + "'");
// if (drFilter.Length > 0)
// {
// drFilter[0]["DormName"] = drFilter[0]["DormName"] + "，" + dr["DormName"];
// }
// else
// {
// drNew.ItemArray = dr.ItemArray;
// dtNew.Rows.Add(drNew);
// }
//}
//if (dtNew.Rows.Count>0)
//{
// pager.TotalRecord = dtNew.Rows.Count;
//}
//else
//{
// pager.TotalRecord = 0;
//}
return(dt);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
using (var en = new WeekReportEntities())
{
//var dd = en.Table_2.ToList();
TB_User user = (from q in en.TB_User
where q.Acc == txtAcc.Text && q.pass == txtCode.Text
select q).FirstOrDefault();
if (user != null)
{
Session[GlobalInfo.Session_User] = user;
if (user.lv == 3)
{
Response.Redirect("~/L2/FrmL2Bridge.aspx");
}
if (user.lv == 2)
{
Response.Redirect("~/L1/L1Bridge.aspx");
}
if (user.lv == 1)
{
Response.Redirect("~/UserInput/FrmUserInputBrige.aspx");
}
}
else
{
Response.Write("沒有此帳號或是密碼錯誤");
}
}
}
public ActionResult Login(FormCollection f)
{
string staikhoan = f["user_name"].ToString();
string smatkhau = f["user_password"].ToString();
TB_User user = login.TB_User.SingleOrDefault(n => n.UserName == staikhoan && n.Password == smatkhau);
if (user != null)
{
Session["NguoiDung"] = user;
return(Redirect(Request.UrlReferrer.ToString()));
}
else if (staikhoan == "")
{
ViewBag.TBTK = "Nhập tài khoản";
}
else if (smatkhau == "")
{
ViewBag.TBMK = "Nhập mật khảu";
}
else
{
ViewBag.ThongBao = " <div class=alert - danger>Bạn nhập sai. Vui lòng nhập lại</div>";
}
return(View());
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNew_Click(object sender, RoutedEventArgs e)
{
try
{
mStatus = "add";
if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtCode.Text))
{
if (!getUserInfo(txtCode.Text))
{
return;
}
TB_User user = new TB_User();
user.USER_NAME = this.txtName.Text.Trim();
user.USER_CODE = this.txtCode.Text.Trim();
user.ROLEID = (this.cmbUserRole.SelectedValue as PTS_TABLE_SRC).ID;
TB_User tmp = TB_UserDao.FindFirst(new EqExpression("USER_CODE", this.txtCode.Text.Trim()));
user.PASSWORD = DES.Encode("111111", Global.DB_PWDKEY);
user.DEPT = txtDept.Text;
user.Save(); //保存
MessageHelper.ShowMessage("保存成功");
this.txtName.Text = "";
this.txtCode.Text = "";
this.cmbUserRole.SelectedIndex = 0;
}
mStatus = "";
bindUserData();
}
catch (Exception ex)
{
MessageHelper.ShowMessage(ex.Message);
}
}
public ActionResult Login(LoginModel model, string returnUrl)
{
TB_User user = repo.LoginAdmin(model.UserName, model.Password);
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.UserName, false);
Session["Admin"] = user;
if (user.Active == "Admin")
{
return(RedirectToAction("Products", "Admin"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
//if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe))
//{
// return RedirectToLocal(returnUrl);
//}
// If we got this far, something failed, redisplay form
ModelState.AddModelError("", "The user name or password provided is incorrect.");
return(View("Index", model));
}
private void CheckBox_Click(object sender, RoutedEventArgs e)
{
TB_User user = (TB_User)this.dgUser.SelectedItem;
if (user != null)
{
user.IsChecked = !user.IsChecked;
}
}
public uc_user(TB_User user)
{
InitializeComponent();
if (user != null)
{
mUser = user;
this.txtName.Text = mUser.USER_NAME;
this.txtName.Tag = mUser;
}
}
private void writeAccountReport(TB_User sales, int year, int month, int line, decimal totalScore)
{
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].PutValue(sales.USER_NAME);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].PutValue(GlobalBusiness.getUserRoleType(sales.ROLEID));
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].PutValue(Math.Round(totalScore, 2));
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].Style.Copy(this.cellstyle);
}
public static bool checkPwd(int id, string pwd)
{
TB_User user = TB_UserDao.FindFirst(new EqExpression("Id", id), new EqExpression("Password", DES.Encode(pwd, Global.DB_PWDKEY)));
if (user != null)
{
return(true);
}
return(false);
}
public TB_UserProfile login(string userName, string password)
{
TB_User user = entities.TB_User.Where(u => u.UserName.Equals(userName) && u.Password.Equals(password)).SingleOrDefault();
if (user != null)
{
return(user.TB_UserProfile.SingleOrDefault());
}
return(null);
}
/// <summary>
/// 事务添加
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Create(TB_User info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = @"INSERT INTO [TB_User] ([SiteID]
,[ADAccount]
,[EmployeeNo]
,[EName]
,[Creator]
,[CName]
,[RoleID])
VALUES(@SiteID
,@ADAccount
,@EmployeeNo
,@EName
,@Creator
,@CName
,@RoleID
)";
string strSelectIdSql = ";SELECT SCOPE_IDENTITY()";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID);
db.AddInParameter(dbCommandWrapper, "@ADAccount", DbType.String, info.ADAccount);
db.AddInParameter(dbCommandWrapper, "@EmployeeNo", DbType.String, info.EmployeeNo);
db.AddInParameter(dbCommandWrapper, "@EName", DbType.String, info.EName);
db.AddInParameter(dbCommandWrapper, "@Creator", DbType.String, info.Creator);
db.AddInParameter(dbCommandWrapper, "@CName", DbType.String, info.CName);
db.AddInParameter(dbCommandWrapper, "@RoleID", DbType.Int32, info.RoleID);
#endregion
if (tran == null)
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper));
}
else
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran));
}
return(intId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
private void InitPageData()
{
string strUserID = Request.QueryString["id"];
TB_DormArea mTB_DormArea = new TB_DormArea();
DormAreaBLL mDormAreaBLL = new DormAreaBLL();
TB_User mTB_User = null;
UserBLL mUserBLL = new UserBLL();
RoleBLL mRoleBLL = new RoleBLL();
TB_Role mTB_Role = new TB_Role()
{
SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID),
};
Pager pager = null;
this.ddlRole.DataTextField = TB_Role.col_Name;
this.ddlRole.DataValueField = TB_Role.col_ID;
this.ddlRole.DataSource = mRoleBLL.GetPagerData(mTB_Role, ref pager);
this.ddlRole.DataBind();
this.ddlRole.Items.Insert(0, new ListItem()
{
Value = "0", Text = "--请选择--"
});
mTB_DormArea.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
DataTable dtLeft = mDormAreaBLL.GetTable(mTB_DormArea, ref pager);
DataTable dtRight = null;
if (null != strUserID && !string.IsNullOrEmpty(strUserID))
{
mTB_User = mUserBLL.Get(Convert.ToInt32(strUserID));
this.txtADAccount.Text = mTB_User.ADAccount;
this.txtEmployeeNo.Text = mTB_User.EmployeeNo;
this.txtCName.Text = mTB_User.CName;
this.txtEName.Text = mTB_User.EName;
this.ddlRole.SelectedValue = mTB_User.RoleID.ToString();
dtRight = mDormAreaBLL.GetTableByUserID(Convert.ToInt32(strUserID));
DataRow[] drFilter = null;
for (int i = dtLeft.Rows.Count - 1; i >= 0; i--)
{
drFilter = dtRight.Select("ID=" + dtLeft.Rows[i][TB_DormArea.col_ID] + "");
if (drFilter.Length > 0)
{
dtLeft.Rows.Remove(dtLeft.Rows[i]);
}
}
}
ViewState["dtLeft"] = dtLeft;
gdvLeft.DataSource = dtLeft;
gdvLeft.DataBind();
ViewState["dtRight"] = dtRight;
gdvRight.DataSource = dtRight;
gdvRight.DataBind();
}
private void timer1_tick(object sender, EventArgs e)
{
TB_Password.UseSystemPasswordChar = false;
TB_User.ForeColor = Color.Black;
TB_Password.ForeColor = Color.Black;
TB_User.Text = "Usuario";
TB_Password.Text = "Contraseña";
TB_User.Refresh();
TB_Password.Refresh();
timer1.Enabled = false;
}
/// <summary>
/// 添加项目负责人
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLeader_Click(object sender, RoutedEventArgs e)
{
frmUserSearch frm = new frmUserSearch();
frm.ShowDialog();
if (frm.mUser != null)
{
TB_User user = frm.mUser[0];
this.txtleder.Text = user.USER_NAME;
this.txtleder.Tag = user;
}
}
public ActionResult History()
{
if (Session["Admin"] == null)
{
return(RedirectToAction("Index", "Admin"));
}
TB_User user = (TB_User)Session["Admin"];
List <TB_Transaction> transactions = entities.TB_Transaction.Where(x => x.UserId == user.UserId).ToList();
return(View(transactions));
}
public ActionResult EWallet()
{
if (Session["user"] == null)
{
return(RedirectToAction("Login", "Account"));
}
TB_User user = (TB_User)Session["user"];
EWallet wallet = entities.EWallets.Where(x => x.UserID == user.UserId).FirstOrDefault();
return(View(wallet));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Create(TB_User info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Create(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult User_Permission_edit(string sEmployeeID)
{
TB_User tb_user = new TB_User();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
TB_User qtb_user = db.TB_User.Where(w => w.sEmployeeID == sEmployeeID).FirstOrDefault();
if (qtb_user != null)
{
tb_user = qtb_user;
}
return(Ok(tb_user));
}
public static void updateUserInfo(TB_User user)
{
try
{
user.Update();
//MessageHelper.ShowMessage("I001");
}
catch (Exception ex)
{
Log.Error(ex.Message);
MessageHelper.ShowMessage("E999");
}
}
public async Task <bool> AddAccount(TB_User user)
{
var dbUser = await _accountDbContext.TB_User.SingleOrDefaultAsync(u => u.StrUserID == user.StrUserID || u.Email == user.Email);
if (dbUser == null)
{
_accountDbContext.Set <TB_User>().Add(user);
await _accountDbContext.SaveChangesAsync();
return(true);
}
return(false);
}
/// <summary>
/// 抓出某課所有的報表
/// </summary>
/// <param name="p_User"></param>
/// <returns></returns>
public static List <TB_Report> ShowOldReport(TB_User p_User)
{
using (var en = new WeekReportEntities())
{
//end必須從新設定
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == p_User.Bureau &&
q.Class == p_User.Class
select q).ToList();
return(data);
}
}
public ActionResult PayUsingWallet()
{
RechargeModel model = (RechargeModel)Session["recharge"];
EWallet wallet = null;
if (Session["user"] != null)
{
TB_User user = (TB_User)Session["user"];
wallet = user.EWallets.FirstOrDefault();
if (Convert.ToDecimal(model.amount) < wallet.Amount)
{
ServiceReference1.ClientAPIServiceSoapClient s = new ServiceReference1.ClientAPIServiceSoapClient();
string clientId = ConfigurationManager.AppSettings["ClientId"];
string clientPwd = ConfigurationManager.AppSettings["ClientPwd"];
string responseid = "";
string status = "";
string balances = "";
string number = Guid.NewGuid().ToString().Substring(0, 6);
TB_Transaction tx = repo.createTransaction(number, model.amount, wallet.UserID ?? 0, Convert.ToInt32(model.ProductId), model.phone);
bool result = s.RequestInput(clientId, clientPwd, number, model.Operators, Convert.ToDecimal(model.amount), model.phone, ref responseid, ref status, ref balances);
tx.Status = status;
tx.ResponseId = responseid;
repo.updateTrasnaction(tx);
if (status == "SUBMIT_SUCCESS")
{
TB_Transaction txu = entities.TB_Transaction.Where(x => x.TransactionId == tx.TransactionId).FirstOrDefault();
txu.PaymentStatus = "Payment Recieved.";
entities.SaveChanges();
repo.DeductMoneyFromWallet(((TB_User)Session["user"]).UserId, Convert.ToDecimal(model.amount));
TB_Paypal paypal = new TB_Paypal();
paypal.Amount = Convert.ToDecimal(model.amount);
paypal.date = DateTime.Now;
paypal.EWalletID = wallet.EWalletID;
paypal.Type = "Mobile Recharge";
paypal.UserID = user.UserId;
paypal.TransactionID = txu.TransactionId;
entities.TB_Paypal.Add(paypal);
entities.SaveChanges();
ViewBag.Message = "Recharge Succesful !";
}
else
{
ViewBag.Message = "Recharge was UnSuccesful !";
ViewBag.MessageDesc = "Some issue occured in the backend. We haven't deducted money from your wallet. Please try again later";
}
}
}
return(View(model));
}
/// <summary>
/// 取出某課當周的主報表
/// </summary>
/// <param name="p_User"></param>
/// <returns></returns>
public static List <TB_Report> GetNowReport(TB_User p_User)
{
using (var en = new WeekReportEntities())
{
List <TB_Report> data = (from q in en.TB_Report
where q.Bureau == p_User.Bureau &&
q.Class == p_User.Class &&
q.TimeStart <= DateTime.Now &&
q.TimeEnd >= DateTime.Now
select q).ToList();
return(data);
}
}
