/// <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 STBC.Model.ST_CONSTRCONDIT DataRowToModel(DataRow row)
{
STBC.Model.ST_CONSTRCONDIT model=new STBC.Model.ST_CONSTRCONDIT();
if (row != null)
{
if(row["ID"]!=null && row["ID"].ToString()!="")
{
model.ID=decimal.Parse(row["ID"].ToString());
}
if(row["FACTID"]!=null && row["FACTID"].ToString()!="")
{
model.FACTID=decimal.Parse(row["FACTID"].ToString());
}
if(row["UNIT"]!=null)
{
model.UNIT=row["UNIT"].ToString();
}
if(row["SYMBOLTYPE"]!=null)
{
model.SYMBOLTYPE=row["SYMBOLTYPE"].ToString();
}
if(row["LIMCONDIT"]!=null)
{
model.LIMCONDIT=row["LIMCONDIT"].ToString();
}
if(row["FACTTYPE"]!=null)
{
model.FACTTYPE=row["FACTTYPE"].ToString();
}
if(row["MEASNAME"]!=null)
{
model.MEASNAME=row["MEASNAME"].ToString();
}
if(row["USERID"]!=null && row["USERID"].ToString()!="")
{
model.USERID=decimal.Parse(row["USERID"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.ST_CONSTRCONDIT DataRowToModel(DataRow row)
{
STBC.Model.ST_CONSTRCONDIT model = new STBC.Model.ST_CONSTRCONDIT();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["FACTID"] != null && row["FACTID"].ToString() != "")
{
model.FACTID = decimal.Parse(row["FACTID"].ToString());
}
if (row["UNIT"] != null)
{
model.UNIT = row["UNIT"].ToString();
}
if (row["SYMBOLTYPE"] != null)
{
model.SYMBOLTYPE = row["SYMBOLTYPE"].ToString();
}
if (row["LIMCONDIT"] != null)
{
model.LIMCONDIT = row["LIMCONDIT"].ToString();
}
if (row["FACTTYPE"] != null)
{
model.FACTTYPE = row["FACTTYPE"].ToString();
}
if (row["MEASNAME"] != null)
{
model.MEASNAME = row["MEASNAME"].ToString();
}
if (row["USERID"] != null && row["USERID"].ToString() != "")
{
model.USERID = decimal.Parse(row["USERID"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_CONSTRCONDIT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ST_CONSTRCONDIT(");
strSql.Append("ID,FACTID,UNIT,SYMBOLTYPE,LIMCONDIT,FACTTYPE,MEASNAME,USERID)");
strSql.Append(" values (");
strSql.Append(":ID,:FACTID,:UNIT,:SYMBOLTYPE,:LIMCONDIT,:FACTTYPE,:MEASNAME,:USERID)");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 7),
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(":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.SYMBOLTYPE;
parameters[4].Value = model.LIMCONDIT;
parameters[5].Value = model.FACTTYPE;
parameters[6].Value = model.MEASNAME;
parameters[7].Value = model.USERID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.ST_CONSTRCONDIT GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,FACTID,UNIT,SYMBOLTYPE,LIMCONDIT,FACTTYPE,MEASNAME,USERID from ST_CONSTRCONDIT ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 22)
};
parameters[0].Value = ID;
STBC.Model.ST_CONSTRCONDIT model = new STBC.Model.ST_CONSTRCONDIT();
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_CONSTRCONDIT GetModel(decimal ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ID,FACTID,UNIT,SYMBOLTYPE,LIMCONDIT,FACTTYPE,MEASNAME,USERID from ST_CONSTRCONDIT ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters = {
new OracleParameter(":ID", OracleDbType.Int32,22) };
parameters[0].Value = ID;
STBC.Model.ST_CONSTRCONDIT model=new STBC.Model.ST_CONSTRCONDIT();
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 btn_limitativeRule_Click(object sender, EventArgs e)
{
//获得用户的id
int userID = CommonClass.OperateUsers.getUserID();
//措施的名字
string measurename = measureLimit.SelectedItem.Text;
STBC.BLL.ST_CONSTRCONDIT constrconditB = new STBC.BLL.ST_CONSTRCONDIT();
STBC.Model.ST_CONSTRCONDIT constrconditM = new STBC.Model.ST_CONSTRCONDIT();
for (int i = 0; i < lsLimitName.Count; i++)
{
//查找到每行因子对应的因子id
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsLimitName[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factid = int.Parse(dt2.Rows[0]["ID"].ToString());
//获取到单位，比如平方米等等
TextBox txtUnit21 = (TextBox)LimcondGrid.Rows[i].FindControl("txtUnit2");
DropDownList ddlFactType1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlFactType");
//如果是数值类型
if (ddlFactType1.SelectedItem.Text == "数值类型")
{
//获取到底是>,<,=类型
DropDownList ddlContType1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlContType");
//获取限制条件的文本
TextBox txtLimitC1 = (TextBox)LimcondGrid.Rows[i].FindControl("txtLimitC");
constrconditM.FACTID = factid;
constrconditM.FACTTYPE = ddlFactType1.SelectedItem.Text;
constrconditM.MEASNAME = measurename;
constrconditM.SYMBOLTYPE = ddlContType1.SelectedItem.Text;
constrconditM.USERID = userID;
constrconditM.UNIT = txtUnit21.Text.ToString().Trim();
constrconditM.LIMCONDIT = txtLimitC1.Text.ToString().Trim();
//插入到数据库里面
if (!constrconditB.Exists(userID, factid, measurename))
{
constrconditB.Add(constrconditM);
}
else
{
constrconditB.Update(constrconditM);
}
}
//否则
else
{
//获取in类型
DropDownList ddlIntype1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlIntype");
TextBox txtLimitC1 = (TextBox)LimcondGrid.Rows[i].FindControl("txtLimitC");
constrconditM.FACTID = factid;
constrconditM.FACTTYPE = ddlFactType1.SelectedItem.Text;
constrconditM.MEASNAME = measurename;
constrconditM.SYMBOLTYPE = ddlIntype1.SelectedItem.Text;
constrconditM.USERID = userID;
constrconditM.UNIT = txtUnit21.Text.ToString().Trim();
constrconditM.LIMCONDIT = txtLimitC1.Text.ToString().Trim();
//插入到数据库里面
if (!constrconditB.Exists(userID, factid, measurename))
{
constrconditB.Add(constrconditM);
}
else
{
constrconditB.Update(constrconditM);
}
}
if (i == lsLimitName.Count - 1)
{
Response.Write("<script>alert('限制条件已经创建了！');</script>");
}
}
}
//重建限制性条件
protected void btn_limitativeRule_Click(object sender, EventArgs e)
{
//获得用户的id
int userID = CommonClass.OperateUsers.getUserID();
//措施的名字
string measurename = measureLimit.SelectedItem.Text;
STBC.BLL.ST_CONSTRCONDIT constrconditB = new STBC.BLL.ST_CONSTRCONDIT();
STBC.Model.ST_CONSTRCONDIT constrconditM = new STBC.Model.ST_CONSTRCONDIT();
for (int i = 0; i < lsLimitName.Count; i++)
{
//查找到每行因子对应的因子id
STBC.BLL.ST_FACTDIR factdirB = new STBC.BLL.ST_FACTDIR();
DataSet ds2 = factdirB.GetList("Name='" + lsLimitName[i].ToString() + "'");
DataTable dt2 = ds2.Tables[0];
int factid = int.Parse(dt2.Rows[0]["ID"].ToString());
//获取到单位，比如平方米等等
TextBox txtUnit21 = (TextBox)LimcondGrid.Rows[i].FindControl("txtUnit2");
DropDownList ddlFactType1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlFactType");
//如果是数值类型
if (ddlFactType1.SelectedItem.Text == "数值类型")
{
//获取到底是>,<,=类型
DropDownList ddlContType1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlContType");
//获取限制条件的文本
TextBox txtLimitC1 = (TextBox)LimcondGrid.Rows[i].FindControl("txtLimitC");
constrconditM.FACTID = factid;
constrconditM.FACTTYPE = ddlFactType1.SelectedItem.Text;
constrconditM.MEASNAME = measurename;
constrconditM.SYMBOLTYPE = ddlContType1.SelectedItem.Text;
constrconditM.USERID = userID;
constrconditM.UNIT = txtUnit21.Text.ToString().Trim();
constrconditM.LIMCONDIT = txtLimitC1.Text.ToString().Trim();
//插入到数据库里面
if (!constrconditB.Exists(userID, factid, measurename))
{
constrconditB.Add(constrconditM);
}
else
{
constrconditB.Update(constrconditM);
}
}
//否则
else
{
//获取in类型
DropDownList ddlIntype1 = (DropDownList)LimcondGrid.Rows[i].FindControl("ddlIntype");
TextBox txtLimitC1 = (TextBox)LimcondGrid.Rows[i].FindControl("txtLimitC");
constrconditM.FACTID = factid;
constrconditM.FACTTYPE = ddlFactType1.SelectedItem.Text;
constrconditM.MEASNAME = measurename;
constrconditM.SYMBOLTYPE = ddlIntype1.SelectedItem.Text;
constrconditM.USERID = userID;
constrconditM.UNIT = txtUnit21.Text.ToString().Trim();
constrconditM.LIMCONDIT = txtLimitC1.Text.ToString().Trim();
//插入到数据库里面
if (!constrconditB.Exists(userID, factid, measurename))
{
constrconditB.Add(constrconditM);
}
else
{
constrconditB.Update(constrconditM);
}
}
if (i == lsLimitName.Count - 1)
{
Response.Write("<script>alert('限制条件已经创建了！');</script>");
}
}
}