private Model.Entity.Count Get()
{
lock (LockHelper)
{
DateTime date = DateTime.Now.Date;
String dateStr = date.ToString(FMT);
if (_dictionary.ContainsKey(dateStr))
{
return(_dictionary[dateStr]);
}
else
{
var item = new Model.Entity.Count {
Date = date
};
const string insertSql = "Insert into Count (Date,Address,LbsAndWifi,LbsAndWifiCache,LbsAndWifiFail,AddressTotal,LbsAndWifiTotal,SMS) values (@Date,0,0,0,0,0,0,0)";
DbParameter[] insertDp = new DbParameter[]
{
Data.DBHelper.CreateInDbParameter("@Date", DbType.DateTime, date)
};
Data.DBHelper.GetInstance().ExecuteNonQuery(insertSql, insertDp);
_dictionary.Add(dateStr, item);
return(item);
}
}
}
public Count()
{
_dictionary = new Dictionary <String, Model.Entity.Count>();
const string getSql = "select * from Count";
DataSet ds = Data.DBHelper.GetInstance().ExecuteAdapter(getSql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
var item = new Model.Entity.Count {
Date = (DateTime)dr["Date"]
};
if (dr["Address"] != DBNull.Value)
{
item.Address = (int)dr["Address"];
}
if (dr["LbsAndWifi"] != DBNull.Value)
{
item.LbsAndWifi = (int)dr["LbsAndWifi"];
}
if (dr["LbsAndWifiCache"] != DBNull.Value)
{
item.LbsAndWifiCache = (int)dr["LbsAndWifiCache"];
}
if (dr["LbsAndWifiFail"] != DBNull.Value)
{
item.LbsAndWifiFail = (int)dr["LbsAndWifiFail"];
}
if (dr["AddressTotal"] != DBNull.Value)
{
item.AddressTotal = (int)dr["AddressTotal"];
}
if (dr["LbsAndWifiTotal"] != DBNull.Value)
{
item.LbsAndWifiTotal = (int)dr["LbsAndWifiTotal"];
}
if (dr["SMS"] != DBNull.Value)
{
item.SMS = (int)dr["SMS"];
}
_dictionary.Add(item.Date.ToString(FMT), item);
}
_count = this.Get();
}
public void Save()
{
Model.Entity.Count count = _count;
if (count.Date != DateTime.Now.Date)
{
_count = this.Get();
}
const string insertSql = "Update Count set Address=@Address,LbsAndWifi=@LbsAndWifi,LbsAndWifiCache=@LbsAndWifiCache,LbsAndWifiFail=@LbsAndWifiFail,AddressTotal=@AddressTotal,LbsAndWifiTotal=@LbsAndWifiTotal,SMS=@SMS,UpdateTime=getdate() where Date=@Date";
DbParameter[] insertDp = new DbParameter[]
{
Data.DBHelper.CreateInDbParameter("@Date", DbType.DateTime, count.Date),
Data.DBHelper.CreateInDbParameter("@Address", DbType.Int32, count.Address),
Data.DBHelper.CreateInDbParameter("@LbsAndWifi", DbType.Int32, count.LbsAndWifi),
Data.DBHelper.CreateInDbParameter("@LbsAndWifiCache", DbType.Int32, count.LbsAndWifiCache),
Data.DBHelper.CreateInDbParameter("@LbsAndWifiFail", DbType.Int32, count.LbsAndWifiFail),
Data.DBHelper.CreateInDbParameter("@AddressTotal", DbType.Int32, count.AddressTotal),
Data.DBHelper.CreateInDbParameter("@LbsAndWifiTotal", DbType.Int32, count.LbsAndWifiTotal),
Data.DBHelper.CreateInDbParameter("@SMS", DbType.Int32, count.SMS)
};
Data.DBHelper.GetInstance().ExecuteNonQuery(insertSql, insertDp);
}
