/// <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 STBC.Model.ST_FACTEVALWEIG DataRowToModel(DataRow row)
{
STBC.Model.ST_FACTEVALWEIG model = new STBC.Model.ST_FACTEVALWEIG();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["SUITAINDICATOR"] != null && row["SUITAINDICATOR"].ToString() != "")
{
model.SUITAINDICATOR = decimal.Parse(row["SUITAINDICATOR"].ToString());
}
if (row["WEIGHT"] != null && row["WEIGHT"].ToString() != "")
{
model.WEIGHT = decimal.Parse(row["WEIGHT"].ToString());
}
if (row["OWNER"] != null && row["OWNER"].ToString() != "")
{
model.OWNER = decimal.Parse(row["OWNER"].ToString());
}
if (row["MEASNAME"] != null)
{
model.MEASNAME = row["MEASNAME"].ToString();
}
}
return(model);
}
/// <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 STBC.Model.ST_FACTEVALWEIG DataRowToModel(DataRow row)
{
STBC.Model.ST_FACTEVALWEIG model=new STBC.Model.ST_FACTEVALWEIG();
if (row != null)
{
if(row["ID"]!=null && row["ID"].ToString()!="")
{
model.ID=decimal.Parse(row["ID"].ToString());
}
if(row["SUITAINDICATOR"]!=null && row["SUITAINDICATOR"].ToString()!="")
{
model.SUITAINDICATOR=decimal.Parse(row["SUITAINDICATOR"].ToString());
}
if(row["WEIGHT"]!=null && row["WEIGHT"].ToString()!="")
{
model.WEIGHT=decimal.Parse(row["WEIGHT"].ToString());
}
if(row["OWNER"]!=null && row["OWNER"].ToString()!="")
{
model.OWNER=decimal.Parse(row["OWNER"].ToString());
}
if(row["MEASNAME"]!=null)
{
model.MEASNAME=row["MEASNAME"].ToString();
}
}
return model;
}
//创建效益评价因子规则（对计算的结果插入到数据库里面）
protected void benefitFactorscreateRule_Click(object sender, EventArgs e)
{
//1获得用户的id
int userID = CommonClass.OperateUsers.getUserID();
//、获取措施。因为因为所有的措施中适宜性权重值都相同，这里只是象征性的给它赋值经济林果。其实没什么用的。
string measurename = "经济林果";
for (int i = 0; i < lsBenName.Count; i++)
{
//3、获取到效益权重的因子名对应的ID
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsBenName[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factid = int.Parse(dt2.Rows[0]["ID"].ToString());
STBC.BLL.ST_FACTEVALWEIG factevalweigB = new STBC.BLL.ST_FACTEVALWEIG();
STBC.Model.ST_FACTEVALWEIG factevalweigM = new STBC.Model.ST_FACTEVALWEIG();
factevalweigM.OWNER = userID;
factevalweigM.SUITAINDICATOR = factid;
factevalweigM.MEASNAME = measurename;
factevalweigM.WEIGHT = (decimal)Math.Round(resultBenefit[i, 0], 4);
//判断数据是否已经存在，如果不存在则插入数据库里面
if (!factevalweigB.Exists(userID, factid, measurename))
{
factevalweigB.Add(factevalweigM);
//提醒用户已经插入数据库
if (i == lsBenName.Count - 1)
{
Response.Write("<script>alert('权重已经插入数据库！');</script>");
}
}
else
{
//更新数据
factevalweigB.Update(factevalweigM);
//提醒数据已经被更新了
if (i == lsBenName.Count - 1)
{
Response.Write("<script>alert('权重已经被更新！');</script>");
}
}
}
}
protected bool insertSuitWeigth(List <string> lsSuitNameList, double[,] resultSuit, int userID, string measurename)
{
bool isok = false;
//效益型权重插入2
for (int i = 0; i < lsSuitNameList.Count; i++)
{
//3、获取到效益权重的因子名对应的ID
//STBC.BLL.SUITAINDICATOR suitaindicatorB = new STBC.BLL.SUITAINDICATOR();
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsSuitNameList[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factID = int.Parse(dt2.Rows[0]["ID"].ToString());
STBC.BLL.ST_FACTEVALWEIG factevalweigB = new STBC.BLL.ST_FACTEVALWEIG();
STBC.Model.ST_FACTEVALWEIG factevalweigM = new STBC.Model.ST_FACTEVALWEIG();
factevalweigM.SUITAINDICATOR = factID;
factevalweigM.OWNER = userID;
double weight1 = resultSuit[i, 0];
factevalweigM.WEIGHT = (decimal)Math.Round(weight1, 4);
factevalweigM.MEASNAME = measurename;
//判断数据是否已经存在，如果不存在则插入数据库里面
if (!factevalweigB.Exists(userID, factID, measurename))
{
factevalweigB.Add(factevalweigM);
}
else
{
//如果数据库已经存在则更新
factevalweigB.Update(factevalweigM);
isok = true;
}
}
return(isok);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.ST_FACTEVALWEIG GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,SUITAINDICATOR,WEIGHT,OWNER,MEASNAME from ST_FACTEVALWEIG ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 22)
};
parameters[0].Value = ID;
STBC.Model.ST_FACTEVALWEIG model = new STBC.Model.ST_FACTEVALWEIG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.ST_FACTEVALWEIG GetModel(decimal ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ID,SUITAINDICATOR,WEIGHT,OWNER,MEASNAME from ST_FACTEVALWEIG ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,22) };
parameters[0].Value = ID;
STBC.Model.ST_FACTEVALWEIG model=new STBC.Model.ST_FACTEVALWEIG();
DataSet ds=DbHelperOra.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
//创建效益评价因子规则（对计算的结果插入到数据库里面）
protected void benefitFactorscreateRule_Click(object sender, EventArgs e)
{
//1获得用户的id
int userID = CommonClass.OperateUsers.getUserID();
//、获取措施。因为因为所有的措施中适宜性权重值都相同，这里只是象征性的给它赋值经济林果。其实没什么用的。
string measurename = "经济林果";
for (int i = 0; i < lsBenName.Count; i++)
{
//3、获取到效益权重的因子名对应的ID
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsBenName[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factid = int.Parse(dt2.Rows[0]["ID"].ToString());
STBC.BLL.ST_FACTEVALWEIG factevalweigB = new STBC.BLL.ST_FACTEVALWEIG();
STBC.Model.ST_FACTEVALWEIG factevalweigM = new STBC.Model.ST_FACTEVALWEIG();
factevalweigM.OWNER = userID;
factevalweigM.SUITAINDICATOR = factid;
factevalweigM.MEASNAME = measurename;
factevalweigM.WEIGHT = (decimal)Math.Round(resultBenefit[i, 0], 4);
//判断数据是否已经存在，如果不存在则插入数据库里面
if (!factevalweigB.Exists(userID, factid, measurename))
{
factevalweigB.Add(factevalweigM);
//提醒用户已经插入数据库
if (i == lsBenName.Count - 1)
{
Response.Write("<script>alert('权重已经插入数据库！');</script>");
}
}
else
{
//更新数据
factevalweigB.Update(factevalweigM);
//提醒数据已经被更新了
if (i == lsBenName.Count - 1)
{
Response.Write("<script>alert('权重已经被更新！');</script>");
}
}
}
}
protected bool insertSuitWeigth(List<string> lsSuitNameList, double[,] resultSuit, int userID, string measurename)
{
bool isok = false;
//效益型权重插入2
for (int i = 0; i < lsSuitNameList.Count; i++)
{
//3、获取到效益权重的因子名对应的ID
//STBC.BLL.SUITAINDICATOR suitaindicatorB = new STBC.BLL.SUITAINDICATOR();
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsSuitNameList[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factID = int.Parse(dt2.Rows[0]["ID"].ToString());
STBC.BLL.ST_FACTEVALWEIG factevalweigB = new STBC.BLL.ST_FACTEVALWEIG();
STBC.Model.ST_FACTEVALWEIG factevalweigM = new STBC.Model.ST_FACTEVALWEIG();
factevalweigM.SUITAINDICATOR = factID;
factevalweigM.OWNER = userID;
double weight1 = resultSuit[i, 0];
factevalweigM.WEIGHT = (decimal)Math.Round(weight1, 4);
factevalweigM.MEASNAME = measurename;
//判断数据是否已经存在，如果不存在则插入数据库里面
if (!factevalweigB.Exists(userID, factID, measurename))
{
factevalweigB.Add(factevalweigM);
}
else
{
//如果数据库已经存在则更新
factevalweigB.Update(factevalweigM);
isok = true;
}
}
return isok;
}
