//新增
public static void AddProduct(TomCustomer c)
{
using (SqlConnection cn = new SqlConnection(TomCommon.DBConnect))
{
SqlCommand cmd = new SqlCommand(
"insert into Customer(CName , Country,CompanyName , EID , Phone,CImg,Gender,Email,Remark2) values(@CName , @Country ,@CompanyName, @EID , @Phone,@CImg,@Gender,@Email,@Birthday)",
cn);
cmd.Parameters.AddWithValue("@CName", c.CName);
cmd.Parameters.AddWithValue("@Country", c.Country);
cmd.Parameters.AddWithValue("@CompanyName", c.CompanyName);
cmd.Parameters.AddWithValue("@EID", c.EID);
cmd.Parameters.AddWithValue("@Phone", c.Phone);
//判斷是否是空值來上傳
if (c.CImg is null)
{
cmd.Parameters.AddWithValue("@CImg", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CImg", c.CImg);
}
cmd.Parameters.AddWithValue("@Gender", c.Gender);
cmd.Parameters.AddWithValue("@Email", c.Email);
cmd.Parameters.AddWithValue("@Birthday", c.Birthday);
cn.Open();
cmd.ExecuteNonQuery();
}
}
//編輯
public static void UpdateCustomer(TomCustomer c)
{
SqlConnection cn = new SqlConnection(TomCommon.DBConnect);
SqlCommand cmd = new SqlCommand(
"UPDATE Customer SET [CName] = @CName, [Country] = @Country, [CompanyName] = @CompanyName,[EID]=@EID,[Phone]=@Phone,[CImg]=@CImg,[Gender]=@Gender,[Email]=@Email,[Remark2]=@Birthday WHERE[CID] = @CID",
cn);
cmd.Parameters.AddWithValue("@CID", c.CID);
cmd.Parameters.AddWithValue("@CName", c.CName);
cmd.Parameters.AddWithValue("@Country", c.Country);
cmd.Parameters.AddWithValue("@CompanyName", c.CompanyName);
cmd.Parameters.AddWithValue("@EID", c.EID);
cmd.Parameters.AddWithValue("@Phone", c.Phone);
cmd.Parameters.AddWithValue("@CImg", c.CImg);
cmd.Parameters.AddWithValue("@Gender", c.Gender);
cmd.Parameters.AddWithValue("@Email", c.Email);
cmd.Parameters.AddWithValue("@Birthday", c.Birthday);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
