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