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"); }