public static MInfo GetMethodInfo(string keyName) { MInfo minfo = null; _map.TryGetValue(keyName, out minfo); return(minfo); }
public FrmInfoSave(FrmMain _m, MInfo _model) { InitializeComponent(); fMain = _m; ShortCut(); InitalData(); txtTitle.Text = _model.Title; txtContent.Text = _model.Content; model = _model; InitalData(); }
/// <summary> /// 测试 /// </summary> /// <param name="people"></param> /// <returns></returns> public ReturnMessageModel <MInfo> Test(MPeople people) { MInfo info = new MInfo(); info.name = people.name; info.age = people.age; ReturnMessageModel <MInfo> returnMessageModel = new ReturnMessageModel <MInfo>(); returnMessageModel.Status = 0; returnMessageModel.Message = "Success"; returnMessageModel.Data = info; return(returnMessageModel); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MInfo model) { StringBuilder sql = new StringBuilder(); sql.Append("INSERT INTO Dat_Info("); sql.Append("Id,IsCtrl,IsAlt,IsShift,Key,Title,Content,UserId,CreateDateTime,TypeId)"); sql.Append(" values ("); sql.Append("@Id,@IsCtrl,@IsAlt,@IsShift,@Key,@Title,@Content,@UserId,@CreateDateTime,@TypeId)"); SQLiteServer server = new SQLiteServer(); try { SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@IsCtrl", DbType.Boolean), new SQLiteParameter("@IsAlt", DbType.Boolean), new SQLiteParameter("@IsShift", DbType.Boolean), new SQLiteParameter("@Key", DbType.String, 500), new SQLiteParameter("@Title", DbType.String, 500), new SQLiteParameter("@Content", DbType.String, 30000), new SQLiteParameter("@UserId", DbType.Int16, 100), new SQLiteParameter("@CreateDateTime", DbType.DateTime), new SQLiteParameter("@TypeId", DbType.Int16, 100) }; parameters[0].Value = int.Parse(server.ExecuteQuery("select ifnull(max(id),0) from Dat_Info").Rows[0][0].ToString()) + 1; parameters[1].Value = model.IsCtrl; parameters[2].Value = model.IsAlt; parameters[3].Value = model.IsShift; parameters[4].Value = model.Key; parameters[5].Value = model.Title; parameters[6].Value = model.Content; parameters[7].Value = model.UserId; parameters[8].Value = DateTime.Now.ToString(); parameters[9].Value = model.TypeId; server.ExecuteNonQuery(sql.ToString(), parameters); } catch (Exception ex) { Log.WriteErrLog(ex); return(false); } finally { } return(true); }
private void InitalData() { try { DInfo info = new DInfo(); DataTable dt = info.GetData("", SystemInfo.userId); List <string> infoList = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { MInfo model = new MInfo(); model.Title = dt.Rows[i][0].ToString(); model.Content = dt.Rows[i][1].ToString(); list.Add(model); } } catch (Exception ex) { Log.WriteErrLog(ex); } }
public bool Update(MInfo model) { StringBuilder sql = new StringBuilder(); sql.Append("Update Dat_Info set Title = @Title, Content =@Content,UserId=@UserId,CreateDateTime=@CreateDateTime,TypeId=@TypeId where Id = @Id"); SQLiteServer server = new SQLiteServer(); try { SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 4), new SQLiteParameter("@Title", DbType.String, 500), new SQLiteParameter("@Content", DbType.String, 30000), new SQLiteParameter("@UserId", DbType.Int16, 100), new SQLiteParameter("@CreateDateTime", DbType.DateTime), new SQLiteParameter("@TypeId", DbType.Int16, 100) }; parameters[0].Value = model.Id; parameters[1].Value = model.Title; parameters[2].Value = model.Content; parameters[3].Value = model.UserId; parameters[4].Value = DateTime.Now.ToString(); parameters[5].Value = model.TypeId; server.ExecuteNonQuery(sql.ToString(), parameters); } catch (Exception ex) { Log.WriteErrLog(ex); return(false); } finally { } return(true); }
/// <summary> /// 获得数据列表 /// </summary> public MInfo GetModel(int id) { StringBuilder sql = new StringBuilder(); sql.Append("select Id, Title ,Content ,typeId FROM Dat_Info where id = @id "); SQLiteServer server = new SQLiteServer(); SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int16, 100) }; parameters[0].Value = id; MInfo model = new MInfo(); DataTable dt = server.ExecuteQuery(sql.ToString(), parameters); if (dt.Rows.Count > 0) { model.Title = dt.Rows[0][1].ToString(); model.Id = int.Parse(dt.Rows[0][0].ToString()); model.Content = dt.Rows[0][2].ToString(); model.TypeId = int.Parse(dt.Rows[0][3].ToString()); } return(model); }
public FrmInfoDetail(MInfo _model) { model = _model; InitializeComponent(); txtContent.Text = model.Content; }
public static void SetMethodInfo(string keyName, Type classType, MethodInfo m) { _map[keyName] = new MInfo(classType, m); }