/// <summary>
/// 提交数据
/// </summary>
/// <param name="wFSteptId"></param>
/// <returns></returns>
private string checkResultSubmit(string FQCCheckId)
{
FQCCheckHelper ipqc = new FQCCheckHelper();
string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["FQCData"])).ToString();
string Describe = Convert.ToString(Request.Form["Describe"]);
string QCResult = Convert.ToString(Request.Form["QCResult"]);
Decimal AcceptQty = Convert.ToDecimal(Request.Form["AcceptQty"]);
Decimal NGQty = Convert.ToDecimal(Request.Form["NGQty"]);
FQCCheckModel model = new FQCCheckModel();
model.Describe = Describe;
model.QCResult = int.Parse(QCResult);
model.FQCCheckId = FQCCheckId;
model.XMLData = XMLData;
model.AcceptQty = AcceptQty;
model.NGQty = NGQty;
string msg = "";
if (ipqc.CheckResultSubmit(model, out msg))
{
return("{\"result\":0,\"msg\":\"" + msg + "\"}");
}
else
{
return("{\"result\":-1,\"msg\":\"数据提交失败:" + msg + "\"}");
}
}
//质检质检结果数据提交
public bool CheckResultSubmit(FQCCheckModel Model, out string returnMsg)
{
try
{
using (SqlConnection conn = DBClass.getSqlConnection())
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 120;
cmd.CommandText = "P_FQCResult_Submit";
cmd.Parameters.AddWithValue("@FQCCheckId", Model.FQCCheckId);
cmd.Parameters.AddWithValue("@Describe", Model.Describe);
cmd.Parameters.AddWithValue("@QCResult", Model.QCResult);
cmd.Parameters.AddWithValue("@XMLData", Model.XMLData);
cmd.Parameters.AddWithValue("@ResourceId", System.Configuration.ConfigurationManager.AppSettings["DefaultResourceId"]);
cmd.Parameters.AddWithValue("@AcceptQty", Model.AcceptQty);
cmd.Parameters.AddWithValue("@NGQty", Model.NGQty);
cmd.Parameters.Add("@Result_Msg", SqlDbType.NVarChar, 300).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 300).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int ret_Value = Convert.ToInt32(cmd.Parameters["@Return"].Value);
returnMsg = (cmd.Parameters["@Result_Msg"].Value).ToString();
cmd.Parameters.Clear();
conn.Close();
if (ret_Value >= 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception EX)
{
throw;
}
}
/// <summary>
/// 保存临时数据
/// </summary>
/// <param name="wFSteptId"></param>
/// <returns></returns>
private string checkResultTempSubmit(string FQCCheckId)
{
FQCCheckHelper ipqc = new FQCCheckHelper();
string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["FQCData"])).ToString();
FQCCheckModel model = new FQCCheckModel();
model.Describe = Describe;
model.FQCCheckId = FQCCheckId;
model.XMLData = XMLData;
string msg = "";
if (ipqc.SaveTempData(model, out msg))
{
return("{\"result\":1,\"msg\":\"" + msg + "\"}");
}
else
{
return("{\"result\":-1,\"msg\":\"保存数据失败:" + msg + "\"}");
}
}
//保存质检临时数据
public bool SaveTempData(FQCCheckModel Model, out string returnMsg)
{
try
{
using (SqlConnection conn = DBClass.getSqlConnection())
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 120;
cmd.CommandText = "P_FQCResult_TempSave";
cmd.Parameters.AddWithValue("@FQCCheckId", Model.FQCCheckId);
cmd.Parameters.AddWithValue("@Describe", Model.Describe);
cmd.Parameters.AddWithValue("@XMLData", Model.XMLData);
cmd.Parameters.Add("@Result_Msg", SqlDbType.NVarChar, 300).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 300).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int ret_Value = Convert.ToInt32(cmd.Parameters["@Return"].Value);
returnMsg = (cmd.Parameters["@Result_Msg"].Value).ToString();
cmd.Parameters.Clear();
conn.Close();
if (ret_Value >= 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
catch
{
throw;
}
}
