private void btn_Add_Click(object sender, EventArgs e)
{
FisherResult result = null;
TSysConfiguration sysConfiguration = new TSysConfiguration()
{
ConfigurationID = 1,
ConfigurationKey = Guid.NewGuid().ToString(),
IsDisabled = false
};
//using(IDbConnection dbConnection = new SqlConnection(Globals.SqlConnectionString)) {
// result = dbConnection.Insert<TSysConfiguration>(sysConfiguration);
//}
//if(result.ExecResult == Result.OK) {
//}
}
private void btn_PageClicked(object sender, EventArgs e)
{
int pageSize = FisherUtil.ParseInt(tbx_PageSize.Text, 10);
int pageIndex = FisherUtil.ParseInt(tbx_PageIndex.Text, 1);
Button btn = (Button)sender;
switch (btn.Name)
{
case "btn_FirstPage":
pageIndex = 1;
break;
case "btn_PrevPage":
pageIndex--;
break;
case "btn_NextPage":
pageIndex++;
break;
case "btn_LastPage":
pageIndex = totalPage;
break;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
else if (pageIndex > totalPage && totalPage > 0)
{
pageIndex = totalPage;
}
//Fisher.Query<TSysConfiguration>(sqlWhere: "",pageSize: 1);
FisherResult <TSysConfiguration> result = Fisher.Query <TSysConfiguration>(tbx_SqlCondition.Text, null, pageSize, pageIndex);
dgv.DataSource = result.Result;
tbx_PageIndex.Text = result.PageIndex.ToString();
tbx_RecordCount.Text = result.TotalRecord.ToString();
tbx_TotalPage.Text = result.TotalPage.ToString();
totalPage = result.TotalPage;
}
private void btn_Save_Click(object sender, EventArgs e)
{
int id = FisherUtil.ParseInt(tbx_ConfigurationID.Text);
TSysConfiguration configuration = new TSysConfiguration();
if (id > 0) // 修改
{
configuration.ConfigurationID = id;
}
configuration.ConfigurationKey = tbx_ConfigurationKey.Text;
configuration.Value = tbx_Value.Text;
configuration.Remark = tbx_Remark.Text;
configuration.IsDisabled = cbx_IsDisabled.Checked;
FisherResult result = null;
result = Fisher.Save <TSysConfiguration>(configuration);
if (result.Success == Result.True)
{
Console.WriteLine(result.Pk_Id);
}
}