protected void Page_Load(object sender, EventArgs e)
{
PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook();
PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1");
PageOffice.ExcelReader.Table table = sheet.OpenTable("B4:D8");
while (!table.EOF)
{
//获取提交的数值
//DataFields.Count标识的是table的列数
if (!table.DataFields.IsEmpty)
{
content += "<br/>月份名称：" + table.DataFields[0].Text;
content += "<br/>计划完成量：" + table.DataFields[1].Text;
content += "<br/>实际完成量：" + table.DataFields[2].Text;
content += "<br/>*********************************************";
}
//循环进入下一行
table.NextRow();
}
table.Close();
workBook.ShowPage(500, 400);
workBook.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook();
PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1");
content += "testA1：" + sheet.OpenCellByDefinedName("testA1").Value + "<br/>";
content += "testB1：" + sheet.OpenCellByDefinedName("testB1").Value + "<br/>";
workBook.ShowPage(500, 400);
workBook.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook();
PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1");
PageOffice.ExcelReader.Table table = sheet.OpenTable("Info");
int result = 0;
while (!table.EOF)
{
//获取提交的数值
//DataFields.Count标识的是提交过来的table的列数
if (!table.DataFields.IsEmpty)
{
content += "<br/>月份名称：" + table.DataFields[0].Text;
content += "<br/>计划完成量：" + table.DataFields[1].Text;
content += "<br/>实际完成量：" + table.DataFields[2].Text;
content += "<br/>累计完成量：" + table.DataFields[3].Text;
if (string.IsNullOrEmpty(table.DataFields[2].Text) || !int.TryParse(table.DataFields[2].Text, out result) ||
!int.TryParse(table.DataFields[1].Text, out result))
{
content += "<br/>完成率：0";
}
else
{
float f = int.Parse(table.DataFields[2].Text);
f = f / int.Parse(table.DataFields[1].Text);
content += "<br/>完成率：" + string.Format("{0:P}", f);
}
content += "<br/>*********************************************";
}
//循环进入下一行
table.NextRow();
}
table.Close();
workBook.ShowPage(500, 400);
workBook.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null || Session["UserName"].ToString().Length <= 0)
{
Response.Redirect("Login.aspx");
}
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|demo_excelorder.mdb";
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook();;
PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("销售订单");
string sql = "";
if (Request.QueryString["ID"] != null && Request.QueryString["ID"].Length > 0)
{
#region 修改保存
string id = "";
id = Request.QueryString["ID"];
int num;
//保存客户信息
num = UpdateOrInsertCustInfo(cmd, id, workBook, sheet, 0);
if (num > 0) //保存成功
{
int resDelete = 0; //要删除的记录条数
//删除当前orderID下的产品数据
sql = "delete from OrderDetail where OrderId = " + id;
try
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
strErrHtml += "删除客户ID为" + id + "的产品订单信息失败，失败原因为：" + ex.Message + "\n";
resDelete = -1;
}
//删除成功或无数据可删除时
if (resDelete >= 0)
{
//插入产品信息
InsertProductInfo(cmd, workBook, sheet, id);
}
}
else
{
strErrHtml += "<br>客户信息保存失败！";
}
#endregion
}
else
{
#region 新建保存
int maxId = 0;//OrderMaster表中最大ID号
sql = "select max(ID) from OrderMaster ";
cmd.CommandText = sql;
try
{
object obj = cmd.ExecuteScalar();
if (obj != null)
{
maxId = int.Parse(obj.ToString());
//保存客户信息
if (UpdateOrInsertCustInfo(cmd, "", workBook, sheet, maxId) > 0)
{
//插入产品信息
InsertProductInfo(cmd, workBook, sheet, (maxId + 1).ToString());
}
}
}
catch (Exception ex)
{
strErrHtml += "新建订单失败，失败原因为：" + ex.Message;
}
#endregion
}
//保存失败,弹出提示框
if (strErrHtml.Length > 0)
{
strErrHtml = "\n" + strErrHtml;
workBook.ShowPage(410, 260);
workBook.CustomSaveResult = "error";
}
workBook.Close();
conn.Close();
string mScriptName = "updateorder.aspx";
string mHttpUrl = "http://" + Request.ServerVariables["HTTP_HOST"] + Request.ServerVariables["SCRIPT_NAME"];
BaseUrl = mHttpUrl.Substring(0, mHttpUrl.Length - mScriptName.Length);
}