private void SetModelToUI(clothing dto)
{
button4.Enabled = false;
dateTimePicker1.Value = dto.Filled;
listBox1.Items.Clear();
foreach (var e in dto.Goods)
{
listBox1.Items.Add(e);
}
numericUpDown1.Value = dto.Price;
}
public string GetBarCode(string tag)
{
string text = "<?xml version=\"1.0\" encoding=\"gb2312\"?><FeedBack>";
string cmdText = string.Format("select a.ypmc,a.yphh,ROUND(yfcbdj,2) as yfcbdj,a.mlcf,isnull(a.tydddj,0) tydddj,lsdj,cjyphh,bjid,a.bq, xl.mc xlmc, a.bhksid, a.bhks from yx_t_ypdmb as a left join yf_T_kfbh AS kf on a.kfbh=kf.dm and a.tzid=kf.tzid left join t_xtdm AS xl on a.fg=xl.dm and xl.ssid=401 and xl.tzid=1 WHERE a.bq='{0}' OR a.yphh ='{0}' ", tag);
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = "server='192.168.35.10';uid=ABEASD14AD;pwd=+AuDkDew;database=tlsoft";
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
sqlConnection.Open();
using (SqlCommand sqlCommand = new SqlCommand(cmdText, sqlConnection))
{
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
string bjid = sqlDataReader[7].ToString();
clothing clothing = this.getClothing(bjid);
string bx = this.getBx(sqlDataReader["bhksid"].ToString());
if (bx == "")
{
bx = this.getBx(sqlDataReader["bhks"].ToString());
}
text += string.Format("<tag ypmc=\"{0}\" yphh=\"{1}\" yfcbdj=\"{2}\" mlcf=\"{3}\" tydddj=\"{4}\" lsdj=\"{5}\" tagCode=\"{6}\" nd=\"{7}\" ml=\"{8}\" cjyphh=\"{9}\" xlmc=\"{10}\" bx=\"{11}\" />", new object[]
{
sqlDataReader["ypmc"],
sqlDataReader["yphh"],
sqlDataReader["yfcbdj"],
sqlDataReader["mlcf"],
sqlDataReader["tydddj"],
sqlDataReader["lsdj"],
sqlDataReader["bq"],
clothing.nd,
clothing.ml,
sqlDataReader["cjyphh"],
sqlDataReader["xlmc"],
bx
});
}
sqlConnection.Close();
}
text += "</FeedBack>";
return(text);
}
