/// <summary> /// 得到一个对象实体 /// </summary> public ModTS_MODULE GetModel(string C_PARENTMODULEID, int N_ORDER) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_MODULEID,C_PARENTMODULEID,C_MODULENAME,C_ASSEMBLYNAME,C_MODULECLASS,C_DISABLE,N_ORDER,N_IMAGEINDEX,C_MODULE_TYPE,C_QUERY_STR,C_REMARK,C_EMP_ID,D_MOD_DT from TS_MODULE "); strSql.Append(" where C_PARENTMODULEID=:C_PARENTMODULEID and N_ORDER=:N_ORDER "); OracleParameter[] parameters = { new OracleParameter(":C_PARENTMODULEID", OracleDbType.Varchar2, 20), new OracleParameter(":N_ORDER", OracleDbType.Int16, 3) }; parameters[0].Value = C_PARENTMODULEID; parameters[1].Value = N_ORDER; ModTS_MODULE model = new ModTS_MODULE(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ModTS_MODULE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TS_MODULE set "); strSql.Append("C_PARENTMODULEID=:C_PARENTMODULEID,"); strSql.Append("C_MODULENAME=:C_MODULENAME,"); strSql.Append("C_ASSEMBLYNAME=:C_ASSEMBLYNAME,"); strSql.Append("C_MODULECLASS=:C_MODULECLASS,"); strSql.Append("C_DISABLE=:C_DISABLE,"); strSql.Append("N_ORDER=:N_ORDER,"); strSql.Append("N_IMAGEINDEX=:N_IMAGEINDEX,"); strSql.Append("C_MODULE_TYPE=:C_MODULE_TYPE,"); strSql.Append("C_QUERY_STR=:C_QUERY_STR,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT"); strSql.Append(" where C_MODULEID=:C_MODULEID "); OracleParameter[] parameters = { new OracleParameter(":C_PARENTMODULEID", OracleDbType.Varchar2, 20), new OracleParameter(":C_MODULENAME", OracleDbType.Varchar2, 50), new OracleParameter(":C_ASSEMBLYNAME", OracleDbType.Varchar2, 255), new OracleParameter(":C_MODULECLASS", OracleDbType.Varchar2, 255), new OracleParameter(":C_DISABLE", OracleDbType.Varchar2, 50), new OracleParameter(":N_ORDER", OracleDbType.Int16, 3), new OracleParameter(":N_IMAGEINDEX", OracleDbType.Int16, 3), new OracleParameter(":C_MODULE_TYPE", OracleDbType.Varchar2, 2), new OracleParameter(":C_QUERY_STR", OracleDbType.Varchar2, 300), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 50), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_MODULEID", OracleDbType.Varchar2, 20) }; parameters[0].Value = model.C_PARENTMODULEID; parameters[1].Value = model.C_MODULENAME; parameters[2].Value = model.C_ASSEMBLYNAME; parameters[3].Value = model.C_MODULECLASS; parameters[4].Value = model.C_DISABLE; parameters[5].Value = model.N_ORDER; parameters[6].Value = model.N_IMAGEINDEX; parameters[7].Value = model.C_MODULE_TYPE; parameters[8].Value = model.C_QUERY_STR; parameters[9].Value = model.C_REMARK; parameters[10].Value = model.C_EMP_ID; parameters[11].Value = model.D_MOD_DT; parameters[12].Value = model.C_MODULEID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void BindInfo() { try { modModule = bllModule.GetModel(strModuleID); if (IsEdit)//修改 { if (modModule != null) { modPar = bllModule.GetModel(modModule.C_PARENTMODULEID); if (modPar != null) { lbl_ParentName.Text = modPar.C_MODULENAME; } else { lbl_ParentName.Text = ""; } icbo_ImgIndex.Text = modModule.N_IMAGEINDEX.ToString(); txt_ModuleName.Text = modModule.C_MODULENAME.ToString(); cbo_BllName.Text = modModule.C_ASSEMBLYNAME.ToString(); ShowForm(cbo_BllName.Text); cbo_FrmName.Text = modModule.C_MODULECLASS.ToString(); icbo_State.Text = modModule.C_DISABLE.ToString(); txt_Parameter.Text = modModule.C_QUERY_STR.ToString(); } else { lbl_ParentName.Text = ""; } } else//新增 { if (modModule != null) { lbl_ParentName.Text = modModule.C_MODULENAME; } else { lbl_ParentName.Text = ""; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ModTS_MODULE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TS_MODULE("); strSql.Append("C_MODULEID,C_PARENTMODULEID,C_MODULENAME,C_ASSEMBLYNAME,C_MODULECLASS,C_DISABLE,N_ORDER,N_IMAGEINDEX,C_MODULE_TYPE,C_QUERY_STR,C_REMARK,C_EMP_ID)"); strSql.Append(" values ("); strSql.Append(":C_MODULEID,:C_PARENTMODULEID,:C_MODULENAME,:C_ASSEMBLYNAME,:C_MODULECLASS,:C_DISABLE,:N_ORDER,:N_IMAGEINDEX,:C_MODULE_TYPE,:C_QUERY_STR,:C_REMARK,:C_EMP_ID)"); OracleParameter[] parameters = { new OracleParameter(":C_MODULEID", OracleDbType.Varchar2, 20), new OracleParameter(":C_PARENTMODULEID", OracleDbType.Varchar2, 20), new OracleParameter(":C_MODULENAME", OracleDbType.Varchar2, 50), new OracleParameter(":C_ASSEMBLYNAME", OracleDbType.Varchar2, 255), new OracleParameter(":C_MODULECLASS", OracleDbType.Varchar2, 255), new OracleParameter(":C_DISABLE", OracleDbType.Varchar2, 50), new OracleParameter(":N_ORDER", OracleDbType.Int16, 3), new OracleParameter(":N_IMAGEINDEX", OracleDbType.Int16, 3), new OracleParameter(":C_MODULE_TYPE", OracleDbType.Varchar2, 2), new OracleParameter(":C_QUERY_STR", OracleDbType.Varchar2, 300), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 50), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 20) }; parameters[0].Value = model.C_MODULEID; parameters[1].Value = model.C_PARENTMODULEID; parameters[2].Value = model.C_MODULENAME; parameters[3].Value = model.C_ASSEMBLYNAME; parameters[4].Value = model.C_MODULECLASS; parameters[5].Value = model.C_DISABLE; parameters[6].Value = model.N_ORDER; parameters[7].Value = model.N_IMAGEINDEX; parameters[8].Value = model.C_MODULE_TYPE; parameters[9].Value = model.C_QUERY_STR; parameters[10].Value = model.C_REMARK; parameters[11].Value = model.C_EMP_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 下移 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void simpleButton5_Click(object sender, EventArgs e) { try { object item = this.bscTSMODULE.Current; if (item != null) { DataRowView drv = item as DataRowView; ModTS_MODULE mod = bllModule.GetModel(drv["C_PARENTMODULEID"].ToString(), Convert.ToInt32(drv["N_ORDER"].ToString()) + 1); if (mod != null) { int order_up = Convert.ToInt32(mod.N_ORDER); int order_down = Convert.ToInt32(drv["N_ORDER"].ToString()); bllModule.ResetOrder(mod.C_MODULEID, drv["C_MODULEID"].ToString(), order_up, order_down); BindTreeList(); foreach (TreeListNode node in tl_Module.Nodes) { if (node.Nodes.Count > 0) { PRV_SetState(drv["C_MODULEID"].ToString(), node); } string a = node.GetValue("C_MODULEID").ToString(); string b = drv["C_MODULEID"].ToString(); if (node.GetValue("C_MODULEID").ToString() == drv["C_MODULEID"].ToString()) { node.Selected = true; } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ModTS_MODULE model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ModTS_MODULE model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public ModTS_MODULE DataRowToModel(DataRow row) { ModTS_MODULE model = new ModTS_MODULE(); if (row != null) { if (row["C_MODULEID"] != null) { model.C_MODULEID = row["C_MODULEID"].ToString(); } if (row["C_PARENTMODULEID"] != null) { model.C_PARENTMODULEID = row["C_PARENTMODULEID"].ToString(); } if (row["C_MODULENAME"] != null) { model.C_MODULENAME = row["C_MODULENAME"].ToString(); } if (row["C_ASSEMBLYNAME"] != null) { model.C_ASSEMBLYNAME = row["C_ASSEMBLYNAME"].ToString(); } if (row["C_MODULECLASS"] != null) { model.C_MODULECLASS = row["C_MODULECLASS"].ToString(); } if (row["C_DISABLE"] != null) { model.C_DISABLE = row["C_DISABLE"].ToString(); } if (row["N_ORDER"] != null) { model.N_ORDER = decimal.Parse(row["N_ORDER"].ToString()); } if (row["N_IMAGEINDEX"] != null && row["N_IMAGEINDEX"].ToString() != "") { model.N_IMAGEINDEX = decimal.Parse(row["N_IMAGEINDEX"].ToString()); } if (row["C_MODULE_TYPE"] != null) { model.C_MODULE_TYPE = row["C_MODULE_TYPE"].ToString(); } if (row["C_QUERY_STR"] != null) { model.C_QUERY_STR = row["C_QUERY_STR"].ToString(); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } } return(model); }
/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void simpleButton1_Click(object sender, EventArgs e) { try { if (IsEdit)//修改 { modModule.C_MODULENAME = txt_ModuleName.Text.Trim(); modModule.C_ASSEMBLYNAME = cbo_BllName.Text; modModule.C_MODULECLASS = cbo_FrmName.Text; modModule.C_DISABLE = icbo_State.EditValue.ToString(); modModule.N_IMAGEINDEX = Convert.ToInt32(icbo_ImgIndex.EditValue.ToString()); modModule.C_EMP_ID = UserInfo.userID; modModule.D_MOD_DT = ServerTime.timeNow(); modModule.C_QUERY_STR = txt_Parameter.Text.Trim(); if (bllModule.Update(modModule)) { bllModule.Update(modModule.C_MODULEID, modModule.C_DISABLE); this.Close(); } } else//新增 { ModTS_MODULE modNew = new ModTS_MODULE(); if (modModule != null) { modNew.C_PARENTMODULEID = modModule.C_MODULEID; } else { modNew.C_PARENTMODULEID = "0"; } int MaxID = bllModule.GetMaxID(); if (MaxID == 0) { MessageBox.Show("无法添加信息!"); return; } else { modNew.C_MODULEID = (MaxID + 1).ToString(); } modNew.C_MODULENAME = txt_ModuleName.Text.Trim(); modNew.C_ASSEMBLYNAME = cbo_BllName.SelectedText; modNew.C_MODULECLASS = cbo_FrmName.SelectedText; modNew.C_DISABLE = icbo_State.EditValue.ToString(); modNew.N_IMAGEINDEX = Convert.ToInt32(icbo_ImgIndex.EditValue.ToString()); modNew.N_ORDER = bllModule.GetOrder(strModuleID) + 1; modNew.C_EMP_ID = UserInfo.userID; modNew.D_MOD_DT = ServerTime.timeNow(); modNew.C_QUERY_STR = txt_Parameter.Text.Trim(); if (bllModule.Add(modNew)) { MessageBox.Show("添加成功!"); this.Close(); } } } catch (Exception ex) { BllTB_LOG bllLog = new BllTB_LOG(); ModTB_LOG mod = new ModTB_LOG(); mod.C_MENU_NAME = "菜单管理"; mod.C_OPER_CONTEXT = ex.Message.ToString(); bllLog.Add(mod); } }