数据库操作典例

    public int AddProduct(string ProductCode, string ProductName, decimal CurrentPrice, decimal OriginalPrice, string PackingUnit, string Specification, string PromotionalPrice, int CompanyID, string PromotionalStart, string PromotionalEnd)
        {
            string strSql = "INSERT INTO tblProduct(ProductCode,CategoryID,ProductName,CurrentPrice,OriginalPrice,StatusCode,CompanyID,PackingUnit,OrderNum,PromotionalPrice,PromotionalStart,PromotionalEnd) VALUES(@ProductCode,1,@ProductName,@CurrentPrice,@OriginalPrice,'NORMAL',@CompanyID,@PackingUnit,0,@PromotionalPrice,@PromotionalStart,@PromotionalEnd)";
            SqlCommand cmd = new SqlCommand(strSql, conn);
            cmd.Parameters.AddWithValue("@ProductCode", ProductCode);
            cmd.Parameters.AddWithValue("@ProductName", ProductName);
            cmd.Parameters.AddWithValue("@CurrentPrice", CurrentPrice);
            cmd.Parameters.AddWithValue("@OriginalPrice", OriginalPrice);
            cmd.Parameters.AddWithValue("@PackingUnit", PackingUnit);
            cmd.Parameters.AddWithValue("@Specification", Specification);
            if (PromotionalPrice.Length == 0)
            {

                cmd.Parameters.AddWithValue("@PromotionalPrice", DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@PromotionalPrice", float.Parse(PromotionalPrice));
            }
            if (PromotionalStart.Length == 0)
            {
                cmd.Parameters.AddWithValue("@PromotionalStart", DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@PromotionalStart", Convert.ToDateTime(PromotionalStart));
            }
            if (PromotionalEnd.Length == 0)
            {
                cmd.Parameters.AddWithValue("@PromotionalEnd", DBNull.Value);
            }
            else
            {

                cmd.Parameters.AddWithValue("@PromotionalEnd", Convert.ToDateTime(PromotionalEnd));
            }
            cmd.Parameters.AddWithValue("@CompanyID", CompanyID);
            conn.Open();
            try
            {
                return cmd.ExecuteNonQuery();
            }
            finally
            {
                conn.Close();
            }
        
        }

 

转载于:https://www.cnblogs.com/huangtu/archive/2013/02/04/2891456.html