知识积累_积累知识
知识积累由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“积累知识”。
上传文件至根目录指定文件夹下（定义FILEUPLOAD控件）
string fullfilename = this.FileUpload1.PostedFile.FileName
// string filename = fullfilename.Substring(fullfilename.LastIndexOf(“”)+ 1);string str=“~/Excel/”+fullfilename;
this.FileUpload1.SaveAs(HttpContext.Current.Server.MapPath(str));按照当前格式页面打印EXCEL
// System.Web.UI.Control oControl = this.tExport;
HttpContext.Current.Response.AppendHeader(“Content-Disposition”, “attachment;filename=test.xls”);
HttpContext.Current.Response.Charset = “utf8”;
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = “application/ms-excel”;
//System.IO.StringWriter tw = new System.IO.StringWriter();
//System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
//oControl.RenderControl(hw);
HttpContext.Current.Response.Write(printResult.ToString());//按照当前HTML语言将页面画出
HttpContext.Current.Response.End();1.导入导出EXCEL 导入：
public void Insert()
{
string fullfilename = this.FileUpload1.PostedFile.FileName;
string str=“~/Excel/”+fullfilename;
this.FileUpload1.SaveAs(HttpContext.Current.Server.MapPath(str));
string strUrl = “”;
strUrl = HttpContext.Current.Server.MapPath(str);
int count = 0;
ExcelToDataTable(strUrl);
try
{
for(int i = 1;i
{
dept_pro_budget_detail_bll.UpdateList(dtExcel.Rows[i][“BUD_DETAIL_ID”].ToString().Trim(), dtExcel.Rows[i][“职能部门初审金额”].ToString().Trim(), dtExcel.Rows[i][“数量”].ToString().Trim(), dtExcel.Rows[i][“单位”].ToString().Trim(), dtExcel.Rows[i][“备注”].ToString().Trim());
count++;
}
Ext.Msg.Alert(“系统更新”, “已完成导入更新'” + count + “'行”).Show();
}
catch(Exception ex)
{
ErrorLog.SaveLog(“预算管理-初审-更新EXCEL数据”);
}
}
public static DataSet ExcelToDataTable(string strExcelFileName)
{
string strConn = “Provider=Microsoft.Jet.OLEDB.4.0;” + “Data Source=” + strExcelFileName + “;” + “Extended Properties=Excel 5.0,IMEX=1;”;
using(OleDbConnection conn = new OleDbConnection(strConn))
{ conn.Open();
DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, “Table” });string[] strTableNames = new string[dtSheetName.Rows.Count];
for(int k = 0;k
{
strTableNames[k] = dtSheetName.Rows[k][“TABLE_NAME”].ToString();
}
string strExcel = string.Format(“select * from [{0}$]”, strTableNames[0]);
DataSet ds = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
adapter.Fill(ds);
conn.Close();
return ds.Tables[0];
}
} 导出: int result_flag = 0;
OleDbConnection oConn = new OleDbConnection();
OleDbCommand oCreateComm = new OleDbCommand();
try
{
string excel_path = System.IO.Path.GetDirectoryName(excel_file);
if(System.IO.Directory.Exists(excel_path)== false)
{
System.IO.Directory.CreateDirectory(excel_path);
}
if(System.IO.File.Exists(excel_file)== true)
{
System.IO.File.Delete(excel_file);
}
string OLEDBConnStr = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + excel_file + “;Extended Properties=Excel 8.0;”;
string strCreateTableSQL = @“CREATE TABLE ” + table_name;
strCreateTableSQL += @“(”;
string db_type = “”;
for(int i = 0;i
{
if(dt.Columns[i].DataType.Name.ToLower()== “decimal”)
{
//db_type = “NUMERIC”;
db_type = “VARCHAR”;
}
else
{
db_type = “VARCHAR”;
}
strCreateTableSQL += @“” + dt.Columns[i].ColumnName + “ ” + db_type;
if(i
oCreateComm.CommandText = strInsertTableSQL;
oCreateComm.ExecuteNonQuery();
}
}
oCreateComm.Dispose();
oConn.Close();
context.Response.Clear();
context.Response.WriteFile(excel_file);
context.Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + System.Web.HttpUtility.UrlEncode(down_file_name)+ “.xls”);
context.Response.Flush();
//System.IO.File.Delete(excel_file);
//context.Response.End();
result_flag = 1;
result_str = “OK”;增加numberfield的keyup keydown keypre事件：
需要将numberfield的enableKeyEvents:true。
numberfield控制输入
(javascript)function isNum(o)
{
if(o.toString()==“”)//判断输入为中文或为空值
{
alert(“请您正确输入金额！”);
txtZfMoney.setValue(“”);
//var a=JKGL.clear(o.toString());
}
else
{
if(o.toString().indexOf('.')>-1)
{
var a=o.toString().split('.');
var b=a[0]+'.'+a[1].substring(0,2);
txtZfMoney.setValue(b);
}
}
} 获取gridpanel数据
function deletefileItems(){
var gsm = fileGrid.getSelectionModel();//获取选择列
var rows = gsm.getSelections();//根据选择列获取到所有的行
if(rows.length > 0){
//当有选择的数据的时候
for(var i = 0;i
//循环迭代所有的选择的row
var row = rows[i];
var filePath = row.get('filePath');//这个就是你想要的Ext.Ajax.request({
//省略ajax请求后台
}）;
}
}else{
Ext.Msg.alert('提示', '请选择要删除的记录');
} } Js判断MeageBox function chooseDispatchActionFunc(){
//判断当前是否有选中的数据
var count=querySelCheckBoxCount(“objectids”);
if(!count || count==0){
Ext.MeageBox.alert('提示', '没有需要处理的调度单！');
return;
}else{
Ext.MeageBox.show({
title:'信息提示',msg: '确认要回执当前选定的调度单?',buttons: {yes : “回执”,no:'快捷回执',cancel:'取消'},icon: Ext.MeageBox.QUESTION,fn:function(btn){
if(btn==“no”){
}else if(btn==“yes”){
}else{
}
}
});
}
} 数据空空数据显示：左外联 右外联
