public void InitUpload(int zlmxid)
{
string comm = @"select zlmxid from yf_t_cpkfsjtg where tplx='cyzp'
and zlmxid={0}";
comm = String.Format(comm, zlmxid);
if (dal.ExecuteScalar(comm) == null)
{
comm = @"INSERT INTO yf_t_cpkfsjtg(zlmxid, mc, zdr, zdrq, tplx, yphh, mypic)
select zlmxid ,mc,'{1}',getdate(),'cyzp',yphh,'已上传' from yf_t_cpkfsjtg a
where a.zlmxid='{0}' and a.tplx='sjtg';";
comm = String.Format(comm, zlmxid, "");
dal.ExecuteNonQuery(comm);
}
}
/// <summary>
///
/// </summary>
/// <param name="AccountNo"></param>
/// <returns></returns>
private bool IsLeave(string AccountNo)
{
String sql = String.Format("SELECT 1 FROM cy_t_coffeeStopSign WHERE AccountNo = '{0}'", AccountNo);
//Log.Info(sql);
nrWebClass.LiLanzDAL dal = new LiLanzDAL();
Object rel = dal.ExecuteScalar(sql);
//Log.Info(rel.GetType().ToString());
if (rel == null)
{
return(false);
}
return(true);
}