public JZJSseconds Get_JzjsDataSeconds(string clhp, DateTime jcsj)
{
DateTime a;
string sql = "select * from JZJS_DATASECONDS where clhp=@clhp and convert(varchar(50),jcsj,120)=convert(varchar(50),@jcsj,120)";
SqlParameter[] spr =
{
new SqlParameter("@clhp", clhp),
new SqlParameter("@jcsj", jcsj.ToString("yyyy-MM-dd HH:mm:ss"))
};
try
{
JZJSseconds asm = new JZJSseconds();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
asm.CLID = dt.Rows[0]["CLID"].ToString();//1
asm.CLHP = dt.Rows[0]["CLHP"].ToString();
asm.JCSJ = DateTime.Parse(dt.Rows[0]["JCSJ"].ToString());
asm.MMTIME = dt.Rows[0]["MMTIME"].ToString();
asm.MMSX = dt.Rows[0]["MMSX"].ToString();
asm.MMLB = dt.Rows[0]["MMLB"].ToString();
asm.MMCS = dt.Rows[0]["MMCS"].ToString();//6
asm.MMGL = dt.Rows[0]["MMGL"].ToString();
asm.MMK = dt.Rows[0]["MMK"].ToString();
asm.MMZS = dt.Rows[0]["MMZS"].ToString();
asm.MMNO = dt.Columns.Contains("MMNO")? dt.Rows[0]["MMNO"].ToString():"";
}
else
{
asm.CLID = "-2";
}
return(asm);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>ASM检测数据Model</returns>
public JZJSseconds Get_JzjsDataSeconds(string CLID)
{
DateTime a;
string sql = "select * from JZJS_DATASECONDS where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
JZJSseconds asm = new JZJSseconds();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
asm.CLID = dt.Rows[0]["CLID"].ToString();//1
asm.CLHP = dt.Rows[0]["CLHP"].ToString();
asm.JCSJ = DateTime.Parse(dt.Rows[0]["JCSJ"].ToString());
asm.MMTIME = dt.Rows[0]["MMTIME"].ToString();
asm.MMSX = dt.Rows[0]["MMSX"].ToString();
asm.MMLB = dt.Rows[0]["MMLB"].ToString();
asm.MMCS = dt.Rows[0]["MMCS"].ToString();//6
asm.MMGL = dt.Rows[0]["MMGL"].ToString();
asm.MMK = dt.Rows[0]["MMK"].ToString();
asm.MMNO = dt.Columns.Contains("MMNO") ? dt.Rows[0]["MMNO"].ToString() : "";
}
else
{
asm.CLID = "-2";
}
return(asm);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用JZJS插入逐秒数据
/// </summary>
/// <param name="JZJS">JZJS</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_JZJSseconds(JZJSseconds jzjs)
{
string sqli = "insert into JZJS_DATASECONDS(JYLSH,JYCS,CYDS,MMZS,MMZGL,MMZSGL,MMGLXZXS,MMJSGL,MMBTGD,MMDQYL,MMXDSD,MMHJWD,MMNL,CLID,CLHP,JCSJ,MMTIME,MMSX,MMLB,MMCS,MMGL,MMK,MMYW,MMNO) values(@JYLSH,@JYCS,@CYDS,@MMZS,@MMZGL,@MMZSGL,@MMGLXZXS,@MMJSGL,@MMBTGD,@MMDQYL,@MMXDSD,@MMHJWD,@MMNL,@CLID,@CLHP,@JCSJ,@MMTIME,@MMSX,@MMLB,@MMCS,@MMGL,@MMK,@MMYW,@MMNO)";
string sqlu = "update JZJS_DATASECONDS set JYLSH=@JYLSH,JYCS=@JYCS,CYDS=@CYDS,MMZS=@MMZS,MMZGL=@MMZGL,MMZSGL=@MMZSGL,MMGLXZXS=@MMGLXZXS,MMJSGL=@MMJSGL,MMBTGD=@MMBTGD,MMDQYL=@MMDQYL,MMXDSD=@MMXDSD,MMHJWD=@MMHJWD,MMNL=@MMNL,CLHP=@CLHP,JCSJ=@JCSJ,MMTIME=@MMTIME,MMSX=@MMSX,MMLB=@MMLB,MMCS=@MMCS,MMGL=@MMGL,MMK=@MMK,MMYW=@MMYW,MMNO=@MMNO where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@JYLSH", jzjs.JYLSH), //1
new SqlParameter("@JYCS", jzjs.JYCS), //1
new SqlParameter("@CYDS", jzjs.CYDS), //1
new SqlParameter("@MMZS", jzjs.MMZS), //1
new SqlParameter("@MMZGL", jzjs.MMZGL), //1
new SqlParameter("@MMZSGL", jzjs.MMZSGL), //1
new SqlParameter("@MMGLXZXS", jzjs.MMGLXZXS), //1
new SqlParameter("@MMJSGL", jzjs.MMJSGL), //1
new SqlParameter("@MMBTGD", jzjs.MMBTGD), //1
new SqlParameter("@MMDQYL", jzjs.MMDQYL), //1
new SqlParameter("@MMXDSD", jzjs.MMXDSD), //1
new SqlParameter("@MMHJWD", jzjs.MMHJWD), //1
new SqlParameter("@MMNL", jzjs.MMNL), //1
new SqlParameter("@CLID", jzjs.CLID), //1
new SqlParameter("@CLHP", jzjs.CLHP),
new SqlParameter("@JCSJ", jzjs.JCSJ),
new SqlParameter("@MMTIME", jzjs.MMTIME),
new SqlParameter("@MMSX", jzjs.MMSX),
new SqlParameter("@MMLB", jzjs.MMLB), //6
new SqlParameter("@MMCS", jzjs.MMCS),
new SqlParameter("@MMGL", jzjs.MMGL),
new SqlParameter("@MMK", jzjs.MMK),
new SqlParameter("@MMYW", jzjs.MMYW),
new SqlParameter("@MMNO", jzjs.MMNO)
//47
};
try
{
if (Have_JZJSseconds(jzjs.CLID))
{
if (DBHelperSQL.Execute(sqlu, spr) > 0)
{
return(2);
}
else
{
return(0);
}
}
else
{
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
return(1);
}
else
{
return(0);
}
}
}
catch (Exception)
{
throw;
return(0);
}
}
