备份及解备份及清除

ContractedBlock.gif ExpandedBlockStart.gif 代码
 
   
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DEV_JIZHANG.Service;
using DEV_JIZHANG.Models;
using DEV_JIZHANG.Common;
using System.Data;
using System.IO;
using ICSharpCode.SharpZipLib.Zip;

namespace DEV_JIZHANG.SystemManagement
{
public partial class SysBack : System.Web.UI.Page
{
private string strSplitChar = " | " ; // 分隔符,常量

private string strEncryptKey = " WXTBASIC " ;

protected void Page_Load( object sender, EventArgs e)
{
if ( ! IsPostBack)
{

}
}

#region 创建各维修点目录
// 创建维修点数据备份目录
private void CreateBackupDir()
{
string strSiteCode = PublicFunction.GetUserID( this .Request);
UZipFilesCreate uzipfilescreate
= UZipFilesCreate.UZipFilesInstance();
uzipfilescreate.filesCreatePath
= Server.MapPath( " ~ " );
uzipfilescreate.CreateDirList(
" \\DataBR\\ " + strSiteCode + " \\Backup " );
}

// 创建维修点数据恢复目录
private void CreateRecoveryDir()
{
string strSiteCode = PublicFunction.GetUserID( this .Request);
UZipFilesCreate uzipfilescreate
= UZipFilesCreate.UZipFilesInstance();
uzipfilescreate.filesCreatePath
= Server.MapPath( " ~ " );
uzipfilescreate.CreateDirList(
" \\DataBR\\ " + strSiteCode + " \\Recovery " );
}
#endregion

#region 数据 导出到CSV
public void ClassToDataTableToCsv( string strSavePath, string className)
{
CSVHelp csv
= new CSVHelp();
strSavePath
= Server.MapPath(strSavePath);
string strError = "" ;
string sql = "" ;

sql
= " select * from " + className + " where uid= " + PublicFunction.GetUserID( this .Page.Request);
DataTable dt
= DBHelper.GetDataSet(sql);
csv.DataTableToCSVFile(dt, strSavePath, strSplitChar,
ref strError);
}
#endregion

protected void btnBack_Click( object sender, EventArgs e)
{
CSVHelp csv
= new CSVHelp();
this .CreateBackupDir(); // 创建备份目录

string uid = PublicFunction.GetUserID( this .Page.Request);
string strBackupDir = " ~/DataBR/ " + uid + " /Backup/ " ; // 备份目录

#region 将维修点信息和用户信息 放入 csv文件
string strError = "" ;
string strLoginName = PublicFunction.GetUserID( this .Request);
string strEncryptUid = csv.EncryptDES(Server.UrlEncode(uid), strEncryptKey);
string strDate = csv.EncryptDES(Server.UrlEncode(DateTime.Now.ToString()), strEncryptKey);

DataTable dt
= new DataTable();
dt.Columns.Add(
" Uid " );
dt.Columns.Add(
" BackDate " );
dt.Rows.Add(
new object [] { strEncryptUid, strDate });
csv.DataTableToCSVFile(dt, Server.MapPath(strBackupDir
+ " 个人.cat " ), strSplitChar, ref strError);

#endregion

#region 从数据库中取出数据放到csv文件中
this .ClassToDataTableToCsv(strBackupDir + " 入库单.cat " , " InInventory " );
this .ClassToDataTableToCsv(strBackupDir + " 出库单.cat " , " OutInventory " );
this .ClassToDataTableToCsv(strBackupDir + " 库存.cat " , " Inventory " );
this .ClassToDataTableToCsv(strBackupDir + " 维修单.cat " , " InService " );
this .ClassToDataTableToCsv(strBackupDir + " 销售单.cat " , " SalesInfo " );
this .ClassToDataTableToCsv(strBackupDir + " 销售产品设置.cat " , " SalesProductName " );
this .ClassToDataTableToCsv(strBackupDir + " 品牌设置.cat " , " SYSBrand " );
this .ClassToDataTableToCsv(strBackupDir + " 供应商设置.cat " , " SYSSupplier " );
this .ClassToDataTableToCsv(strBackupDir + " 共享数据设置.cat " , " UserShare " );
this .ClassToDataTableToCsv(strBackupDir + " 邮寄单.cat " , " YJ " );
#endregion


#region 打包csv文件到zip文件,并弹出下载保存
MemoryStream ms
= new MemoryStream();
byte [] buffer = null ;

using (ZipFile file = ZipFile.Create(ms))
{
file.BeginUpdate();
file.NameTransform
= new MyNameTransfom(); // 通过这个名称格式化器,可以将里面的文件名进行一些处理。默认情况下,会自动根据文件的路径在zip中创建有关的文件夹。

file.Add(Server.MapPath(strBackupDir
+ " 个人.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 入库单.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 出库单.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 库存.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 维修单.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 销售单.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 销售产品设置.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 品牌设置.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 供应商设置.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 共享数据设置.cat " ));
file.Add(Server.MapPath(strBackupDir
+ " 邮寄单.cat " ));

file.CommitUpdate();

buffer
= new byte [ms.Length];
ms.Position
= 0 ;
ms.Read(buffer,
0 , buffer.Length);
}

string strFileName = " WXT_DataBackup_ " + PublicFunction.GetUserID( this .Page.Request) + " _ " + DateTime.Now.ToString( " yyyyMMdd " ) + " .zip " ;
Response.AddHeader(
" content-disposition " , " attachment;filename= " + Server.UrlEncode(strFileName));
// Response.AddHeader("Content-Transfer-Encoding", "binary");
// Response.ContentType = "application/octet-stream";
// Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.BinaryWrite(buffer);
Response.Flush();
Response.End();
#endregion
}

protected void btnUp_Click( object sender, EventArgs e)
{
this .CreateRecoveryDir();

string strSiteCode = PublicFunction.GetUserID( this .Request);
string strRecoveryDir = " ~/DataBR/ " + strSiteCode + " /Recovery/ " ; // 恢复目录


try
{
#region 上传并解压文件
CSVHelp csv
= new CSVHelp();
if (FileUpload1.PostedFile.ContentLength == 0 )
{
// Page.RegisterClientScriptBlock("myKey", "<script>alert('请浏览并选择恢复的文件!')</script>");
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('请浏览并选择恢复的文件!')</script> " );
return ;
}

if (FileUpload1.PostedFile.ContentType != " application/x-zip-compressed " )
{
// Page.RegisterClientScriptBlock("myKey", "<script>alert('恢复的文件不正确!')</script>");
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复的文件不正确!')</script> " );
return ;
}

// 上传
string FileName = " RecoveryData.zip " ;
string svrFileName = Server.MapPath(strRecoveryDir) + FileName;
this .FileUpload1.PostedFile.SaveAs(svrFileName);

UZipFilesCreate uzipfilescreate
= UZipFilesCreate.UZipFilesInstance();
uzipfilescreate.ZipFileName
= svrFileName; // this.UploadFile.PostedFile.FileName.Trim();
uzipfilescreate.filesCreatePath = Server.MapPath(strRecoveryDir);
try
{
// uzipfilescreate.UZipCreateFiles();

ZipEntry entry;
// this.lblError1.Text = uzipfilescreate.ZipFileName.ToString();
ZipInputStream zipinputstream = new ZipInputStream(File.OpenRead(uzipfilescreate.ZipFileName)); // 此句有错误


while ((entry = zipinputstream.GetNextEntry()) != null )
{
// this.CreateDirList(entry.Name);
// string strPath = this.filescreatepath + "\\" + entry.Name;
// this.lblError1.Text = "in";
string strPath = uzipfilescreate.filesCreatePath + " \\ " + entry.Name;
FileStream streamWriter
= File.Create(strPath);
byte [] data = new byte [entry.Size];
zipinputstream.Read(data,
0 , data.Length);
streamWriter.Write(data,
0 , data.Length);
streamWriter.Close();
File.SetLastWriteTime(strPath, entry.DateTime);
}
zipinputstream.Close();
}
catch (Exception ex)
{
string strex = ex.Message.ToString();
// this.lblError.Text = strex;
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('您刚刚恢复过,请稍后再试! " + strex.Replace( " ' " , "" ) + " ')</script> " );
return ;
}
#endregion

#region 取出导入文件的维修点和登录用户名,与系统登录的维修点和登录名比较,不匹配则提示错误
string strError = "" ;
DataTable dtTemp
= null ;

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 个人.cat " ), ref strError);
if (dtTemp.Rows.Count != 1 )
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('备份源数据文件被破坏,不能进行恢复!')</script> " );
return ;
}
else
{
string strEncryptUid = dtTemp.Rows[ 0 ][ 0 ].ToString().Trim();
string strEncryptDate = dtTemp.Rows[ 0 ][ 1 ].ToString().Trim();
// string strSiteCode = PublicFunction.GetSiteCode(this.Request);
string strLoginUid = PublicFunction.GetUserID( this .Request);

if (csv.EncryptDES(strLoginUid, strEncryptKey) != strEncryptUid)
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('使用的文件非此登录用户的备份文件,不能进行恢复!')</script> " );
return ;
}
}
#endregion

#region csv 导出 datatable,并插入恢复数据
string uid = PublicFunction.GetUserID( this .Page.Request);
dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 入库单.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete ininventory where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
InInventory ininventory
= new InInventory();
ininventory.InNo
= item[ 1 ].ToString();
ininventory.Depot
= item[ 2 ].ToString();
ininventory.InGong
= item[ 3 ].ToString();
ininventory.InBrand
= item[ 4 ].ToString();
ininventory.InModel
= item[ 5 ].ToString();
ininventory.InName
= item[ 6 ].ToString();
ininventory.InCount
= int .Parse(item[ 7 ].ToString());
ininventory.InCost
= decimal .Parse(item[ 8 ].ToString());
ininventory.InPeople
= item[ 9 ].ToString();
ininventory.InRemark
= item[ 10 ].ToString();
ininventory.InDate
= DateTime.Parse(item[ 11 ].ToString());
ininventory.Uid
= int .Parse(item[ 12 ].ToString());
if ( ! JIZHANGService.CreateInInventoryBLL().SaveEntity(ininventory))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 维修单.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete inservice where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
InService inService
= new InService();
inService.Customer
= item[ 1 ].ToString();
inService.Sex
= item[ 2 ].ToString();
inService.FixedPhone
= item[ 3 ].ToString();
inService.MobilePhone
= item[ 4 ].ToString();
inService.IMIE
= item[ 5 ].ToString();
inService.IdNum
= item[ 6 ].ToString();
inService.PhoneType
= item[ 7 ].ToString();
inService.Brand
= item[ 8 ].ToString();
inService.Model
= item[ 9 ].ToString();
inService.PhoneClor
= item[ 10 ].ToString();
inService.Facade
= item[ 11 ].ToString();
inService.Symptom
= item[ 12 ].ToString();
inService.Addon
= item[ 13 ].ToString();
inService.Remark
= item[ 14 ].ToString();
inService.WxDate
= DateTime.Parse(item[ 15 ].ToString());
inService.WxType
= item[ 16 ].ToString();
inService.WxNo
= item[ 17 ].ToString();
inService.Uid
= int .Parse(item[ 18 ].ToString());
inService.WxModel
= item[ 19 ].ToString();
inService.WxPeople
= item[ 20 ].ToString();
inService.WxResult
= item[ 21 ].ToString();
inService.WxFab1
= item[ 22 ].ToString();
inService.WxFab2
= item[ 23 ].ToString();
inService.WxFab3
= item[ 24 ].ToString();
inService.WxFab4
= item[ 25 ].ToString();
inService.WxFab5
= item[ 26 ].ToString();
inService.WxFab6
= item[ 27 ].ToString();
inService.FabCost
= decimal .Parse(item[ 28 ].ToString());
inService.FabPrice
= decimal .Parse(item[ 29 ].ToString());
inService.FanRemark
= item[ 30 ].ToString();
inService.FanShouType
= item[ 31 ].ToString();
inService.FanShiPrice
= decimal .Parse(item[ 32 ].ToString());
inService.FanPiaoType
= item[ 33 ].ToString();
inService.FanXiaoPiao
= item[ 34 ].ToString();
inService.WxwDate
= DateTime.Parse(item[ 35 ].ToString());
inService.YnXF
= item[ 36 ].ToString();
if ( ! JIZHANGService.CreateInServiceBLL().SaveEntity(inService))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 库存.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete inventory where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
Inventory inventory
= new Inventory();
inventory.Brand
= item[ 1 ].ToString();
inventory.Model
= item[ 2 ].ToString();
inventory.InCount
= int .Parse(item[ 3 ].ToString());
inventory.InCost
= decimal .Parse(item[ 4 ].ToString());
inventory.InDate
= DateTime.Parse(item[ 5 ].ToString());
inventory.Uid
= int .Parse(item[ 6 ].ToString());
inventory.Depot
= item[ 7 ].ToString();
inventory.Dname
= item[ 8 ].ToString();
if ( ! JIZHANGService.CreateInventoryBLL().SaveEntity(inventory))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 出库单.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete outinventory where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
OutInventory outInventory
= new OutInventory();
outInventory.OutNo
= item[ 1 ].ToString();
outInventory.Depot
= item[ 2 ].ToString();
outInventory.OutGong
= item[ 3 ].ToString();
outInventory.OutBrand
= item[ 4 ].ToString();
outInventory.OutModel
= item[ 5 ].ToString();
outInventory.OutName
= item[ 6 ].ToString();
outInventory.OutCount
= int .Parse(item[ 7 ].ToString());
outInventory.OutCost
= decimal .Parse(item[ 8 ].ToString());
outInventory.OutPeople
= item[ 9 ].ToString();
outInventory.OutRemark
= item[ 10 ].ToString();
outInventory.OutDate
= DateTime.Parse(item[ 11 ].ToString());
outInventory.Uid
= int .Parse(item[ 12 ].ToString());
if ( ! JIZHANGService.CreateOutInventoryBLL().SaveEntity(outInventory))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 销售单.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete salesinfo where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
SalesInfo salesInfo
= new SalesInfo();
salesInfo.SalesBrand
= item[ 1 ].ToString();
salesInfo.SalesItem
= item[ 2 ].ToString();
salesInfo.SalesCount
= int .Parse(item[ 3 ].ToString());
salesInfo.SalesPrice
= decimal .Parse(item[ 4 ].ToString());
salesInfo.SalesCost
= decimal .Parse(item[ 5 ].ToString());
salesInfo.SaleNo
= item[ 6 ].ToString();
salesInfo.SalesBackType
= item[ 7 ].ToString();
salesInfo.SalesBackPrice
= decimal .Parse(item[ 8 ].ToString());
salesInfo.Uid
= int .Parse(item[ 9 ].ToString());
salesInfo.UserName
= item[ 10 ].ToString();
salesInfo.Sex
= item[ 11 ].ToString();
salesInfo.UserPhone
= item[ 12 ].ToString();
salesInfo.PiaoType
= item[ 13 ].ToString();
salesInfo.SmallPiao
= item[ 14 ].ToString();
salesInfo.Remark
= item[ 15 ].ToString();
salesInfo.SalesPeople
= item[ 16 ].ToString();
salesInfo.SalesDate
= DateTime.Parse(item[ 17 ].ToString());
salesInfo.SalesType
= item[ 18 ].ToString();
salesInfo.SalesBackDate
= DateTime.Parse(item[ 19 ].ToString());
if ( ! JIZHANGService.CreateSalesInfoBLL().SaveEntity(salesInfo))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 邮寄单.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete yj where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
YJ yj
= new YJ();
yj.Brand
= item[ 1 ].ToString();
yj.Model
= item[ 2 ].ToString();
yj.Number
= item[ 3 ].ToString();
yj.Count
= int .Parse(item[ 4 ].ToString());
yj.UserName
= item[ 5 ].ToString();
yj.Remark
= item[ 6 ].ToString();

yj.SDate
= DateTime.Parse(item[ 7 ].ToString());
yj.YJNO
= item[ 8 ].ToString();
yj.YJUser
= item[ 9 ].ToString();
yj.YJbao
= item[ 10 ].ToString();
yj.Yname
= item[ 11 ].ToString();
yj.Uid
= int .Parse(item[ 12 ].ToString());
yj.YJDate
= DateTime.Parse(item[ 13 ].ToString());
yj.YJState
= item[ 14 ].ToString();
yj.YJBack
= item[ 15 ].ToString();
yj.YJBDate
= item[ 16 ].ToString();

if ( ! JIZHANGService.CreateYJBLL().SaveEntity(yj))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 销售产品设置.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete salesproductname where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
SalesProductName spn
= new SalesProductName();
spn.Uid
= int .Parse(item[ 1 ].ToString());
spn.ProductName
= item[ 2 ].ToString();
spn.ProductCost
= decimal .Parse(item[ 3 ].ToString());
spn.ProductPrice
= decimal .Parse(item[ 4 ].ToString());
spn.ProductBrand
= item[ 5 ].ToString();
if ( ! JIZHANGService.CreateSalesProductNameBLL().SaveEntity(spn))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 品牌设置.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete sysbrand where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
SYSBrand sb
= new SYSBrand();
sb.Uid
= int .Parse(item[ 1 ].ToString());
sb.Brand
= item[ 2 ].ToString();
if ( ! JIZHANGService.CreateSYSBrandBLL().SaveEntity(sb))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 供应商设置.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete syssupplier where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
SYSSupplier sss
= new SYSSupplier();
sss.Uid
= int .Parse(item[ 1 ].ToString());
sss.Supplier
= item[ 2 ].ToString();
sss.Phone
= item[ 3 ].ToString();
sss.Address
= item[ 4 ].ToString();
if ( ! JIZHANGService.CreateSYSSupplierBLL().SaveEntity(sss))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}

dtTemp
= csv.ImportCSVToDataTable(Server.MapPath(strRecoveryDir + " 共享数据设置.cat " ), ref strError);
DBHelper.ExecuteCommand(
" delete usershare where uid= " + uid);
foreach (DataRow item in dtTemp.Rows)
{
UserShare us
= new UserShare();
us.Uid
= int .Parse(item[ 1 ].ToString());
us.Puid
= int .Parse(item[ 2 ].ToString());
us.Pname
= item[ 3 ].ToString();
us.Mname
= item[ 4 ].ToString();
us.Rname
= item[ 5 ].ToString();
if ( ! JIZHANGService.CreateUserShareBLL().SaveEntity(us))
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('恢复库存数据时失败! " + item[ 0 ] + " ')</script> " );
return ;
}
}
#endregion

this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('数据恢复成功!')</script> " );
}
catch (Exception err)
{
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('数据恢复失败! " + err.Message.ToString().Replace( " ' " , "" ) + " ')</script> " );
}
}

protected void btnClear_Click( object sender, EventArgs e)
{
string uid = PublicFunction.GetUserID( this .Page.Request);

DBHelper.ExecuteCommand(
" delete ininventory where uid= " + uid);
DBHelper.ExecuteCommand(
" delete usershare where uid= " + uid);
DBHelper.ExecuteCommand(
" delete syssupplier where uid= " + uid);
DBHelper.ExecuteCommand(
" delete sysbrand where uid= " + uid);
DBHelper.ExecuteCommand(
" delete salesproductname where uid= " + uid);
DBHelper.ExecuteCommand(
" delete yj where uid= " + uid);
DBHelper.ExecuteCommand(
" delete salesinfo where uid= " + uid);
DBHelper.ExecuteCommand(
" delete outinventory where uid= " + uid);
DBHelper.ExecuteCommand(
" delete inventory where uid= " + uid);
DBHelper.ExecuteCommand(
" delete inservice where uid= " + uid);
this .ClientScript.RegisterClientScriptBlock( this .GetType(), " myKey " , " <script>alert('清空数据成功!')</script> " );


}


}
}

 

转载于:https://www.cnblogs.com/dthom/articles/1812749.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值