public static string EncryptPwd(String userName, String passWord)
{
string _returnString = string.Empty;
try
{
//修改原数据
string _sql = "SELECT * FROM " + DataModelUtility.Table_Manager + " WHERE " + DataModelUtility.Field_Id + "='" + userName + "'";
DataTable dt = DbHelperSQL.DoQueryEx("c", _sql, true);
if (dt.Rows.Count == 0)
{
return("");//用户不存在
}
DataRow row = dt.Rows[0];
//得到密匙
string salt = row[DataModelUtility.Field_Salt].ToString();
//验证密码是否正确
if (EncryptPassWord.EncryptPwd(passWord, salt) == row[DataModelUtility.Field_Password].ToString())
{
//登录成功
_returnString = "ok_check";
}
}
catch (Exception)
{
_returnString = "error_check";
}
return(_returnString);
}
/// <summary>
/// 通过 查所有订单
/// </summary>
/// <param name="Onum"></param>
/// <returns></returns>
public static DataTable getAllOrderByOnum(string Onum)
{
DataTable _dt = null;
string _sql = Sql + " where " + Field_Onum + " = '" + Onum + "'";
_dt = DbHelperSQL.DoQueryEx("a", _sql, true);
return(_dt);
}
public static DataTable getAllOrder()
{
DataTable _dt = null;
string _sql = Sql + " order by " + Field_RT + " desc";
_dt = DbHelperSQL.DoQueryEx("a", _sql, true);
return(_dt);
}
public static DataTable getOrderNull()
{
DataTable _dt = null;
string _sql = Sql + " WHERE " + Field_Onum + " ='-1111111111'" + " ORDER BY " + Field_RT;
_dt = DbHelperSQL.DoQueryEx("b", _sql, true);
return(_dt);
}
internal static DataTable getOrderByComposeForExport(string _Onum, string _GN, string _PO, string _SN, string _FromDateTime, string _ToDateTime)
{
string _whereCause = string.Empty;
if (_Onum != string.Empty)
{
_whereCause += Field_Onum + " LIKE '%" + _Onum + "%' AND ";
}
if (_GN != string.Empty)
{
_whereCause += Field_GN + " LIKE '%" + _GN + "%' AND ";
}
if (_PO != string.Empty)
{
_whereCause += Field_PO + " LIKE '%" + _PO + "%' AND ";
}
if (_SN != string.Empty)
{
_whereCause += Field_SN + " LIKE '%" + _SN + "%' AND ";
}
if (_FromDateTime != string.Empty)
{
string _s = _FromDateTime;
_FromDateTime = _s.Substring(0, 4) + "-" + _s.Substring(4, 2) + "-" + _s.Substring(6, 2) + " " + _s.Substring(8, 2) + ":" + _s.Substring(10, 2) + ":" + _s.Substring(12, 2);
_whereCause += Field_RT + " >= '" + _FromDateTime + "' AND ";
}
if (_ToDateTime != string.Empty)
{
string _s = _ToDateTime;
_ToDateTime = _s.Substring(0, 4) + "-" + _s.Substring(4, 2) + "-" + _s.Substring(6, 2) + " " + _s.Substring(8, 2) + ":" + _s.Substring(10, 2) + ":" + _s.Substring(12, 2);
_whereCause += Field_RT + " <= '" + _ToDateTime + "' AND ";
}
_whereCause = _whereCause.Trim().TrimEnd("AND".ToCharArray());
DataTable _dt = null;
string Sql = String.Format("SELECT {0} AS 发运单号 ,{1} AS 仓库代码,{2} AS 扫描序列号,{3} AS 扫描时间 ,{4} AS 接收确认时间 FROM {5} ", Field_PO, Field_GN, Field_SN, Field_ST, Field_RT, Table_Garbage);
string _sql = Sql + " WHERE " + _whereCause + " ORDER BY " + Field_RT + " DESC";
_dt = DbHelperSQL.DoQueryEx("b", _sql, true);
return(_dt);
}
internal static DataTable getOrderByCompose(string _Onum, string _GN, string _PO, string _SN, string _FromDateTime, string _ToDateTime)
{
string _whereCause = string.Empty;
if (_Onum != string.Empty)
{
_whereCause += Field_Onum + " LIKE '%" + _Onum + "%' AND ";
}
if (_GN != string.Empty)
{
_whereCause += Field_GN + " LIKE '%" + _GN + "%' AND ";
}
if (_PO != string.Empty)
{
_whereCause += Field_PO + " LIKE '%" + _PO + "%' AND ";
}
if (_SN != string.Empty)
{
_whereCause += Field_SN + " LIKE '%" + _SN + "%' AND ";
}
if (_FromDateTime != string.Empty)
{
string _s = _FromDateTime;
_FromDateTime = _s.Substring(0, 4) + "-" + _s.Substring(4, 2) + "-" + _s.Substring(6, 2) + " " + _s.Substring(8, 2) + ":" + _s.Substring(10, 2) + ":" + _s.Substring(12, 2);
_whereCause += Field_RT + " >= '" + _FromDateTime + "' AND ";
}
if (_ToDateTime != string.Empty)
{
string _s = _ToDateTime;
_ToDateTime = _s.Substring(0, 4) + "-" + _s.Substring(4, 2) + "-" + _s.Substring(6, 2) + " " + _s.Substring(8, 2) + ":" + _s.Substring(10, 2) + ":" + _s.Substring(12, 2);
_whereCause += Field_RT + " <= '" + _ToDateTime + "' AND ";
}
_whereCause = _whereCause.Trim().TrimEnd("AND".ToCharArray());
DataTable _dt = null;
string _sql = Sql + " WHERE " + _whereCause + " ORDER BY " + Field_RT + " DESC";
_dt = DbHelperSQL.DoQueryEx("b", _sql, true);
return(_dt);
}
