public int Delete(FileTemplateTypeModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new FileTemplateTypeBLL().Delete(ObjModel.Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
private FileTemplateTypeModel _DataBind(int Code)
{
FileTemplateTypeModel model = new FileTemplateTypeModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from FileTemplateType ");
builder.Append(" where Code=@Code");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, Code);
SqlDataReader sqlDataReader = null;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
this.Initialize(sqlDataReader, model);
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(model);
}
private void Initialize(SqlDataReader reader, FileTemplateTypeModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.Code = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.FileTemplateTypeName = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.ParentCode = reader.GetInt32(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.FullID = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.Deep = reader.GetInt32(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.OrderByID = reader.GetInt32(5);
}
}
private List <FileTemplateTypeModel> _Select(FileTemplateTypeQueryModel qmObj)
{
List <FileTemplateTypeModel> list = new List <FileTemplateTypeModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from FileTemplateType ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY Code desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
FileTemplateTypeModel model = new FileTemplateTypeModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
int code = Int32.Parse(Request.QueryString["code"]);
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
if (fttBFL.HasChild(code))
{
Response.Write("<script>window.alert('该节点含有子节点不能被删除，删除子节点后再进行操作！');</script>");
return;
}
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
fttModel.Code = code;
fttBFL.DeleteNodeAndTemplate(fttModel);
Response.Write("<script>opener.parent.location.reload();window.close();</script>");
Response.End();
}
protected void UpdateButton_Click(object sender, EventArgs e)
{
TextBox tb = (TextBox)(this.FormView1.Row.FindControl("FileTemplateTypeNameTextBox"));
if (tb.Text.Trim().Equals(String.Empty))
{
return;
}
int code = Int32.Parse(Request.QueryString["code"]);
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
fttModel.Code = code;
fttModel.FileTemplateTypeName = tb.Text;
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
fttBFL.Update(fttModel);
Response.Write("<script>opener.parent.location.reload();window.close()</script>");
}
public FileTemplateTypeModel GetFileTemplateType(int Code)
{
FileTemplateTypeModel model = new FileTemplateTypeModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new FileTemplateTypeBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public void DeleteNodeAndTemplate(FileTemplateTypeModel objModel)
{
FileTemplateBFL ebfl = new FileTemplateBFL();
FileTemplateQueryModel queryModel = new FileTemplateQueryModel();
queryModel.FileTemplateTypeCodeEqual = objModel.Code;
List <FileTemplateModel> fileTemplateList = new List <FileTemplateModel>();
fileTemplateList = ebfl.GetFileTemplateList(queryModel);
if (fileTemplateList != null)
{
foreach (FileTemplateModel model2 in fileTemplateList)
{
this.DeleteVersionByTemplate(model2);
ebfl.Delete(model2);
}
}
this.Delete(objModel);
}
public void btAdd_Click(object sender, EventArgs e)
{
int nodeValue = Int32.Parse(Request.QueryString["NodeValue"]);
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
fttModel = fttBFL.GetFileTemplateType(nodeValue);
FileTemplateBFL ftBFL = new FileTemplateBFL();
FileTemplateModel ftModel = new FileTemplateModel();
ftModel.FileTemplateName = this.tboxName.Text.Trim();
ftModel.SortCode = this.tboxSort.Text.Trim();
ftModel.FileTemplateTypeCode = nodeValue;
int code = ftBFL.Insert(ftModel);
Response.Write("<script>opener.parent.location.reload();location.href('FileTemplateVersionList.aspx?Code=" + code.ToString() + "');</script>");
//
//this.AddButton.Visible = false;
//this.tboxName.Enabled = false;
//this.tboxSort.Enabled = false;
}
protected void Page_Load(object sender, EventArgs e)
{
int nodeValue = Int32.Parse(Request.QueryString["NodeValue"]);
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
fttModel = fttBFL.GetFileTemplateType(nodeValue);
int parentCode = 0;
parentCode = fttModel.ParentCode;
string Text = fttModel.FileTemplateTypeName;
while (parentCode != 0)
{
fttModel = new FileTemplateTypeModel();
fttModel = fttBFL.GetFileTemplateType(parentCode);
parentCode = fttModel.ParentCode;
Text = fttModel.FileTemplateTypeName + " --> " + Text;
}
this.lblSortName.Text = Text;
}
public string GetParentPath(int code, out int parentCodeOut, out int typeCode)
{
int parentCode = 0;
FileTemplateBFL ebfl = new FileTemplateBFL();
FileTemplateModel fileTemplate = new FileTemplateModel();
FileTemplateTypeModel fileTemplateType = new FileTemplateTypeModel();
fileTemplate = ebfl.GetFileTemplate(code);
typeCode = fileTemplate.FileTemplateTypeCode;
fileTemplateType = this.GetFileTemplateType(typeCode);
string fileTemplateTypeName = fileTemplateType.FileTemplateTypeName;
parentCodeOut = fileTemplateType.ParentCode;
for (parentCode = fileTemplateType.ParentCode; parentCode != 0; parentCode = fileTemplateType.ParentCode)
{
fileTemplateType = new FileTemplateTypeModel();
fileTemplateType = this.GetFileTemplateType(parentCode);
fileTemplateTypeName = fileTemplateType.FileTemplateTypeName + " -> " + fileTemplateTypeName;
}
return(fileTemplateTypeName);
}
private int _Insert(FileTemplateTypeModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into FileTemplateType(");
builder.Append("FileTemplateTypeName,ParentCode,FullID,Deep,OrderByID)");
builder.Append(" values (");
builder.Append("@FileTemplateTypeName,@ParentCode,@FullID,@Deep,@OrderByID) ");
builder.Append("SELECT @Code = SCOPE_IDENTITY()");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@FileTemplateTypeName", SqlDbType.VarChar, 50, mObj.FileTemplateTypeName);
this._DataProcess.ProcessParametersAdd("@ParentCode", SqlDbType.Int, 4, mObj.ParentCode);
this._DataProcess.ProcessParametersAdd("@FullID", SqlDbType.VarChar, 50, mObj.FullID);
this._DataProcess.ProcessParametersAdd("@Deep", SqlDbType.Int, 4, mObj.Deep);
this._DataProcess.ProcessParametersAdd("@OrderByID", SqlDbType.Int, 4, mObj.OrderByID);
SqlParameter parameter = this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, null);
parameter.Direction = ParameterDirection.Output;
this._DataProcess.RunSql();
mObj.Code = (int)parameter.Value;
return(mObj.Code);
}
public List <FileTemplateTypeModel> GetRecursionFileTemplateTypeChildNodeByNodeCode(int NodeCode)
{
FileTemplateTypeQueryModel queryModel = new FileTemplateTypeQueryModel();
queryModel.ParentCodeEqual = NodeCode;
List <FileTemplateTypeModel> fileTemplateTypeList = this.GetFileTemplateTypeList(queryModel);
List <FileTemplateTypeModel> list2 = new List <FileTemplateTypeModel>();
foreach (FileTemplateTypeModel model2 in fileTemplateTypeList)
{
FileTemplateTypeModel item = new FileTemplateTypeModel();
item.Code = model2.Code;
list2.Add(item);
List <FileTemplateTypeModel> recursionFileTemplateTypeChildNodeByNodeCode = this.GetRecursionFileTemplateTypeChildNodeByNodeCode(model2.Code);
foreach (FileTemplateTypeModel model4 in recursionFileTemplateTypeChildNodeByNodeCode)
{
FileTemplateTypeModel model5 = new FileTemplateTypeModel();
model5.Code = model4.Code;
list2.Add(model5);
}
}
return(list2);
}
protected void AddButton_Click(object sender, EventArgs e)
{
TextBox tb = (TextBox)(this.FormView1.Row.FindControl("FileTemplateTypeNameTextBox"));
if (tb.Text.Trim().Equals(String.Empty))
{
return;
}
parentCode = Int32.Parse(Request.QueryString["Parentcode"]);
fullPath = Request.QueryString["FullPath"];
deep = Int32.Parse(Request.QueryString["Deep"]);
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
fttModel.FullID = fullPath;
fttModel.ParentCode = parentCode;
fttModel.Deep = deep + 1;
fttModel.FileTemplateTypeName = tb.Text;
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
fttBFL.Insert(fttModel);
this.FormView1.ChangeMode(FormViewMode.ReadOnly);
Response.Write("<script>opener.parent.location.reload();window.close();</script>");
}
private int _Update(FileTemplateTypeModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update FileTemplateType set ");
if (mObj.FileTemplateTypeName != null)
{
builder.Append("FileTemplateTypeName=@FileTemplateTypeName,");
this._DataProcess.ProcessParametersAdd("@FileTemplateTypeName", SqlDbType.VarChar, 50, mObj.FileTemplateTypeName);
}
if (mObj.ParentCode != 0)
{
builder.Append("ParentCode=@ParentCode,");
this._DataProcess.ProcessParametersAdd("@ParentCode", SqlDbType.Int, 4, mObj.ParentCode);
}
if (mObj.FullID != null)
{
builder.Append("FullID=@FullID,");
this._DataProcess.ProcessParametersAdd("@FullID", SqlDbType.VarChar, 50, mObj.FullID);
}
if (mObj.Deep != 0)
{
builder.Append("Deep=@Deep,");
this._DataProcess.ProcessParametersAdd("@Deep", SqlDbType.Int, 4, mObj.Deep);
}
if (mObj.OrderByID != 0)
{
builder.Append("OrderByID=@OrderByID,");
this._DataProcess.ProcessParametersAdd("@OrderByID", SqlDbType.Int, 4, mObj.OrderByID);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where Code=@Code");
this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, mObj.Code);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
protected void Page_Load(object sender, EventArgs e)
{
formType = Request.QueryString["FormType"];
if (formType != null)
{
if (formType.Equals("Add"))
{
this.FormView1.ChangeMode(FormViewMode.Insert);
}
parentCode = Int32.Parse(Request.QueryString["Parentcode"]);
fullPath = Request.QueryString["FullPath"];
deep = Int32.Parse(Request.QueryString["Deep"]);
}
else
{
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
fttModel = fttBFL.GetFileTemplateType(Int32.Parse(Request.QueryString["code"]));
deep = fttModel.Deep;
fullPath = fttModel.FullID;
}
text = "模版类别";
if (deep != 0 && fullPath != null)
{
string[] path = fullPath.Split('/');
for (int i = 1; i < path.Length; i++)
{
FileTemplateTypeBFL fttBFL = new FileTemplateTypeBFL();
FileTemplateTypeModel fttModel = new FileTemplateTypeModel();
fttModel = fttBFL.GetFileTemplateType(Int32.Parse(path[i]));
text += "-->" + fttModel.FileTemplateTypeName;
}
}
lblPath = (Label)(FormView1.Row.FindControl("lblPath"));
lblPath.Text = text;
}
public int Insert(FileTemplateTypeModel mObj)
{
return(this._Insert(mObj));
}
public int Update(FileTemplateTypeModel mObj)
{
return(this._Update(mObj));
}
public int Update(FileTemplateTypeModel ObjModel, SqlTransaction Transaction)
{
FileTemplateTypeDAL edal = new FileTemplateTypeDAL(Transaction);
return(edal.Update(ObjModel));
}
public int Delete(FileTemplateTypeModel mObj)
{
return(this._Delete(mObj.Code));
}
