public void NumericInteger()
{
Parser p = new Parser(StringToStream("42"));
ParseInteger o = p.ParseObject() as ParseInteger;
Assert.NotNull(o);
Assert.True(o.Value == 42);
}
public void NumericInteger6()
{
Parser p = new Parser(StringToStream("1 0 obj42endobj"));
ParseIndirectObject i = p.ParseIndirectObject() as ParseIndirectObject;
Assert.NotNull(i);
Assert.True(i.Id == 1);
Assert.True(i.Gen == 0);
Assert.NotNull(i.Object);
ParseInteger o = i.Object as ParseInteger;
Assert.NotNull(o);
Assert.True(o.Value == 42);
}
/// <summary>
/// 更新添加有效的表头
/// </summary>
/// <param name="pagecode"></param>
/// <param name="hcode"></param>
/// <param name="hname"></param>
/// <param name="breadth"></param>
/// <param name="nowrow"></param>
/// <param name="nowline"></param>
/// <param name="takerow"></param>
/// <param name="takeline"></param>
/// <param name="errmsg"></param>
/// <returns></returns>
public bool updataAddEffectiveExcleHeader(string pagecode, string hcode, string oldhode, string hname, int takeline, string selecttype, string optiontype, ref string errmsg)
{
bool result = true;
OracleDBO mydbo = new OracleDBO();
mydbo.IsThrowException = true;
mydbo.AutoClose = false;
mydbo.IsByParamName = true;
try
{
List <OracleDBO.OracleCmdParam> oparam = new List <OracleDBO.OracleCmdParam>();
string sql = @"select m.nowline from M_P_EXCEL_CONTENT m where m.pagecode =:pagecode order by m.nowline desc";
// string sql = @"select m.nowline from m_p_excel_header m where m.pagecode = :pagecode and m.hname=:hname";
oparam.Add(OracleDBO.Param("pagecode", pagecode));
DataTable dt1 = mydbo.GetDataTable(sql, oparam);
string aaa = dt1.Rows[0]["nowline"].ToString();
int A = Convert.ToInt32(aaa);
int a = A + 1;
string a1 = Convert.ToString(a);
if (!string.IsNullOrEmpty(hcode))
{
string sql1 = @"insert into m_p_excel_effective
(pagecode,hcode, effectivename, linesort, takeline)
values
(:pagecode,:hcode, :hname, :nowline, :takeline)";
oparam.Add(OracleDBO.Param("nowline", a1));
oparam.Add(OracleDBO.Param("takeline", takeline + ""));
oparam.Add(OracleDBO.Param("hcode", hcode));
oparam.Add(OracleDBO.Param("hname", hname));
int n = mydbo.ExecuteNonQuery(sql1, oparam);
if (n > 0)
{
List <OracleDBO.OracleCmdParam> oparam2 = new List <OracleDBO.OracleCmdParam>();
string sql121 = @"select * from m_p_excel_content c where c.pagecode=:pagecode";
oparam2.Add(OracleDBO.Param("pagecode", pagecode));
DataTable dt = mydbo.GetDataTable(sql121, oparam2);
int y = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
List <OracleDBO.OracleCmdParam> oparam21 = new List <OracleDBO.OracleCmdParam>();
if (y != ParseInteger.ParseInt(dt.Rows[i]["nowrow"].ToString()))
{
List <OracleDBO.OracleCmdParam> oparam20 = new List <OracleDBO.OracleCmdParam>();
string sql1210 = @"select * from m_p_excel_content c where c.pagecode=:pagecode and c.hcode=:hcode and c.nowrow=:nowrow";
oparam20.Add(OracleDBO.Param("pagecode", pagecode));
oparam20.Add(OracleDBO.Param("nowrow", dt.Rows[i]["nowrow"].ToString()));
oparam20.Add(OracleDBO.Param("hcode", hcode));
DataTable dt12 = mydbo.GetDataTable(sql1210, oparam20);
if (dt12.Rows.Count < 1)
{
string sql12 = @"insert into m_p_excel_content
(pagecode, hcode, nowrow, nowline)
values
(:pagecode, :hcode, :nowrow, :nowline)";
oparam21.Add(OracleDBO.Param("nowrow", dt.Rows[i]["nowrow"].ToString()));
oparam21.Add(OracleDBO.Param("nowline", a1));
oparam21.Add(OracleDBO.Param("pagecode", pagecode));
oparam21.Add(OracleDBO.Param("hcode", hcode));
int n1 = mydbo.ExecuteNonQuery(sql12, oparam21);
}
y = ParseInteger.ParseInt(a1);
}
}
//List<OracleDBO.OracleCmdParam> oparam1 = new List<OracleDBO.OracleCmdParam>();
//string sql2 = @"insert into m_p_inputattribute(hcode,selecttype,optiontype) values(:hcode,:selecttype,:optiontype)";
//oparam1.Add(OracleDBO.Param("hcode", hcode));
//oparam1.Add(OracleDBO.Param("selecttype", selecttype));
//oparam1.Add(OracleDBO.Param("optiontype", optiontype));
//mydbo.ExecuteNonQuery(sql2, oparam1);
}
}
else
{
List <OracleDBO.OracleCmdParam> oparam11 = new List <OracleDBO.OracleCmdParam>();
string sql1 = @"update m_p_excel_effective h set h.linesort = :nowline where h.hcode = :hcode";
oparam11.Add(OracleDBO.Param("nowline", dt1.Rows[0]["nowline"]));
oparam11.Add(OracleDBO.Param("hcode", oldhode));
int n = mydbo.ExecuteNonQuery(sql1, oparam11);
}
}
catch (Exception ex)
{
errmsg = ex.Message.ToString();
result = false;
LogWriter.WriteLog(ex);
}
finally
{
mydbo.Close();
}
return(result);
}
