protected static void Init()
{
if (FishEntity.Variable.DictList == null)
{
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
FishEntity.Variable.DictList = bll.GetModelList("isdelete=0");
}
}
protected void InitDataGridViewColumns()
{
dataGridView1.Columns.Clear();
if (FishEntity.Variable.ProductDataTypeList == null)
{
return;
}
FishEntity.SystemDataType checkType = FishEntity.Variable.ProductDataTypeList.Find((i) => { return(i.Code == FishEntity.Constant.CheckItem); });
if (checkType == null)
{
return;
}
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
_columns = bll.GetModelList(string.Format(" isdelete=0 and issystem=0 and pcode='{0}' order by pcode asc,orderid asc", checkType.Code));
if (_columns == null || _columns.Count < 1)
{
return;
}
try
{
DataGridViewColumn col = null;
foreach (FishEntity.DictEntity item in _columns)
{
col = new DataGridViewTextBoxColumn();
col.HeaderText = item.name;
col.Name = item.code;
col.Width = 80;
dataGridView1.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = item.name + "_id";
col.Name = item.code + "_id";
col.Visible = false;
dataGridView1.Columns.Add(col);
}
col = new DataGridViewTextBoxColumn();
col.Name = "id";
col.HeaderText = "id";
dataGridView1.Columns.Add(col);
col.Visible = false;
col = new DataGridViewTextBoxColumn();
col.Name = "line";
col.HeaderText = "line";
col.Visible = false;
dataGridView1.Columns.Add(col);
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
public override int Query()
{
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
List <FishEntity.DictEntity> list = bll.GetModelList("isdelete=0 and issystem=1 order by pcode asc ,orderid asc");
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = list;
return(1);
}
public override int Delete()
{
//return base.Delete();
if (dataGridView1.SelectedRows == null)
{
MessageBox.Show("请选择要删除的行记录");
return(0);
}
string ids = string.Empty;
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
if (string.IsNullOrEmpty(ids) == false)
{
ids += ",";
}
ids += row.Cells["id"].Value.ToString();
}
if (string.IsNullOrEmpty(ids))
{
MessageBox.Show("请选择要删除的行记录");
return(0);
}
if (MessageBox.Show("您确定要删除选中的记录吗?", "询问", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.Cancel)
{
return(0);
}
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
if (bll.DeleteList(ids))
{
FishEntity.Variable.DictList = null;
Query();
}
return(1);
}
private void btnOk_Click(object sender, EventArgs e)
{
if (Check() == false)
{
this.DialogResult = System.Windows.Forms.DialogResult.None;
return;
}
bool isAdd = false;
if (_entity == null)
{
_entity = new FishEntity.DictEntity();
_entity.isdelete = 0;
_entity.issystem = _dataType == FishEntity.DataTypeEnum.SYSTEM ? 1 : 0;
isAdd = true;
}
else
{
string code = txtCode.Text.Trim();
if (_entity.code.Equals(code) == false)
{
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
if (bll.Exists(code, cmbType.SelectedValue.ToString(), _entity.issystem))
{
MessageBox.Show("代码已经存在，请修改其他值。");
this.DialogResult = System.Windows.Forms.DialogResult.None;
return;
}
}
}
_entity.code = txtCode.Text.Trim();
_entity.name = txtName.Text.Trim();
_entity.pcode = cmbType.SelectedValue.ToString();
_entity.orderid = (int)numericUpDown1.Value;
_entity.remark = txtRemark.Text.Trim();
if (_entity.pcode.Equals(FishEntity.Constant.Area))
{
_entity.pid = int.Parse(cmbPid.SelectedValue.ToString());
}
else if (_entity.pcode.Equals(FishEntity.Constant.Brand))
{
_entity.pid = int.Parse(cmbPid.SelectedValue.ToString());
}
else
{
_entity.pid = 0;
}
if (isAdd)
{
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
if (bll.Exists(_entity.code, _entity.pcode, _entity.issystem))
{
MessageBox.Show("代码已经存在，请修改其他值。");
this.DialogResult = System.Windows.Forms.DialogResult.None;
return;
}
bool isOk = bll.Add(_entity);
if (isOk)
{
OnRefresh();
}
}
else
{
FishBll.Bll.DictBll bll = new FishBll.Bll.DictBll();
bool isOk = bll.Update(_entity);
if (isOk)
{
OnRefresh();
}
}
InitDataUtil.DictList = null;
}