public void New(Model.Entity.DealerDevice obj)
{
const string sqlCommond = "Insert into DealerDevice (DealerId,DeviceId,StockTime,Purchaser,SalesTime,ReworkTime,Status,Remark,CreateTime,UpdateTime) values (@DealerId,@DeviceId,@StockTime,@Purchaser,@SalesTime,@ReworkTime,@Status,@Remark,@CreateTime,@UpdateTime)";
var dp = new DbParameter[]
{
Data.DBHelper.CreateInDbParameter("@DealerId", DbType.Int32, obj.DealerId),
Data.DBHelper.CreateInDbParameter("@DeviceID", DbType.Int32, obj.DeviceId),
Data.DBHelper.CreateInDbParameter("@StockTime", DbType.DateTime, GetItemValue(obj.StockTime)),
Data.DBHelper.CreateInDbParameter("@Purchaser", DbType.Int32, GetItemValue(obj.Purchaser)),
Data.DBHelper.CreateInDbParameter("@SalesTime", DbType.DateTime, GetItemValue(obj.SalesTime)),
Data.DBHelper.CreateInDbParameter("@ReworkTime", DbType.DateTime, GetItemValue(obj.ReworkTime)),
Data.DBHelper.CreateInDbParameter("@Status", DbType.Int32, obj.Status),
Data.DBHelper.CreateInDbParameter("@Remark", DbType.String, GetItemValue(obj.Remark)),
Data.DBHelper.CreateInDbParameter("@CreateTime", DbType.DateTime, obj.CreateTime),
Data.DBHelper.CreateInDbParameter("@UpdateTime", DbType.DateTime, obj.UpdateTime)
};
Data.DBHelper.GetInstance().ExecuteNonQuery(sqlCommond, dp);
lock (this)
{
Dictionary <int, Model.Entity.DealerDevice> dictDevice;
if (!_dictionaryByDealer.TryGetValue(obj.DealerId, out dictDevice))
{
dictDevice = new Dictionary <int, Model.Entity.DealerDevice>();
_dictionaryByDealer.Add(obj.DealerId, dictDevice);
}
dictDevice.Add(obj.DeviceId, obj);
}
}
public DealerDevice()
: base(typeof(Model.Entity.DealerDevice))
{
_dictionaryByDealer = new Dictionary <int, Dictionary <int, Model.Entity.DealerDevice> >();
const string sqlCommond = "select * from DealerDevice";
var ds = Data.DBHelper.GetInstance().ExecuteAdapter(sqlCommond);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
var item = new Model.Entity.DealerDevice();
item.DealerId = (int)row["DealerId"];
item.DeviceId = (int)row["DeviceId"];
item.CreateTime = (DateTime)row["CreateTime"];
if (row["Purchaser"] != DBNull.Value)
{
item.Purchaser = (int)row["Purchaser"];
}
item.Status = (int)row["Status"];
if (row["Remark"] != DBNull.Value)
{
item.Remark = (string)row["Remark"];
}
if (row["ReworkTime"] != DBNull.Value)
{
item.ReworkTime = (DateTime)row["ReworkTime"];
}
if (row["SalesTime"] != DBNull.Value)
{
item.SalesTime = (DateTime)row["SalesTime"];
}
if (row["StockTime"] != DBNull.Value)
{
item.StockTime = (DateTime)row["StockTime"];
}
item.UpdateTime = (DateTime)row["UpdateTime"];
Dictionary <int, Model.Entity.DealerDevice> dictDevice;
if (!_dictionaryByDealer.TryGetValue(item.DealerId, out dictDevice))
{
dictDevice = new Dictionary <int, Model.Entity.DealerDevice>();
_dictionaryByDealer.Add(item.DealerId, dictDevice);
}
dictDevice.Add(item.DeviceId, item);
}
}
}
public void Update(Model.Entity.DealerDevice obj)
{
Dictionary <int, Model.Entity.DealerDevice> dictDevice;
if (
_dictionaryByDealer.TryGetValue(obj.DealerId, out dictDevice))
{
Model.Entity.DealerDevice item;
if (dictDevice.TryGetValue(obj.DeviceId, out item))
{
item.UpdateTime = DateTime.Now;
const string sqlCommond =
"Update DealerDevice set StockTime=@StockTime,Purchaser=@Purchaser,SalesTime=@SalesTime,ReworkTime=@ReworkTime,Status=@Status,Remark=@Remark,UpdateTime=getdate() where DealerId=@DealerId and DeviceId=@DeviceId";
var dp = new DbParameter[]
{
Data.DBHelper.CreateInDbParameter("@DealerId", DbType.Int32, obj.DealerId),
Data.DBHelper.CreateInDbParameter("@DeviceID", DbType.Int32, obj.DeviceId),
Data.DBHelper.CreateInDbParameter("@StockTime", DbType.DateTime, GetItemValue(obj.StockTime)),
Data.DBHelper.CreateInDbParameter("@Purchaser", DbType.Int32, GetItemValue(obj.Purchaser)),
Data.DBHelper.CreateInDbParameter("@SalesTime", DbType.DateTime, GetItemValue(obj.SalesTime)),
Data.DBHelper.CreateInDbParameter("@ReworkTime", DbType.DateTime, GetItemValue(obj.ReworkTime)),
Data.DBHelper.CreateInDbParameter("@Status", DbType.Int32, obj.Status),
Data.DBHelper.CreateInDbParameter("@Remark", DbType.String, GetItemValue(obj.Remark))
};
Data.DBHelper.GetInstance().ExecuteNonQuery(sqlCommond, dp);
if (obj != item)
{
item.StockTime = obj.StockTime;
item.Purchaser = obj.Purchaser;
item.SalesTime = obj.SalesTime;
item.ReworkTime = obj.ReworkTime;
item.Status = obj.Status;
item.Remark = obj.Remark;
}
}
}
}