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();
}
}
