/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_LICENSE_ACCEPT model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_LICENSE_ACCEPT GetEntity(decimal REQUISITIONID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select REQUISITIONID, REQUISITIONNAME, ADDRESS, TEL, PHONE, EMAIL, POST, REQUISITIONCONTENT, DEPUTY, MATERIALS, MARK, CREATDATE, AUDITOR, AUDIT_STATE, FILE_PATH, AUDIT_DESC, AUDIT_REPLY ");
strSql.Append(" from BASE_LICENSE_ACCEPT ");
strSql.Append(" where ");
strSql.Append(" REQUISITIONID = :REQUISITIONID ");
OracleParameter[] parameters =
{
new OracleParameter(":REQUISITIONID", OracleType.Number, 4)
};
parameters[0].Value = REQUISITIONID;
Entity.BASE_LICENSE_ACCEPT entity = new Entity.BASE_LICENSE_ACCEPT();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["REQUISITIONID"].ToString() != "")
{
entity.REQUISITIONID = decimal.Parse(dt.Rows[0]["REQUISITIONID"].ToString());
}
entity.REQUISITIONNAME = dt.Rows[0]["REQUISITIONNAME"].ToString();
entity.ADDRESS = dt.Rows[0]["ADDRESS"].ToString();
entity.TEL = dt.Rows[0]["TEL"].ToString();
entity.PHONE = dt.Rows[0]["PHONE"].ToString();
entity.EMAIL = dt.Rows[0]["EMAIL"].ToString();
entity.POST = dt.Rows[0]["POST"].ToString();
entity.REQUISITIONCONTENT = dt.Rows[0]["REQUISITIONCONTENT"].ToString();
entity.DEPUTY = dt.Rows[0]["DEPUTY"].ToString();
entity.MATERIALS = dt.Rows[0]["MATERIALS"].ToString();
entity.MARK = dt.Rows[0]["MARK"].ToString();
if (dt.Rows[0]["CREATDATE"].ToString() != "")
{
entity.CREATDATE = DateTime.Parse(dt.Rows[0]["CREATDATE"].ToString());
}
entity.AUDITOR = dt.Rows[0]["AUDITOR"].ToString();
if (dt.Rows[0]["AUDIT_STATE"].ToString() != "")
{
entity.AUDIT_STATE = decimal.Parse(dt.Rows[0]["AUDIT_STATE"].ToString());
}
entity.FILE_PATH = dt.Rows[0]["FILE_PATH"].ToString();
entity.AUDIT_DESC = dt.Rows[0]["AUDIT_DESC"].ToString();
entity.AUDIT_REPLY = dt.Rows[0]["AUDIT_REPLY"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_LICENSE_ACCEPT entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_LICENSE_ACCEPT(");
strSql.Append("REQUISITIONID,REQUISITIONNAME,ADDRESS,TEL,PHONE,EMAIL,POST,REQUISITIONCONTENT,DEPUTY,MATERIALS,MARK,CREATDATE,AUDITOR,AUDIT_STATE,FILE_PATH,AUDIT_DESC,AUDIT_REPLY");
strSql.Append(") values (");
strSql.Append(":REQUISITIONID,:REQUISITIONNAME,:ADDRESS,:TEL,:PHONE,:EMAIL,:POST,:REQUISITIONCONTENT,:DEPUTY,:MATERIALS,:MARK,:CREATDATE,:AUDITOR,:AUDIT_STATE,:FILE_PATH,:AUDIT_DESC,:AUDIT_REPLY");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":REQUISITIONID", OracleType.Number, 4),
new OracleParameter(":REQUISITIONNAME", OracleType.VarChar, 50),
new OracleParameter(":ADDRESS", OracleType.VarChar, 50),
new OracleParameter(":TEL", OracleType.VarChar, 50),
new OracleParameter(":PHONE", OracleType.VarChar, 50),
new OracleParameter(":EMAIL", OracleType.VarChar, 50),
new OracleParameter(":POST", OracleType.VarChar, 20),
new OracleParameter(":REQUISITIONCONTENT", OracleType.VarChar, 200),
new OracleParameter(":DEPUTY", OracleType.VarChar, 20),
new OracleParameter(":MATERIALS", OracleType.VarChar, 20),
new OracleParameter(":MARK", OracleType.VarChar, 20),
new OracleParameter(":CREATDATE", OracleType.DateTime),
new OracleParameter(":AUDITOR", OracleType.VarChar, 20),
new OracleParameter(":AUDIT_STATE", OracleType.Number, 4),
new OracleParameter(":FILE_PATH", OracleType.VarChar, 50),
new OracleParameter(":AUDIT_DESC", OracleType.VarChar, 200),
new OracleParameter(":AUDIT_REPLY", OracleType.VarChar, 200)
};
parameters[0].Value = entity.REQUISITIONID;
parameters[1].Value = entity.REQUISITIONNAME;
parameters[2].Value = entity.ADDRESS;
parameters[3].Value = entity.TEL;
parameters[4].Value = entity.PHONE;
parameters[5].Value = entity.EMAIL;
parameters[6].Value = entity.POST;
parameters[7].Value = entity.REQUISITIONCONTENT;
parameters[8].Value = entity.DEPUTY;
parameters[9].Value = entity.MATERIALS;
parameters[10].Value = entity.MARK;
parameters[11].Value = entity.CREATDATE;
parameters[12].Value = entity.AUDITOR;
parameters[13].Value = entity.AUDIT_STATE;
parameters[14].Value = entity.FILE_PATH;
parameters[15].Value = entity.AUDIT_DESC;
parameters[16].Value = entity.AUDIT_REPLY;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 涉路申请
/// </summary>
/// <param name="model">申请书实体</param>
public void Add(Entity.BASE_LICENSE_ACCEPT model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_LICENSE_ACCEPT entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_LICENSE_ACCEPT set ");
strSql.Append(" REQUISITIONID = :REQUISITIONID , ");
strSql.Append(" REQUISITIONNAME = :REQUISITIONNAME , ");
strSql.Append(" ADDRESS = :ADDRESS , ");
strSql.Append(" TEL = :TEL , ");
strSql.Append(" PHONE = :PHONE , ");
strSql.Append(" EMAIL = :EMAIL , ");
strSql.Append(" POST = :POST , ");
strSql.Append(" REQUISITIONCONTENT = :REQUISITIONCONTENT , ");
strSql.Append(" DEPUTY = :DEPUTY , ");
strSql.Append(" MATERIALS = :MATERIALS , ");
strSql.Append(" MARK = :MARK , ");
strSql.Append(" CREATDATE = :CREATDATE , ");
strSql.Append(" AUDITOR = :AUDITOR , ");
strSql.Append(" AUDIT_STATE = :AUDIT_STATE , ");
strSql.Append(" FILE_PATH = :FILE_PATH , ");
strSql.Append(" AUDIT_DESC = :AUDIT_DESC , ");
strSql.Append(" AUDIT_REPLY = :AUDIT_REPLY ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":REQUISITIONID", OracleType.Number, 4),
new OracleParameter(":REQUISITIONNAME", OracleType.VarChar, 50),
new OracleParameter(":ADDRESS", OracleType.VarChar, 50),
new OracleParameter(":TEL", OracleType.VarChar, 50),
new OracleParameter(":PHONE", OracleType.VarChar, 50),
new OracleParameter(":EMAIL", OracleType.VarChar, 50),
new OracleParameter(":POST", OracleType.VarChar, 20),
new OracleParameter(":REQUISITIONCONTENT", OracleType.VarChar, 200),
new OracleParameter(":DEPUTY", OracleType.VarChar, 20),
new OracleParameter(":MATERIALS", OracleType.VarChar, 20),
new OracleParameter(":MARK", OracleType.VarChar, 20),
new OracleParameter(":CREATDATE", OracleType.DateTime),
new OracleParameter(":AUDITOR", OracleType.VarChar, 20),
new OracleParameter(":AUDIT_STATE", OracleType.Number, 4),
new OracleParameter(":FILE_PATH", OracleType.VarChar, 50),
new OracleParameter(":AUDIT_DESC", OracleType.VarChar, 200),
new OracleParameter(":AUDIT_REPLY", OracleType.VarChar, 200)
};
parameters[0].Value = entity.REQUISITIONID;
parameters[1].Value = entity.REQUISITIONNAME;
parameters[2].Value = entity.ADDRESS;
parameters[3].Value = entity.TEL;
parameters[4].Value = entity.PHONE;
parameters[5].Value = entity.EMAIL;
parameters[6].Value = entity.POST;
parameters[7].Value = entity.REQUISITIONCONTENT;
parameters[8].Value = entity.DEPUTY;
parameters[9].Value = entity.MATERIALS;
parameters[10].Value = entity.MARK;
parameters[11].Value = entity.CREATDATE;
parameters[12].Value = entity.AUDITOR;
parameters[13].Value = entity.AUDIT_STATE;
parameters[14].Value = entity.FILE_PATH;
parameters[15].Value = entity.AUDIT_DESC;
parameters[16].Value = entity.AUDIT_REPLY;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
