private void BindInfo()
{
model = bllConfig.GetModel(strID);
if (model != null)
{
txt_Use.Text = model.C_USE;
txt_Path.Text = model.C_URL;
txt_DataName.Text = model.C_FILE;
txt_Name.Text = model.C_USERNAME;
txt_PassWord.Text = model.C_PASSWORD;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TS_SERVER_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_SERVER_CONFIG set ");
strSql.Append("C_URL=:C_URL,");
strSql.Append("C_FILE=:C_FILE,");
strSql.Append("C_USERNAME=:C_USERNAME,");
strSql.Append("C_PASSWORD=:C_PASSWORD,");
strSql.Append("C_TYPE=:C_TYPE,");
strSql.Append("C_USE=:C_USE,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_NO=:C_NO");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_URL", OracleDbType.Varchar2, 200),
new OracleParameter(":C_FILE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_USERNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PASSWORD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_USE", OracleDbType.Varchar2, 500),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_URL;
parameters[1].Value = model.C_FILE;
parameters[2].Value = model.C_USERNAME;
parameters[3].Value = model.C_PASSWORD;
parameters[4].Value = model.C_TYPE;
parameters[5].Value = model.C_USE;
parameters[6].Value = model.C_REMARK;
parameters[7].Value = model.C_NO;
parameters[8].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_SERVER_CONFIG DataRowToModel(DataRow row)
{
Mod_TS_SERVER_CONFIG model = new Mod_TS_SERVER_CONFIG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_URL"] != null)
{
model.C_URL = row["C_URL"].ToString();
}
if (row["C_FILE"] != null)
{
model.C_FILE = row["C_FILE"].ToString();
}
if (row["C_USERNAME"] != null)
{
model.C_USERNAME = row["C_USERNAME"].ToString();
}
if (row["C_PASSWORD"] != null)
{
model.C_PASSWORD = row["C_PASSWORD"].ToString();
}
if (row["C_TYPE"] != null)
{
model.C_TYPE = row["C_TYPE"].ToString();
}
if (row["C_USE"] != null)
{
model.C_USE = row["C_USE"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_NO"] != null)
{
model.C_NO = row["C_NO"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_SERVER_CONFIG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TS_SERVER_CONFIG(");
strSql.Append("C_ID,C_URL,C_FILE,C_USERNAME,C_PASSWORD,C_TYPE,C_USE,C_REMARK,C_NO)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_URL,:C_FILE,:C_USERNAME,:C_PASSWORD,:C_TYPE,:C_USE,:C_REMARK,:C_NO)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_URL", OracleDbType.Varchar2, 200),
new OracleParameter(":C_FILE", OracleDbType.Varchar2, 200),
new OracleParameter(":C_USERNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PASSWORD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_USE", OracleDbType.Varchar2, 500),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_NO", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_URL;
parameters[2].Value = model.C_FILE;
parameters[3].Value = model.C_USERNAME;
parameters[4].Value = model.C_PASSWORD;
parameters[5].Value = model.C_TYPE;
parameters[6].Value = model.C_USE;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_NO;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TS_SERVER_CONFIG GetModel_ByNo(string C_NO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_URL,C_FILE,C_USERNAME,C_PASSWORD,C_TYPE,C_USE,C_REMARK,C_NO from TS_SERVER_CONFIG ");
strSql.Append(" where C_NO=:C_NO ");
OracleParameter[] parameters =
{
new OracleParameter(":C_NO", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_NO;
Mod_TS_SERVER_CONFIG model = new Mod_TS_SERVER_CONFIG();
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 bool Update(Mod_TS_SERVER_CONFIG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TS_SERVER_CONFIG model)
{
return(dal.Add(model));
}
