// -----------------------------------------------------------------------------------
// Main functions for fingerprint recognition management
// -----------------------------------------------------------------------------------
// Initializes GrFinger ActiveX and all necessary utilities.
public int InitializeGrFinger(AxGrFingerXLib.AxGrFingerXCtrl grfingerx)
{
GRConstants result;
_grfingerx = grfingerx;
//Check DataBase Class.
if (_DB == null)
{
_DB = new DBClass();
}
//Open DataBase
if (_DB.openDB() == false)
{
return(ERR_CANT_OPEN_BD);
}
//Create a new Template
if (_tpt == null)
{
_tpt = new TTemplate();
}
//Create a new raw image
_raw = new TRawImage();
//Initialize library
result = (GRConstants)_grfingerx.Initialize();
if (result < 0)
{
return((int)result);
}
return((int)_grfingerx.CapInitialize());
}
// Open connection
public bool openDB()
{
_connection = new OleDbConnection();
_connection.ConnectionString = CONNECTION_STRING;
try{
_connection.Open();
}
catch {
return(false);
}
tptBlob = new TTemplate();
return(true);
} //END
/// <summary>
/// The create sections.
/// </summary>
/// <param name="tree">
/// The tree.
/// </param>
/// <param name="template">
/// The template.
/// </param>
private static void CreateSections(TTree tree, TTemplate template)
{
foreach (TSection section in template)
{
Item item = tree.Database.GetItem(section.ID);
if (item == null)
{
tree.Database.CreateItem(section.ID, section.Name, new TemplateID(TemplateIDs.TemplateSection), template.ID);
}
CreateFields(tree, section);
}
}
public void WriteXlsxTest()
{
string file = AppDomain.CurrentDomain.BaseDirectory + "/ExcelTests/t2.xlsx";
IExcel excel = ExcelFactory.CreateDefault();
DataTable dt = excel.Read(file, 0, 2);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
TTemplate template = new TTemplate();
TRow R1 = new TRow();
TCell A = new TCell("A", "A", 0, 0); A.ColSpan = 2;
TCell B = new TCell("", "B", 0, 2);
TCell C = new TCell("C", "C", 0, 3); C.RowSpan = 2;
TCell D = new TCell("D", "D", 0, 4); D.RowSpan = 2;
TCell E = new TCell("", "E", 0, 5); E.ColSpan = 2;
R1.Cells.Add(A);
R1.Cells.Add(B);
R1.Cells.Add(C);
R1.Cells.Add(D);
R1.Cells.Add(E);
TRow R2 = new TRow();
TCell A1 = new TCell("A1", "A1", 1, 0);
TCell A2 = new TCell("A2", "A2", 1, 1);
TCell B1 = new TCell("B1", "B1", 1, 2);
TCell E1 = new TCell("E1", "E1", 1, 5);
TCell E2 = new TCell("E2", "E2", 1, 6);
R2.Cells.Add(A1);
R2.Cells.Add(A2);
R2.Cells.Add(B1);
R2.Cells.Add(E1);
R2.Cells.Add(E2);
TSheet tsheet = new TSheet();
tsheet.Name = "Sheet1";
tsheet.Title = "表格O";
tsheet.Head.Rows.Add(R1);
tsheet.Head.Rows.Add(R2);
template.Sheets.Add(tsheet);
string outputFilePath = AppDomain.CurrentDomain.BaseDirectory + "/ExcelTests/out2.xlsx";
bool result = excel.WriteFile(outputFilePath, ds, template);
Assert.IsTrue(result);
}
/// <summary>
/// The create template.
/// </summary>
/// <param name="tree">
/// The tree.
/// </param>
/// <param name="template">
/// The template.
/// </param>
/// <param name="parentId">
/// The parent id.
/// </param>
public static void CreateTemplate(TTree tree, TTemplate template, ID parentId)
{
Assert.ArgumentNotNull(tree, "database");
Assert.ArgumentNotNull(template, "template");
Assert.ArgumentNotNull(parentId, "parentId");
Item item = tree.Database.GetItem(template.ID);
if (item == null)
{
tree.Database.CreateItem(template.ID, template.Name, new TemplateID(TemplateIDs.Template), parentId);
}
CreateSections(tree, template);
tree.Database.Engines.TemplateEngine.Reset();
}
// Add template to database. Returns added template ID.
public bool addTemplate(TTemplate tpt, ref int id)
{
OleDbCommand cmdInsert = null;
OleDbParameter dbParamInsert = null;
OleDbCommand cmdSelect = null;
try{
// Create SQL command containing ? parameter for BLOB.
cmdInsert = new OleDbCommand("INSERT INTO enroll(template) values(?) ", _connection);
// Create parameter for ? contained in the SQL statement.
System.Byte [] temp = new System.Byte[tpt._size + 1];
System.Array.Copy(tpt._tpt, 0, temp, 0, tpt._size);
dbParamInsert = new OleDbParameter("@template", OleDbType.VarBinary, tpt._size,
ParameterDirection.Input, false, 0, 0, "ID",
DataRowVersion.Current, temp);
cmdInsert.Parameters.Add(dbParamInsert);
//execute query
if (_connection.State == ConnectionState.Open)
{
cmdInsert.ExecuteNonQuery();
}
}
catch {
return(false);
}
try{
// Create SQL command containing ? parameter for BLOB.
cmdSelect = new OleDbCommand("SELECT top 1 ID FROM enroll ORDER BY ID DESC", _connection);
id = System.Convert.ToInt32(cmdSelect.ExecuteScalar());
}
catch {
return(false);
}
return(true);
}
/****************************************************************************/
private TToken CreateToken(CompiledTransform transform, string name, JToken child)
{
var t = child.GetType().ToString();
if (child is JValue val)
{
if (name.StartsWith("#include"))
{
transform.LoadInclude(val.Value.ToString());
return(null);
}
if (name.StartsWith("#break"))
{
return(new TBreak());
}
if (name.StartsWith("#variable"))
{
return(new TVariable(name, val));
}
if (name.StartsWith("#message"))
{
return(new TMessage(val));
}
if (name.StartsWith("#throw"))
{
return(new TThrow(name, val));
}
var sval = val.ToString();
if (name.StartsWith("#arrayitem"))
{
return(new TSimpleArrayItem(val));
}
if (sval.StartsWith("#copyof"))
{
return(new TCopyOf(name, sval));
}
return(new TProperty(name, val));
}
if (child is JObject obj)
{
if (name.StartsWith("#template"))
{
var template = new TTemplate(name, obj);
this.Templates.Add(template.Name, template);
return(null);
}
if (name.StartsWith("#function"))
{
var function = new TFunction(name, obj);
this.Functions.Add(function.Name, function);
return(null);
}
if (name.StartsWith("#variable"))
{
return(new TVariableObject(name, obj));
}
if (name.StartsWith("#calltemplate"))
{
return(new TCallTemplate(name, obj));
}
if (name.StartsWith("#bind"))
{
return(new TBind(name, obj));
}
if (name.StartsWith("#foreachgroup"))
{
return(new TForEachGroup(name, obj));
}
if (name.StartsWith("#foreach"))
{
return(new TForEach(name, obj));
}
if (name.StartsWith("#arrayitem"))
{
return(new TObject(name, obj));
}
if (name.StartsWith("#array"))
{
return(new TArray(name, obj));
}
if (name.StartsWith("#if"))
{
return(new TIf(name, obj));
}
if (name.StartsWith("#try"))
{
return(new TTry(obj));
}
if (name.StartsWith("#catch"))
{
if (_previous is TTry || _previous is TCatch)
{
return(new TCatch(name, obj));
}
throw new Transformer.SyntaxException("#catch must follow a #try or another #catch");
}
if (name.StartsWith("#if"))
{
return(new TIf(name, obj));
}
if (name.StartsWith("#elseif"))
{
if (_previous is TIf || _previous is TElseIf)
{
return(new TElseIf(name, obj));
}
throw new Transformer.SyntaxException("#elseif must follow an #if or another #elseif");
}
if (name.StartsWith("#else"))
{
if (_previous is TIf || _previous is TElseIf)
{
return(new TElse(name, obj));
}
throw new Transformer.SyntaxException("#elseif must follow an #if or an #elseif");
}
return(new TObject(name, obj));
}
if (child is JArray array)
{
return(new TExplicitArray(name, array));
}
return(null);
}
/// <summary>
/// Initializes a new instance of the <see cref="TItemBase"/> class.
/// </summary>
/// <param name="name">
/// The name.
/// </param>
/// <param name="id">
/// The id.
/// </param>
/// <param name="template">
/// The template.
/// </param>
public TItemBase(string name, ID id, TTemplate template)
: this(name, id, new TemplateID(template.ID))
{
}
/// <summary>
/// Initializes a new instance of the <see cref="TItemBase"/> class.
/// </summary>
/// <param name="id">
/// The id.
/// </param>
/// <param name="template">
/// The template.
/// </param>
public TItemBase(ID id, TTemplate template)
: this("TItem", id, template)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="TItemBase"/> class.
/// </summary>
/// <param name="template">
/// The template.
/// </param>
public TItemBase(TTemplate template)
: this(ID.NewID, template)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="TItemBase"/> class.
/// </summary>
/// <param name="name">
/// The name.
/// </param>
/// <param name="template">
/// The template.
/// </param>
public TItemBase(string name, TTemplate template)
: this(name, ID.NewID, template)
{
}
public ActionResult Export(int payId)
{
PaymentManager pm = new PaymentManager();
Payment payment = pm.LoadPayment(payId);
#region 动态模板
TTemplate template = new TTemplate();
TRow R1 = new TRow();
TRow R2 = new TRow();
int index1 = 3;
int index2 = 3;
TCell A = new TCell("PersonId", "ID", 0, 0); A.RowSpan = 2; A.Width = 1;
TCell B = new TCell("PersonName", "姓名", 0, 1); B.RowSpan = 2;
TCell C = new TCell("PersonCode", "身份证", 0, 2); C.RowSpan = 2;
R1.Cells.Add(A);
R1.Cells.Add(B);
R1.Cells.Add(C);
foreach (PayItemDO item in payment.Items)
{
TCell cell = new TCell();
cell.Name = item.ItemName;
cell.Caption = item.ItemCaption;
if (item.IsLeaf == true)
{
//cell.Width = 50;
}
if (item.ParentId == 0)
{
cell.RowIndex = 0;
cell.ColumnIndex = index1;
int colspan = 1;
foreach (PayItemDO pi in payment.Items)
{
if (pi.ParentId == item.ItemId)
{
colspan++;
}
}
if (colspan == 1)
{
cell.RowSpan = 2;
index1++;
index2++;
}
else
{
cell.ColSpan = colspan - 1;
index1 = index1 + cell.ColSpan;
}
R1.Cells.Add(cell);
}
else
{
cell.RowIndex = 1;
cell.ColumnIndex = index2;
index2 = index2 + 1;
R2.Cells.Add(cell);
}
}
TSheet tsheet = new TSheet();
tsheet.Name = "Sheet1";
tsheet.Title = "Sheet1";
tsheet.Head.Rows.Add(R1);
tsheet.Head.Rows.Add(R2);
template.Sheets.Add(tsheet);
#endregion
IExcel excel = ExcelFactory.CreateDefault();
DataSet ds = new DataSet();
payment.DataSource.TableName = "Sheet1";
ds.Tables.Add(payment.DataSource);
POIStream stream = new POIStream();
stream.AllowClose = false;
excel.Write(stream, template, ds, ExcelExtendType.XLSX);
stream.AllowClose = true;
byte[] buffer = new byte[stream.Length];
stream.Position = 0;
stream.Read(buffer, 0, buffer.Length);
stream.Close();
HttpResponse context = System.Web.HttpContext.Current.Response;
try
{
context.ContentType = "application/ms-excel";
context.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xlsx", HttpUtility.UrlEncode(payment.PayTitle, System.Text.Encoding.UTF8)));
context.BinaryWrite(buffer);
context.Flush();
context.End();
}
catch (Exception ex)
{
context.ContentType = "text/plain";
context.Write(ex.Message);
}
return(null);
}
