public int mail_Select(ForecastOrders info)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
string sql = string.Format(@"select count(*) from Mail where Waveid='{0}' and WaveType='{1}'and WaveReleaseTime='{2} '
and Shipment='{3}' and ThreePL='{4}'and ShipToSity='{5}' and ShipToCode='{6}' and
ShipToName='{7}' and Pieces='{8}'and Cartons='{9 }'and Sorterlane='{10}' "
, info.waveId, info.WaveType, info.WaveReleaseTime, info.Shipment, info.pl, info.Shiptocity, info.Shiptocode, info.Shiptoname, info.Pieces, info.Cartons, info.Sorterlane);
SqlCommand cmd = new SqlCommand(sql, conn);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@WID",C);
conn.Open();
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
}
}
public int appointed(string type, string id)
{
DateTime dt = DateTime.Now;
string str = dt.ToString("yyyy-MM-dd ");
string d = dt.ToString("HH:mm");
type = type + " " + d;
ForecastOrders info = new ForecastOrders();
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
string sql = "update dbo.Wave set DeliverTime= '" + type + "' where wid=" + id;;
SqlCommand cmd = new SqlCommand(sql, conn);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@WID",C);
conn.Open();
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
}
}
public virtual int _GetUniqueIdentifier()
{
var hashCode = 399326290;
hashCode = hashCode * -1521134295 + (Id?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (percentage?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (ItemDescription?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (RealOrderedQuantities?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (ForecastOrders?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Month?.GetHashCode() ?? 0);
return(hashCode);
}
public string GetSqlWhere(ForecastOrders info)
{
StringBuilder sb = new StringBuilder();
//sb.Append(" 1=1 ");
sb.Append("AND Mail.ThreePL='RBOW'");
if (!string.IsNullOrEmpty(info.waveId))
{
sb.Append(" AND Wave.waveId like '%" + info.waveId.Trim() + "%'");
}
if (!string.IsNullOrEmpty(info.WaveReleaseTime))
{
sb.Append(" AND CONVERT(varchar, Wave.WaveReleaseTime,112)>=CONVERT(varchar, dateadd(day,0,'" + info.WaveReleaseTime + "'),112)");
}
if (info.State != "全部")
{
if (info.State == "待发货/正在发货中")
{
sb.Append(" AND State in('正在发货中' , '待发货')");
}
else
{
sb.Append(" AND State='" + info.State + "'");
}
}
if (!string.IsNullOrEmpty(info.WaveReleaseTime2))
{
sb.Append("AND CONVERT(varchar, Wave.WaveReleaseTime,112)<=CONVERT(varchar, dateadd(day,0,'" + info.WaveReleaseTime2 + "'),112)");
}
if (!string.IsNullOrEmpty(info.PickTime))
{
sb.Append("AND CONVERT(varchar, Wave.PickTime,112)>=CONVERT(varchar, dateadd(day,0,'" + info.PickTime + "'),112)");
}
if (!string.IsNullOrEmpty(info.PickTime2))
{
sb.Append("AND CONVERT(varchar, Wave.PickTime,112)<=CONVERT(varchar, dateadd(day,0,'" + info.PickTime2 + "'),112)");
}
if (!string.IsNullOrEmpty(info.DeliverTime))
{
sb.Append("AND CONVERT(varchar,Wave. shipments,112)>=CONVERT(varchar, dateadd(day,0,'" + info.DeliverTime + "'),112)");
}
if (!string.IsNullOrEmpty(info.DeliverTime2))
{
sb.Append("AND CONVERT(varchar, Wave.shipments,112)<=CONVERT(varchar, dateadd(day,0,'" + info.DeliverTime2 + "'),112)");
}
return(sb.ToString());
}
public int mail_Select(ForecastOrders info)
{
int acc = 0;
try
{
ForecastWarehouseAccessor Accessor = new ForecastWarehouseAccessor();
acc = Accessor.mail_Select(info);
}
catch (Exception ex)
{
LogError(ex);
}
return(acc);
}
public string GetSqlWhere2(ForecastOrders info)
{
StringBuilder sb = new StringBuilder();
if (info.zhi2 != "请选择")
{
if (info.zhi2 == "desc")
{
sb.Append(" desc");
}
else
{
sb.Append(" asc");
}
}
return(sb.ToString());
}
public IEnumerable <ForecastOrders> GetCRMInfo(ForecastOrders Info, int PageIndex, int PageSize, out int RowCount)
{
string strSQL = this.GetSqlWhere(Info);
string strSQL2 = this.GetSqlWhere2(Info);
DbParam[] dbParams =
{
new DbParam("@where", DbType.String, strSQL, ParameterDirection.Input),
new DbParam("@zhi", DbType.String, strSQL2, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, 0, ParameterDirection.Output)
};
IEnumerable <ForecastOrders> crmlist = base.ExecuteDataTable("Proc_GetWave", dbParams).ConvertToEntityCollection <ForecastOrders>();
RowCount = (int)dbParams[4].Value;
return(crmlist);
}
