public productInfo GetInfo(int id)
{
productInfo info = null;
SqlParameter[] param =
{
new SqlParameter("@id", id)
};
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_product_GetById", param);
if (r != null)
{
info = new productInfo();
while (r.Read())
{
info.id = Int32.Parse(r["id"].ToString());
info.ProductTypeId = Int32.Parse(r["ProductTypeId"].ToString());
info.ProductName = r["ProductName"].ToString();
info.name = r["name"].ToString();
info.description = (object)r["description"].ToString();
info.tag = r["tag"].ToString();
info.image = r["image"].ToString();
info.altImage = r["altImage"].ToString();
info.price = Int64.Parse(r["price"].ToString());
}
r.Close();
r.Dispose();
}
return(info);
}
public void ProductInfoTest()
{
var productInfoType = new productInfo
{
is_auto_traded = true,
is_in_hosted_statistics = true,
is_in_live_center_soccer = true,
is_in_live_score = true,
links = new[]
{
new productInfoLink {
name = "info link 1", @ref = "ref 1"
},
new productInfoLink {
name = "info link 2", @ref = "ref 2"
},
new productInfoLink {
name = "info link 3", @ref = "ref 3"
}
},
streaming = new[]
{
new streamingChannel {
id = 1, name = "streaming channel 1"
},
new streamingChannel {
id = 2, name = "streaming channel 2"
},
new streamingChannel {
id = 3, name = "streaming channel 3"
},
new streamingChannel {
id = 4, name = "streaming channel 4"
}
}
};
var productInfoDTO = new ProductInfoDTO(productInfoType);
var productInfo = new ProductInfo(productInfoDTO.IsAutoTraded,
productInfoDTO.IsInHostedStatistics,
productInfoDTO.IsInLiveCenterSoccer,
productInfoDTO.IsInLiveScore,
productInfoDTO.ProductInfoLinks?.Select(s => new ProductInfoLink(s.Reference, s.Name)),
productInfoDTO.StreamingChannels?.Select(s => new StreamingChannel(s.Id, s.Name)));
Assert.IsNotNull(productInfo);
Assert.AreEqual(productInfoType.is_auto_traded, productInfo.IsAutoTraded);
Assert.AreEqual(productInfoType.is_in_hosted_statistics, productInfo.IsInHostedStatistics);
Assert.AreEqual(productInfoType.is_in_live_center_soccer, productInfo.IsInLiveCenterSoccer);
Assert.AreEqual(productInfoType.is_in_live_score, productInfo.IsInLiveScore);
Assert.AreEqual(productInfoType.links.Length, productInfo.Links.Count());
Assert.AreEqual(productInfoType.streaming.Length, productInfo.Channels.Count());
Assert.AreNotEqual(productInfo.Links.ToList()[0].Name, productInfo.Links.ToList()[2].Name);
Assert.AreNotEqual(productInfo.Channels.ToList()[0].Name, productInfo.Channels.ToList()[2].Name);
}
public void ProductInfoTest()
{
var productInfoType = new productInfo
{
is_auto_traded = new productInfoItem(),
is_in_hosted_statistics = new productInfoItem(),
is_in_live_center_soccer = new productInfoItem(),
is_in_live_match_tracker = new productInfoItem(),
is_in_live_score = new productInfoItem(),
links = new[]
{
new productInfoLink {
name = "info link 1", @ref = "ref 1"
},
new productInfoLink {
name = "info link 2", @ref = "ref 2"
},
new productInfoLink {
name = "info link 3", @ref = "ref 3"
}
},
streaming = new[]
{
new streamingChannel {
id = 1, name = "streaming channel 1"
},
new streamingChannel {
id = 2, name = "streaming channel 2"
},
new streamingChannel {
id = 3, name = "streaming channel 3"
},
new streamingChannel {
id = 4, name = "streaming channel 4"
}
}
};
var productInfoDTO = new ProductInfoDTO(productInfoType);
var productInfo = new ProductInfo(productInfoDTO);
Assert.IsNotNull(productInfo);
Assert.AreEqual(productInfoType.is_auto_traded != null, productInfo.IsAutoTraded);
Assert.AreEqual(productInfoType.is_in_hosted_statistics != null, productInfo.IsInHostedStatistics);
Assert.AreEqual(productInfoType.is_in_live_center_soccer != null, productInfo.IsInLiveCenterSoccer);
Assert.AreEqual(productInfoType.is_in_live_match_tracker != null, productInfo.IsInLiveMatchTracker);
Assert.AreEqual(productInfoType.is_in_live_score != null, productInfo.IsInLiveScore);
Assert.AreEqual(productInfoType.links.Length, productInfo.Links.Count());
Assert.AreEqual(productInfoType.streaming.Length, productInfo.Channels.Count());
Assert.AreNotEqual(productInfo.Links.ToList()[0].Name, productInfo.Links.ToList()[2].Name);
Assert.AreNotEqual(productInfo.Channels.ToList()[0].Name, productInfo.Channels.ToList()[2].Name);
}
private void Save()
{
productInfo info;
var nextId = 0;
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && int.Parse(Request.QueryString["id"]) > 0)
{
info = ServiceFactory.GetInstanceProduct().GetInfo(int.Parse(Request.QueryString["id"]));
if (info == null)
{
Response.Redirect("edit-product.aspx", true);
}
nextId = info.id;
}
else
{
info = new productInfo();
nextId = UntilityFunction.nextId("tbl_product");
}
info.ProductTypeId = UntilityFunction.IntegerForNull(DDL_ProductType.SelectedValue);
info.ProductName = DDL_ProductType.SelectedItem.Text;
info.name = TB_Name.Text;
info.description = TB_Description.Text;
info.tag = TB_tag.Text;
if (Upload_Images.HasFile)
{
info.image = UploadImage(nextId);
}
info.altImage = TB_Alt.Text;
info.isHot = CB_Hot.Checked;
info.price = 0;
info.link = Rewrite.GenDetail(info.ProductName, info.ProductTypeId, info.id == 0 ? UntilityFunction.nextId("tbl_product") : info.id, info.name, Rewrite.Product);
if (info.id > 0)
{
ServiceFactory.GetInstanceProduct().Update(info);
MessageBox.Show("Cập nhật thành công");
}
else
{
info.id = nextId;
HD_ID.Value = ServiceFactory.GetInstanceProduct().Add(info).ToString();
MessageBox.Show("Thêm mới thành công");
IsEdit = true;
}
Image1.ImageUrl = info.image != ""
? UntilityFunction.GetPathImage(Config.GetPathProduct, info.id, 200) + info.image
: Config.GetPathNoImage;
}
public int Add(productInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@ProductTypeId", info.ProductTypeId),
new SqlParameter("@ProductName", info.ProductName),
new SqlParameter("@name", info.name),
new SqlParameter("@description", info.description),
new SqlParameter("@tag", info.tag),
new SqlParameter("@image", info.image),
new SqlParameter("@altImage", info.altImage),
new SqlParameter("@price", info.price)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_product_Add", param).ToString()));
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (tbNumber.Text == "")
{
return;
}
pif.RemoveAt(Convert.ToInt32(tbNumber.Text));
for (int i = Convert.ToInt32(tbNumber.Text); i < pif.Count; i++)
{
pif[i] = new productInfo(pif[i].number - 1, pif[i].spmc, pif[i].nums, pif[i].price, pif[i].flag);
}
dgTable.ItemsSource = null;
tbNumber.Text = "";
dgTable.ItemsSource = pif;
}
public int Update(productInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@id", info.id)
, new SqlParameter("@ProductTypeId",info.ProductTypeId),
new SqlParameter("@ProductName", info.ProductName),
new SqlParameter("@name", info.name),
new SqlParameter("@description", info.description),
new SqlParameter("@tag", info.tag),
new SqlParameter("@image", info.image),
new SqlParameter("@altImage", info.altImage),
new SqlParameter("@price", info.price)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_product_Update", param));
}
internal ProductInfoDTO(productInfo productInfo)
{
Contract.Requires(productInfo != null);
IsInLiveScore = productInfo.is_in_live_score != null;
IsInHostedStatistics = productInfo.is_in_hosted_statistics != null;
IsInLiveCenterSoccer = productInfo.is_in_live_center_soccer != null;
IsAutoTraded = productInfo.is_auto_traded != null;
ProductInfoLinks = productInfo.links != null && productInfo.links.Any()
? new ReadOnlyCollection <ProductInfoLinkDTO>(productInfo.links.Select(p => new ProductInfoLinkDTO(p)).ToList())
: null;
StreamingChannels = productInfo.streaming != null && productInfo.streaming.Any()
? new ReadOnlyCollection <StreamingChannelDTO>(productInfo.streaming.Select(s => new StreamingChannelDTO(s)).ToList())
: null;
}
public List <productInfo> GetList(int pageIndex, int pageSize, out int total)
{
List <productInfo> list = null;
var t = 0;
SqlParameter[] param =
{
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@totalrow", DbType.Int32)
{
Direction = ParameterDirection.Output
}
};
SqlCommand comx;
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_product_GetList", param, out comx);
if (r != null)
{
list = new List <productInfo>();
while (r.Read())
{
var info = new productInfo();
info.id = Int32.Parse(r["id"].ToString());
info.ProductTypeId = Int32.Parse(r["ProductTypeId"].ToString());
info.ProductName = r["ProductName"].ToString();
info.name = r["name"].ToString();
info.description = r["description"].ToString();
info.tag = r["tag"].ToString();
info.image = r["image"].ToString();
info.altImage = r["altImage"].ToString();
info.isHot = bool.Parse(r["isHot"].ToString());
info.price = Int64.Parse(r["price"].ToString());
info.link = r["link"].ToString();
list.Add(info);
}
r.Close();
r.Dispose();
t = int.Parse(comx.Parameters[2].Value.ToString());
}
total = t;
return(list);
}
internal ProductInfoDTO(productInfo productInfo)
{
Guard.Argument(productInfo, nameof(productInfo)).NotNull();
IsAutoTraded = productInfo.is_auto_traded != null;
IsInHostedStatistics = productInfo.is_in_hosted_statistics != null;
IsInLiveCenterSoccer = productInfo.is_in_live_center_soccer != null;
IsInLiveMatchTracker = productInfo.is_in_live_match_tracker != null;
IsInLiveScore = productInfo.is_in_live_score != null;
ProductInfoLinks = productInfo.links != null && productInfo.links.Any()
? new ReadOnlyCollection <ProductInfoLinkDTO>(productInfo.links.Select(p => new ProductInfoLinkDTO(p)).ToList())
: null;
StreamingChannels = productInfo.streaming != null && productInfo.streaming.Any()
? new ReadOnlyCollection <StreamingChannelDTO>(productInfo.streaming.Select(s => new StreamingChannelDTO(s)).ToList())
: null;
}
public List <productInfo> GetHotProduct()
{
List <productInfo> list = null;
var r = DataHelper.ExecuteReader(Config.ConnectString, "tuan_product_gethot", null);
if (r != null)
{
list = new List <productInfo>();
while (r.Read())
{
var info = new productInfo();
info.id = int.Parse(r["id"].ToString());
info.name = r["name"].ToString();
info.description = r["description"].ToString();
info.image = r["image"].ToString();
info.altImage = r["altImage"].ToString();
info.link = r["link"].ToString();
list.Add(info);
}
r.Close();
r.Dispose();
}
return(list);
}
/// <summary>
/// 查询检测结果信息，参数可以为空
/// </summary>
/// <param name="isPackData">是否查询一箱的平均结果</param>
/// <returns>查询检测结果信息</returns>
public List <ResultDisplayInfo> GetAnalysisResult(productInfo info, DateTime beginDate, DateTime endDate, bool isPackData = false)
{
try
{
//构建查询语句
TDBableType datatype = isPackData == false ? TDBableType.AnalysisResult : TDBableType.EachPackResult;
string sqlstr = "select * from " + DBTableName[(int)datatype] + " where ID>=1 "; //添加一个ID>=1防止后面的and出现错误
if (((DateTime)beginDate).ToString(Common.SettingData.ShortDateTimeString).Equals(((DateTime)endDate).ToString(Common.SettingData.ShortDateTimeString)))
{
string[] tt = ((DateTime)beginDate).ToString(Common.SettingData.ShortDateTimeString).Split(' ');
sqlstr += " and 时间 >=#" + tt[0] + " 0:0:0#";
sqlstr += " and 时间 <=#" + tt[0] + " 23:59:59#";
}
else
{
sqlstr += " and 时间 >=#" + ((DateTime)beginDate).ToString(Common.SettingData.ShortDateTimeString) + "#";
sqlstr += " and 时间 <=#" + ((DateTime)endDate).ToString(Common.SettingData.ShortDateTimeString) + "#";
}
if (info.custom != "")
{
sqlstr += " and 客户='" + info.custom.Trim() + "'";
}
if (info.grade != "")
{
sqlstr += " and 等级='" + info.grade.Trim() + "'";
}
if (info.worker != "")
{
sqlstr += " and 班组='" + info.worker.Trim() + "'";
}
if (info.place != "")
{
sqlstr += " and 产地='" + info.place.Trim() + "'";
}
if (info.year != "" && info.year != "0")
{
sqlstr += " and 年份=" + info.year.ToString();
}
OleDbCommand myAccessCommand = new OleDbCommand(sqlstr, myAccessConn);
OleDbDataReader myDataReader = myAccessCommand.ExecuteReader();
List <ResultDisplayInfo> analysisList = new List <ResultDisplayInfo>();
while (myDataReader.Read())
{
ResultDisplayInfo data = new ResultDisplayInfo();
data.id = GetData <int>(myDataReader, "ID");
data.time = GetData <DateTime>(myDataReader, "时间");
data.custom = GetData <string>(myDataReader, "客户");
data.grade = GetData <string>(myDataReader, "等级");
data.worker = GetData <string>(myDataReader, "班组");
data.place = GetData <string>(myDataReader, "产地");
data.year = GetData <int>(myDataReader, "年份");
data.output = GetData <int>(myDataReader, "流量");
data.filename = GetData <string>(myDataReader, "光谱名称");
data.values = new double[SettingData.settingData.programParamerter.dbComponentNames.Count];
//读取组分值
for (int i = 0; i < SettingData.settingData.programParamerter.dbComponentNames.Count; i++)
{
data.values[i] = GetData <double>(myDataReader, SettingData.settingData.programParamerter.dbComponentNames[i]);
}
analysisList.Add(data);
}
myDataReader.Close();
for (int i = 0; i < analysisList.Count; i++)
{
for (int j = i; j < analysisList.Count; j++)
{
if (analysisList[i].time > analysisList[j].time)
{
ResultDisplayInfo temp = null;
temp = analysisList[i];
analysisList[i] = analysisList[j];
analysisList[j] = temp;
}
}
}
return(analysisList);
}
catch (Exception ex)
{
ErrorString = ex.Message;
return(null);
}
}
