/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FACTDIR model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ST_FACTDIR(");
strSql.Append("ID,NAME,PARENT)");
strSql.Append(" values (");
strSql.Append(":ID,:NAME,:PARENT)");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,2),
new OracleParameter(":NAME", OracleDbType.Varchar2,100),
new OracleParameter(":PARENT", OracleDbType.Int32,2)};
parameters[0].Value = model.ID;
parameters[1].Value = model.NAME;
parameters[2].Value = model.PARENT;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FACTEVALWEIG model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ST_FACTEVALWEIG(");
strSql.Append("ID,SUITAINDICATOR,WEIGHT,OWNER,MEASNAME)");
strSql.Append(" values (");
strSql.Append(":ID,:SUITAINDICATOR,:WEIGHT,:OWNER,:MEASNAME)");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,7),
new OracleParameter(":SUITAINDICATOR", OracleDbType.Int32,2),
new OracleParameter(":WEIGHT", OracleDbType.Decimal,7),
new OracleParameter(":OWNER", OracleDbType.Int32,7),
new OracleParameter(":MEASNAME", OracleDbType.Varchar2,100)};
parameters[0].Value = model.ID;
parameters[1].Value = model.SUITAINDICATOR;
parameters[2].Value = model.WEIGHT;
parameters[3].Value = model.OWNER;
parameters[4].Value = model.MEASNAME;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_SUITCLASS model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ST_SUITCLASS(");
strSql.Append("ID,NAME,CODE,CEILING,FLOOR,USERID)");
strSql.Append(" values (");
strSql.Append(":ID,:NAME,:CODE,:CEILING,:FLOOR,:USERID)");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,7),
new OracleParameter(":NAME", OracleDbType.Varchar2,100),
new OracleParameter(":CODE", OracleDbType.Varchar2,100),
new OracleParameter(":CEILING", OracleDbType.Decimal,7),
new OracleParameter(":FLOOR", OracleDbType.Decimal,7),
new OracleParameter(":USERID", OracleDbType.Int32,7)};
parameters[0].Value = model.ID;
parameters[1].Value = model.NAME;
parameters[2].Value = model.CODE;
parameters[3].Value = model.CEILING;
parameters[4].Value = model.FLOOR;
parameters[5].Value = model.USERID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FUZZFUNCT model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ST_FUZZFUNCT(");
strSql.Append("ID,FACTID,UNIT,INFLEXION,FUNCTTYPE,MEASNAME,USERID)");
strSql.Append(" values (");
strSql.Append(":ID,:FACTID,:UNIT,:INFLEXION,:FUNCTTYPE,:MEASNAME,:USERID)");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,7),
new OracleParameter(":FACTID", OracleDbType.Int32,7),
new OracleParameter(":UNIT", OracleDbType.Varchar2,20),
new OracleParameter(":INFLEXION", OracleDbType.Varchar2,200),
new OracleParameter(":FUNCTTYPE", OracleDbType.Varchar2,20),
new OracleParameter(":MEASNAME", OracleDbType.Varchar2,100),
new OracleParameter(":USERID", OracleDbType.Int32,7)};
parameters[0].Value = model.ID;
parameters[1].Value = model.FACTID;
parameters[2].Value = model.UNIT;
parameters[3].Value = model.INFLEXION;
parameters[4].Value = model.FUNCTTYPE;
parameters[5].Value = model.MEASNAME;
parameters[6].Value = model.USERID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.EVALUATEDATA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EVALUATEDATA(");
strSql.Append("坡度,流失强度,覆盖度,可供投资,距道路,距居民地,土地利用,劳力密度,政府决策,K,综经济林果,综封禁,综低效林改,综生态林,适宜性选择)");
strSql.Append(" values (");
strSql.Append(":坡度,:流失强度,:覆盖度,:可供投资,:距道路,:距居民地,:土地利用,:劳力密度,:政府决策,:K:综经济林果,:综封禁,:综低效林改,:综生态林,:适宜性选择)");
OracleParameter[] parameters = {
new OracleParameter(":坡度", OracleDbType.Decimal,38),
new OracleParameter(":流失强度", OracleDbType.NVarchar2),
new OracleParameter(":覆盖度", OracleDbType.Decimal,38),
new OracleParameter(":可供投资", OracleDbType.Decimal,38),
new OracleParameter(":距道路", OracleDbType.Decimal,38),
new OracleParameter(":距居民地", OracleDbType.Decimal,38),
new OracleParameter(":土地利用", OracleDbType.NVarchar2),
new OracleParameter(":劳力密度", OracleDbType.Decimal,38),
new OracleParameter(":政府决策", OracleDbType.NVarchar2),
new OracleParameter(":K", OracleDbType.Decimal,15),
new OracleParameter(":综经济林果", OracleDbType.Decimal,38),
new OracleParameter(":综封禁", OracleDbType.Decimal,38),
new OracleParameter(":综低效林改", OracleDbType.Decimal,38),
new OracleParameter(":综生态林", OracleDbType.Decimal,38),
new OracleParameter(":适宜性选择", OracleDbType.NVarchar2)};
parameters[0].Value = model.坡度;
parameters[1].Value = model.流失强度;
parameters[2].Value = model.覆盖度;
parameters[3].Value = model.可供投资;
parameters[4].Value = model.距道路;
parameters[5].Value = model.距居民地;
parameters[6].Value = model.土地利用;
parameters[7].Value = model.劳力密度;
parameters[8].Value = model.政府决策;
parameters[9].Value = model.K;
parameters[10].Value = model.综经济林果;
parameters[11].Value = model.综封禁;
parameters[12].Value = model.综低效林改;
parameters[13].Value = model.综生态林;
parameters[14].Value = model.适宜性选择;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_USERS model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ST_USERS(");
strSql.Append("USERID,USERNAME,USERSEX,LEVELNAME,USERTRADE,USERCOMPANY,USERPOSITION,USERRESEARCH_FIELDS,PSW,PHOTO)");
strSql.Append(" values (");
strSql.Append(":USERID,:USERNAME,:USERSEX,:LEVELNAME,:USERTRADE,:USERCOMPANY,:USERPOSITION,:USERRESEARCH_FIELDS,:PSW,:PHOTO)");
OracleParameter[] parameters = {
new OracleParameter(":USERID", OracleDbType.Int32,7),
new OracleParameter(":USERNAME", OracleDbType.Varchar2,20),
new OracleParameter(":USERSEX", OracleDbType.Varchar2,5),
new OracleParameter(":LEVELNAME", OracleDbType.Varchar2,10),
new OracleParameter(":USERTRADE", OracleDbType.Varchar2,20),
new OracleParameter(":USERCOMPANY", OracleDbType.Varchar2,200),
new OracleParameter(":USERPOSITION", OracleDbType.Varchar2,20),
new OracleParameter(":USERRESEARCH_FIELDS", OracleDbType.Varchar2,200),
new OracleParameter(":PSW", OracleDbType.Varchar2,20),
new OracleParameter(":PHOTO", OracleDbType.Varchar2,7)};
parameters[0].Value = model.USERID;
parameters[1].Value = model.USERNAME;
parameters[2].Value = model.USERSEX;
parameters[3].Value = model.LEVELNAME;
parameters[4].Value = model.USERTRADE;
parameters[5].Value = model.USERCOMPANY;
parameters[6].Value = model.USERPOSITION;
parameters[7].Value = model.USERRESEARCH_FIELDS;
parameters[8].Value = model.PSW;
parameters[9].Value = model.PHOTO;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.EVALUATEDATA model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_MEASURE model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_MEASURE model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_FACTDIR model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_FACTDIR set ");
strSql.Append("NAME=:NAME,");
strSql.Append("PARENT=:PARENT");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters = {
new OracleParameter(":NAME", OracleDbType.Varchar2,100),
new OracleParameter(":PARENT", OracleDbType.Int32,2),
new OracleParameter(":ID", OracleDbType.Int32,2)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.PARENT;
parameters[2].Value = model.ID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_USERS model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_USERS model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_USERS set ");
strSql.Append("USERNAME=:USERNAME,");
strSql.Append("USERSEX=:USERSEX,");
strSql.Append("LEVELNAME=:LEVELNAME,");
strSql.Append("USERTRADE=:USERTRADE,");
strSql.Append("USERCOMPANY=:USERCOMPANY,");
strSql.Append("USERPOSITION=:USERPOSITION,");
strSql.Append("USERRESEARCH_FIELDS=:USERRESEARCH_FIELDS,");
strSql.Append("PSW=:PSW,");
strSql.Append("PHOTO=:PHOTO");
strSql.Append(" where USERID=:USERID ");
OracleParameter[] parameters = {
new OracleParameter(":USERNAME", OracleDbType.Varchar2,20),
new OracleParameter(":USERSEX", OracleDbType.Varchar2,5),
new OracleParameter(":LEVELNAME", OracleDbType.Varchar2,10),
new OracleParameter(":USERTRADE", OracleDbType.Varchar2,20),
new OracleParameter(":USERCOMPANY", OracleDbType.Varchar2,200),
new OracleParameter(":USERPOSITION", OracleDbType.Varchar2,20),
new OracleParameter(":USERRESEARCH_FIELDS", OracleDbType.Varchar2,200),
new OracleParameter(":PSW", OracleDbType.Varchar2,20),
new OracleParameter(":PHOTO", OracleDbType.Varchar2,7),
new OracleParameter(":USERID", OracleDbType.Int32,7)};
parameters[0].Value = model.USERNAME;
parameters[1].Value = model.USERSEX;
parameters[2].Value = model.LEVELNAME;
parameters[3].Value = model.USERTRADE;
parameters[4].Value = model.USERCOMPANY;
parameters[5].Value = model.USERPOSITION;
parameters[6].Value = model.USERRESEARCH_FIELDS;
parameters[7].Value = model.PSW;
parameters[8].Value = model.PHOTO;
parameters[9].Value = model.USERID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_FACTEVALWEIG model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_FUZZFUNCT model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_FUZZFUNCT set ");
strSql.Append("UNIT=:UNIT,");
strSql.Append("INFLEXION=:INFLEXION,");
strSql.Append("FUNCTTYPE=:FUNCTTYPE");
strSql.Append(" where FACTID=:FACTID and USERID=:USERID");
OracleParameter[] parameters = {
new OracleParameter(":UNIT", OracleDbType.Varchar2,20),
new OracleParameter(":INFLEXION", OracleDbType.Varchar2,200),
new OracleParameter(":FUNCTTYPE", OracleDbType.Varchar2,20),
new OracleParameter(":FACTID", OracleDbType.Int32,7),
new OracleParameter(":USERID", OracleDbType.Int32,7)};
parameters[0].Value = model.UNIT;
parameters[1].Value = model.INFLEXION;
parameters[2].Value = model.FUNCTTYPE;
parameters[3].Value = model.FACTID;
parameters[4].Value = model.USERID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_SUITCLASS model)
{
return dal.Update(model);
}
/// <summary>
/// 更新经济林果适宜性评价值
/// </summary>
public bool UpdateSummary(STBC.Model.EVALUATEDATA model, string strMeasure, double zong)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EVALUATEDATA set ");
int rows = 0;
if (strMeasure == "经济林果")
{
strSql.Append("综经济林果=:综经济林果");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters = {
new OracleParameter(":综经济林果", OracleDbType.Decimal,38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal,4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
else if (strMeasure == "低效林改造")
{
strSql.Append("综低效林改=:综低效林改");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters = {
new OracleParameter(":综低效林改", OracleDbType.Decimal,38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal,4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
else if (strMeasure == "封禁")
{
strSql.Append("综封禁=:综封禁");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters = {
new OracleParameter(":综封禁", OracleDbType.Decimal,38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal,4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
//生态林草
else
{
strSql.Append("综生态林=:综生态林");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters = {
new OracleParameter(":综生态林", OracleDbType.Decimal,38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal,4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_CONSTRCONDIT model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.EVALUATEDATA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EVALUATEDATA set ");
strSql.Append("坡度=:坡度,");
strSql.Append("流失强度=:流失强度,");
strSql.Append("覆盖度=:覆盖度,");
strSql.Append("可供投资=:可供投资,");
strSql.Append("距道路=:距道路,");
strSql.Append("距居民地=:距居民地,");
strSql.Append("土地利用=:土地利用,");
strSql.Append("劳力密度=:劳力密度,");
strSql.Append("政府决策=:政府决策,");
strSql.Append("K=:K,");
strSql.Append("综经济林果=:综经济林果,");
strSql.Append("综封禁=:综封禁,");
strSql.Append("综低效林改=:综低效林改,");
strSql.Append("综生态林=:综生态林,");
strSql.Append("适宜性选择=:适宜性选择");
strSql.Append(" where ");
OracleParameter[] parameters = {
new OracleParameter(":坡度", OracleDbType.Decimal,38),
new OracleParameter(":流失强度", OracleDbType.NVarchar2),
new OracleParameter(":覆盖度", OracleDbType.Decimal,38),
new OracleParameter(":可供投资", OracleDbType.Decimal,38),
new OracleParameter(":距道路", OracleDbType.Decimal,38),
new OracleParameter(":距居民地", OracleDbType.Decimal,38),
new OracleParameter(":土地利用", OracleDbType.NVarchar2),
new OracleParameter(":劳力密度", OracleDbType.Decimal,38),
new OracleParameter(":政府决策", OracleDbType.NVarchar2),
new OracleParameter(":K", OracleDbType.Decimal,15),
new OracleParameter(":综经济林果", OracleDbType.Decimal,38),
new OracleParameter(":综封禁", OracleDbType.Decimal,38),
new OracleParameter(":综低效林改", OracleDbType.Decimal,38),
new OracleParameter(":综生态林", OracleDbType.Decimal,38),
new OracleParameter(":适宜性选择", OracleDbType.NVarchar2)};
parameters[0].Value = model.坡度;
parameters[1].Value = model.流失强度;
parameters[2].Value = model.覆盖度;
parameters[3].Value = model.可供投资;
parameters[4].Value = model.距道路;
parameters[5].Value = model.距居民地;
parameters[6].Value = model.土地利用;
parameters[7].Value = model.劳力密度;
parameters[8].Value = model.政府决策;
parameters[9].Value = model.K;
parameters[10].Value = model.综经济林果;
parameters[11].Value = model.综封禁;
parameters[12].Value = model.综低效林改;
parameters[13].Value = model.综生态林;
parameters[14].Value = model.适宜性选择;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_USERS model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FACTEVALWEIG model)
{
return dal.Add(model);
}
/// <summary>
/// 汇总计算单项措施适宜性评价
/// </summary>
/// <param name="model">模型</param>
/// <param name="strMeasure">措施名字</param>
/// <param name="zong">单项因子计算总结果</param>
/// <returns></returns>
public bool UpdateSummary(STBC.Model.EVALUATEDATA model, string strMeasure, double zong)
{
return dal.UpdateSummary(model, strMeasure, zong);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_SUITCLASS model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_SUITCLASS set ");
//strSql.Append("NAME=:NAME,");
strSql.Append("CODE=:CODE,");
strSql.Append("CEILING=:CEILING,");
strSql.Append("FLOOR=:FLOOR");
//strSql.Append("USERID=:USERID");
strSql.Append(" where USERID=:USERID and NAME=:NAME");
OracleParameter[] parameters = {
new OracleParameter(":CODE", OracleDbType.Varchar2,100),
new OracleParameter(":CEILING", OracleDbType.Decimal,7),
new OracleParameter(":FLOOR", OracleDbType.Decimal,7),
new OracleParameter(":USERID", OracleDbType.Int32,7),
new OracleParameter(":NAME", OracleDbType.Varchar2,100)};
parameters[0].Value = model.CODE;
parameters[1].Value = model.CEILING;
parameters[2].Value = model.FLOOR;
parameters[3].Value = model.USERID;
parameters[4].Value = model.NAME;
//parameters[5].Value = model.ID;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.EVALUATEDATA model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_CONSTRCONDIT model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_CONSTRCONDIT set ");
//strSql.Append("FACTID=:FACTID,");
strSql.Append("UNIT=:UNIT,");
strSql.Append("SYMBOLTYPE=:SYMBOLTYPE,");
strSql.Append("LIMCONDIT=:LIMCONDIT,");
strSql.Append("FACTTYPE=:FACTTYPE,");
//strSql.Append("MEASNAME=:MEASNAME,");
//strSql.Append("USERID=:USERID");
strSql.Append(" where FACTID=:FACTID and USERID=:USERID and MEASNAME=:MEASNAME");
OracleParameter[] parameters = {
//new OracleParameter(":FACTID", OracleDbType.Int32,7),
new OracleParameter(":UNIT", OracleDbType.Varchar2,20),
new OracleParameter(":SYMBOLTYPE", OracleDbType.Varchar2,20),
new OracleParameter(":LIMCONDIT", OracleDbType.Varchar2,200),
new OracleParameter(":FACTTYPE", OracleDbType.Varchar2,20),
new OracleParameter(":FACTID", OracleDbType.Int32,7),
new OracleParameter(":USERID", OracleDbType.Int32,7),
new OracleParameter(":MEASNAME", OracleDbType.Varchar2,100)
};
parameters[0].Value = model.UNIT;
parameters[1].Value = model.SYMBOLTYPE;
parameters[2].Value = model.LIMCONDIT;
parameters[3].Value = model.FACTTYPE;
parameters[4].Value = model.FACTID;
parameters[5].Value = model.USERID;
//parameters[6].Value = model.ID;
parameters[6].Value = model.MEASNAME;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_CONSTRCONDIT model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_FACTEVALWEIG model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ST_FACTEVALWEIG set ");
//strSql.Append("SUITAINDICATOR=:SUITAINDICATOR,");
strSql.Append("WEIGHT=:WEIGHT");
//strSql.Append("OWNER=:OWNER,");
//strSql.Append("MEASNAME=:MEASNAME");
strSql.Append(" where OWNER=:OWNER and SUITAINDICATOR=:SUITAINDICATOR and MEASNAME=:MEASNAME");
OracleParameter[] parameters = {
new OracleParameter(":WEIGHT", OracleDbType.Decimal,7),
new OracleParameter(":OWNER", OracleDbType.Int32,7),
new OracleParameter(":SUITAINDICATOR", OracleDbType.Int32,2),
new OracleParameter(":MEASNAME", OracleDbType.Varchar2,100)};
parameters[0].Value = model.WEIGHT;
parameters[1].Value = model.OWNER;
parameters[2].Value = model.SUITAINDICATOR;
parameters[3].Value = model.MEASNAME;
int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.ST_FUZZFUNCT model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FUZZFUNCT model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_SUITCLASS model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FACTDIR model)
{
return dal.Add(model);
}
