public static bool SelectOneFromType(TypeEntity te)
{
try
{
string sql = "select * from Type where guid = '" + te.Guid + "'";
string dbFile = "first";
int temp = 0;
TypeEntity je = new TypeEntity();
using (SQLiteConnection sc1 = new SQLiteConnection(string.Format(SQLiteService.connectionFormat, dbFile)))
{
SQLiteCommand sCom = new SQLiteCommand(sql, sc1);
sc1.Open();
using (SQLiteDataReader dr1 = sCom.ExecuteReader())
{
if (dr1.Read())
{
temp = 1;
}
dr1.Close();
}
sc1.Close();
}
//返回更新成功或者失败的标志
if (temp > 0)
{
return true;
}
return false;
}
catch (Exception ex)
{
throw ex;
}
}
public static TypeViewModel LoadDataAsTypeViewModel(string dbFile, string sql)
{
try
{
TypeViewModel vm = new TypeViewModel();
vm.OcTypeEntities = new ObservableCollection<TypeEntity>();
//System.Windows.MessageBox.Show(string.Format(SQLiteService.connectionFormat, dbFile));
using (SQLiteConnection sc1 = new SQLiteConnection(string.Format(SQLiteService.connectionFormat, dbFile)))
{
SQLiteCommand sCom = new SQLiteCommand(sql, sc1);
sc1.Open();
using (SQLiteDataReader dr1 = sCom.ExecuteReader())
{
while (dr1.Read())
{
//Jewelry je = new Jewelry();
//je.Guid = dr1["guid"].ToString();
//je.Image = helper.Base64ToImage(dr1["image"].ToString());
////je.SaleWho = dr1["buytime"].ToString();
//je.BuyTime = helper.DateToString((DateTime)dr1["buytime"]);
//je.BuyPrice = (double)dr1["buyprice"];
//je.BuyWho = dr1["buywho"].ToString();
//je.GoldPrice = (double)dr1["goldprice"];
//je.Type = dr1["type"].ToString();
//je.Color = dr1["color"].ToString();
//je.Mark = dr1["mark"].ToString();
//je.BuySource = dr1["buySource"].ToString();
//je.OwnWho = dr1["ownwho"].ToString();
//je.State = dr1["state"].ToString();
//je.BorrowTime = helper.DateToString((DateTime)dr1["borrowtime"]);
//je.BorrowWho = dr1["borrowwho"].ToString();
//je.BorrowPirce = (double)dr1["borrowprice"];
//je.BorrowReturnTime = helper.DateToString((DateTime)dr1["borrowreturntime"]);
//je.SaleTime = helper.DateToString((DateTime)dr1["saletime"]);
//je.SaleWho = dr1["salewho"].ToString();
//je.SalePirce = (double)dr1["saleprice"];
//je.SaleState = dr1["salestate"].ToString();
//je.Ohe = LoadHistory(je.Guid);
TypeEntity te = new TypeEntity();
te.Guid = dr1["guid"].ToString();
te.Type = dr1["name"].ToString();
_totalCount = int.Parse(dr1["TotalCount"].ToString());
vm.OcTypeEntities.Add(te);
}
dr1.Close();
}
sc1.Close();
}
return vm;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveType(TypeEntity te, string type)
{
try
{
//定义temp存储影响行数
int temp = 0;
//判断是否是新增，如果是新增的话，选择不同的语句，为了createtime的插入或者不插入
bool isnew = false;
//插入数据库的类别
string insertType = "";
switch (type)
{
case "JeweleyCategoryType":
insertType = GlobalBindingHelper.JewelryType;
break;
case "JeweleyOwnType":
insertType = GlobalBindingHelper.OwnType;
break;
case "JeweleyColorType":
insertType = GlobalBindingHelper.ColorType;
break;
default:
break;
}
//判断数据库中是否存在一条记录
if (!SelectOneFromType(te))
{
isnew = true;
}
string connectString = string.Format(connectionFormat, "first");
string sqlAll, sql;
//判断是编辑false，还是新增true
if (isnew)
{
sqlAll = "insert into Type (name,category,createtime,updatetime,guid) Values('{0}','{1}','{2}','{3}','{4}')";
sql = string.Format(sqlAll, te.Type, insertType, System.DateTime.Now.ToString("s"), System.DateTime.Now.ToString("s"),te.Guid);
}
else
{
sqlAll = "update Type set name = '{0}',updatetime = '{1}' where guid='{2}'";
sql = string.Format(sqlAll, te.Type, System.DateTime.Now.ToString("s"), te.Guid);
}
using (SQLiteConnection sqlcon = new SQLiteConnection(connectString))
{
SQLiteCommand cmd = new SQLiteCommand(sql, sqlcon);
sqlcon.Open();
temp = cmd.ExecuteNonQuery();
sqlcon.Close();
}
//返回更新成功或者失败的标志
if (temp > 0)
{
return true;
}
return false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw ex;
}
}
internal static void CreateNew(object sender, ExecutedRoutedEventArgs e)
{
try
{
//获取参数，如果为空，就返回
Dictionary<string, object> paraDic = e.Parameter as Dictionary<string, object>;
if (paraDic == null)
return;
//定义参数
string type = ""; //新增哪个页面
string pageID = ""; //导航页面
bool isEdit = false; //是否可以编辑，就是是否出现保存和取消按钮
string title = ""; //页面的标题
//获取对应的参数
if (paraDic.ContainsKey("type"))
{
type = (string)paraDic["type"];
}
if (paraDic.ContainsKey("pageID"))
{
pageID = (string)paraDic["pageID"];
}
if (paraDic.ContainsKey("isEdit"))
{
isEdit = (bool)paraDic["isEdit"];
}
if (paraDic.ContainsKey("title"))
{
title = (string)paraDic["title"];
}
switch (type)
{
//珠宝增加
case "GoodsType":
ObservableCollection<Jewelry> main_ic = paraDic["context1"] as ObservableCollection<Jewelry>;
if (main_ic != null)
{
Jewelry _je = new Jewelry(true);
//main_ic.Add(_je);
WinDetail wd1 = new WinDetail(_je, isEdit, title);
wd1.PageFrame.Navigate(new Uri(Tools.PageTool(pageID), UriKind.RelativeOrAbsolute));
bool? res = wd1.ShowDialog();
if (res.HasValue && res.Value)
{
}
CommonReflashData((FrameworkElement)paraDic["context2"]);
}
break;
//珠宝类别增加
case "JeweleyCategoryType":
//珠宝归属人增加
case "JeweleyOwnType":
//珠宝颜色增加
case "JeweleyColorType":
//上面三个类别都用同一个操作
ObservableCollection<TypeEntity> ObTE = paraDic["context1"] as ObservableCollection<TypeEntity>;
if (ObTE != null)
{
TypeEntity _te = new TypeEntity(true);
//main_ic.Add(_je);
WinDetail2 wd1 = new WinDetail2(_te, isEdit, title);
wd1.PageFrame.Navigate(new Uri(Tools.PageTool(pageID), UriKind.RelativeOrAbsolute));
bool? res = wd1.ShowDialog();
if (res.HasValue && res.Value)
{
}
CommonReflashData((FrameworkElement)paraDic["context2"]);
}
break;
case "":
break;
default:
break;
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
//记录日志，暂未添加
}
finally
{
}
}