private string GetCheck3(string tbDelivery)
{
int intSizeCount = new GenericBusiness().GetMaxSizeCount();
sb.Length = 0;
sb.AppendLine("select a.Customer_ID,a.CheckDate,B.DiscountPrice ,");
sb.AppendLine(SizeField.GetSizeSumField(intSizeCount, "c.") + " AS Quantity");
sb.AppendLine("into " + tbDelivery);
sb.AppendLine(" FROM [vn_Check] A ");
sb.AppendLine(" INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID ");
sb.AppendLine(" INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID ");
sb.AppendLine(" WHERE 1 = 1 ");
sb.AppendLine(" AND Exists (SELECT 1 FROM " + tbCustomerFilter + " WHERE ID = A.Customer_ID) \n");
sb.AppendFormat(" and a.CheckDate>='{0}' and a.CheckDate<='{1} 23:59:59' ", Syearbegin, Syearend);
sb.AppendLine("group by a.Customer_ID,a.CheckDate,B.DiscountPrice");
da.ExecuteNonQuery(sb.ToString());
return(tbDelivery);
}
private void Awake()
{
sizeField = this.GetComponent <SizeField>();
_persistentPath = Application.persistentDataPath + Path.DirectorySeparatorChar;
gameData = RepositoryData.CreateNewGameData(_persistentPath, _saveFileName, "Default");
}
