public void InsertDictionaryDetail(DictionaryDetail dictDetail)
{
string[] code = GetPYWB(dictDetail.Name);
string sql = string.Format(m_SqlInsertDictionaryDetail, dictDetail.DictionaryID, dictDetail.Name, code[0], code[1], dictDetail.CODE);
m_app.SqlHelper.ExecuteNoneQuery(sql);
}
private void gridViewDictionaryDetailFocusedRowChanged()
{
if (gridViewDictionaryDetail.FocusedRowHandle >= 0)
{
DataRowView drv = gridViewDictionaryDetail.GetRow(gridViewDictionaryDetail.FocusedRowHandle) as DataRowView;
if (drv != null)
{
DictionaryDetail dict = new DictionaryDetail(drv);
textEditDictionaryDetailName.Text = dict.Name;
textEditDictionaryDetailCode.Text = dict.CODE;
}
}
m_stateDetail = EditState.View;
this.FreshView();
}
private DictionaryDetail GetFormDictionaryDetail()
{
DictionaryDetail dictDetail = new DictionaryDetail();
dictDetail.Name = textEditDictionaryDetailName.Text;
dictDetail.CODE = textEditDictionaryDetailCode.Text;
if (gridViewDictionaryDetail.FocusedRowHandle >= 0)
{
DataRowView drv = gridViewDictionaryDetail.GetRow(gridViewDictionaryDetail.FocusedRowHandle) as DataRowView;
dictDetail.ID = drv[DictionaryDetail.s_ID].ToString().Trim();
dictDetail.DictionaryID = drv[DictionaryDetail.s_DictionaryID].ToString().Trim();
}
return(dictDetail);
}
/// <summary>
/// 删除字典明细事件
/// edit by Yanqiao.Cai 2012-11-06
/// 1、add try ... catch
/// 2、添加提示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButtonDeleteDetail_Click(object sender, EventArgs e)
{
try
{
if (gridViewDictionary.FocusedRowHandle < 0)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条字典分类记录");
return;
}
else if (gridViewDictionaryDetail.FocusedRowHandle < 0)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条字典记录");
return;
}
DataRow dr = gridViewDictionaryDetail.GetDataRow(gridViewDictionaryDetail.FocusedRowHandle);
if (null == dr || null == dr["NAME"])
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条字典记录");
return;
}
if (DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("您确定要删除字典 " + dr["NAME"] + " 吗？", "删除字典", DrectSoft.Common.Ctrs.DLG.MyMessageBoxButtons.OkCancel) == DialogResult.Cancel)
{
return;
}
DictionaryDetail dictDetail = GetFormDictionaryDetail();
m_SqlHelp.DeleteDictionaryDetail(dictDetail);
RefreshDictionaryDetail();
m_stateDetail = EditState.None;
this.FreshView();
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
public void DeleteDictionaryDetail(DictionaryDetail dictDetail)
{
string sql = string.Format(m_SqlCancelDictionaryDetail, dictDetail.ID);
m_app.SqlHelper.ExecuteNoneQuery(sql);
}
/// <summary>
/// 保存字典明细事件
/// edit by Yanqiao.Cai 2012-11-06
/// 1、add try ... catch
/// 2、添加提示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButtonSaveDetail_Click(object sender, EventArgs e)
{
try
{
if (m_stateDetail == EditState.Add)
{
if (gridViewDictionary.FocusedRowHandle < 0)
{
Host.CustomMessageBox.MessageShow("请选择一条分类记录", Core.CustomMessageBoxKind.InformationOk);
return;
}
else if (textEditDictionaryDetailName.Text.Trim() == "")
{
Host.CustomMessageBox.MessageShow("分类明细的名称不能为空", Core.CustomMessageBoxKind.InformationOk);
textEditDictionaryDetailName.Focus();
return;
}
DictionaryDetail dictDetail = GetFormDictionaryDetail();
dictDetail.Name = textEditDictionaryDetailName.Text.Trim();
dictDetail.CODE = textEditDictionaryDetailCode.Text.Trim();
Dictionary dict = GetFormDictionary();
dictDetail.DictionaryID = dict.ID;
m_SqlHelp.InsertDictionaryDetail(dictDetail);
RefreshDictionaryDetail();
}
else if (m_stateDetail == EditState.Edit)
{
if (gridViewDictionary.FocusedRowHandle < 0)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条分类记录");
return;
}
else if (gridViewDictionaryDetail.FocusedRowHandle < 0)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条字典记录");
return;
}
else if (string.IsNullOrEmpty(textEditDictionaryDetailName.Text.Trim()))
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("字典名称不能为空");
textEditDictionaryDetailName.Focus();
return;
}
DictionaryDetail dictDetail = GetFormDictionaryDetail();
dictDetail.Name = textEditDictionaryDetailName.Text.Trim();
dictDetail.CODE = textEditDictionaryDetailCode.Text.Trim();
Dictionary dict = GetFormDictionary();
dictDetail.DictionaryID = dict.ID;
m_SqlHelp.UpdateDictionaryDetail(dictDetail);
RefreshDictionaryDetail();
}
m_stateDetail = EditState.None;
this.FreshView();
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
