private void button1_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb_sellerid.Text))
{
MyOperation.MessageShow("请填写完整的书主号");
tb_sellerid.Focus();
return;
}
string sql = string.Format("SELECT s.sellinfoid AS `图书ID`,b.`name` AS `书名`,b.press AS `出版社`,s.price AS `售价`," +
"s.issold AS `是否出售` FROM tt_sellinfo AS s , tt_bookinfo AS b WHERE s.bookid = b.id AND " +
"s.sellerid = '{0}'", tb_sellerid.Text);
DataTable dt = dbo.Selectinfo(sql);
int count = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ("0" == dt.Rows[i]["是否出售"].ToString())
{
dt.Rows[i]["是否出售"] = "否";
}
else
{
dt.Rows[i]["是否出售"] = "是";
count++;
}
}
dataGrid.ItemsSource = dt.DefaultView;
lb_info.Content = string.Format("共寄售{0}本，已出售{1}本", dt.Rows.Count.ToString(), count.ToString());
}
private static async Task RawTest(bool hasSessionId, RegisterOptions registerOptions, CallOptions callOptions)
{
WampPlayground playground = new WampPlayground();
CallerCallee dualChannel = await playground.GetCallerCalleeDualChannel();
IWampChannel calleeChannel = dualChannel.CalleeChannel;
IWampChannel callerChannel = dualChannel.CallerChannel;
MyOperation myOperation = new MyOperation();
await calleeChannel.RealmProxy.RpcCatalog.Register(myOperation, registerOptions);
MyCallback myCallback = new MyCallback();
callerChannel.RealmProxy.RpcCatalog.Invoke(myCallback, callOptions, myOperation.Procedure);
long?expectedCaller = null;
if (hasSessionId)
{
expectedCaller = dualChannel.CallerSessionId;
}
if (callOptions.DiscloseMe == false && registerOptions.DiscloseCaller == true)
{
Assert.That(myCallback.ErrorUri, Is.EqualTo(WampErrors.DiscloseMeNotAllowed));
}
else
{
Assert.That(myOperation.Details.Caller, Is.EqualTo(expectedCaller));
}
}
public async Task ProgressiveCallsCalleeProxyProgress()
{
WampPlayground playground = new WampPlayground();
CallerCallee dualChannel = await playground.GetCallerCalleeDualChannel();
IWampChannel calleeChannel = dualChannel.CalleeChannel;
IWampChannel callerChannel = dualChannel.CallerChannel;
MyOperation myOperation = new MyOperation();
await calleeChannel.RealmProxy.RpcCatalog.Register(myOperation, new RegisterOptions());
ILongOpService proxy = callerChannel.RealmProxy.Services.GetCalleeProxyPortable <ILongOpService>();
List <int> results = new List <int>();
MyProgress <int> progress = new MyProgress <int>(i => results.Add(i));
Task <int> result = proxy.LongOp(10, progress);
result.Wait();
CollectionAssert.AreEquivalent(Enumerable.Range(0, 10), results);
Assert.That(result.Result, Is.EqualTo(10));
}
private void SearchSellerinfo()
{
if (string.IsNullOrEmpty(this.tb_selleridsearch.Text))
{
MyOperation.MessageShow("请输入查询的书主号");
this.tb_selleridsearch.Focus();
return;
}
string sql = string.Format("SELECT * FROM tt_sellerinfo WHERE sellerid = '{0}'", tb_selleridsearch.Text);
DataTable dt = dbo.Selectinfo(sql);
if (dt.Rows.Count != 1)
{
sellerid = "";
MyOperation.MessageShow("查询失败，请检查书主号是否正确");
this.tb_selleridsearch.Focus();
return;
}
else
{
sellerid = dt.Rows[0]["sellerid"].ToString();
tb_jiebie.Text = dt.Rows[0]["grade"].ToString();
tb_mark.Text = dt.Rows[0]["mark"].ToString();
tb_name.Text = dt.Rows[0]["name"].ToString();
tb_tel.Text = dt.Rows[0]["phone"].ToString();
}
}
public MyCondition(IMyVariableStorage <T> storage, MyOperation operation, string leftSideStorage, string rightSideStorage)
{
Debug.Assert(storage != null, "Variable storage must not be null.");
m_storage = storage;
m_operation = operation;
m_leftSideStorage = MyStringId.GetOrCompute(leftSideStorage);
m_rightSideStorage = MyStringId.GetOrCompute(rightSideStorage);
}
public ClassDelegates(Mood moodType, string x)
{
name = x;
if (moodType == Mood.HAPPY)
chosenGreet = new MyOperation(HappyGreet); // or simply, chosenGreet = HappyGreet;
else
chosenGreet = AngryGreet;
}
//书主信息表
private void button4_Click(object sender, RoutedEventArgs e)
{
string sql = "SELECT ts.sellerid AS `书主号`,ts.`name` AS `姓名`,ts.phone AS `手机`," +
"ts.grade AS `年级`,ts.mark AS `备注` FROM tt_sellerinfo AS ts";
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了全部书主信息");
ExcelOperation.SendToExcel(dt, "书主信息表");
}
public MyCondition(IMyVariableStorage <T> storage, MyOperation operation, T leftSideValue, T rightSideValue)
{
// Debug.Assert(storage != null, "Variable storage must not be null."); // the storage can be null here
m_storage = storage;
m_operation = operation;
m_leftSideStorage = MyStringId.NullOrEmpty;
m_rightSideStorage = MyStringId.NullOrEmpty;
m_leftSideValue = leftSideValue;
m_rightSideValue = rightSideValue;
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(textBox2.Text))
{
MyOperation.MessageShow("请输入要查询的书主ID");
textBox2.Focus();
return;
}
displayye(textBox2.Text);
}
//导出全部员工信息
private void button3_Click(object sender, RoutedEventArgs e)
{
string sql = "SELECT ts.staffid AS `员工号`,ts.`name` AS `姓名`,ts.email AS `邮箱`,ts.phone AS `手机`," +
"ts.role AS `角色`,ts.mark AS `备注` FROM tt_staffinfo AS ts";
DataTable dt = dbo.Selectinfo(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["角色"] = ("admin" == dt.Rows[i]["角色"].ToString()) ? "管理员" : "员工";
}
MyOperation.DebugPrint("导出了全部员工信息");
ExcelOperation.SendToExcel(dt, "员工信息表");
}
private async Task Register(IWampChannel channel, string procedure, string match, Action <MyOperation, InvocationDetails> action)
{
MyOperation operation = new MyOperation(action, procedure);
Task <IAsyncDisposable> task =
channel.RealmProxy.RpcCatalog.Register(operation,
new RegisterOptions()
{
Match = match
});
await task;
}
private void search_book()
{
lbb_author.Content = lbb_ISBN.Content = lbb_name.Content = lbb_press.Content = lbb_price.Content = "";
if (string.IsNullOrEmpty(tb_isbn.Text))
{
MyOperation.MessageShow("请输入图书的ISBN号");
tb_isbn.Focus();
return;
}
string sql = string.Format("SELECT * FROM tt_bookinfo WHERE isbn LIKE '%{0}%'", tb_isbn.Text);
DataTable dt = dbo.Selectinfo(sql);
//修改为只看第一个符合ISBN号的图书，这样可以规避ISBN号重复的问题
if (dt.Rows.Count >= 1)
{
bookinfo boi = new bookinfo();
boi.bookid = dt.Rows[0]["id"].ToString();
boi.author = dt.Rows[0]["author"].ToString();
boi.isbn = dt.Rows[0]["isbn"].ToString();
boi.name = dt.Rows[0]["name"].ToString();
boi.press = dt.Rows[0]["press"].ToString();
boi.price = dt.Rows[0]["price"].ToString();
boi.imgpath = dt.Rows[0]["imgpath"].ToString();
tb_price.Text = (MyOperation.string2float(dt.Rows[0]["price"].ToString()) * 0.3).ToString("0.0");
DisplayBookinfo(boi);
return;
}
//else if (dt.Rows.Count > 1)
//{
// MyOperation.MessageShow("存在2本以上相同ISBN号的图书，请确认ISBN号或者联系系统管理员");
// tb_isbn.Focus();
// return;
//}
else
{
string url = string.Format("http://api.jige.olege.com/book?q={0}&type=ISBN", tb_isbn.Text);
string html = GetHtml(url);
bookinfo bi;
if (PraseHtml(html, out bi))
{
bi.bookid = InsertNewBookInfo(bi);
if ("" == bi.bookid)
{
return;
}
DisplayBookinfo(bi);
}
}
}
//可以刷新当前实时余额以及出售数量
private string get_money2()
{
string sql = "SELECT date,money FROM tt_fanance ORDER BY date DESC LIMIT 0,1";
DataTable dt = dbo.Selectinfo(sql);
float count_old = 0;
string datetime = "";
if (dt.Rows.Count == 1)
{
count_old = float.Parse(dt.Rows[0]["money"].ToString());
datetime = dt.Rows[0]["date"].ToString();
}
else
{
datetime = "2000/1/1 00:00:00";
}
float count1 = 0;
//计算该班次出售的数量
sql = string.Format("SELECT count(*) FROM tt_sellinfo WHERE issold = '1' AND soldtime > '{0}' GROUP BY NULL", datetime);
dt = dbo.Selectinfo(sql);
if (dt.Rows.Count == 1)
{
lb_thiscount.Content = dt.Rows[0][0].ToString();
}
else
{
lb_thiscount.Content = "数量异常";
}
//先计算出售信息
sql = string.Format("SELECT SUM(price) FROM tt_sellinfo WHERE issold = '1' AND soldtime > '{0}' GROUP BY NULL", datetime);
dt = dbo.Selectinfo(sql);
if (dt.Rows.Count == 1)
{
count1 = float.Parse(dt.Rows[0][0].ToString());
}
float count2 = 0;
//再计算提款信息
sql = string.Format("SELECT SUM(count) FROM tt_tikuan WHERE date > '{0}' GROUP BY NULL", datetime);
dt = dbo.Selectinfo(sql);
if (dt.Rows.Count == 1)
{
count2 = float.Parse(dt.Rows[0][0].ToString());
}
MyOperation.DebugPrint("前日剩余：" + count_old.ToString() + "今日收入：" + count1.ToString() + "今日支出：" + count2.ToString());
return((count_old + count1 - count2).ToString());
}
private void button7_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker5.SelectedDate || null == datePicker6.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT tt_fanance.money AS `余额`, tt_fanance.date AS `结算时间` FROM tt_fanance " +
"WHERE date > '{0}' AND date < '{1}'", datePicker5.SelectedDate, datePicker6.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了现金流向信息");
ExcelOperation.SendToExcel(dt, "现金详情表");
}
private void tb_sellidsearch_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter)
{
SearchSellinfo();
e.Handled = true;
}
}
catch (Exception e1)
{
MyOperation.DebugPrint(e1.Message);
}
}
private void tb_price_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter)
{
ChangePrice();
e.Handled = true;
}
}
catch (Exception e1)
{
MyOperation.DebugPrint(e1.Message);
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb1.Text))
{
MyOperation.MessageShow("请输入书主号");
tb1.Focus();
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.count AS `数额`,tt.date AS `提款时间` " +
"FROM tt_tikuan AS tt ,tt_sellerinfo AS ts WHERE tt.sellerid = ts.sellerid AND ts.sellerid = '{0}'", tb1.Text);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了取现信息：" + tb1.Text);
ExcelOperation.SendToExcel(dt, string.Format("书主【{0}】取现详情表", tb1.Text));
}
private void tb_isbn_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter)
{
search_book();
e.Handled = true;
}
}
catch (Exception e1)
{
MyOperation.MessageShow(e1.Message);
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(this.textBox1.Text))
{
MyOperation.MessageShow("请输入查询的书主信息");
this.textBox1.Focus();
return;
}
string sql = string.Format("SELECT * FROM tt_sellerinfo WHERE phone LIKE '%{0}%'", textBox1.Text);
DataTable dt = dbo.Selectinfo(sql);
dataGrid.ItemsSource = dt.DefaultView;
}
//按时间导出取现信息
private void button5_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker1.SelectedDate || null == datePicker2.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.count AS `数额`,tt.date AS `提款时间` FROM tt_tikuan AS tt ," +
"tt_sellerinfo AS ts WHERE tt.sellerid = ts.sellerid AND tt.date > '{0}' AND tt.date < '{1}'", datePicker1.SelectedDate, datePicker2.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了取现信息");
ExcelOperation.SendToExcel(dt, "取现详情表");
}
public void ThreadProc()
{
DBOperation dbo = new DBOperation();
YouGeWebApi ygw = new YouGeWebApi();
if (string.IsNullOrEmpty(_book_id))
{
throw new Exception("book_id is null!");
}
if (string.IsNullOrEmpty(_price))
{
throw new Exception("price is null!");
}
//判断本地是否有相同book_id和price的交易记录，如果有就全部同步成一个mallid,不要再上报给喵校园主库
string sql = string.Format("SELECT tt_bookinfo.id,tt_sellinfo.mallid FROM tt_bookinfo ,tt_sellinfo WHERE tt_bookinfo.id " +
"= tt_sellinfo.bookid AND tt_bookinfo.gbookid ='{0}' AND ABS(tt_sellinfo.price- {1}) < 1e-5 AND tt_sellinfo.mallid IS NOT NULL",
_book_id, _price);
DataTable dt = dbo.Selectinfo(sql);
//如果有，则直接全部更新一次mallid，不用上报给喵校园主库
if (dt.Rows.Count > 0)
{
sql = string.Format("UPDATE tt_sellinfo SET mallid = '{0}' WHERE bookid = '{1}' AND ABS(price- {2}) < 1e-5",
dt.Rows[0]["mallid"].ToString(), dt.Rows[0]["id"].ToString(), _price);
dbo.AddDelUpdate(sql);
return;
}
//如果没有，则添加到喵校园主库，返回交易ID后，同步到每一条符合条件的交易中
string sellinfoid;//喵校园交易ID
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("book_id", _book_id);
parameters.Add("price", _price);
parameters.Add("seller_id", Properties.Settings.Default.sellerid);
if (ygw.InsertNewSellInfo(parameters, out sellinfoid))
{
sql = string.Format("UPDATE tt_sellinfo SET mallid = '{0}' WHERE bookid = '{1}' AND ABS(price- {2}) < 1e-5",
sellinfoid, _local_book_id, _price);
dbo.AddDelUpdate(sql);
MessageBox.Show("执行完成");
return;
}
else
{
MyOperation.DebugPrint("Insert Error!", 3);
throw new Exception("Insert Error!");
}
}
private void DisplayBookinfo(bookinfo bi)
{
if (null == bi)
{
return;
}
try
{
lbb_bookid.Content = "内部编号：" + bi.bookid;
lbb_author.Content = "作者：" + bi.author;
lbb_ISBN.Content = "ISBN：" + bi.isbn;
lbb_name.Content = "书名：" + bi.name;
lbb_press.Content = "出版社：" + bi.press;
lbb_price.Content = "定价：" + bi.price;
//====================标准image source添加方法=====================
// Create source
BitmapImage myBitmapImage = new BitmapImage();
// BitmapImage.UriSource must be in a BeginInit/EndInit block
myBitmapImage.BeginInit();
myBitmapImage.UriSource = new Uri(@bi.imgpath, UriKind.Absolute);
// To save significant application memory, set the DecodePixelWidth or
// DecodePixelHeight of the BitmapImage value of the image source to the desired
// height or width of the rendered image. If you don't do this, the application will
// cache the image as though it were rendered as its normal size rather then just
// the size that is displayed.
// Note: In order to preserve aspect ratio, set DecodePixelWidth
// or DecodePixelHeight but not both.
myBitmapImage.DecodePixelWidth = 250;
myBitmapImage.EndInit();
//set image source
bookimage.Source = myBitmapImage;
DisplayAll(1);
}
catch (UriFormatException e)
{
MyOperation.DebugPrint("DisplayBookinfo未能解析URL:" + e.Message, 1);
bookimage.Source = new BitmapImage(new Uri(@"/images/defaultbookimg.jpg", UriKind.RelativeOrAbsolute));
DisplayAll(1);
}
catch (Exception e)
{
MyOperation.DebugPrint("DisplayBookinfo出现catch异常:" + e.Message, 3);
DisplayAll(2);
MyOperation.MessageShow("系统异常，请联系管理员处理");
}
}
private void UserControl_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.F5)
{
Display();
e.Handled = true;
}
}
catch (Exception e1)
{
MyOperation.DebugPrint("结账下班界面刷新时出现了异常" + e1.Message);
MyOperation.MessageShow("结账下班界面刷新时出现了异常" + e1.Message);
}
}
private void button8_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker7.SelectedDate || null == datePicker8.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT ts.`name` AS `姓名`,tt.time AS `时长`,tt.group AS `班次`,tt.date AS `签到时间`," +
"tt.mark AS `备注` FROM tt_time AS tt ,tt_staffinfo AS ts WHERE ts.staffid = tt.staffid AND tt.date > '{0}' AND " +
"tt.date < '{1}'", datePicker7.SelectedDate, datePicker8.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了工时信息");
ExcelOperation.SendToExcel(dt, "工时详情表");
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb_sellerid.Text) || tb_sellerid.Text.Length != 8)
{
MyOperation.MessageShow("请填写正确的书主号，长度8位");
tb_sellerid.Focus();
return;
}
else
{
string sqls = string.Format("SELECT * FROM tt_sellerinfo WHERE sellerid = '{0}'", tb_sellerid.Text);
DataTable dt = dbo.Selectinfo(sqls);
if (dt.Rows.Count > 0)
{
MyOperation.MessageShow("该书主号已经存在");
tb_sellerid.Focus();
return;
}
}
if (string.IsNullOrEmpty(tb_name.Text))
{
MyOperation.MessageShow("请填写完整的姓名");
tb_name.Focus();
return;
}
if (string.IsNullOrEmpty(tb_phone.Text))
{
MyOperation.MessageShow("请填写完整的手机");
tb_phone.Focus();
return;
}
string sql = string.Format("INSERT INTO tt_sellerinfo (id,sellerid,name,phone,grade,mark) VALUES (null,'{0}','{1}','{2}','{3}','{4}')",
tb_sellerid.Text, tb_name.Text, tb_phone.Text, tb_grade.Text, tb_mark.Text);
if (dbo.AddDelUpdate(sql) == 1)
{
MyOperation.MessageShow("添加成功");
tb_sellerid.Text = tb_name.Text = tb_phone.Text = tb_mark.Text = tb_grade.Text = "";
}
else
{
MyOperation.MessageShow("添加失败，请重试");
}
}
private void ModifyScene(UIApplication uiapp, String text, MyOperation operation)
{
uidoc = uiapp.ActiveUIDocument;
if (uidoc != null)
{
using (Transaction trans = new Transaction(uidoc.Document))
{
if (trans.Start(text) == TransactionStatus.Started)
{
operation(1);
trans.Commit();
}
}
}
}
//出售信息详情表
private void button6_Click(object sender, RoutedEventArgs e)
{
if (null == datePicker3.SelectedDate || null == datePicker4.SelectedDate)
{
MyOperation.MessageShow("请选择开始和结束日期");
return;
}
string sql = string.Format("SELECT tb.`name` AS `书名`,tb.press AS `出版社`,ts.sellinfoid AS `图书ID`,ts.price " +
"AS `售价`,tsr.sellerid AS `书主ID`,tsr.`name` AS `书主`,ts.soldtime AS `出售时间` FROM tt_sellinfo AS ts ," +
"tt_bookinfo AS tb ,tt_sellerinfo AS tsr WHERE ts.sellerid = tsr.sellerid AND ts.bookid = tb.id AND ts.soldtime" +
" > '{0}' AND ts.soldtime < '{1}'", datePicker3.SelectedDate, datePicker4.SelectedDate);
DataTable dt = dbo.Selectinfo(sql);
MyOperation.DebugPrint("导出了出售信息");
ExcelOperation.SendToExcel(dt, "出售详情表");
}
public async Task ProgressiveCallsCalleeProxyObservableError()
{
WampPlayground playground = new WampPlayground();
CallerCallee dualChannel = await playground.GetCallerCalleeDualChannel();
IWampChannel calleeChannel = dualChannel.CalleeChannel;
IWampChannel callerChannel = dualChannel.CallerChannel;
MyOperation myOperation = new MyOperation();
await calleeChannel.RealmProxy.RpcCatalog.Register(myOperation, new RegisterOptions());
ILongOpObsService proxy = callerChannel.RealmProxy.Services.GetCalleeProxy <ILongOpObsService>();
Assert.Throws(typeof(WampException), () => proxy.LongOp(9, true).ToEnumerable().Count());
}
public async Task ProgressiveCallsCalleeProxyObservable()
{
WampPlayground playground = new WampPlayground();
CallerCallee dualChannel = await playground.GetCallerCalleeDualChannel();
IWampChannel calleeChannel = dualChannel.CalleeChannel;
IWampChannel callerChannel = dualChannel.CallerChannel;
MyOperation myOperation = new MyOperation();
await calleeChannel.RealmProxy.RpcCatalog.Register(myOperation, new RegisterOptions());
ILongOpObsService proxy = callerChannel.RealmProxy.Services.GetCalleeProxy <ILongOpObsService>();
IEnumerable <int> results = proxy.LongOp(9, false).ToEnumerable(); // it will emit one more than asked
CollectionAssert.AreEquivalent(Enumerable.Range(0, 10), results);
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb_name.Text))
{
MyOperation.MessageShow("没有输入内容");
this.tb_name.Focus();
return;
}
string sql = string.Format("UPDATE tt_sellerinfo SET `name` = '{0}' WHERE `sellerid` = '{1}'", tb_name.Text, sellerid);
if (1 == dbo.AddDelUpdate(sql))
{
MyOperation.MessageShow("修改成功！");
}
else
{
MyOperation.MessageShow("修改失败！");
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb1.Text))
{
MyOperation.MessageShow("请输入书主号");
tb1.Focus();
return;
}
string sql = string.Format("SELECT s.sellinfoid AS `图书ID`,b.`name` AS `书名`,b.press AS `出版社`,s.price AS `售价`," +
"s.issold AS `是否已售` FROM tt_sellinfo AS s , tt_bookinfo AS b WHERE s.bookid = b.id AND " +
"s.sellerid = '{0}'", tb1.Text);
DataTable dt = dbo.Selectinfo(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["是否已售"] = ("0" == dt.Rows[i]["是否已售"].ToString()) ? "否" : "是";
}
MyOperation.DebugPrint("导出了书主信息：" + tb1.Text);
ExcelOperation.SendToExcel(dt, string.Format("书主【{0}】交易详情表", tb1.Text));
}
private double getResult(double AnumbleA, double AnumbleB, string Aopt, MyOperation Aoper)
{
Aoper = OperationFactory.createOperate(Aopt);
Aoper.NumberA = AnumbleA;
Aoper.NumberB = AnumbleB;
return Aoper.GetResult(); ;
}