public void updateLocalMobil(string acccount, string mobil, out Error error) { error = null; SqlParameter sqlParam; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "update consumer_member set CM007=@CM007 where CM002=@CM002;"; THC_Library.DataBase.DataBaseControl dbCtl = new THC_Library.DataBase.DataBaseControl(); try { sqlParam = new SqlParameter("@CM007", mobil); if (mobil == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = mobil; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM002", acccount); paraList.Add(sqlParam); dbCtl.Open(); dbCtl.ExecuteScalar(strSQL, paraList); } catch (SqlException sqlEx) { error = new Error(); if (sqlEx.Number == 2601) { error.Number = 101; error.ErrorMessage = "帳號已註冊"; } else { error.Number = 100; error.ErrorMessage = "系統錯誤"; } } catch (Exception ex) { error = new Error(); error.Number = 100; error.ErrorMessage = "系統錯誤"; } finally { dbCtl.Close(); } }
public void updateLocalAccount(string acccount, string mobil, string iid, string addr, out Error error) { /* * CM001 Int PK 1.0 * CM002 varchar(50) 會員帳號 唯一 mail 1.0 * CM003 varchar (50) FB帳號 1.0 * CM004 varchar (50) Line帳號 1.0 * CM005 varchar (50) Google帳號 1.0 * CM006 nvarchar (20) 會員姓名 1.0 * CM007 varchar(10) 手機號碼 1.0 * CM008 nvarchar(200) 地址 1.0 * CM009 varchar(10) 身分證號 1.0 * CM010 char(1) 性別 ‘’未填 0 女 1 男 2 彩虹 1.0 * CM011 char(1) 年齡 1 10-19 2 20-29 …… 1.0 * */ error = null; SqlParameter sqlParam; IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "update consumer_member set CM007=@CM007,CM008=@CM008,CM009=@CM009 " + "where CM002=@CM002;"; THC_Library.DataBase.DataBaseControl dbCtl = new THC_Library.DataBase.DataBaseControl(); try { sqlParam = new SqlParameter("@CM007", mobil); if (mobil == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = mobil; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM008", SqlDbType.NVarChar); if (addr == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = addr; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM009", SqlDbType.VarChar); if (iid == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = iid; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM002", acccount); paraList.Add(sqlParam); dbCtl.Open(); dbCtl.ExecuteScalar(strSQL, paraList); } catch (SqlException sqlEx) { error = new Error(); if (sqlEx.Number == 2601) { error.Number = 101; error.ErrorMessage = "帳號已註冊"; } else { error.Number = 100; error.ErrorMessage = "系統錯誤"; } } catch (Exception ex) { error = new Error(); error.Number = 100; error.ErrorMessage = "系統錯誤"; } finally { dbCtl.Close(); } }
public void newLocalAccount(string acccount, string mail, string mobil, string gender, string age, out Error error) { error = null; SqlParameter sqlParam; /* * CM001 Int PK 1.0 * CM002 varchar(50) 會員帳號 唯一 mail 1.0 * CM003 varchar (50) FB帳號 1.0 * CM004 varchar (50) Line帳號 1.0 * CM005 varchar (50) Google帳號 1.0 * CM006 nvarchar (20) 會員姓名 1.0 * CM007 varchar(10) 手機號碼 1.0 * CM008 nvarchar(200) 地址 1.0 * CM009 varchar(10) 身分證號 1.0 * CM010 char(1) 性別 ‘’未填 0 女 1 男 2 彩虹 1.0 * CM011 char(1) 年齡 1 10-19 2 20-29 …… 1.0 * */ IList <SqlParameter> paraList = new System.Collections.Generic.List <SqlParameter>(); string strSQL = "insert into consumer_member (CM002,CM007,CM010,CM011) values " + "(@CM002,@CM007,@CM010,@CM011);"; THC_Library.DataBase.DataBaseControl dbCtl = new THC_Library.DataBase.DataBaseControl(); try { sqlParam = new SqlParameter("@CM002", acccount); paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM007", mobil); if (mobil == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = mobil; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM010", SqlDbType.Char); if (gender == null) { sqlParam.Value = "0"; } else { sqlParam.Value = gender; } paraList.Add(sqlParam); sqlParam = new SqlParameter("@CM011", SqlDbType.Char); if (age == null) { sqlParam.Value = DBNull.Value; } else { sqlParam.Value = age; } paraList.Add(sqlParam); dbCtl.Open(); dbCtl.ExecuteCommad(strSQL, paraList); } catch (SqlException sqlEx) { error = new Error(); if (sqlEx.Number == 2601) { error.Number = 101; error.ErrorMessage = "帳號已註冊"; } else { error.Number = 100; error.ErrorMessage = "系統錯誤"; } } catch (Exception ex) { error = new Error(); error.Number = 100; error.ErrorMessage = "系統錯誤"; } finally { dbCtl.Close(); } }