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