C# (CSharp) DataFormat.DateToDB示例

示例#1

        public bool Finalize()
        {
            string Query        = string.Empty;
            string finalizeDate = DataFormat.DateToDB(System.DateTime.Now.ToShortDateString());

            Query = "UPDATE Expense_Details SET Finalized = " + finalizeDate + " WHERE Finalized=0";

            if (_dbHelper.ExecuteNonQuery(Query) > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }

示例#2

        public bool UpdateFinalizationDetails()
        {
            string Query        = string.Empty;
            string finalizeDate = DataFormat.DateToDB(System.DateTime.Now.ToShortDateString());

            Query = "UPDATE Finalization_Details SET Finalize_Date = '" + DataFormat.GetCurrentDate() + "' WHERE IsDeleted=0";

            if (_dbHelper.ExecuteNonQuery(Query) > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }