/// <summary> /// /// </summary> /// <param name="unitId"></param> /// <param name="row"></param> /// <param name="col"></param> /// <returns></returns> public int MoveUnit(string unitId, string row, string col) { string funMsg = "function: MoveUnit(string unitId, string row, string col)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_moveunit";//"spMoveUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.NVarChar, Value = unitId }, new SqlParameter { ParameterName = "@row", SqlDbType = SqlDbType.NVarChar, Value = row }, new SqlParameter { ParameterName = "@col", SqlDbType = SqlDbType.NVarChar, Value = col } })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int UpdateUnit(string unitId, string cx_axis, string cy_axis, string modifyBy) { string funMsg = "Function: UpdateData(string unitId, string x_axis, string y_axis, string modifyBy)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "spUpdateUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.Char, Value = unitId }, new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.VarChar, Value = cx_axis }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.VarChar, Value = cy_axis }, new SqlParameter { ParameterName = "@modifyBy", SqlDbType = SqlDbType.Char, Value = modifyBy }, })); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <param name="unitId"></param> /// <param name="area"></param> /// <param name="countf"></param> /// <param name="countt"></param> /// <param name="countw"></param> /// <param name="direction"></param> /// <returns></returns> public int UpdateUnit(string unitId, decimal area, int countf, int countt, int countw, string direction) { string funMsg = "function: UpdateUnit(string item, decimal area, int countf, int countt, int countw, string direction)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_updunit";//"spUpdateUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.NVarChar, Value = unitId }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.Decimal, Value = area }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.Int, Value = countf }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.Int, Value = countt }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.Int, Value = countw }, new SqlParameter { ParameterName = "@direction", SqlDbType = SqlDbType.NVarChar, Value = direction }, })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int InsertUnitByName(string buildName, string cx_axis, string cy_axis, string createBy) { string funMsg = "Function: InsertUnitByName(string buildId, string x_axis, string y_axis, int createBy)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "spInsertUnitByName"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.Char, Value = buildName }, new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.VarChar, Value = cx_axis }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.VarChar, Value = cy_axis }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = createBy }, })); } catch (Exception ex) { throw ex; } }
public int DeleteUnit(string unitId, string modifyBy) { string funMsg = "Function: DeleteUnit(string unitId, string modifyBy)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spDeleteUnit"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.VarChar, Value = unitId }, new SqlParameter { ParameterName = "@modifyBy", SqlDbType = SqlDbType.Char, Value = modifyBy } )); } catch (Exception ex) { throw ex; } }
public int UpdateBuild(string buildId, string buildName, string address, string modifyBy) { string funMsg = "Function: UpdateBuild(string buildId, string buildName, string address, string modifyBy)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spUpdateBuild"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@buildId", SqlDbType = SqlDbType.VarChar, Value = buildId }, new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.VarChar, Value = buildName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.VarChar, Value = address }, new SqlParameter { ParameterName = "@modifyBy", SqlDbType = SqlDbType.Char, Value = modifyBy } })); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <param name="estate"></param> /// <returns></returns> public int UpdateEstate(CentaEstateType estate) { string funMsg = "function: UpdateEstate(CentaEstateType estate)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_updest";//"spUpdateEstate"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@scopeId", SqlDbType = SqlDbType.NVarChar, Value = estate.ScopeId }, new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.NVarChar, Value = estate.EstateId }, new SqlParameter { ParameterName = "@estateName", SqlDbType = SqlDbType.NVarChar, Value = estate.EstateName }, new SqlParameter { ParameterName = "@estateType", SqlDbType = SqlDbType.NVarChar, Value = estate.EstateType }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.NVarChar, Value = estate.Address }, new SqlParameter { ParameterName = "@phase", SqlDbType = SqlDbType.NVarChar, Value = estate.Phase } })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int ImportBuild(BuildFwType buildFwType) { string funMsg = "function: ImportBuild(BuildFwType buildFwType)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spImportBuild"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.Char, Value = buildFwType.BuildName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.Char, Value = buildFwType.Address }, new SqlParameter { ParameterName = "@flowStatus", SqlDbType = SqlDbType.Int, Value = buildFwType.Flow }, new SqlParameter { ParameterName = "@operateStatus", SqlDbType = SqlDbType.Int, Value = buildFwType.Operate }, new SqlParameter { ParameterName = "@collect_BuildId", SqlDbType = SqlDbType.Char, Value = buildFwType.Collect_BuildId }, new SqlParameter { ParameterName = "@collect_EstateId", SqlDbType = SqlDbType.Char, Value = buildFwType.Collect_EstateId }, new SqlParameter { ParameterName = "@collect_BuildName", SqlDbType = SqlDbType.NVarChar, Value = buildFwType.Collect_BuildName }, new SqlParameter { ParameterName = "@collect_Address", SqlDbType = SqlDbType.NVarChar, Value = buildFwType.Collect_Address }, new SqlParameter { ParameterName = "@agencyCom_BuildId", SqlDbType = SqlDbType.Char, Value = buildFwType.AgencyCom_BuildId }, new SqlParameter { ParameterName = "@agencyCom_EstateId", SqlDbType = SqlDbType.Char, Value = buildFwType.AgencyCom_EstateId }, new SqlParameter { ParameterName = "@agencyCom_BuildName", SqlDbType = SqlDbType.NVarChar, Value = buildFwType.AgencyCom_BuildName }, new SqlParameter { ParameterName = "@agencyCom_Address", SqlDbType = SqlDbType.NVarChar, Value = buildFwType.AgencyCom_Address }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = buildFwType.CreateBy }, })); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <param name="buildId"></param> /// <param name="floor"></param> /// <param name="room"></param> /// <param name="area"></param> /// <param name="countf"></param> /// <param name="countt"></param> /// <param name="countw"></param> /// <param name="direction"></param> /// <returns></returns> public int AddUnit(string buildId, string floor, string room, decimal area, string countf, string countt, string countw, string direction) { string funMsg = "function: AddUnit(string buildId, string floor, string room, decimal area, string countf, string countt,string countw,string direction)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_addunit";//"spInsertUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@centabldg", SqlDbType = SqlDbType.NVarChar, Value = buildId }, new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.NVarChar, Value = room }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.NVarChar, Value = floor }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.Decimal, Value = area }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.NVarChar, Value = countf }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.NVarChar, Value = countt }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.NVarChar, Value = countw }, new SqlParameter { ParameterName = "@direction", SqlDbType = SqlDbType.NVarChar, Value = direction }, new SqlParameter { ParameterName = "@c_feature", SqlDbType = SqlDbType.NVarChar, Value = buildId }, new SqlParameter { ParameterName = "@c_feature2", SqlDbType = SqlDbType.NVarChar, Value = buildId }, })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int InsertUnit(string buildId, string x_axis, string y_axis, int countf, int countt, int countw, int county, float area, string directionTo, string createBy) { string funMsg = "Function: InsertUnit(string buildId, string x_axis, string y_axis, int countf,int countt,int countw,int county,float area,string directionTo, string createBy)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "spInsertUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@buildId", SqlDbType = SqlDbType.Char, Value = buildId }, new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.NVarChar, Value = x_axis }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.NVarChar, Value = y_axis }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.Int, Value = countf }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.Int, Value = countt }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.Int, Value = countw }, new SqlParameter { ParameterName = "@county", SqlDbType = SqlDbType.Int, Value = county }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.Float, Value = area }, new SqlParameter { ParameterName = "@directionTo", SqlDbType = SqlDbType.NVarChar, Value = directionTo }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = createBy }, })); } catch (Exception ex) { throw ex; } }
public int ImportEstate(EstateCtType estateCtType) { string funMsg = "function: ImportEstate(EstateCtType estateCtType)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spImportEstate"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@scopeId", SqlDbType = SqlDbType.Char, Value = estateCtType.ScopeId }, new SqlParameter { ParameterName = "@estateName", SqlDbType = SqlDbType.NVarChar, Value = estateCtType.EstateName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.NVarChar, Value = estateCtType.Address }, new SqlParameter { ParameterName = "@operateStatus", SqlDbType = SqlDbType.Int, Value = estateCtType.Operate }, new SqlParameter { ParameterName = "@FlowStatus", SqlDbType = SqlDbType.Int, Value = estateCtType.Flow }, new SqlParameter { ParameterName = "@agencyCom_EstateId", SqlDbType = SqlDbType.Char, Value = estateCtType.AgencyCom_EstateId }, new SqlParameter { ParameterName = "@agencyCom_ScopeId", SqlDbType = SqlDbType.Char, Value = estateCtType.AgencyCom_ScopeId }, new SqlParameter { ParameterName = "@agencyCom_EstateName", SqlDbType = SqlDbType.NVarChar, Value = estateCtType.AgencyCom_EstateName }, new SqlParameter { ParameterName = "@agencyCom_Address", SqlDbType = SqlDbType.NVarChar, Value = estateCtType.AgencyCom_Address }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = estateCtType.CreateBy } })); } catch (Exception ex) { throw ex; } }
public int DeleteUnit(string unitId) { string funMsg = "Function: RemoveData(string unitId)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "spDeleteUnit"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.Char, Value = unitId } })); } catch (Exception ex) { throw ex; } }
public int InsertComparedBuild(string buildId, string estateId, string buildName, string address, string framework_BuildId, string framework_EstateId, string framework_BuildName, string framework_Address, int statusId) { string funMsg = "function: InsertComparedBuild(string buildId, string estateId, string buildName, string address, string framework_BuildId, string framework_EstateId, string framework_BuildName, string framework_Address, int statusId)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spInsertComparedBuild"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@buildId", SqlDbType = SqlDbType.VarChar, Value = buildId }, new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.VarChar, Value = estateId }, new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.NVarChar, Value = buildName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.NVarChar, Value = address }, new SqlParameter { ParameterName = "@framework_BuildId", SqlDbType = SqlDbType.Char, Value = framework_BuildId }, new SqlParameter { ParameterName = "@framework_EstateId", SqlDbType = SqlDbType.Char, Value = framework_EstateId }, new SqlParameter { ParameterName = "@framework_BuildName", SqlDbType = SqlDbType.NVarChar, Value = framework_BuildName }, new SqlParameter { ParameterName = "@framework_Address", SqlDbType = SqlDbType.NVarChar, Value = framework_Address }, new SqlParameter { ParameterName = "@statusId", SqlDbType = SqlDbType.Int, Value = statusId } })); } catch (Exception ex) { throw ex; } }
public int InsertComparedEstate(EstateCmType b, EstateFwType c, int p) { string funMsg = "function: InsertComparedEstate(EstateCmType b, EstateFwType c, int p)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spInsertComparedEstate"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.VarChar, Value = b.EstateId }, new SqlParameter { ParameterName = "@scopeId", SqlDbType = SqlDbType.Char, Value = b.ScopeId }, new SqlParameter { ParameterName = "@estateName", SqlDbType = SqlDbType.NVarChar, Value = b.EstateName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.NVarChar, Value = b.Address }, new SqlParameter { ParameterName = "@framework_EstateId", SqlDbType = SqlDbType.Char, Value = c.EstateId }, new SqlParameter { ParameterName = "@framework_ScopeId", SqlDbType = SqlDbType.Char, Value = c.ScopeId }, new SqlParameter { ParameterName = "@framework_EstateName", SqlDbType = SqlDbType.NVarChar, Value = c.EstateName }, new SqlParameter { ParameterName = "@framework_Address", SqlDbType = SqlDbType.NVarChar, Value = c.Address }, new SqlParameter { ParameterName = "@statusId", SqlDbType = SqlDbType.Int, Value = p }, })); } catch (Exception ex) { throw ex; } }
public int InsertBuild(string estateId, string buildName, string address, int x_cnt, bool x_except, int y_cnt_b, int y_cnt_e, bool y_except, string createBy) { string funMsg = "function: InsertBuild(string estateId, string buildName, string address,int x_cnt,bool x_except,int y_cnt,bool y_except, string createBy)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spInsertBuild"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.Char, Value = estateId }, new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.NVarChar, Value = buildName }, new SqlParameter { ParameterName = "@address", SqlDbType = SqlDbType.NVarChar, Value = address }, new SqlParameter { ParameterName = "@x_cnt", SqlDbType = SqlDbType.Int, Value = x_cnt }, new SqlParameter { ParameterName = "@x_except", SqlDbType = SqlDbType.Bit, Value = x_except }, new SqlParameter { ParameterName = "@y_cnt_b", SqlDbType = SqlDbType.Int, Value = y_cnt_b }, new SqlParameter { ParameterName = "@y_cnt_e", SqlDbType = SqlDbType.Int, Value = y_cnt_e }, new SqlParameter { ParameterName = "@y_except", SqlDbType = SqlDbType.Bit, Value = y_except }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = createBy } })); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <param name="estateId"></param> /// <param name="buildName"></param> /// <returns></returns> public int AddBuild(string estateId, string buildName) { string funMsg = "function: AddBuild(string estateId, string buildName)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_addbldg";//"spInsertBuild"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.NVarChar, Value = estateId }, new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.NVarChar, Value = buildName }, new SqlParameter { ParameterName = "@buildType", SqlDbType = SqlDbType.NVarChar, Value = string.Empty }, new SqlParameter { ParameterName = "@x_cnt", SqlDbType = SqlDbType.NVarChar, Value = string.Empty }, new SqlParameter { ParameterName = "@y_cnt_begin", SqlDbType = SqlDbType.NVarChar, Value = string.Empty }, new SqlParameter { ParameterName = "@y_cnt_end", SqlDbType = SqlDbType.NVarChar, Value = string.Empty }, new SqlParameter { ParameterName = "@x_except", SqlDbType = SqlDbType.Bit, Value = false }, new SqlParameter { ParameterName = "@y_except", SqlDbType = SqlDbType.Bit, Value = false } })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int InsertOrder(string estateId, string createBy) { string funMsg = "function: InsertOrder(string estateId, string createBy)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spInsertOrder"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.VarChar, Value = estateId }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.VarChar, Value = createBy } })); } catch (Exception ex) { throw ex; } }
public int UpdateOrderStatus(string estateId, int statusId) { string funMsg = "function: UpdateOrderStatus(string estateId, int statusId)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spUpdateOrderStatus"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@estateId", SqlDbType = SqlDbType.VarChar, Value = estateId }, new SqlParameter { ParameterName = "@StatusId", SqlDbType = SqlDbType.Int, Value = statusId } })); } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> /// <param name="buildId"></param> /// <param name="buildName"></param> /// <returns></returns> public int UpdateBuild(string buildId, string buildName) { string funMsg = "function: UpdateBuild(string buildId, string buildName)" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_updbldg";//"spUpdateBuild"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@buildId", SqlDbType = SqlDbType.NVarChar, Value = buildId }, new SqlParameter { ParameterName = "@buildName", SqlDbType = SqlDbType.NVarChar, Value = buildName } })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
/// <summary> /// /// </summary> /// <param name="unitId"></param> /// <param name="nmark"></param> /// <returns></returns> public int UpdateUnitByNmark(string unitId, int nmark) { string funMsg = "function: UpdateEstateByNmark(string unitId,int nmark);" + FileUtility.NewLine + _ClassMsg; string procedureName = string.Empty; try { procedureName = "sp_delunit";//"spUpdateUnitByNmark"; return(DbUtility.ExecuteNonQueryByProc(procedureName, this._CentaDbConn, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.NVarChar, Value = unitId }, new SqlParameter { ParameterName = "@nmark", SqlDbType = SqlDbType.Int, Value = nmark } })); } catch (Exception ex) { string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg; throw new Exception(exMsg, ex.InnerException); } }
public int UpdateUnit(string unitId, int countf, int countt, int countw, int county, string direction, float area) { string funMsg = "function: UpdateUnit(string unitId, int countf, int countt, int countw, int county, string direction, float area)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spUpdateUnit"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.Char, Value = unitId }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.Int, Value = countf }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.Int, Value = countt }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.Int, Value = countw }, new SqlParameter { ParameterName = "@county", SqlDbType = SqlDbType.Int, Value = county }, new SqlParameter { ParameterName = "@directionTo", SqlDbType = SqlDbType.Char, Value = direction }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.Float, Value = area } })); } catch (Exception ex) { throw ex; } }
public int ImportUnit(UnitFwType unitFwType) { string funMsg = "function: ImportUnit(UnitFwType unitFwType)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spImportUnit"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.CX_Axis }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.CY_Axis }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.Int, Value = unitFwType.CountF }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.Int, Value = unitFwType.CountT }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.Int, Value = unitFwType.CountW }, new SqlParameter { ParameterName = "@county", SqlDbType = SqlDbType.Int, Value = unitFwType.CountY }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.Float, Value = unitFwType.Area }, new SqlParameter { ParameterName = "@directionTo", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.DirectionTo }, new SqlParameter { ParameterName = "@operateStatus", SqlDbType = SqlDbType.Int, Value = unitFwType.Operate }, new SqlParameter { ParameterName = "@collect_UnitId", SqlDbType = SqlDbType.Char, Value = unitFwType.Collect_UnitId }, new SqlParameter { ParameterName = "@collect_BuildId", SqlDbType = SqlDbType.Char, Value = unitFwType.Collect_BuildId }, new SqlParameter { ParameterName = "@collect_CX_Axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.Collect_CX_Axis }, new SqlParameter { ParameterName = "@collect_CY_Axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.Collect_CY_Axis }, new SqlParameter { ParameterName = "@collect_CountF", SqlDbType = SqlDbType.Int, Value = unitFwType.Collect_CountF }, new SqlParameter { ParameterName = "@collect_CountT", SqlDbType = SqlDbType.Int, Value = unitFwType.Collect_CountT }, new SqlParameter { ParameterName = "@collect_CountW", SqlDbType = SqlDbType.Int, Value = unitFwType.Collect_CountW }, new SqlParameter { ParameterName = "@collect_CountY", SqlDbType = SqlDbType.Int, Value = unitFwType.Collect_CountY }, new SqlParameter { ParameterName = "@collect_Area", SqlDbType = SqlDbType.Float, Value = unitFwType.Collect_Area }, new SqlParameter { ParameterName = "@collect_DirectionTo", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.Collect_DirectionTo }, new SqlParameter { ParameterName = "@agencyCom_UnitId", SqlDbType = SqlDbType.Char, Value = unitFwType.AgencyCom_UnitId }, new SqlParameter { ParameterName = "@agencyCom_BuildId", SqlDbType = SqlDbType.Char, Value = unitFwType.AgencyCom_BuildId }, new SqlParameter { ParameterName = "@agencyCom_CX_Axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.AgencyCom_CX_Axis }, new SqlParameter { ParameterName = "@agencyCom_CY_Axis", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.AgencyCom_CY_Axis }, new SqlParameter { ParameterName = "@agencyCom_CountF", SqlDbType = SqlDbType.Int, Value = unitFwType.AgencyCom_CountF }, new SqlParameter { ParameterName = "@agencyCom_CountT", SqlDbType = SqlDbType.Int, Value = unitFwType.AgencyCom_CountT }, new SqlParameter { ParameterName = "@agencyCom_CountW", SqlDbType = SqlDbType.Int, Value = unitFwType.AgencyCom_CountW }, new SqlParameter { ParameterName = "@agencyCom_CountY", SqlDbType = SqlDbType.Int, Value = unitFwType.AgencyCom_CountY }, new SqlParameter { ParameterName = "@agencyCom_Area", SqlDbType = SqlDbType.Float, Value = unitFwType.AgencyCom_Area }, new SqlParameter { ParameterName = "@agencyCom_DirectionTo", SqlDbType = SqlDbType.NVarChar, Value = unitFwType.AgencyCom_DirectionTo }, new SqlParameter { ParameterName = "@createBy", SqlDbType = SqlDbType.Char, Value = unitFwType.CreateBy }, })); } catch (Exception ex) { throw ex; } }
public int InsertComparedUnit(UnitCmType obj, UnitFwType m, int comparedStatus) { string funMsg = "function: InsertComparedUnit(UnitCmType obj, UnitFwType m, int comparedStatus)" + FileUtility.NewLine + _ClassMsg; try { string procedure = "spInsertComparedUnit"; return(DbUtility.ExecuteNonQueryByProc(procedure, this.ConnStr, new SqlParameter[] { new SqlParameter { ParameterName = "@unitId", SqlDbType = SqlDbType.VarChar, Value = obj.UnitId }, new SqlParameter { ParameterName = "@buildId", SqlDbType = SqlDbType.VarChar, Value = obj.BuildId }, new SqlParameter { ParameterName = "@cx_axis", SqlDbType = SqlDbType.NVarChar, Value = obj.CX_Axis }, new SqlParameter { ParameterName = "@cy_axis", SqlDbType = SqlDbType.NVarChar, Value = obj.CY_Axis }, new SqlParameter { ParameterName = "@countf", SqlDbType = SqlDbType.Int, Value = obj.CountF }, new SqlParameter { ParameterName = "@countt", SqlDbType = SqlDbType.Int, Value = obj.CountT }, new SqlParameter { ParameterName = "@countw", SqlDbType = SqlDbType.Int, Value = obj.CountW }, new SqlParameter { ParameterName = "@county", SqlDbType = SqlDbType.Int, Value = obj.CountY }, new SqlParameter { ParameterName = "@area", SqlDbType = SqlDbType.VarChar, Value = obj.Area }, new SqlParameter { ParameterName = "@directionTo", SqlDbType = SqlDbType.VarChar, Value = obj.DirectionTo }, new SqlParameter { ParameterName = "@framework_UnitId", SqlDbType = SqlDbType.Char, Value = m.UnitId }, new SqlParameter { ParameterName = "@framework_BuildId", SqlDbType = SqlDbType.Char, Value = m.BuildId }, new SqlParameter { ParameterName = "@framework_CX_Axis", SqlDbType = SqlDbType.NVarChar, Value = m.CX_Axis }, new SqlParameter { ParameterName = "@framework_CY_Axis", SqlDbType = SqlDbType.NVarChar, Value = m.CY_Axis }, new SqlParameter { ParameterName = "@framework_CountF", SqlDbType = SqlDbType.Int, Value = m.CountF }, new SqlParameter { ParameterName = "@framework_CountT", SqlDbType = SqlDbType.Int, Value = m.CountT }, new SqlParameter { ParameterName = "@framework_CountW", SqlDbType = SqlDbType.Int, Value = m.CountW }, new SqlParameter { ParameterName = "@framework_CountY", SqlDbType = SqlDbType.Int, Value = m.CountY }, new SqlParameter { ParameterName = "@framework_Area", SqlDbType = SqlDbType.Float, Value = m.Area }, new SqlParameter { ParameterName = "@framework_DirectionTo", SqlDbType = SqlDbType.NVarChar, Value = m.DirectionTo }, new SqlParameter { ParameterName = "@statusId", SqlDbType = SqlDbType.Int, Value = comparedStatus } })); } catch (Exception ex) { throw ex; } }