public bool CheckResultSubmit(IPQCRountCheckModel 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_IPQCRountResult_Submit";
cmd.Parameters.AddWithValue("@IPQCRouteCheckId", Model.IPQCRouteCheckId);
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.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 IPQCRountCheckId)
{
IPQCRouteCheckHelper ipqc = new IPQCRouteCheckHelper();
string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["IPQCData"])).ToString();
IPQCRountCheckModel model = new IPQCRountCheckModel();
model.Describe = Describe;
model.XMLData = XMLData;
model.IPQCRouteCheckId = IPQCRountCheckId;
string msg = "";
if (ipqc.SaveTempData(model, out msg))
{
return("{\"result\":1,\"msg\":\"" + msg + "\"}");
}
else
{
return("{\"result\":-1,\"msg\":\"保存数据失败:" + msg + "\"}");
}
}
public bool SaveTempData(IPQCRountCheckModel 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_IPQCRountResult_TempSave";
cmd.Parameters.AddWithValue("@IPQCRouteCheckId", Model.IPQCRouteCheckId);
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;
}
}
/// <summary>
/// 提交数据
/// </summary>
/// <param name="wFSteptId"></param>
/// <returns></returns>
private string checkResultSubmit(string IPQCRountCheckId)
{
IPQCRouteCheckHelper ipqc = new IPQCRouteCheckHelper();
string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["IPQCData"])).ToString();
string Describe = Convert.ToString(Request.Form["Describe"]);
string QCResult = Convert.ToString(Request.Form["QCResult"]);
IPQCRountCheckModel model = new IPQCRountCheckModel();
model.Describe = Describe;
model.QCResult = int.Parse(QCResult);
model.XMLData = XMLData;
model.IPQCRouteCheckId = IPQCRountCheckId;
string msg = "";
if (ipqc.CheckResultSubmit(model, out msg))
{
return("{\"result\":0,\"msg\":\"" + msg + "\"}");
}
else
{
return("{\"result\":-1,\"msg\":\"数据提交失败:" + msg + "\"}");
}
}
