代码拉取完成,页面将自动刷新
using SqlSugar;
using WinformDevFramework.Core.Winform;
using WinformDevFramework.IServices;
using WinformDevFramework;
namespace ${NameSpace}
{
public partial class Frm${tableName} : BaseForm1
{
private I${tableName}Services _${tableName}Services;
public Frm${tableName}(I${tableName}Services ${tableName}Services)
{
_${tableName}Services= ${tableName}Services;
InitializeComponent();
}
public override void Init()
{
base.Init();
//查询数据
this.dataGridViewList.DataSource = GetData();
// 设置隐藏列
#foreach($info in $EntityList)
#if(!${info.isIdentity})
this.dataGridViewList.Columns["${info.controlName}"].HeaderText = "${info.dataBaseFieldDDesr}";
#end
#end
SetToolButtonStatus(formStatus);
SetToolsButton();
}
public override void TabControlSelectingFunction(object? sender, TabControlCancelEventArgs e)
{
base.TabControlSelectingFunction(sender, e);
}
public override void DataGridViewListDoubleClick(object? sender, DataGridViewCellEventArgs e)
{
base.DataGridViewListDoubleClick(sender, e);
var g = (DataGridView)sender;
var model = g.CurrentRow.DataBoundItem as ${tableName};
//给详情页设置数据
this.txtID.Text = model.ID.ToString();
#foreach($info in $EntityList)
#if(!${info.isIdentity})
this.${info.controlName}.Text = model.${info.controlName}.ToString();
#end
#end
SetToolButtonStatus(formStatus);
}
public override void AddFunction(object sender, EventArgs e)
{
base.AddFunction(sender, e);
SetToolButtonStatus(formStatus);
}
public override void EditFunction(object sender, EventArgs e)
{
base.EditFunction(sender, e);
SetToolButtonStatus(formStatus);
}
public override void SaveFunction(object sender, EventArgs e)
{
base.SaveFunction(sender, e);
{
//新增
if (string.IsNullOrEmpty(txtID.Text))
{
${tableName} model = new ${tableName}();
// TODO获取界面的数据
#foreach($info in $EntityList)
#if(!${info.isIdentity})
model.${info.controlName}=this.${info.controlName}.Text;
#end
#end
var id = _${tableName}Services.Insert(model);
txtID.Text = id.ToString();
if (id > 0)
{
MessageBox.Show("保存成功!", "提示");
}
}
// 修改
else
{
${tableName} model = _${tableName}Services.QueryById(int.Parse(txtID.Text));
// TODO获取界面的数据
#foreach($info in $EntityList)
#if(!${info.isIdentity})
model.${info.controlName}=this.${info.controlName}.Text;
#end
#end
if (_${tableName}Services.Update(model))
{
MessageBox.Show("保存成功!", "提示");
}
}
SetToolButtonStatus(formStatus);
//列表重新赋值
this.dataGridViewList.DataSource = GetData();
}
}
public override void CanelFunction(object sender, EventArgs e)
{
bool isAdd = formStatus == FormStatus.Add;
base.CanelFunction(sender, e);
SetToolButtonStatus(formStatus);
btnEdit.Enabled = !isAdd;
btnDel.Enabled= !isAdd;
}
public override void DelFunction(object sender, EventArgs e)
{
base.DelFunction(sender, e);
var result = MessageBox.Show("是否删除?", "确认", MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Yes)
{
_${tableName}Services.DeleteById(Int32.Parse(txtID.Text));
formStatus = FormStatus.Del;
SetToolButtonStatus(formStatus);
//列表重新赋值
this.dataGridViewList.DataSource = GetData();
}
}
public override void SetToolButtonStatus(FormStatus status)
{
base.SetToolButtonStatus(status);
switch (status)
{
case FormStatus.Add:
{
btnAdd.Enabled = false;
btnEdit.Enabled = false;
btnSave.Enabled = true;
btnDel.Enabled = false;
btnCanel.Enabled = true;
SetControlStatus(this.groupBox1, true);
ClearControlsText(this.groupBox1);
break;
}
case FormStatus.Edit:
{
btnAdd.Enabled = false;
btnEdit.Enabled = false;
btnSave.Enabled = true;
btnDel.Enabled = false;
btnCanel.Enabled = true;
SetControlStatus(this.groupBox1, true);
break;
}
case FormStatus.View:
{
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnSave.Enabled = false;
btnDel.Enabled = true;
btnCanel.Enabled = false;
SetControlStatus(this.groupBox1, false);
break;
}
case FormStatus.Canel:
{
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnSave.Enabled = false;
btnDel.Enabled = false;
btnCanel.Enabled = false;
SetControlStatus(this.groupBox1, false);
break;
}
case FormStatus.First:
{
btnAdd.Enabled = true;
btnEdit.Enabled = false;
btnSave.Enabled = false;
btnDel.Enabled = false;
btnCanel.Enabled = false;
SetControlStatus(this.groupBox1, false);
break;
}
case FormStatus.Save:
{
btnAdd.Enabled = true;
btnEdit.Enabled = true;
btnSave.Enabled = false;
btnDel.Enabled = true;
btnCanel.Enabled = false;
SetControlStatus(this.groupBox1, false);
break;
}
case FormStatus.Del:
{
btnAdd.Enabled = true;
btnEdit.Enabled = false;
btnSave.Enabled = false;
btnDel.Enabled = false;
btnCanel.Enabled = false;
SetControlStatus(this.groupBox1, false);
ClearControlsText(this.groupBox1);
break;
}
}
}
public override bool ValidateData()
{
#foreach($info in $EntityList)
#if(!${info.isIdentity}&&${info.isCheck})
if (string.IsNullOrEmpty(${info.controlName}.Text))
{
MessageBox.Show("${info.dataBaseFieldDDesr}不能为空!");
return false;
}
#end
#end
return true;
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
private List<${tableName}> GetData()
{
List<${tableName}> data = new List<${tableName}>();
data = _${tableName}Services.Query();
return data;
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。