internal async Task <JsonResult> IQCComplete(IQC iQC)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("iqc_complete", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.AddWithValue("@grn_no", iQC.GRNHeaderNo);
smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string json = smd.Parameters["@jsonOutput"].Value.ToString();
smd.Dispose();
JArray arr = JArray.Parse(json);
return(new JsonResult(arr));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
internal async Task <int> IQCBinScan(IQC binscan)
{
SqlConnection cn = null;
try
{
DataTable dt = new DataTable();
cn = Connection.GetConnection();
SqlCommand da = new SqlCommand("SELECT count(1) FROM [dbo].[bin_mst] bm WHERE [bm].[bincode] = '" + binscan.Bincode + "' AND [bm].[location] = " + binscan.LocationId + " AND [bm].[bin_type] = 'REJECT'", cn);
//da.Parameters.Add("@bincode", SqlDbType.NVarChar,50);
//da.Parameters["@bincode"].Value = binscan.Bincode;
//da.Parameters.Add("@location_id", SqlDbType.Int);
//da.Parameters["@location_id"].Value = binscan.LocationId;
object count = await da.ExecuteScalarAsync().ConfigureAwait(false);
return(Convert.ToInt16(count.ToString()));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public async Task <JsonResult> IQCDeleteLine([FromBody] IQC delete)
{
try
{
return(await _iQCLogic.IQCDeleteLine(delete).ConfigureAwait(false));
}
catch (Exception ee)
{
return(await _iQCLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
public async Task <JsonResult> IQCScanBarcode([FromBody] IQC iQC)
{
try
{
return(await _iQCLogic.IQCScanBarcode(iQC).ConfigureAwait(false));
}
catch (Exception ee)
{
return(await _iQCLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
public async Task <JsonResult> GRNScannedBarcodeInfo([FromBody] IQC grn_no)
{
try
{
return(await _iQCLogic.GRNScannedBarcodeInfo(grn_no).ConfigureAwait(false));
}
catch (Exception ee)
{
return(await _iQCLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
internal async Task <JsonResult> IQCDeleteLine(IQC delete)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("iqc_line_delete", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.AddWithValue("@grn_line_no", delete.GRNLineNo);
smd.Parameters.AddWithValue("@grn_no", delete.GRNHeaderNo);
smd.Parameters.AddWithValue("@rejection_reason", delete.RejectionReason);
smd.Parameters.AddWithValue("@barcode", delete.Barcode);
smd.Parameters.AddWithValue("@bincode", delete.Bincode);
smd.Parameters.AddWithValue("@quantity", delete.Quantity);
smd.Parameters.AddWithValue("@vendor_lot_no", delete.VendorLotNo);
smd.Parameters.AddWithValue("@expire_date", delete.ExpireDate);
smd.Parameters.Add("@iqcheaderOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.Add("@iqc_lines", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string iqcheader = smd.Parameters["@iqcheaderOutput"].Value.ToString();
string iqc_lines = smd.Parameters["@iqc_lines"].Value.ToString();
smd.Dispose();
List <IQCResponse> response = new List <IQCResponse>();
IQCResponse data = new IQCResponse()
{
Header = JArray.Parse(iqcheader),
Lines = JArray.Parse(iqc_lines)
};
response.Add(data);
return(new JsonResult(response));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public async Task <JsonResult> IQCBinScan([FromBody] IQC binscan)
{
try
{
int count = await _iQCLogic.IQCBinScan(binscan).ConfigureAwait(false);
if (count > 0)
{
return(await _iQCLogic.SendRespose("True", "Bin found in reject").ConfigureAwait(false));
}
else
{
return(await _iQCLogic.SendRespose("False", binscan.Bincode + " Not found in reject bintype").ConfigureAwait(false));
}
}
catch (Exception ee)
{
return(await _iQCLogic.SendRespose("False", ee.Message).ConfigureAwait(false));
}
}
private void btnOK_Click(object sender, EventArgs e)
{
int i = 0;
if (!int.TryParse(txtqty.Text.Trim(), out i))
{
return;
}
if (int.Parse(txtqty.Text.Trim()) <= int.Parse(txtenableqty.Text))
{
IQC ic = new IQC();
//string barcodemsg = ic.AddOQCTestRecord("checkagain", "", "", "", "", txtorg_id.SelectedValue.ToString(), this.txtlotno.Text, "", "", txtqty.Text
// , "", "", "", "", txtreason.Text, Login.username, "", "", "", checktype, "", "", "", "");
string barcodemsg = AddOQCTestRecord("checkagain", "", "", "", "", "", ""
, this.txtlotno.Text, "", txtqty.Text, txtorg_id.SelectedValue.ToString(), "", "", "", ""
, "", "", "", "", "", "", "", "", ""
, "", "", "", "", "", checktype, "", txtreason.Text
, "", Login.username, "", "");
if (barcodemsg.IndexOf("成功") >= 0)
{
lblinfo.ForeColor = Color.Blue;
lblinfo.Text = barcodemsg;
clearform();
}
else
{
lblinfo.Text = barcodemsg;
lblinfo.ForeColor = Color.Red;
}
}
else
{
lblinfo.ForeColor = Color.Red;
lblinfo.Text = "超过了最大可改判数量:" + this.txtenableqty.Text;
return;
}
}
internal async Task <JsonResult> IQCData(IQC grn_no)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("iqc_start_info_by_grn_no", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.AddWithValue("@grn_no", grn_no.GRNHeaderNo);
smd.Parameters.Add("@iqcheaderOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.Add("@iqc_lines", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
string iqcheader = smd.Parameters["@iqcheaderOutput"].Value.ToString();
string iqc_lines = smd.Parameters["@iqc_lines"].Value.ToString();
smd.Dispose();
List <IQCResponse> response = new List <IQCResponse>();
IQCResponse data = new IQCResponse()
{
Header = JArray.Parse(iqcheader),
Lines = JArray.Parse(iqc_lines)
};
response.Add(data);
return(new JsonResult(response));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
