public static string GetSubjectName(string subjectCode, string subjectSetCode) { string text2; try { string text = ""; if (subjectCode == "") { return(text); } EntityData subjectByCode = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode); if (subjectByCode.HasRecord()) { text = subjectByCode.GetString("SubjectName"); } subjectByCode.Dispose(); text2 = text; } catch (Exception exception) { throw exception; } return(text2); }
public static bool IsLeafSubjectNode(string subjectCode, string subjectSetCode) { bool flag2; try { if (subjectCode == "") { throw new ApplicationException("输入空科目编号。"); } EntityData subjectByCode = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode); if (!subjectByCode.HasRecord()) { throw new ApplicationException("没有这个科目编号。"); } int @int = subjectByCode.GetInt("ChildNodesCount"); subjectByCode.Dispose(); bool flag = false; if (@int == 0) { flag = true; } flag2 = flag; } catch (Exception exception) { throw exception; } return(flag2); }
/// 有效性检查 /// </summary> /// <param name="Hint"></param> /// <returns></returns> private bool CheckValid(ref string Hint, ref int parentLayer) { Hint = ""; parentLayer = 0; string subjectCode = this.txtSubjectCode.Value; string subjectSetCode = this.txtSubjectSetCode.Value; string ruleCode = SubjectRule.GetSubjectSetRuleCode(subjectSetCode); if (subjectCode == "") { Hint = "请输入科目代码"; return(false); } if (this.txtSubjectName.Value == "") { Hint = "请输入科目名称"; return(false); } // if (SubjectRule.IsFitRule(subjectCode,ruleCode)==false) // { // Hint = string.Format("科目编号不符合规则“{0}”,请重新输入!", ruleCode); // return false; // } string parentSubjectCode = SubjectRule.GetParentSubjectCode(subjectCode, ruleCode); if (parentSubjectCode != "") { EntityData entityParent = SubjectDAO.GetSubjectByCode(parentSubjectCode, subjectSetCode); if (!entityParent.HasRecord()) { Hint = string.Format("该科目编号的上级科目“{0}”不存在,请重新输入!", parentSubjectCode); return(false); } else { parentLayer = entityParent.GetInt("Layer"); } entityParent.Dispose(); } return(true); }
private void LoadData() { try { string subjectCode = this.txtSubjectCode.Value; string subjectSetCode = this.txtSubjectSetCode.Value; if (subjectCode != "") { EntityData entity = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode); if (entity.HasRecord()) { this.txtSubjectName.Value = entity.GetString("SubjectName"); if (entity.GetInt("IsDebit") == 1) { this.CheckBoxIsDebit.Checked = true; } else { this.CheckBoxIsDebit.Checked = false; } if (entity.GetInt("IsCrebit") == 1) { this.CheckBoxIsCrebit.Checked = true; } else { this.CheckBoxIsCrebit.Checked = false; } } else { Response.Write(Rms.Web.JavaScript.Alert(true, "科目不存在")); } entity.Dispose(); } } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错:" + ex.Message)); } }
public static void DeleteSubject(string subjectCode, string subjectSetCode) { try { EntityData entity = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode); SubjectDAO.DeleteSubject(entity); entity.Dispose(); QueryAgent agent = new QueryAgent(); try { agent.ExecuteSql(string.Format("delete Subject where SubjectSetCode = '{0}' and SubjectCode like '{1}%'", subjectSetCode, subjectCode)); } finally { agent.Dispose(); } } catch (Exception exception) { throw exception; } }
public static string CheckSubject(string SubjectCode, string SubjectSetCode, string HintDesc, ref string SubjectName) { string text2; try { string text = ""; SubjectName = ""; if (SubjectCode == "") { return(text); } EntityData subjectByCode = SubjectDAO.GetSubjectByCode(SubjectCode, SubjectSetCode); if (subjectByCode.HasRecord()) { SubjectName = subjectByCode.GetString("SubjectName"); if (subjectByCode.GetInt("ChildNodesCount") > 0) { text = string.Format("{0}不是末级科目 !", HintDesc); } } else if (HintDesc == "") { text = "科目不存在 !"; } else { text = string.Format("{0}不存在 !", HintDesc); } subjectByCode.Dispose(); text2 = text; } catch (Exception exception) { throw exception; } return(text2); }
public static bool CheckSubjectNode(string subjectCode, string subjectSetCode) { bool flag2; try { bool flag = false; if (subjectCode != "") { EntityData subjectByCode = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode); if (subjectByCode.HasRecord() && (subjectByCode.GetInt("ChildNodesCount") == 0)) { flag = true; } subjectByCode.Dispose(); } flag2 = flag; } catch (Exception exception) { throw exception; } return(flag2); }
protected void btnSave_ServerClick(object sender, System.EventArgs e) { try { string Hint = ""; int parentLayer = 0; if (!CheckValid(ref Hint, ref parentLayer)) { Response.Write(Rms.Web.JavaScript.Alert(true, Hint)); return; } string subjectCode = this.txtSubjectCode.Value; string subjectSetCode = this.txtSubjectSetCode.Value; EntityData entity = SubjectDAO.GetSubjectByCode(this.txtOldSubjectCode.Value, subjectSetCode); DataRow dr = null; bool IsNew = false; if (entity.HasRecord()) { IsNew = false; dr = entity.CurrentRow; //修改主键时,先删除,再新增 if (this.txtSubjectCode.Value != this.txtOldSubjectCode.Value) { dr.Delete(); IsNew = true; dr = entity.GetNewRecord(); dr["SubjectSetCode"] = subjectSetCode; } } else { IsNew = true; dr = entity.GetNewRecord(); dr["SubjectSetCode"] = subjectSetCode; } dr["SubjectName"] = this.txtSubjectName.Value; dr["SubjectCode"] = this.txtSubjectCode.Value; dr["Layer"] = parentLayer + 1; if (this.CheckBoxIsDebit.Checked == true) { dr["IsDebit"] = 1; } else { dr["IsDebit"] = 0; } if (this.CheckBoxIsCrebit.Checked == true) { dr["IsCrebit"] = 1; } else { dr["IsCrebit"] = 0; } if (IsNew) { entity.AddNewRecord(dr); } SubjectDAO.SubmitAllSubject(entity); this.txtOldSubjectCode.Value = this.txtSubjectCode.Value; entity.Dispose(); } catch (Exception ex) { Response.Write(JavaScript.Alert(true, "保存失败:" + ex.Message)); ApplicationLog.WriteLog(this.ToString(), ex, ""); return; } GoBack(); }