private void btnSave_Click(object sender, EventArgs e)
{
string errMsg = string.Empty;
// if (pictureBox1.Image == null) errMsg += "请选择图片！\r\n";
if (lbID.Text == "lbID")
{
errMsg += "请点击您要修改的记录！\r\n";
}
string errSubClass = "";//判断子分类
List <Models.ClassJson> classJson = new List <ClassJson>();
foreach (Panel item in panelRoomList.Controls)
{
if (item.Name != "panelSave")
{
Controls.MainClassPanel panel = item as Controls.MainClassPanel;
errSubClass += panel.comboBox1.Text.Trim();
//计算分类
classJson.Add(new ClassJson()
{
ClassA = panel.ClassAname, ClassB = panel.comboBox1.Text.Trim()
});
//存盘子类
saveClassB(panel.ClassAname, panel.comboBox1.Text.Trim());
}
}
if (errSubClass == "")
{
errMsg += "请至少选择一个子分类！\r\n";
}
//准备存盘
if (string.IsNullOrEmpty(errMsg))
{
//2.保存信息到数据库
int id = Convert.ToInt32(lbID.Text);
Models.FileInfoModel info = new BLL.FileInfoModelBLL().GetById(id);
info.ClassJson = JsonConvert.SerializeObject(classJson);
info.Memo = tbMemo.Text;
new BLL.FileInfoModelBLL().Update(info);
MessageBox.Show("修改成功！");
//3.刷新gridview
BindDataWithPage(1, _sqlWhere);
}
else
{
MessageBox.Show(errMsg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void BindDataWithPage(int index, string sqlWhere)
{
allenPage1.PageIndex = index;
DataTable dt = new BLL.FileInfoModelBLL().GetPagedDataTable(allenPage1.PageSize, index, sqlWhere);
for (int i = 0; i < dt.Rows.Count; i++)
{
var m = JsonConvert.DeserializeObject <List <Models.comboClassModel> >(dt.Rows[i]["classJson"].ToString());
string result = "";
foreach (var item in m)
{
result += item.ClassA + "-" + item.ClassB + ";";
}
dt.Rows[i]["classJson"] = result;
}
dataGridView1.DataSource = dt;
//设置列名
dataGridView1.Columns[0].HeaderText = "序号";
dataGridView1.Columns["classJson"].HeaderText = "类别";
dataGridView1.Columns["classJson"].Width = 200;
dataGridView1.Columns[2].HeaderText = "文件名";
dataGridView1.Columns[3].HeaderText = "建立时间";
dataGridView1.Columns[4].HeaderText = "备注";
dataGridView1.Columns[5].HeaderText = "状态";
//设置时间格式
var dataGridViewColumn = dataGridView1.Columns["CreateTime"];
if (dataGridViewColumn != null)
{
dataGridViewColumn.DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss.fff";
dataGridViewColumn.FillWeight = 200;
}
//获取并设置总记录数
allenPage1.RecordCount = new BLL.FileInfoModelBLL().GetTotalCount();
}
private void btnDel_Click(object sender, EventArgs e)
{
DataGridView dv = this.dataGridView1;
if (dv != null && dv.CurrentRow != null)
{
string fileUrl = Server.ConfigHelper.UpLoadPath + dv.CurrentRow.Cells["fileUrl"].Value.ToString(); //todo,是否要删除原始图片？
int.TryParse(dv.CurrentRow.Cells["id"].Value.ToString(), out var id);
DialogResult result = MessageBox.Show("确认要删除所选内容吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
var r = new BLL.FileInfoModelBLL().DeleteById(id);
if (r > 0)
{
MessageBox.Show("删除成功！");
BindDataWithPage(allenPage1.PageIndex, _sqlWhere);
}
}
}
else
{
MessageBox.Show("请先点击需要删除的记录！");
}
}