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