/// <summary>
/// 修改一条快检单号
/// </summary>
/// <returns></returns>
public static int Update()
{
int rtn = 0;
if (Wisdom.GETSAMPLE_RESPONSE != null)
{
getsample.Response model = Wisdom.GETSAMPLE_RESPONSE;
try
{
_strB.Append("UPDATE TB_SAMPLE SET ");
_strB.AppendFormat("SAMPDATE='{0}',SAMPCOMPANY='{1}',SAMPPERSON='{2}',",
model.sampleDate, model.sampleDept, model.sampPerson);
_strB.AppendFormat("FOODNAME='{0}',BARCODE='{1}',BSAMPCOMPANY='{2}',BSCOMPADDR='{3}',BSCOMPPHON='{4}',BSCOMPCONT='{5}' Where SAMPLENUM='{6}'",
model.productName, model.barCode, model.bsampCompany, model.bscompAddr, model.bscompPhon, model.bscompCont, Wisdom.DeviceID, model.sampleid);
DataBase.ExecuteCommand(_strB.ToString());
rtn = 1;
}
catch (Exception ex)
{
throw ex;
}
}
return(rtn);
}
/// <summary>
/// 根据快检单号检索云平台是否有数据
/// </summary>
private void SearchCloud()
{
try
{
Wisdom.GETSAMPLE_REQUEST = new getsample.Request()
{
deviceid = Wisdom.DeviceID,
sampleid = tb_SAMPLENUM.Text.Trim()
};
string json = Wisdom.HttpPostRequest(Wisdom.GETSAMPLE);
JavaScriptSerializer js = new JavaScriptSerializer();
getsample.Response model = js.Deserialize <getsample.Response>(json);
if (model.result.Equals("0"))
{
model.sampleid = sampleId;
Wisdom.GETSAMPLE_RESPONSE = model;
Insert();
}
else
{
MessageBox.Show("未在云平台上检索到该快检单号！\r\n请确保平台已录入，或核对快检单号是否填写正确！", "操作提示", MessageBoxButton.YesNo, MessageBoxImage.Question);
//if (MessageBox.Show("未在云平台上检索到该快检单号，是否手动添加快检单号?", "操作提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
//{
// AddSampleid();
//}
}
}
catch (Exception ex)
{
throw ex;
}
finally { Lb_SearchInfo.Visibility = Visibility.Collapsed; }
}
/// <summary>
/// 新增一条快检单号
/// </summary>
/// <returns></returns>
public static int Insert()
{
int rtn = 0;
if (Wisdom.GETSAMPLE_RESPONSE != null)
{
getsample.Response model = Wisdom.GETSAMPLE_RESPONSE;
try
{
_strB.Length = 0;
_strB.Append("INSERT INTO TB_SAMPLE ");
_strB.Append("(SAMPLENUM,SAMPDATE,SAMPCOMPANY,SCOMPADDR,SCOMPCONT,SCOMPPHON,SAMPPERSON, ");
_strB.Append("FOODNAME,BARCODE,BSAMPCOMPANY,BSCOMPADDR,BSCOMPPHON,BSCOMPCONT,BRAND,PRODATE,MODEL, ");
_strB.Append("BATCHNUM,SHELFLIFE,PROCOMPANY,PROCOMPADDR,PROCOMPPHON,DEVICEID) VALUES(");
_strB.AppendFormat("'{0}',", model.sampleid);
_strB.AppendFormat("'{0}',", model.sampleDate);
_strB.AppendFormat("'{0}',", model.sampleDept);
_strB.AppendFormat("'{0}',", model.scompAddr);
_strB.AppendFormat("'{0}',", model.scompCont);
_strB.AppendFormat("'{0}',", model.scompPhon);
_strB.AppendFormat("'{0}',", model.sampPerson);
_strB.AppendFormat("'{0}',", model.productName);
_strB.AppendFormat("'{0}',", model.barCode);
_strB.AppendFormat("'{0}',", model.bsampCompany);
_strB.AppendFormat("'{0}',", model.bscompAddr);
_strB.AppendFormat("'{0}',", model.bscompPhon);
_strB.AppendFormat("'{0}',", model.bscompCont);
_strB.AppendFormat("'{0}',", model.brand);
_strB.AppendFormat("'{0}',", model.prodate);
_strB.AppendFormat("'{0}',", model.model);
_strB.AppendFormat("'{0}',", model.batchNum);
_strB.AppendFormat("'{0}',", model.shelfLife);
_strB.AppendFormat("'{0}',", model.proCompany);
_strB.AppendFormat("'{0}',", model.procompAddr);
_strB.AppendFormat("'{0}',", model.procompPhon);
_strB.AppendFormat("'{0}')", Wisdom.DeviceID);
DataBase.ExecuteCommand(_strB.ToString());
rtn = 1;
}
catch (Exception ex)
{
throw ex;
}
}
return(rtn);
}
/// <summary>
/// 根据快检单号检索云平台是否有数据 有数据返回true，没有则返回false
/// </summary>
private Boolean SearchCloud()
{
try
{
Wisdom.GETSAMPLE_REQUEST = new DYSeriesDataSet.getsample.Request()
{
deviceid = Wisdom.DeviceID,
sampleid = tb_sampleid.Text.Trim()
};
String json = Wisdom.HttpPostRequest(Wisdom.GETSAMPLE);
JavaScriptSerializer js = new JavaScriptSerializer();
getsample.Response model = js.Deserialize <getsample.Response>(json);
if (model.result.Equals("0"))
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
