public List <HisPropertyModel> GetHisPropertyByID(string boid, string ns, string gatherid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT * FROM HISPROPERTY T ");
strSql.Append(" WHERE BOID=@BOID AND GATHERID=@GATHERID ");
SqlParameter[] parameters;
if (!string.IsNullOrEmpty(ns))
{
strSql.Append(" AND NS=:NS ");
parameters = new SqlParameter[] {
new SqlParameter("BOID", SqlDbType.VarChar, 36),
new SqlParameter("GATHERID", SqlDbType.VarChar, 50),
new SqlParameter("NS", SqlDbType.VarChar, 50)
};
parameters[0].Value = boid;
parameters[1].Value = gatherid;
parameters[2].Value = ns;
}
else
{
parameters = new SqlParameter[] {
new SqlParameter("BOID", SqlDbType.VarChar, 36),
new SqlParameter("GATHERID", SqlDbType.VarChar, 36)
};
parameters[0].Value = boid;
parameters[1].Value = gatherid;
}
DataTable dt = DBUtility.SqlServerDBHelper.GetDataTable(strSql.ToString(), parameters);
List <HisPropertyModel> list = new List <HisPropertyModel>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
HisPropertyModel model = new HisPropertyModel();
model.BOID = item["BOID"].ToString();
model.GATHERID = item["GATHERID"].ToString();
model.MD = item["MD"].ToString();
model.MDSOURCE = item["MDSOURCE"].ToString();
model.NS = item["NS"].ToString();
list.Add(model);
}
}
return(list);
}
public bool InsertHisProperty(HisPropertyModel HisProperty)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO HISPROPERTY( ");
strInsertSql.Append(" BOID,GATHERID,NS,MD,MDSOURCE)");
strInsertSql.Append(" VALUES (@BOID,@GATHERID,@NS,@MD,@MDSOURCE)");
SqlParameter[] parameters =
{
new SqlParameter("BOID", SqlDbType.VarChar, 36),
new SqlParameter("GATHERID", SqlDbType.VarChar, 50),
new SqlParameter("NS", SqlDbType.VarChar, 50),
new SqlParameter("MD", SqlDbType.Xml),
new SqlParameter("MDSOURCE", SqlDbType.VarChar, 50)
};
parameters[0].Value = HisProperty.BOID;
parameters[1].Value = HisProperty.GATHERID;
parameters[2].Value = HisProperty.NS;
parameters[2].Value = HisProperty.MD;
parameters[4].Value = HisProperty.MDSOURCE;
return(DBUtility.SqlServerDBHelper.ExecuteCommand(strInsertSql.ToString(), parameters) > 0 ? true : false);
}
public bool UpdateHisProperty(HisPropertyModel HisProperty)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE HISPROPERTY SET ");
strUpdateSql.Append(" GATHERID=@GATHERID, MD=@MD ,MDSOURCE=@MDSOURCE ");
strUpdateSql.Append(" WHERE BOID=@BOID AND NS=@NS");
SqlParameter[] parameters =
{
new SqlParameter("GATHERID", SqlDbType.VarChar, 36),
new SqlParameter("MD", SqlDbType.Xml),
new SqlParameter("MDSOURCE", SqlDbType.VarChar, 50),
new SqlParameter("BOID", SqlDbType.VarChar, 36),
new SqlParameter("NS", SqlDbType.VarChar, 50)
};
parameters[0].Value = HisProperty.GATHERID;
parameters[1].Value = HisProperty.MD;
parameters[2].Value = HisProperty.MDSOURCE;
parameters[3].Value = HisProperty.BOID;
parameters[4].Value = HisProperty.NS;
return(DBUtility.SqlServerDBHelper.ExecuteCommand(strUpdateSql.ToString(), parameters) > 0 ? true : false);
}
public bool UpdateHisProperty(HisPropertyModel HisProperty)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE HISPROPERTY SET ");
strUpdateSql.Append(" GATHERID=:GATHERID, MD=:MD ,MDSOURCE=:MDSOURCE ");
strUpdateSql.Append(" WHERE BOID=:BOID AND NS=:NS");
OracleParameter[] parameters =
{
new OracleParameter("GATHERID", OracleDbType.Varchar2, 36),
new OracleParameter("MD", OracleDbType.XmlType),
new OracleParameter("MDSOURCE", OracleDbType.Varchar2, 50),
new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("NS", OracleDbType.Varchar2, 50)
};
parameters[0].Value = HisProperty.GATHERID;
parameters[1].Value = HisProperty.MD;
parameters[2].Value = HisProperty.MDSOURCE;
parameters[3].Value = HisProperty.BOID;
parameters[4].Value = HisProperty.NS;
return(OracleDBHelper.OracleHelper.ExecuteSql(strUpdateSql.ToString(), parameters) > 0 ? true : false);
}
public bool InsertHisProperty(HisPropertyModel HisProperty)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO HISPROPERTY( ");
strInsertSql.Append(" BOID,GATHERID,NS,MD,MDSOURCE)");
strInsertSql.Append(" VALUES (:BOID,:GATHERID,:NS,:MD,:MDSOURCE)");
OracleParameter[] parameters =
{
new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("GATHERID", OracleDbType.Varchar2, 50),
new OracleParameter("NS", OracleDbType.Varchar2, 50),
new OracleParameter("MD", OracleDbType.XmlType),
new OracleParameter("MDSOURCE", OracleDbType.Varchar2, 50)
};
parameters[0].Value = HisProperty.BOID;
parameters[1].Value = HisProperty.GATHERID;
parameters[2].Value = HisProperty.NS;
parameters[2].Value = HisProperty.MD;
parameters[4].Value = HisProperty.MDSOURCE;
return(OracleDBHelper.OracleHelper.ExecuteSql(strInsertSql.ToString(), parameters) > 0 ? true : false);
}
public bool ExistHisProperty(HisPropertyModel HisProperty)
{
throw new NotImplementedException();
}
public bool UpdateHisProperty(HisPropertyModel HisProperty)
{
return(ObjectCreate <HisPropertyModel> .CreateIHisBOProperty("BOPropertyBusiness").UpdateHisProperty(HisProperty));
}
public bool InsertHisProperty(HisPropertyModel HisProperty)
{
return(ObjectCreate <GeometryModel> .CreateIHisBOProperty("BOPropertyBusiness").InsertHisProperty(HisProperty));
}
