private DocumentDirectoryModel _DataBind(int Code)
{
DocumentDirectoryModel model = new DocumentDirectoryModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from DocumentDirectory ");
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);
}
public int Update(DocumentDirectoryModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new DocumentDirectoryBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
private int _Insert(DocumentDirectoryModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into DocumentDirectory(");
builder.Append("DirectoryName,DepartmentCode,DirectoryNodeCode,FileTemplateCode,ParentCode,FullID,Deep,CreateDate,OrderByID)");
builder.Append(" values (");
builder.Append("@DirectoryName,@DepartmentCode,@DirectoryNodeCode,@FileTemplateCode,@ParentCode,@FullID,@Deep,@CreateDate,@OrderByID) ");
builder.Append("SELECT @Code = SCOPE_IDENTITY()");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@DirectoryName", SqlDbType.VarChar, 50, mObj.DirectoryName);
this._DataProcess.ProcessParametersAdd("@DepartmentCode", SqlDbType.VarChar, 50, mObj.DepartmentCode);
this._DataProcess.ProcessParametersAdd("@DirectoryNodeCode", SqlDbType.VarChar, 50, mObj.DirectoryNodeCode);
this._DataProcess.ProcessParametersAdd("@FileTemplateCode", SqlDbType.Int, 4, mObj.FileTemplateCode);
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("@CreateDate", SqlDbType.DateTime, 8, mObj.CreateDate);
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 <DocumentFileModel> GetDocumentFileListByCondition(string SortColumns, int StartRecord, int MaxRecords, string NodeCode, string FileCodeEqual, string DoucmentMarkingSNEqual, string SubjectEqual, DateTime ArchiveDateTimeEqualStart, DateTime ArchiveDateTimeEqualEnd)
{
DocumentDirectoryBFL ybfl = new DocumentDirectoryBFL();
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
DocumentDirectoryModel model2 = new DocumentDirectoryModel();
queryModel.CodeEqual = int.Parse(NodeCode);
List <DocumentDirectoryModel> documentDirectoryList = ybfl.GetDocumentDirectoryList(queryModel);
string departmentCode = "";
int fileTemplateCode = 0;
if (documentDirectoryList.Count > 0)
{
departmentCode = documentDirectoryList[0].DepartmentCode;
fileTemplateCode = documentDirectoryList[0].FileTemplateCode;
}
DocumentFileQueryModel model3 = new DocumentFileQueryModel();
model3.FileTemplateCodeEqual = fileTemplateCode;
model3.ApplyDepartmentCodeEqual = departmentCode;
model3.SortColumns = SortColumns;
model3.StartRecord = StartRecord;
model3.MaxRecords = MaxRecords;
model3.DoucmentMarkingSNEqual = DoucmentMarkingSNEqual;
model3.SubjectEqual = SubjectEqual;
model3.FileCodeEqul = FileCodeEqual;
model3.ArchiveDatetimeEqualStart = ArchiveDateTimeEqualStart;
model3.ArchiveDatetimeEqualEnd = ArchiveDateTimeEqualEnd;
return(this.GetDocumentFileList(model3));
}
public List <DocumentFileModel> GetDocumentFileList(string SortColumns, int StartRecord, int MaxRecords, string NodeCode)
{
DocumentDirectoryBFL ybfl = new DocumentDirectoryBFL();
DocumentDirectoryQueryModel queryModel = new DocumentDirectoryQueryModel();
DocumentDirectoryModel model2 = new DocumentDirectoryModel();
queryModel.CodeEqual = int.Parse(NodeCode);
List <DocumentDirectoryModel> documentDirectoryList = ybfl.GetDocumentDirectoryList(queryModel);
string departmentCode = "";
int fileTemplateCode = 0;
if (documentDirectoryList.Count > 0)
{
departmentCode = documentDirectoryList[0].DepartmentCode;
fileTemplateCode = documentDirectoryList[0].FileTemplateCode;
}
DocumentFileQueryModel model3 = new DocumentFileQueryModel();
model3.FileTemplateCodeEqual = fileTemplateCode;
model3.ApplyDepartmentCodeEqual = departmentCode;
model3.SortColumns = SortColumns;
model3.StartRecord = StartRecord;
model3.MaxRecords = MaxRecords;
return(this.GetDocumentFileList(model3));
}
private int _Update(DocumentDirectoryModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update DocumentDirectory set ");
if (mObj.DirectoryName != null)
{
builder.Append("DirectoryName=@DirectoryName,");
this._DataProcess.ProcessParametersAdd("@DirectoryName", SqlDbType.VarChar, 50, mObj.DirectoryName);
}
if (mObj.DepartmentCode != null)
{
builder.Append("DepartmentCode=@DepartmentCode,");
this._DataProcess.ProcessParametersAdd("@DepartmentCode", SqlDbType.VarChar, 50, mObj.DepartmentCode);
}
if (mObj.DirectoryNodeCode != null)
{
builder.Append("DirectoryNodeCode=@DirectoryNodeCode,");
this._DataProcess.ProcessParametersAdd("@DirectoryNodeCode", SqlDbType.VarChar, 50, mObj.DirectoryNodeCode);
}
if (mObj.FileTemplateCode != 0)
{
builder.Append("FileTemplateCode=@FileTemplateCode,");
this._DataProcess.ProcessParametersAdd("@FileTemplateCode", SqlDbType.Int, 4, mObj.FileTemplateCode);
}
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.CreateDate != DateTime.MinValue)
{
builder.Append("CreateDate=@CreateDate,");
this._DataProcess.ProcessParametersAdd("@CreateDate", SqlDbType.DateTime, 8, mObj.CreateDate);
}
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());
}
private List <DocumentDirectoryModel> _Select(DocumentDirectoryQueryModel qmObj)
{
List <DocumentDirectoryModel> list = new List <DocumentDirectoryModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from DocumentDirectory ");
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)))
{
DocumentDirectoryModel model = new DocumentDirectoryModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public DocumentDirectoryModel GetDocumentDirectory(int Code)
{
DocumentDirectoryModel model = new DocumentDirectoryModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new DocumentDirectoryBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
private void Initialize(SqlDataReader reader, DocumentDirectoryModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.Code = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.DirectoryName = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.DepartmentCode = reader.GetString(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.DirectoryNodeCode = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.FileTemplateCode = reader.GetInt32(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.ParentCode = reader.GetInt32(5);
}
if (reader.GetValue(6) != DBNull.Value)
{
obj.FullID = reader.GetString(6);
}
if (reader.GetValue(7) != DBNull.Value)
{
obj.Deep = reader.GetInt32(7);
}
if (reader.GetValue(8) != DBNull.Value)
{
obj.CreateDate = reader.GetDateTime(8);
}
if (reader.GetValue(9) != DBNull.Value)
{
obj.OrderByID = reader.GetInt32(9);
}
}
public void Insert(XmlDocument doc, int ParentCode, XmlNodeList CurrentNodeList, string DepartmentCode, string FullID, int Deep, string DirectoryNodeCode)
{
DocumentDirectoryModel objModel = new DocumentDirectoryModel();
foreach (XmlNode node in CurrentNodeList)
{
objModel.DirectoryName = node.Attributes["Text"].InnerText;
objModel.ParentCode = ParentCode;
objModel.DepartmentCode = DepartmentCode;
objModel.DirectoryNodeCode = DirectoryNodeCode;
objModel.CreateDate = DateTime.Now;
objModel.Deep = Deep + 1;
if (!node.HasChildNodes)
{
objModel.FileTemplateCode = int.Parse(node.Attributes["Code"].InnerText);
}
objModel.FullID = FullID + "/" + ParentCode;
this.Insert(doc, this.Insert(objModel), node.ChildNodes, DepartmentCode, FullID + "/" + ParentCode, Deep + 1, DirectoryNodeCode);
}
}
protected void SelectButton_Click(object sender, EventArgs e)
{
if (this.ParentCode != "" && this.ParentCode != null)
{
DocumentDirectoryBFL objBFL = new DocumentDirectoryBFL();
DocumentDirectoryModel ObjModel = new DocumentDirectoryModel();
string DepartmentCode = objBFL.GetDocumentDirectory(int.Parse(this.ParentCode)).DepartmentCode;
string DirectoryNodeCode = objBFL.GetDocumentDirectory(int.Parse(this.ParentCode)).DirectoryNodeCode;
string FullID = objBFL.GetDocumentDirectory(int.Parse(this.ParentCode)).FullID;
int Deep = objBFL.GetDocumentDirectory(int.Parse(this.ParentCode)).Deep;
foreach (GridViewRow gvr in GridView1.Rows)
{
CheckBox chk = (CheckBox)gvr.Cells[3].Controls[1];
if (chk.Checked)
{
Label labFileTemplateName = (Label)gvr.Cells[1].Controls[1];
ObjModel.DirectoryName = labFileTemplateName.Text;
ObjModel.ParentCode = int.Parse(ParentCode);
ObjModel.DepartmentCode = DepartmentCode;
ObjModel.DirectoryNodeCode = DirectoryNodeCode;
ObjModel.CreateDate = System.DateTime.Now;
ObjModel.Deep = Deep + 1;
Label labCode = (Label)gvr.Cells[0].Controls[1];
ObjModel.FileTemplateCode = int.Parse(labCode.Text);
ObjModel.FullID = FullID + "/" + ParentCode;
objBFL.Insert(ObjModel);
}
}
Response.Write("<script>window.parent.opener.location.reload();</script>");
}
}
public int Update(DocumentDirectoryModel mObj)
{
return(this._Update(mObj));
}
public int Insert(DocumentDirectoryModel mObj)
{
return(this._Insert(mObj));
}
public int Delete(DocumentDirectoryModel mObj)
{
return(this._Delete(mObj.Code));
}
public int Update(DocumentDirectoryModel ObjModel, SqlTransaction Transaction)
{
DocumentDirectoryDAL ydal = new DocumentDirectoryDAL(Transaction);
return(ydal.Update(ObjModel));
}
public int Insert(DocumentDirectoryModel ObjModel, SqlTransaction Transaction)
{
DocumentDirectoryDAL ydal = new DocumentDirectoryDAL(Transaction);
return(ydal.Insert(ObjModel));
}
