private void btnDel_Click(object sender, EventArgs e)
{
if (Id == 0)
{
ShowMsg("请先选择一条数据再删除");
return;
}
var step = lsbMain.SelectedItem as StepSetting;
if (step == null)
{
ShowMsg("请先选择一条数据再删除!");
return;
}
if (step.Id != Id)
{
ShowMsg("请先选择一条数据再删除!!");
return;
}
var dialog = ShowConfirm("是否要删除" + step.Name + "?");
if (dialog == DialogResult.Yes)
{
var isSuccess = DbEntityAccess.Delete <StepSetting>(Id);
if (isSuccess)
{
LoadList();
}
}
}
private void LoadList()
{
cmbWebTypeId.Items.Clear();
var webTypeList = DbEntityAccess.GetList <WebType>(" and EnumDic=" + (int)EnumDic.WebType);
cmbWebTypeId.Items.AddRange(webTypeList.ToArray());
if (cmbWebTypeId.Items.Count > 0)
{
cmbWebTypeId.SelectedIndex = 0;
}
cmbData.Items.Clear();
string[] tempList = Config.SuitTblName.Split(',').Where(m => !string.IsNullOrEmpty(m)).ToArray();
cmbData.Items.AddRange(tempList);
if (cmbData.Items.Count > 0)
{
cmbData.SelectedIndex = 0;
}
lsbMain.Items.Clear();
lsbMain.Items.Add("加载中...");
this.Refresh();
lsbMain.Items.Clear();
List <StepSetting> list = DbEntityAccess.GetList <StepSetting>();
foreach (StepSetting item in list)
{
item.StepDetailSetting = DbEntityAccess.GetList <StepDetailSetting>(" and StepSettingId=" + item.Id);
}
lsbMain.Items.AddRange(list.ToArray());
if (lsbMain.Items.Count > 0)
{
lsbMain.SelectedIndex = 0;
}
}
/// <summary>
/// 测试数据库方法
/// </summary>
/// <param name="args"></param>
static void Main2222(string[] args)
{
////新增
//StepSetting ss = new StepSetting();
//ss.Name = "必应6";
//ss.CreateDate = DateTime.Now;
//ss.Url = "www.bing.com6";
//ss.Remark = "111";
//DbEntityAccess.Add(ss);
//Console.WriteLine("主键ID:" + ss.Id);
//var newModel = DbEntityAccess.GetModel<StepSetting>(2);
//Console.WriteLine(@"更改前的值:" + newModel.ToJson());
////编辑
//StepSetting ss = new StepSetting();
//ss.Id = 2;
//ss.Name = "必应3213312";
//ss.CreateDate = DateTime.Now;
//ss.Url = "cn.bing.com32131231";
//DbEntityAccess.Update(ss);
//newModel = DbEntityAccess.GetModel<StepSetting>(2);
//Console.WriteLine(@"更改后的值:" + newModel.ToJson());
//删除
//StepSetting ss = new StepSetting();
//ss.Name = "测试";
//ss.CreateDate = DateTime.Now;
//ss.Url = "www.bing.com";
//DbEntityAccess.Add(ss);
//Console.WriteLine(@"新增入的:" + ss.ToJson());
//DbEntityAccess.Delete<StepSetting>(ss.Id);
//Console.WriteLine(@"删除刚添加入的主键ID:" + ss.Id);
var list = DbEntityAccess.GetList <StepSetting>();
Console.WriteLine(@"总条数:" + list.Count);
Console.WriteLine(list.ToJson());
int count = 0;
var list2 = DbEntityAccess.GetListByPage <StepSetting>(ref count, null, 3, 2, "OpDate", true);
Console.WriteLine(@"总条数2:" + count);
Console.WriteLine(list2.ToJson());
Console.Read();
}
private void btnSave_Click(object sender, EventArgs e)
{
var model = this.GetData2();
model.Id = Id;
string error = Validate(model);
if (!string.IsNullOrEmpty(error))
{
ShowMsg(error);
return;
}
int id = model.Id;
if (id == 0)
{
id = DbEntityAccess.Add(model);
}
else
{
DbEntityAccess.Update(model);
}
bool isSuccess = id > 0;
if (model.StepDetailSetting.Count > 0)
{
DbEntityAccess.DeleteByOnly <StepDetailSetting>(id);
foreach (StepDetailSetting item in model.StepDetailSetting)
{
item.StepSettingId = id;
DbEntityAccess.Add <StepDetailSetting>(item);
}
}
if (isSuccess)
{
LoadList();
}
}
