www.pudn.com > FORU(SMS).rar > UpData.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
using System.Windows.Forms; 
namespace FORU_SMS_.BaseClass 
{ 
    public class UpData 
    { 
        DataConn Dconn = new DataConn(); 
        public void updata(AddGoods Agoods) 
        { 
            string sql = ""; 
            sql = sql + "update SMS_Goods set GoodsName=@GoodsName,StoreName=@StoreName,SupName=@SupName,SpecName=@SpecName,UnitName=@UnitName,GoodsNum=@GoodsNum,GoodsPrice=@GoodsPrice,GoodsAPrice=@GoodsAPrice,GoodsPeople=@GoodsPeople,GoodsRemarks=@GoodsRemarks where GoodsID='" + Agoods._GoodsID + "'"; 
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn()); 
            sqlcom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50, "GoodsName").Value = Agoods.GoodsName; 
            sqlcom.Parameters.Add("@StoreName", SqlDbType.VarChar, 50, "StoreName").Value = Agoods.StoreName; 
            sqlcom.Parameters.Add("@SupName", SqlDbType.VarChar, 50, "SupName").Value = Agoods.SupName; 
            sqlcom.Parameters.Add("@SpecName", SqlDbType.VarChar, 50, "SpecName").Value = Agoods.SpecName; 
            sqlcom.Parameters.Add("@UnitName", SqlDbType.VarChar, 50, "UnitName").Value = Agoods.UnitName; 
            sqlcom.Parameters.Add("@GoodsNum", SqlDbType.Int, 4, "GoodsNum").Value = Agoods.GoodsNum; 
            sqlcom.Parameters.Add("@GoodsPrice", SqlDbType.Float, 10, "GoodsPrice").Value = Agoods.GoodsPrice; 
            sqlcom.Parameters.Add("@GoodsAPrice", SqlDbType.Float, 10, "GoodsAPrice").Value = Agoods.GoodsAPrice; 
            sqlcom.Parameters.Add("@GoodsPeople", SqlDbType.VarChar, 20, "GoodsPeople").Value = Agoods.GoodsPeople; 
            sqlcom.Parameters.Add("@GoodsRemarks", SqlDbType.VarChar, 1000, "GoodsRemarks").Value = Agoods.GoodsRemarks; 
            try 
            { 
                sqlcom.ExecuteNonQuery(); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
    } 
 
}