private void UpData(String boxGUID, QRBean boxBean)
{
DBOperation dBOperation = new DBOperation();
try
{
if (tbBoxID.Text == "")
{
throw new Exception("请先选择未上传的箱子的ID");
}
DataSet dataSet = dBOperation.GetUploadCase(boxGUID);
UploadData uploadData = new UploadData();
uploadData.tempDelId = BaseData.TempId;
uploadData.parentCode = boxBean;
foreach (DataRow Row in dataSet.Tables[0].Rows)
{
uploadData.childCodes.Add(QRanalyze.QRDecod(Row["FCapData"].ToString()));
}
String result = HttpRequest.UploadCapData(uploadData, Session.Id);
RelationResult Result = JsonConvert.DeserializeObject <RelationResult>(result);
if (Result.success)
{
dBOperation.UploadBoxTStatus(boxGUID);
tbBoxID.Text = "";
tbBoxTag.Text = "";
boxGUID = "";
dgBox.DataSource = dBOperation.QueryNoUplaodBox().Tables[0];
dgBox.Columns["ID"].HeaderText = "未上传箱号ID";
dgBox.Columns["ID"].Width = 300;
dgBox.Columns["FGuid"].HeaderText = "GUID编码";
dgBox.Columns["FGuid"].Width = 300;
}
else
{
throw new Exception(Result.message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally {
dBOperation.Dispose();
}
}
/// <summary>
/// 验证上级码值是否符合关联
/// </summary>
/// <param name="tempDelId"></param>
/// <param name="cookId"></param>
/// <returns></returns>
public static String ConfirmSuperCodeRelation(QRBean bean, String cookId)
{
try
{
string serviceAddress = baseUri + "/a/erp/related/manual/validate/parent";
serviceAddress += String.Format("?vid={0}&cid={1}&tid={2}&pid={3}", bean.vid, bean.cid, bean.tid, bean.pid);;
return(GetRequst(serviceAddress, cookId));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取关联模板集合
/// </summary>
/// <param name="bean"></param>
/// <param name="cookId"></param>
/// <returns></returns>
public static String GetTemplates(QRBean bean, String cookId)
{
try
{
string serviceAddress = baseUri + "/a/unit/template/unitTemp/vctp";
serviceAddress += String.Format("?vid={0}&cid={1}&tid={2}&pid={3}", bean.vid, bean.cid, bean.tid, bean.pid);
return(GetRequst(serviceAddress, cookId));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 上传一个箱号
/// </summary>
/// <param name="boxId">箱号</param>
/// <returns></returns>
public static String UpDataOne(String BoxNum)
{
QRBean BoxNumber = QRanalyze.QRDecod(BoxNum.Substring(BoxNum.Length - 35, 35));
OleDbConnection connection = GetConnectionOne(AccessDbHelp.GetConnectString());
OleDbTransaction transaction = connection.BeginTransaction();
try
{
//找出最小未装箱的最小箱号
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connection;
cmd.Transaction = transaction;
String sqlBox = String.Format("SELECT FGuid from BOX where ID = (select min(ID) from BOX Where FStatus = '{0}')", BoxStatusNoUp);
cmd.CommandText = sqlBox;
Object boxGuid = cmd.ExecuteScalar();
String BoxGuid;
if (boxGuid == null)
{
throw new Exception("没有可以使用箱");
}
else
{
BoxGuid = boxGuid.ToString();
}
//生成装箱上传数据
DataSet dataSet = new DataSet();
String sql_box = String.Format("select [FCapData] from [Case] where [FBoxId] = '{0}'", BoxGuid);
OleDbDataAdapter da = new OleDbDataAdapter(sql_box, connection);
da.SelectCommand.Transaction = transaction;
da.Fill(dataSet);
UploadData uploadData = new UploadData();
uploadData.tempDelId = BaseData.TempId;
uploadData.parentCode = BoxNumber;
foreach (DataRow Row in dataSet.Tables[0].Rows)
{
String msg = Row["FCapData"].ToString();
uploadData.childCodes.Add(QRanalyze.QRDecod(msg.Substring(msg.Length - 35, 35)));
}
RelationResult result = JsonConvert.DeserializeObject <RelationResult>(HttpRequest.UploadCapData(uploadData, Session.Id));
//RelationResult result = new RelationResult();
//result.success = true;
if (result.success)
{
String sqlUp = String.Format("Update [Box] set [FStatus] = '{0}',[FBoxNumber] = '{1}' where [FGuid] = '{2}'", BoxStatusHaveUp, BoxNum, BoxGuid);
cmd.CommandText = sqlUp;
cmd.ExecuteNonQuery();
}
else
{
throw new Exception(result.message);
}
transaction.Commit();
return(BoxGuid);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
