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); } }