public void GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar)
{
DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1);
SalesTotalWeight = new t_Decimal(0);
TotalCar = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true));
parms.Add(new LBDbParameter("TotalCar", TotalCar, true));
parms.Add(new LBDbParameter("DTFrom", new t_DTSmall(dtFrom)));
parms.Add(new LBDbParameter("DTTo", new t_DTSmall(dtTo)));
string strSQL = @"
select @SalesTotalWeight = sum(SuttleWeight/1000.0), @TotalCar = count(1)
from dbo.SaleCarOutBill o
inner join SaleCarInBill i on
i.SaleCarInBillID = o.SaleCarInBillID
where i.BillStatus = 2 and
o.BillDate>=@DTFrom and o.BillDate<@DTTo
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value);
TotalCar.SetValueWithObject(parms["TotalCar"].Value);
}
public void GetInsideCarCount(FactoryArgs args, out t_ID CarCount)
{
CarCount = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CarCount", CarCount, true));
string strSQL = @"
select @CarCount = sum(1)
from dbo.View_SaleCarInOutBill
where SaleCarOutBillID is null and isnull(IsCancel,0) = 0
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
CarCount.SetValueWithObject(parms["CarCount"].Value);
}
public void Update(FactoryArgs args, t_String SysConfigFieldName, t_String SysConfigValue)
{
t_ID SysConfigDataType = new t_ID(0);//0字符串 1小数 2整数 3布尔值
t_String SysConfigFieldText = new t_String("");
using (DataTable dtConfig = _DALDbSysConfig.GetDbSysConfigField(args, SysConfigFieldName))
{
if (dtConfig.Rows.Count == 0)
{
throw new Exception("该系统设置无效！");
}
else
{
DataRow drConfig = dtConfig.Rows[0];
SysConfigDataType.SetValueWithObject(drConfig["SysConfigDataType"]);
SysConfigFieldText.SetValueWithObject(drConfig["SysConfigFieldText"]);
}
}
if (SysConfigDataType.Value == 1)
{
decimal decValue;
if (!decimal.TryParse(SysConfigValue.Value, out decValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为小数类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
if (SysConfigDataType.Value == 2)
{
int iValue;
if (!int.TryParse(SysConfigValue.Value, out iValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为整数类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
if (SysConfigDataType.Value == 3)
{
int iValue;
if (!int.TryParse(SysConfigValue.Value, out iValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为布尔值类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
_DALDbSysConfig.Update(args, SysConfigFieldName, SysConfigValue);
}
public void ReadReceiveType(FactoryArgs args, t_BigID CustomerID, out t_ID ReceiveType)
{
ReceiveType = new t_ID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType, true));
string strSQL = @"
select ReceiveType
from dbo.DbCustomer
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReceiveType.SetValueWithObject(parms["ReceiveType"].Value);
}
public void GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar)
{
DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1);
SalesTotalWeight = new t_Decimal(0);
TotalCar = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true));
parms.Add(new LBDbParameter("TotalCar", TotalCar, true));
parms.Add(new LBDbParameter("DTFrom", new t_String(dtFrom.ToString("yyyy-MM-dd HH:mm:ss"))));
parms.Add(new LBDbParameter("DTTo", new t_String(dtTo.ToString("yyyy-MM-dd HH:mm:ss"))));
string strSQL = @"
select sum(SuttleWeight/1000.0) as SalesTotalWeight,count(1) as TotalCar
from SaleCarInBill i
where i.IsCancel = 0 and
i.BillDate>=@DTFrom and i.BillDate<@DTTo
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value);
TotalCar.SetValueWithObject(parms["TotalCar"].Value);
}
