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