public JsonResult DelInform()
{
try
{
string delinformids = Request.Form["delinformids"].ToString();
if (delinformids.Contains("_"))
{
string[] aInformids = delinformids.Split('_');
foreach (var informid in aInformids)
{
int Informid = Convert.ToInt32(informid);
Inform inform = new BaseDAL <Inform>().GetModel(u => u.InformId == Informid);
new BaseDAL <Inform>().Del(inform);
}
}
else
{
int Informid = Convert.ToInt32(delinformids);
Inform inform = new BaseDAL <Inform>().GetModel(u => u.InformId == Informid);
new BaseDAL <Inform>().Del(inform);
}
dictionary.Add("success", true);
}
catch
{
dictionary.Add("success", false);
}
return(Json(dictionary));
}
public string GetExcel()
{
string filename = "";
HSSFWorkbook workbook = new HSSFWorkbook(); //创建一个工作薄
ISheet sheet1 = workbook.CreateSheet(); //创建一个sheet页
IRow rowHeader = sheet1.CreateRow(0); //创建第一行
rowHeader.CreateCell(0, CellType.STRING).SetCellValue("通知信息"); //创建第一行第一列的单元格，设定里面的值为ID
rowHeader.CreateCell(1, CellType.STRING).SetCellValue("是否显示");
rowHeader.CreateCell(2, CellType.STRING).SetCellValue("信息类型");
List <Inform> list = new BaseDAL <Inform>().GetListBy(u => u.InformId > 0);
int i = 0;
if (list.Count > 0)
{
foreach (var Inform in list)
{
IRow rowDate = sheet1.CreateRow(i + 1);
rowDate.CreateCell(0, CellType.STRING).SetCellValue(Inform.InformText.ToString());
rowDate.CreateCell(1, CellType.STRING).SetCellValue(Inform.IsVisible.ToString());
rowDate.CreateCell(2, CellType.STRING).SetCellValue(Inform.InfoType.ToString());
i++;
}
filename = "/file/" + Guid.NewGuid().ToString() + ".xls";
using (Stream stream = System.IO.File.OpenWrite(Server.MapPath(filename)))
{
workbook.Write(stream);
}
}
return(filename);
}
public JsonResult UpdateOrder(int id)
{
string BookName = Request.Form["BookName"].ToString();
string UserName = Request.Form["UserName"].ToString();
int BookAmount = int.Parse(Request.Form["BookAmount"].ToString());
double BookPrice = double.Parse(Request.Form["BookPrice"].ToString());
string OrderNumber = Request.Form["OrderNumber"].ToString();
BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == id);
bookOrder.BookName = BookName;
bookOrder.UserName = UserName;
bookOrder.BookAmount = BookAmount;
bookOrder.BookPrice = BookPrice;
bookOrder.BookTotalPrice = BookAmount * BookPrice;
bookOrder.OrderNumber = OrderNumber;
if (new BaseDAL <BookOrder>().Modify(bookOrder) > 0)
{
dictionary.Add("success", true);
}
else
{
dictionary.Add("success", false);
dictionary.Add("infor", "更新失败");
}
return(Json(dictionary));
}
public JsonResult DelOrder()
{
try
{
string sBookOrderids = Request.Form["delbookorderids"].ToString();
if (sBookOrderids.Contains("_"))
{
string[] aBookOrderids = sBookOrderids.Split('_');
foreach (var BookOrderid in aBookOrderids)
{
int bookOrderid = Convert.ToInt32(BookOrderid);
BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == bookOrderid);
new BaseDAL <BookOrder>().Del(bookOrder);
}
}
else
{
int bookOrderid = Convert.ToInt32(sBookOrderids);
BookOrder bookOrder = new BaseDAL <BookOrder>().GetModel(u => u.BookOrderId == bookOrderid);
new BaseDAL <BookOrder>().Del(bookOrder);
}
dictionary.Add("success", true);
}
catch
{
dictionary.Add("success", false);
}
return(Json(dictionary));
}
static void Main(string[] args)
{
try
{
Console.WriteLine("欢迎来到.net高级班vip课程，今天的内容是特性和AOP");
People people = new People();
UserModel user = new UserModel();
user.Id = 1;
string name = user.GetTableName <UserModel>();
string remark = UserState.Normal.GetRemark();
BaseDAL.Save <UserModel>(user);
#region AOP show
Console.WriteLine("***********************");
Decorator.Show();
Console.WriteLine("***********************");
Proxy.Show();
Console.WriteLine("***********************");
CastleProxy.Show();
Console.WriteLine("***********************");
UnityAOP.Show();
#endregion
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.Read();
}
protected void BindingDropDownList()
{
BaseDAL <KHUVUC> abc = new BaseDAL <KHUVUC>();
var listMaKV = abc.GetAll().Select(c => c.MAKV).ToList();
cbbMAKV.DataSource = listMaKV;
}
public JsonResult DelWebComment()
{
try
{
string sWebCommentids = Request.Form["delwebcommentids"].ToString();
if (sWebCommentids.Contains("_"))
{
string[] aWebCommentids = sWebCommentids.Split('_');
foreach (var WebCommenid in aWebCommentids)
{
int WebCommentid = Convert.ToInt32(WebCommenid);
WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == WebCommentid);
new BaseDAL <WebComment>().Del(webComment);
}
}
else
{
int WebCommentid = Convert.ToInt32(sWebCommentids);
WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == WebCommentid);
new BaseDAL <WebComment>().Del(webComment);
}
dictionary.Add("success", true);
}
catch
{
dictionary.Add("success", false);
}
return(Json(dictionary));
}
static void Main(string[] args)
{
try
{
Console.WriteLine("这是第一个学习项目");
BaseDAL baseDAL = new BaseDAL();
Company company1 = baseDAL.Find <Company>(1);
/// List<Company> list = baseDAL.FindAll<Company>();
User user = baseDAL.Find <User>(1);
//List<User> list = baseDAL.FindAll<User>();
//company.Name = "腾讯课堂234564576754";
////company.Validate();
//baseDAL.Update<Company>(company);
//
}
catch (Exception ex)//UI层必须把异常catch住
{
Console.WriteLine(ex.Message);
}
Console.Read();
}
static void Main(string[] args)
{
IBaseDAL basedal = new BaseDAL();
//查询一条
User user = basedal.Find <User>(1);
//查询所有
List <User> listuser = basedal.FindAll <User>();
user.Name = "喻贞";
//更新一条数据
//bool update = basedal.update<User>(user);
//插入一条数据
//bool insert = basedal.insert<User>(user);
//删除一条数据
bool delete = basedal.delete <User>(2);
//List<a> l= new List<a>();
//for (int i = 0; i < 10; i++)
//{
// a a = new a() { id = i+1 };
// l.Add(a);
//}
//var result = l.Select(x => x.id < 3 ? 0 : x.id).Where(x=>x!=0);
}
public string BuscarQuestoes(string idQuestao)
{
int idQuestaoInt = int.Parse(idQuestao);
string resultado = BaseDAL.DataTable_JSON_JavaSerializer(BaseDAL.BuscarQuestoesDAL(idQuestaoInt));
return(resultado);
}
//Get Graph Chart
public JsonResult GetGraph()
{
DateTime startTime = Convert.ToDateTime(Request.Form["startTime"].ToString());
DateTime endTime = Convert.ToDateTime(Request.Form["endTime"].ToString());
List <User> list = new BaseDAL <User>().GetListBy(u => u.CreatedTime >= startTime && u.CreatedTime <= endTime && u.Type == 0);
var listGraph = (from u in list
group u by u.CreatedTime.Value.Year.ToString() + u.CreatedTime.Value.Month.ToString() into g
orderby Convert.ToInt32(g.Key.Substring(0, 4)), Convert.ToInt32(g.Key.Substring(4, g.Key.Length - 4))
select new
{
key = g.Key,
count = g.Count()
}).ToList();
Dictionary <string, object> dt = new Dictionary <string, object>();
// JavaScriptSerializer jss = new JavaScriptSerializer();
List <string> aTime = new List <string>();
List <int> aCountGraph = new List <int>();
foreach (var a in listGraph)
{
aTime.Add(a.key);
aCountGraph.Add(a.count);
}
dt.Add("a1", aTime);
dt.Add("a2", aCountGraph);
//return jss.Serialize(dt);
return(Json(dt));
}
public static void refreshDatagrid(DataGridView dv)
{
dv.Rows.Clear();
//绑定数据
// this.dataGridView1.Rows.Clear();
IList <SendMessage> receiveList = BaseDAL.QueryForList <SendMessage>("QueryAllReceiceMsgList", LoginUser.ID);
if (receiveList != null && receiveList.Count() > 0)
{
foreach (SendMessage msg in receiveList)
{
var msgStatus = string.Empty;
if (msg.Status == 1)
{
msgStatus = "未读";
}
else if (msg.Status == 2)
{
msgStatus = "已读";
}
string[] rowItem = new string[] {
msgStatus,
msg.SenderName,
msg.SendeUid,
(msg.SentTime != null && msg.SentTime != DateTime.MinValue)?msg.SentTime.ToString("yyyy-MM-dd HH:mm:ss"):"",
msg.ID.ToString()
};
dv.Rows.Add(rowItem);
}
}
}
public void consignBtn_Click(object sender, EventArgs e)
{
item.status = 100;
item.completeDate = DateTime.Now;
item.itemDetials = itemDetialsIn.InnerText;
if (itemDal.Update(item) == 1)
{
if (item.money != 0 & item.money != null)
{
BaseDAL<OA_finance> financeDal = new BaseDAL<OA_finance>();
OA_finance finance = new OA_finance();
finance.money = item.money;
finance.actionDate = DateTime.Now;
finance.actionDetails = "委托方：" + item.client + "，项目负责人：" + item.leaderName; ;
finance.actionName = item.itemName;
financeDal.Add(finance);
}
moneyInput.Value = item.money.ToString();
yearIn.Value = item.completeDate.Year.ToString();
monthIn.Value = item.completeDate.Month.ToString();
dayIn.Value = item.completeDate.Day.ToString();
itemDetialsIn.Value = item.itemDetials;
programProgress.InnerText = item.status + "%";
itemProgress.Style.Add("width", 5.36 * item.status + "px");
List<OA_item> itemList = itemDal.GetList(1, 2000);
if (Header1.DataBind(itemList, user.realName, user.loginName) == 0)
{
user.status = 100;
userDal.Update(user);
}
scripthelp.Alert("项目交付成功！", this.Page);
}
else scripthelp.Alert("项目交付失败！", Page);
}
//Update User to DB
public JsonResult UpdateUser(int id)
{
string UserName = Request.Form["UserName"].ToString();
string Pwd = Request.Form["Pwd"].ToString();
string Gender = Request.Form["Gender"].ToString();
string Email = Request.Form["Email"].ToString();
string Tel = Request.Form["Tel"].ToString();
string QQ = Request.Form["QQ"].ToString();
User user = new BaseDAL <User>().GetModel(u => u.UserId == id);
user.UserName = UserName;
user.Pwd = Pwd;
user.Gender = Gender;
user.Email = Email;
user.Tel = Tel;
user.QQ = QQ;
if (new BaseDAL <User>().Modify(user) > 0)
{
dictionary.Add("success", true);
}
else
{
dictionary.Add("success", false);
dictionary.Add("infor", "更新失败");
}
return(Json(dictionary));
}
/// <summary>
/// 重写获取分页数据方法
/// </summary>
/// <param name="totalCount">总记录数</param>
/// <param name="errorMsg">异常信息</param>
/// <param name="permissionValidate">是否过滤权限</param>
/// <param name="pageIndex">页号</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="orderFields">排序字段</param>
/// <param name="isDescs">是否降序</param>
/// <param name="expression">条件表达式</param>
/// <param name="whereSql">where语句</param>
/// <param name="references">是否加载导航属性</param>
/// <param name="connString">数据库连接字符串</param>
/// <returns></returns>
public override List <Sys_DbConfig> GetPageEntities(out long totalCount, out string errorMsg, bool permissionValidate = true, int pageIndex = 1, int pageSize = 10, List <string> orderFields = null, List <bool> isDescs = null, System.Linq.Expressions.Expression <Func <Sys_DbConfig, bool> > expression = null, string whereSql = null, List <string> fieldNames = null, bool references = false, string connString = null)
{
totalCount = 0;
BaseDAL <Sys_Module> moduleDal = new BaseDAL <Sys_Module>(this.CurrUser);
int dataSourceType = (int)ModuleDataSourceType.DbTable;
List <Sys_Module> modules = expression == null?moduleDal.GetPageEntities(out totalCount, out errorMsg, false, pageIndex, pageSize, null, null, x => x.DataSourceType == dataSourceType) : moduleDal.GetEntities(out errorMsg, x => x.DataSourceType == dataSourceType, null, false);
List <Sys_DbConfig> list = modules.Select(x => GetModuleCacheConfig(x.TableName, x.Name, x.Id)).ToList();
list = list.Where(x => x != null).ToList();
//将未添加到模块表中的模块也加进来
List <Type> modelTypes = GetAllModelTypes();
if (modelTypes == null || modelTypes.Count == 0)
{
return(new List <Sys_DbConfig>());
}
List <string> tables = moduleDal.GetEntities(out errorMsg, x => x.TableName != null && x.TableName != string.Empty).Select(x => x.TableName).ToList();
list.AddRange(modelTypes.Where(x => !tables.Contains(x.Name)).Select(x => GetModuleCacheConfig(x.Name)));
if (expression != null)
{
list = list.Where(expression.Compile()).ToList();
totalCount = list.Count;
}
//页序号
int index = pageIndex < 1 ? 0 : (pageIndex - 1);
//每页记录数
int rows = pageSize < 1 ? 10 : (pageSize > 2000 ? 2000 : pageSize);
list = list.Skip <Sys_DbConfig>(rows * index).Take <Sys_DbConfig>(rows).OrderByDescending(x => x.CurrPageDensity).ToList();
return(list);
}
/// <summary>
/// 获取实体集合重写
/// </summary>
/// <param name="errorMsg"></param>
/// <param name="expression"></param>
/// <param name="whereSql"></param>
/// <param name="permissionFilter"></param>
/// <param name="orderFields"></param>
/// <param name="isDescs"></param>
/// <param name="top"></param>
/// <param name="references"></param>
/// <param name="connString"></param>
/// <returns></returns>
public override List <Sys_CacheConfig> GetEntities(out string errorMsg, System.Linq.Expressions.Expression <Func <Sys_CacheConfig, bool> > expression = null, string whereSql = null, bool permissionFilter = true, List <string> orderFields = null, List <bool> isDescs = null, int?top = null, List <string> fieldNames = null, bool references = false, string connString = null)
{
BaseDAL <Sys_Module> moduleDal = new BaseDAL <Sys_Module>(this.CurrUser);
int dataSourceType = (int)ModuleDataSourceType.DbTable;
List <Sys_Module> modules = moduleDal.GetEntities(out errorMsg, x => x.DataSourceType == dataSourceType, null, permissionFilter);
List <Sys_CacheConfig> list = modules.Select(x => GetModuleCacheConfig(x.TableName, x.Name, x.Id)).ToList();
//将未添加到模块表中的模块也加进来
List <Type> modelTypes = GetAllModelTypes();
List <string> tables = moduleDal.GetEntities(out errorMsg, x => x.TableName != null && x.TableName != string.Empty).Select(x => x.TableName).ToList();
list.AddRange(modelTypes.Where(x => !tables.Contains(x.Name)).Select(x => GetModuleCacheConfig(x.Name)));
if (expression != null)
{
list = list.Where(expression.Compile()).ToList();
if (orderFields != null && orderFields.Count > 0)
{
for (int i = 0; i < orderFields.Count; i++)
{
string orderField = string.IsNullOrEmpty(orderFields[i]) ? "Id" : orderFields[i];
bool isdesc = isDescs != null && orderFields.Count == isDescs.Count ? isDescs[i] : true;
SortComparer <Sys_CacheConfig> reverser = new SortComparer <Sys_CacheConfig>(typeof(Sys_CacheConfig), orderField, isdesc ? ReverserInfo.Direction.DESC : ReverserInfo.Direction.ASC);
list.Sort(reverser);
}
}
}
return(list);
}
private MySqlDataReader CallEmpDetail_USP(string empDataJson, OperationType operationType)
{
MySqlDataReader dr = null;
var errorOutput = "";
try
{
MySqlParameter empDetailParam = new MySqlParameter("@empData", empDataJson);
empDetailParam.Direction = ParameterDirection.Input;
MySqlParameter operationTypeParam = new MySqlParameter("@operationType", operationType);
operationTypeParam.Direction = ParameterDirection.Input;
MySqlParameter outputParam = new MySqlParameter("@_errorOutput", errorOutput);
outputParam.Direction = ParameterDirection.Output;
MySqlCommand cmd = BaseDAL.GetSqlCommandProcedure(Get_All_Emp_Data_USP);
cmd.Parameters.Add(empDetailParam);
cmd.Parameters.Add(operationTypeParam);
cmd.Parameters.Add(outputParam);
dr = cmd.ExecuteReader();
}
catch (MySqlException execption)
{
throw new Exception("Internal Error occurred: " + execption.Message);
}
return(dr);
}
public JsonResult UpdateWebComment(int id)
{
int UserId = Convert.ToInt32(Request.Form["UserId"].ToString());
string CommentTitle = Request.Form["CommentTitle"].ToString();
string CommentText = Server.HtmlEncode(Request.Form["CommentText"].ToString());
DateTime CreatedTime = DateTime.Parse(Request.Form["CreatedTime"].ToString());
string ClientIP = Request.Form["ClientIP"].ToString();
WebComment webComment = new BaseDAL <WebComment>().GetModel(u => u.WebCommentId == id);
webComment.UserId = UserId;
webComment.CommentTitle = CommentTitle;
webComment.CommentText = Server.HtmlDecode(CommentText);
webComment.CreatedTime = CreatedTime;
webComment.ClientIP = ClientIP;
if (new BaseDAL <WebComment>().Modify(webComment) > 0)
{
dictionary.Add("success", true);
}
else
{
dictionary.Add("success", false);
dictionary.Add("infor", "更新失败");
}
return(Json(dictionary));
}
public void Do()
{
NatServerCrowd natServerCrowd = new NatServerCrowd();
natServerCrowd.Start();
int count = natServerCrowd.GetCount();
var list = natServerCrowd.GetAddressList();
Console.WriteLine("NatServer IP列表：");
list.ForEach(item =>
{
//存到数据库
NatProxyModel natProxyModel = new NatProxyModel
{
Type = (int)NatProxyTypeEnum.Nat,
AddressInnerNet = item.Address,
Port = item.Port,
IsUsable = true,
StartUpTime = DateTime.Now,
AddressOuterNet = IPAddressUtils.GetOuterNatIP()
};
var id = BaseDAL.Insert(natProxyModel);
natServerCrowd.AddIdItem(id);
Console.WriteLine("启动成功！PrimaryId：{0}，AddressInnerNetAndPort：{1}:{2}", id, natProxyModel.AddressInnerNet, natProxyModel.Port);
});
ConsoleCloseHandler.natServerCrowd = natServerCrowd;
ConsoleCloseHandler.SetConsoleCtrlHandler(ConsoleCloseHandler.cancelHandler, true);
}
/// <summary>
/// 获取用户可（查看、编辑、删除）模块中哪些组织下的数据，
/// 返回可（查看、编辑、删除）的组织Id集合
/// </summary>
/// <param name="userId">用户Id</param>
/// <param name="moduleId">模块Id</param>
/// <param name="dataPermissionType">数据权限类型,0-查看，1-编辑，2-删除</param>
/// <returns>返回组织Id集合字典</returns>
public List <string> GetUserDataPermissions(Guid userId, Guid moduleId, int dataPermissionType)
{
List <string> orgIds = new List <string>();
//如果存在用户自定义权限则取自定义用户权限
string errMsg = string.Empty;
BaseDAL <Sys_UserPermissionData> userPermissionDal = new BaseDAL <Sys_UserPermissionData>(this.CurrUser);
Sys_UserPermissionData permissionData = userPermissionDal.GetEntity(out errMsg, x => x.Sys_UserId == userId && x.Sys_ModuleId == moduleId && !x.IsDeleted);
string orgIdsStr = string.Empty;
if (permissionData != null)
{
orgIdsStr = dataPermissionType == 0 ? permissionData.CanViewOrgIds :
(dataPermissionType == 1 ? permissionData.CanEditOrgIds : permissionData.CanDelOrgIds);
}
if (!string.IsNullOrWhiteSpace(orgIdsStr))
{
string[] token = orgIdsStr.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (token.Contains("-1"))
{
return new List <string>()
{
"-1"
}
}
;
foreach (string orgId in token)
{
if (!orgIds.Contains(orgId))
{
orgIds.Add(orgId);
}
}
return(orgIds);
}
//取用户角色权限
List <Guid> roleIds = ObjectReferenceClass.GetUserRoleIds(userId);
foreach (Guid roleId in roleIds)
{
Dictionary <string, bool> tempOrgIds = GetRoleDataPermissions(roleId, moduleId, dataPermissionType, true);
if (tempOrgIds.ContainsKey("-1"))
{
return new List <string>()
{
"-1"
}
}
;
foreach (string orgId in tempOrgIds.Keys)
{
if (!orgIds.Contains(orgId))
{
orgIds.Add(orgId);
}
}
}
return(orgIds);
}
}
}
public ActionResult EditPwPost(string oldPw, string newPw)
{
var adminUserDal = new BaseDAL <AdminUser>();
var user = adminUserDal.GetModel("Id=1");
if (user == null)
{
return(Json(new ReMsg()
{
Success = false, Info = "用户不存在"
}));
}
if (user.Pw != oldPw)
{
return(Json(new ReMsg()
{
Success = false, Info = "密码不正确"
}));
}
user.Pw = newPw;
adminUserDal.Update(user);
return(Json(true));
}
/// <summary>
/// 检查邮箱准确性
/// </summary>
/// <param name="inputEmailTxt"></param>
/// <param name="tips"></param>
/// <returns></returns>
public bool checkEmail(string inputEmailText, out string tips)
{
inputEmailText = inputEmailText.Trim();
bool checkResult = false;
Regex reg = new Regex(@"^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+(\.[a-zA-Z0-9_-]+)+$");
if (reg.IsMatch(inputEmailText))
{
if (BaseDAL.Get("GetEmailCount", inputEmailText) == 0)
{
checkResult = true;
tips = String.Format($"\"{inputEmailText}\"可用。");
// XtraMessageBox.Show(String.Format($"\"{inputEmailText}\"可用。"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
tips = String.Format($"\"{inputEmailText}\"已存在。");
// XtraMessageBox.Show(String.Format($"\"{inputEmailText}\"已存在。"), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
tips = String.Format($"请检查邮箱格式");
// XtraMessageBox.Show("请检查邮箱格式", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(checkResult);
}
static void Main(string[] args)
{
B1DAL dal = new B1DAL();
b1 b = new b1();
b.b = 10;
var m = dal.Add(b);
var model = dal.GetModel("id", 1);
List <Filter> fl = new List <Filter>();
fl.AddFilter("id", FilterOption.LessThan, 3);
var list = dal.GetPageList(fl, 1, 15, "id");
BaseDAL <a1> dala = new BaseDAL <a1>();
dala.DbConnect = new DbEnum().GetDbConnectionName(dbE.T.testEntities);
List <Filter> afl1 = new List <Filter>();
afl1.AddFilter("name", FilterOption.Contains, "3");
List <Filter> afl = new List <Filter>();
afl.AddFilter("name", FilterOption.Contains, "3");
afl.AddFilter("name", FilterOption.Contains, "9");
var alist1 = dala.GetPageList(afl, 1, 100, "a").PageObject as List <a1>;
var alist2 = dala.GetPageList(afl1, 1, 100, "a").PageObject as List <a1>;
}
/// <summary>
/// 获取用户（查看、新增、编辑）字段权限
/// </summary>
/// <param name="userId">用户Id</param>
/// <param name="moduleId">模块Id</param>
/// <param name="fieldPermissionType">字段权限类型，0-查看，1-新增，2-编辑</param>
/// <returns>返回允许（查看、新增、编辑）的字段名集合</returns>
public List <string> GetUserFieldsPermissions(Guid userId, Guid moduleId, int fieldPermissionType)
{
List <string> fieldNames = new List <string>();
//如果存在用户自定义权限则取自定义用户权限
string errMsg = string.Empty;
BaseDAL <Sys_UserPermissionField> userPermissionDal = new BaseDAL <Sys_UserPermissionField>();
Sys_UserPermissionField permissionField = userPermissionDal.GetEntity(out errMsg, x => x.Sys_UserId == userId && x.Sys_ModuleId == moduleId && !x.IsDeleted);
string fields = string.Empty;
if (permissionField != null)
{
fields = fieldPermissionType == 0 ? permissionField.CanViewFields :
(fieldPermissionType == 1 ? permissionField.CanAddFields : permissionField.CanEditFields);
}
if (!string.IsNullOrWhiteSpace(fields))
{
string[] token = fields.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (token.Contains("-1"))
{
return new List <string>()
{
"-1"
}
}
; //所有字段权限
foreach (string field in token)
{
if (!fieldNames.Contains(field))
{
fieldNames.Add(field);
}
}
return(fieldNames);
}
//取用户角色权限
List <Guid> roleIds = ObjectReferenceClass.GetUserRoleIds(userId);
foreach (Guid roleId in roleIds)
{
Dictionary <string, bool> tempFields = GetRoleFieldPermissions(roleId, moduleId, fieldPermissionType, true);
if (tempFields.ContainsKey("-1"))
{
return new List <string>()
{
"-1"
}
}
; //所有字段权限
foreach (string field in tempFields.Keys)
{
if (!fieldNames.Contains(field))
{
fieldNames.Add(field);
}
}
}
return(fieldNames);
}
}
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
DAL = new LitedbDAL();
}
public static IResponsitryBase <T> CreateDAL <T>(DBType pp) where T : class, new()
{
IResponsitryBase <T> dal;
switch (pp)
{
case (DBType.Sql):
dataAccess = new BaseDAL <T>();
break;
case (DBType.Sql2005):
dataAccess = new SQL2005Dal <T>();
break;
case (DBType.Oracle):
dataAccess = new OracleDal <T>();
break;
case (DBType.MySql):
dataAccess = new MySqlDal <T>();
break;
default:
dataAccess = new BaseDAL <T>();
break;
}
}
private MySqlDataReader CallExcelrawDataDetail_USP(string excelDataJson)
{
MySqlDataReader dr = null;
var errorOutput = "";
try
{
MySqlParameter excelParam = new MySqlParameter("@customerListData", excelDataJson);
excelParam.Direction = ParameterDirection.Input;
MySqlParameter outputParam = new MySqlParameter("@_errorOutput", errorOutput);
outputParam.Direction = ParameterDirection.Output;
MySqlCommand cmd = BaseDAL.GetSqlCommandProcedure(Get_All_Excel_Raw_Data_USP);
cmd.Parameters.Add(excelParam);
cmd.Parameters.Add(outputParam);
dr = cmd.ExecuteReader();
}
catch (MySqlException execption)
{
throw new Exception("Internal Error occurred: " + execption.Message);
}
return(dr);
}
static void Main(string[] args)
{
try
{
Console.WriteLine("特性和AOP");
People people = new People();
UserModel userModel = new UserModel();
userModel.Id = 23;
string remark = userModel.GetTableName();
BaseDAL.Save <UserModel>(userModel);
#region AOP show
Console.WriteLine("***********************");
Decorator.Show();
Console.WriteLine("***********************");
Proxy.Show();
Console.WriteLine("***********************");
CastleProxy.Show();
Console.WriteLine("***********************");
UnityAOP.Show();
#endregion
}
catch (Exception)
{
throw;
}
Console.Read();
}
//Delete User from DB
public JsonResult DelUser()
{
try
{
string sUserids = Request.Form["deluserids"].ToString();
if (sUserids.Contains("_"))
{
string[] aUserids = sUserids.Split('_');
foreach (var id in aUserids)
{
int userid = Convert.ToInt32(id);
User user = new BaseDAL <User>().GetModel(u => u.UserId == userid);
new BaseDAL <User>().Del(user);
}
}
else
{
int userid = Convert.ToInt32(sUserids);
User user = new BaseDAL <User>().GetModel(u => u.UserId == userid);
new BaseDAL <User>().Del(user);
}
dictionary.Add("success", true);
}
catch
{
dictionary.Add("success", false);
}
return(Json(dictionary));
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int rowIndex = e.RowIndex;
if (rowIndex >= 0)
{
DataGridViewRow rowobj = this.dataGridView1.Rows[e.RowIndex];
var msgIDStr = rowobj.Cells["MsgID"].Value;
if (msgIDStr != null)
{
int msgID = 0;
if (Int32.TryParse(msgIDStr.ToString(), out msgID))
{
SendMessage singleMsg = BaseDAL.Get <SendMessage>("GetMsgInfo", msgID);
if (singleMsg != null)
{
// Running on the worker thread
this.dataGridView1.Invoke((MethodInvoker) delegate {
BaseDAL.Update("UpdateMsgReadStatus", singleMsg.ID);
refreshDatagrid(this.dataGridView1);
});
MessageFrm msgfrm = new MessageFrm(singleMsg);
msgfrm.TopMost = true;
msgfrm.Show();
}
}
}
}
}
public async Task <ModelMetrics> GenerateModel(BaseDAL storage, string modelFileName)
{
if (storage == null)
{
Log.Error("Trainer::GenerateModel - BaseDAL is null");
throw new ArgumentNullException(nameof(storage));
}
if (string.IsNullOrEmpty(modelFileName))
{
Log.Error("Trainer::GenerateModel - modelFileName is null");
throw new ArgumentNullException(nameof(modelFileName));
}
if (!File.Exists(modelFileName))
{
Log.Error($"Trainer::GenerateModel - {modelFileName} does not exist");
throw new FileNotFoundException(modelFileName);
}
var startTime = DateTime.Now;
var options = new RandomizedPcaTrainer.Options
{
FeatureColumnName = FEATURES,
ExampleWeightColumnName = null,
Rank = 4,
Oversampling = 20,
EnsureZeroMean = true,
Seed = Constants.ML_SEED
};
var(data, cleanRowCount, maliciousRowCount) = GetDataView(await storage.QueryPacketsAsync(a => a.IsClean), await storage.QueryPacketsAsync(a => !a.IsClean));
IEstimator <ITransformer> dataProcessPipeline = _mlContext.Transforms.Concatenate(
FEATURES,
typeof(PayloadItem).ToPropertyList <PayloadItem>(nameof(PayloadItem.Label)));
IEstimator <ITransformer> trainer = _mlContext.AnomalyDetection.Trainers.RandomizedPca(options: options);
EstimatorChain <ITransformer> trainingPipeline = dataProcessPipeline.Append(trainer);
TransformerChain <ITransformer> trainedModel = trainingPipeline.Fit(data.TrainSet);
_mlContext.Model.Save(trainedModel, data.TrainSet.Schema, modelFileName);
var testSetTransform = trainedModel.Transform(data.TestSet);
return(new ModelMetrics
{
Metrics = _mlContext.AnomalyDetection.Evaluate(testSetTransform),
NumCleanRows = cleanRowCount,
NumMaliciousRows = maliciousRowCount,
Duration = DateTime.Now.Subtract(startTime)
});
}
static void Main(string[] args)
{
B1DAL dal = new B1DAL();
b1 b = new b1();
b.b = 10;
var m=dal.Add(b);
var model = dal.GetModel("id", 1);
List<Filter> fl=new List<Filter>();
fl.AddFilter("id",FilterOption.LessThan,3);
var list = dal.GetPageList(fl, 1, 15, "id");
BaseDAL<a1> dala = new BaseDAL<a1>();
dala.DbConnect = new DbEnum().GetDbConnectionName(dbE.T.testEntities);
List<Filter> afl1=new List<Filter>();
afl1.AddFilter("name",FilterOption.Contains,"3");
List<Filter> afl=new List<Filter>();
afl.AddFilter("name",FilterOption.Contains,"3");
afl.AddFilter("name",FilterOption.Contains,"9");
var alist1 = dala.GetPageList(afl, 1, 100, "a").PageObject as List<a1>;
var alist2 = dala.GetPageList(afl1, 1, 100, "a").PageObject as List<a1>;
}
/// <summary>
/// 获取单据编号
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public string GetAutoOrderCode(string tablename)
{
string strclear = string.Empty;
try
{
string strRes = string.Empty;
if (string.IsNullOrWhiteSpace(tablename))
{
return strRes;
}
var ents = from n in GetTable<T_FB_ORDERCODE>()
where n.TABLENAME == tablename
select n;
T_FB_ORDERCODE orderCode = ents.FirstOrDefault();
if (orderCode == null)
{
return strRes;
}
string shortName = orderCode.PRENAME;
DateTime CurrentDate = orderCode.CURRENTDATE.Value;
using (BaseDAL dal = new BaseDAL())
{
Tracer.Debug("模块代码：" + tablename);
switch (tablename)
{
case "T_FB_COMPANYBUDGETAPPLYMASTER":
tablename = "T_FB_COMPANYBUDGETAPPLY";//名称太长导致无法创建sequence
break;
case "T_FB_COMPANYBUDGETMODMASTER":
tablename = "T_FB_COMPANYBUDGETMOD";//名称太长导致无法创建sequence
break;
case "T_FB_COMPANYBUDGETSUMMASTER":
tablename = "T_FB_COMPANYBUDGETSUM";//名称太长导致无法创建sequence
break;
case "T_FB_PERSONMONEYASSIGNMASTER":
tablename = "T_FB_PERSONMONEYASSIGN";//名称太长导致无法创建sequence
break;
default:
break;
}
if (CurrentDate.Date != System.DateTime.Now.Date)
{
orderCode.CURRENTDATE = System.DateTime.Now.Date;
orderCode.RUNNINGNUMBER = 1;
strclear = @"declare n number(10); tsql varchar2(1000); begin select "
+ tablename + "_SEQ.nextval into n from dual; "
+ " n:=-(n);"
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by '|| n;"
+ " execute immediate tsql; "
+ " select " + tablename + "_SEQ.nextval into n from dual; "
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by 1 '; "
+ " execute immediate tsql; "
+ " end; ";
Tracer.Debug("ExecuteCustomerSql：" + strclear);
dal.ExecuteCustomerSql(strclear);
}
decimal curNumber = 0;
string strNextSqense = @" select " + tablename + "_SEQ.nextval from dual";
Tracer.Debug("调用新生成单号接口：tablename：" + tablename + " ExecuteCustomerSql:" + strNextSqense);
curNumber = decimal.Parse(dal.ExecuteCustomerSql(strNextSqense).ToString());
string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd");
string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0');
Tracer.Debug("生成单号：" + code);
orderCode.RUNNINGNUMBER =Convert.ToInt32(curNumber + 1);
Update(orderCode);
return code;
}
}
catch (Exception ex)
{
Tracer.Debug("ExecuteCustomerSql：" + strclear + ex.ToString());
throw (ex);
}
}
public void Test_Select_All_Posts_Data_Table()
{
BaseDAL bDAL = new BaseDAL("Data Source=vm-dev-sql;Initial Catalog=SolrIndx; User Id=sa; Password=Professional2;Connection Timeout=6;");
var retset = bDAL.ExecuteSPReturnDataTable("SelectAllUsersPosts");
Assert.IsTrue(retset != null);
}
protected void loginBtn_Click(object sender, EventArgs e)
{
string checkCode = user_checkCode.Text.Trim().ToLower();
if (Session["CheckCode"] == null | !checkCode.Equals(Session["CheckCode"].ToString().ToLower()))
{
string script = "alert('老兄，验证码错误哦！')";
Page.ClientScript.RegisterStartupScript(this.GetType(), null, script, true);
user_checkCode.Text = "";
}
else
{
string userName = user_name.Text.Trim();
string userPwd = user_password.Text.Trim();
string encodePwd = FormsAuthentication.HashPasswordForStoringInConfigFile(userPwd, "md5").Substring(0, 30);
int failCount=Common.FailLoginCount(Common.GetIp());
if (failCount>5)
{
if (failCount < 11)
{
OA_log log = new OA_log();
log.ip = Common.GetIp();
log.wrongPw = "登录失败超五次：" + string.Format("{0}", userName) + "密码:" + userPwd;
string[] columnA = { "ip", "wrongPw" };
ArrayList al = new ArrayList { log.ip, log.wrongPw };
logDal.insert(columnA, log, al);
}
scripthelp.Alert(userName + "登录失败超过五次！请联系管理员或一个小时后再登录", this.Page);
return;
}
OA_users user = new OA_users();
BaseDAL<OA_users> userDal = new BaseDAL<OA_users>();
if (Regex.IsMatch(userName, @"[-|;|,|\/|\(|\)|\[|\]|\}|\{|%|@|\*|!|\']") && Regex.IsMatch(userPwd, @"[-|;|,|\/|\(|\)|\[|\]|\}|\{|%|\*|!|\']")) user = null;
else
{
user = userDal.GetUser("loginName", userName, "pw", encodePwd);
}
if (user != null)
{
string userRole = user.roles;
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, userName, DateTime.Now, DateTime.Now.AddMinutes(30), false, userRole, "/");
string HashTicket = FormsAuthentication.Encrypt(ticket);
HttpCookie userCookie = new HttpCookie(FormsAuthentication.FormsCookieName, HashTicket);
Context.Response.Cookies.Add(userCookie);
Session["user"] = user;
if(FormsAuthentication.GetRedirectUrl(userName,false)=="default.aspx") Response.Redirect(FormsAuthentication.GetRedirectUrl(userName, false));
else Response.Redirect("home.aspx");
}
else
{
OA_log log = new OA_log();
log.ip = Common.GetIp();
log.wrongPw ="登录名:"+ string.Format("{0}", userName) + "密码:" + userPwd;
string[] columnA = { "ip", "wrongPw" };
ArrayList al = new ArrayList { log.ip, log.wrongPw };
logDal.insert(columnA, log, al);
Common.isDeleteOldLog();//防止日志文件太多所以删除过多过久的日志
scripthelp.Alert("老兄，用户名或密码错误哦！", this.Page);
user_checkCode.Text = "";
}
}
}
