public static string Login(string name, string pwd) { string sql = "select * from table_users where c_login_name='" + DALSecurityTool.TransferInsertField(name) + "' and c_pwd='" + DALSecurityTool.TransferInsertField(SecurityFactory.GetSecurity().Encrypt(pwd)) + "'"; ArrayList lists = FT.DAL.Orm.SimpleOrmOperator.QueryList(typeof(UserObject), sql); if (lists.Count == 0) { return("2"); } else { UserObject user = lists[0] as UserObject; RoleObject role = FT.DAL.Orm.SimpleOrmOperator.Query <RoleObject>(user.RoleId); DepartMent dept = FT.DAL.Orm.SimpleOrmOperator.Query <DepartMent>(user.DepId); OperatorTick ot = new OperatorTick(user.Id, user.FullName, user.DepId, role.RoleString, pwd); ot.Desp1 = user.WorkId; ot.Desp2 = dept.ParentCode; ot.Desp3 = dept.DepCode; ot.Desp4 = dept.DepFullName; ot.Desp5 = user.FullName; ot.Desp6 = role.RoleName; ot.Desp7 = user.Km; ot.Desp8 = string.Empty; return(FT.Web.OperatorTick.GenerateOpTicket(ot)); } //return "1"; }
public static string Login(string name, string pwd) { string sql = "select * from table_user_info where c_login_name='" + DALSecurityTool.TransferInsertField(name) + "' and c_pwd='" + DALSecurityTool.TransferInsertField(SecurityFactory.GetSecurity().Encrypt(pwd)) + "'"; ArrayList lists = FT.DAL.Orm.SimpleOrmOperator.QueryList(typeof(UserInfo), sql); if (lists.Count == 0) { return("2"); } else { UserInfo user = lists[0] as UserInfo; RoleInfo role = FT.DAL.Orm.SimpleOrmOperator.Query <RoleInfo>(user.RoleId); DepartmentInfo dept = FT.DAL.Orm.SimpleOrmOperator.Query <DepartmentInfo>(user.DepId); OperatorTick ot = new OperatorTick(user.Id, user.FullName, user.DepId, role.MenuStr, pwd); ot.Desp1 = user.WorkId; ot.Desp2 = dept.GlbmCode; ot.Desp3 = dept.DepCode; ot.Desp4 = dept.DepFullName; ot.Desp5 = user.FullName; ot.Desp6 = role.MenuStr; ot.Desp7 = role.RightStr; ot.Desp8 = user.Km.ToString(); return(FT.Web.OperatorTick.GenerateOpTicket(ot)); } //return "1"; }
/// <summary> /// 创建一个对象到数据库中,成功后通过select max()来返回主键 /// </summary> /// <param name="obj">实体对象</param> /// <returns>是否插入成功</returns> public static bool Create(object obj) { IDataAccess dataAccess = CreateConn(); Type type = obj.GetType(); StringBuilder sql = new StringBuilder(SimpleOrmCache.GetInsertSql(type)); Hashtable table = SimpleOrmCache.GetInsertField(type); System.Collections.IDictionaryEnumerator enumerator = table.GetEnumerator(); string field = string.Empty; object value = null; while (enumerator.MoveNext()) { field = enumerator.Key.ToString(); value = type.GetField(field, BindingFlags.IgnoreCase | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.Public | BindingFlags.FlattenHierarchy).GetValue(obj); sql.Replace("#" + field + "#", value == null ? "" : DALSecurityTool.TransferInsertField(TransObjectField(value))); } bool result = dataAccess.ExecuteSql(sql.ToString()); if (result)//执行把主键赋给对象 { string pk = SimpleOrmCache.GetPK(type); object objtmp = dataAccess.SelectScalar("select max(" + pk + ") from " + SimpleOrmCache.GetTableName(type)); if (objtmp != null) { FormHelper.SetDataToObject(obj, pk, objtmp); //FormHelper.SetDataToObject(obj,pk,FormHelper.ParseFieldInfo(obj,objtmp); //FieldInfo fieldtmp=type.GetField(pk); //fieldtmp.SetValue(obj, FormHelper.ParseFieldInfo(fieldtmp, objtmp)); } } return(result); }
/// <summary> /// 更新一个实体对象 /// </summary> /// <param name="obj">实体对象</param> /// <returns>是否更新成功</returns> public static bool Update(object obj) { IDataAccess dataAccess = CreateConn(); Type type = obj.GetType(); StringBuilder sql = new StringBuilder(SimpleOrmCache.GetUpdateSql(type)); Hashtable table = SimpleOrmCache.GetUpdateField(type); System.Collections.IDictionaryEnumerator enumerator = table.GetEnumerator(); string field = string.Empty; object value = null; while (enumerator.MoveNext()) { field = enumerator.Key.ToString(); value = type.GetField(field, BindingFlags.IgnoreCase | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.Public | BindingFlags.FlattenHierarchy).GetValue(obj); sql.Replace("#" + field + "#", value == null ? "" : DALSecurityTool.TransferInsertField(TransObjectField(value))); } FieldInfo key = type.GetField(SimpleOrmCache.GetPK(type), BindingFlags.IgnoreCase | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.Public | BindingFlags.FlattenHierarchy); if (typeof(int) == key.FieldType) { sql.Append(key.GetValue(obj).ToString()); } else { sql.Append("'" + key.GetValue(obj).ToString() + "'"); } return(dataAccess.ExecuteSql(sql.ToString())); }
/// <summary> /// 增加一个车辆照片信息 /// </summary> /// <param name="info">车辆照片信息</param> /// <returns>是否成功增加</returns> public bool Add(VehiclePhoto info) { info.XuHao = this.GetXuHao(); string sql = "insert into table_vehicle_photo(cn_classical,cn_type,suffix,xuhao) values('" + DALSecurityTool.TransferInsertField(info.Cn_Classical) + "','" + DALSecurityTool.TransferInsertField(info.Cn_Type) + "','" + DALSecurityTool.TransferInsertField(info.Suffix) + "','" + DALSecurityTool.TransferInsertField(info.XuHao) + "')"; return(this.access.ExecuteSql(sql)); }
public static string Login(string name, string pwd) { string sql = "select * from table_users where c_login_name='" + DALSecurityTool.TransferInsertField(name) + "' and c_pwd='" + DALSecurityTool.TransferInsertField(SecurityFactory.GetSecurity().Encrypt(pwd)) + "'"; ArrayList lists = FT.DAL.Orm.SimpleOrmOperator.QueryList(typeof(UserObject), sql); if (lists.Count == 0) { return("2"); } else { UserObject user = lists[0] as UserObject; OperatorTick ot = new OperatorTick(user.Id, user.FullName, -1, "", pwd); ot.Desp5 = user.FullName; ot.Desp8 = string.Empty; return(FT.Web.OperatorTick.GenerateOpTicket(ot)); } //return "1"; }
private void button1_Click(object sender, EventArgs e) { string learncar = this.cbLearnCar.Text.Trim().ToUpper(); if (learncar.Length == 0) { MessageBoxHelper.Show("对不起,必须输入申请的驾照型号!"); return; } ArrayList list = SimpleOrmOperator.QueryConditionList <ExamUser>(" where c_idcard='" + DALSecurityTool.TransferInsertField(this.txtIdCard.Text.Trim()) + "'"); if (list == null || list.Count == 0) { MessageBoxHelper.Show("对不起,不存在该学员,请咨询管理员!"); return; } else { ExamUser user = list[0] as ExamUser; ExamPolicy policy = StaticCacheManager.GetConfig <ExamPolicy>(); if (this.checkExam.Checked && policy.IsLimit && user.PassCount >= policy.SuccessTimes) { MessageBoxHelper.Show("对不起,您已经合格了" + user.PassCount.ToString() + "次,无法再次进行考试!"); return; } // 判断是否考试合格次数超过了配置的考试合格次数限制 ArrayList topics = this.GetRandomTopic(learncar); //this.Hide(); ExamWorkStation form = new ExamWorkStation(topics, user, this.checkTrain.Checked); form.ShowDialog(); } }
private void button3_Click(object sender, EventArgs e) { ArrayList list = SimpleOrmOperator.QueryConditionList <ExamUser>(" where c_idcard='" + DALSecurityTool.TransferInsertField(this.txtIdCard.Text.Trim()) + "'"); if (list == null || list.Count == 0) { MessageBox.Show("对不起,不存在该学员,请咨询管理员!"); } else { ExamLogSearch ctr = new ExamLogSearch(); Form tmp = new Form(); tmp.WindowState = FormWindowState.Maximized; tmp.ShowIcon = false; tmp.Text = "模拟考试记录列表"; tmp.ShowInTaskbar = true; tmp.StartPosition = FormStartPosition.CenterScreen; ctr.SetUserIdCard(this.txtIdCard.Text.Trim()); ctr.Dock = DockStyle.Fill; tmp.Controls.Add(ctr); tmp.ShowDialog(); } }