/// <summary>
/// 生成模型表XML
/// </summary>
/// <param name="Val"></param>
public void CreateXml(mTable Val)
{
XmlDoc xml = new XmlDoc();
xml.xmlfilePath = GetConfig.System("TableXmlPath") + Val.TableName + ".xml";
xml.CreateXml("utf-8", Val.TableName);
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
if (!IsPostBack)
{
bTable bT = new bTable();
string Action = Request.QueryString["Action"];
if (Action == "del")
{
mTable mT = new mTable();
mT.Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (bT.GetIsSystem(mT))
{
StringDeal.Alter("此模型为系统模型禁止删除！");
}
mT.TableName = bT.GetTableName(mT.Id);
bT.TableDel(mT);
HXD.ModelField.BLL.Table bt = new HXD.ModelField.BLL.Table();
bt.DeleteXml(mT);
}
DBList.DataSource = bT.TableList();
DBList.DataBind();
}
}
/// <summary>
/// 修改模型表
/// </summary>
/// <param name="Info"></param>
public void TableUpdate(mTable Info)
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@Id", Info.Id),
new SqlParameter("@Title", Info.Title),
new SqlParameter("@Note", Info.Note)
};
SQLHelper.ExecuteNonQuery("TableEdit", par);
}
/// <summary>
/// 添加模型表
/// </summary>
/// <param name="Info"></param>
public void TableInsert(mTable Info)
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@Title", Info.Title),
new SqlParameter("@TableName", Info.TableName),
new SqlParameter("@Note", Info.Note),
new SqlParameter("@Type", Info.Type)
};
SQLHelper.ExecuteNonQuery("TableInsert", par);
}
/// <summary>
/// 读取模型表信息
/// </summary>
protected void TableRead()
{
if (mT.Id > 0)
{
mTable mTa = bT.TableRead(mT);
this.Title.Text = mTa.Title;
this.TableName.Text = mTa.TableName.Replace("tb_U_", "");
this.Note.Text = mTa.Note;
this.Type.SelectedValue = mTa.Type.ToString();
this.Type.Attributes.Add("disabled", "disabled");
}
}
/// <summary>
/// 根据ID获取单条模型信息
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public mTable TableRead(mTable Info)
{
using (SqlDataReader dr = SQLHelper.ExecuteReader("TableRead", Info.Id))
{
if (dr.Read())
{
Info.Title = dr[0].ToString();
Info.TableName = dr[1].ToString();
Info.Note = dr[2].ToString();
Info.Type = StringDeal.ToInt(dr[3]);
}
}
return(Info);
}
/// <summary>
/// 判断数据库中是否存在某表名
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool IsTable(mTable Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("IsExistTable", Info.TableName)));
}
/// <summary>
/// 删除模型
/// </summary>
/// <param name="Info"></param>
public void TableDel(mTable Info)
{
SQLHelper.ExecuteNonQuery("TableDel", Info.Id);
}
/// <summary>
/// 获取模型是否为系统模型
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool GetIsSystem(mTable Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetTableIsSystem", Info.Id)));
}
/// <summary>
/// 删除模型表XML
/// </summary>
/// <param name="Val"></param>
public void DeleteXml(mTable Val)
{
Files.DeleteFile(GetConfig.System("TableXmlPath") + Val.TableName + ".xml");
}
public bool GetIsSystem(mTable Info)
{
return(dal.GetIsSystem(Info));
}
public bool IsTable(mTable Info)
{
return(dal.IsTable(Info));
}
public mTable TableRead(mTable Info)
{
return(dal.TableRead(Info));
}
public void TableDel(mTable Info)
{
dal.TableDel(Info);
}
public void TableUpdate(mTable Info)
{
dal.TableUpdate(Info);
}
public void TableInsert(mTable Info)
{
dal.TableInsert(Info);
}
