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; } /// /// 获取数据 /// /// private List<${tableName}> GetData() { List<${tableName}> data = new List<${tableName}>(); data = _${tableName}Services.Query(); return data; } } }