updata.cs

来自「库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发」· CS 代码 · 共 40 行

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

}