public bool AddAccount(TAccountDBRecord DBRecord) { if (this.AccountExists(DBRecord.UserEntry.sAccount)) { return(false); } DateTime dtNow = DateTime.Now; IDataParameter[] SqlParams = { new System.Data.SqlClient.SqlParameter("@FLD_LOGINID", DBRecord.UserEntry.sAccount), new System.Data.SqlClient.SqlParameter("@FLD_PASSWORD", DBRecord.UserEntry.sPassword), new System.Data.SqlClient.SqlParameter("@FLD_USERNAME", DBRecord.UserEntry.sUserName), new System.Data.SqlClient.SqlParameter("@FLD_SSNO", DBRecord.UserEntry.sSSNo), new System.Data.SqlClient.SqlParameter("@FLD_BIRTHDAY", DBRecord.UserEntryAdd.sBirthDay), new System.Data.SqlClient.SqlParameter("@FLD_PHONE", DBRecord.UserEntry.sPhone), new System.Data.SqlClient.SqlParameter("@FLD_MOBILEPHONE", DBRecord.UserEntryAdd.sMobilePhone), new System.Data.SqlClient.SqlParameter("@FLD_ADDRESS1", DBRecord.UserEntryAdd.sMemo), new System.Data.SqlClient.SqlParameter("@FLD_ADDRESS2", DBRecord.UserEntryAdd.sMemo2), new System.Data.SqlClient.SqlParameter("@FLD_EMAIL", DBRecord.UserEntry.sEMail), new System.Data.SqlClient.SqlParameter("@FLD_QUIZ1", DBRecord.UserEntry.sQuiz), new System.Data.SqlClient.SqlParameter("@FLD_ANSWER1", DBRecord.UserEntry.sAnswer), new System.Data.SqlClient.SqlParameter("@FLD_QUIZ2", DBRecord.UserEntryAdd.sQuiz2), new System.Data.SqlClient.SqlParameter("@FLD_ANSWER2", DBRecord.UserEntryAdd.sAnswer2), new System.Data.SqlClient.SqlParameter("@FLD_CREATEDATE", dtNow), new System.Data.SqlClient.SqlParameter("@FLD_UPDATEDATE", dtNow), new System.Data.SqlClient.SqlParameter("@FLD_DELETED", 0), new System.Data.SqlClient.SqlParameter("@FLD_ACTIONTICK", 0), new System.Data.SqlClient.SqlParameter("@FLD_ERRORCOUNT", 0) }; DataSet dsCustome = new DataSet(); if (dbClient.ExecuteProcedure("CreateAccount", SqlParams, ref dsCustome) >= 0) { return(true); } return(false); }
public bool Add(THumInfo objHumInfo, THumDataInfo objHumDataInfo) { string sGuid = HUtil32.GetGuid(); string sAccount = objHumInfo.sAccount; string sChrName = objHumInfo.sChrName; int boIsHero = objHumInfo.boIsHero ? 1 : 0; int boSelected = objHumInfo.boSelected ? 1 : 0; int nSelectID = objHumInfo.Header.nSelectID; int boDeleted = objHumInfo.boDeleted?1:0; DateTime dCreateDate = DateTime.FromOADate(objHumInfo.dCreateDate); DateTime dModDate = objHumInfo.dModDate; int btCount = objHumInfo.btCount; DataSet dsCustom = new DataSet(); IDataParameter[] SqlParams = new IDataParameter[] { new System.Data.SqlClient.SqlParameter("@sGuid", sGuid), new System.Data.SqlClient.SqlParameter("@sAccount", sAccount), new System.Data.SqlClient.SqlParameter("@sChrName", sChrName), new System.Data.SqlClient.SqlParameter("@boIsHero", boIsHero), new System.Data.SqlClient.SqlParameter("@boSelected", boSelected), new System.Data.SqlClient.SqlParameter("@nSelectID", nSelectID), new System.Data.SqlClient.SqlParameter("@boDeleted", boDeleted), new System.Data.SqlClient.SqlParameter("@dCreateDate", dCreateDate), new System.Data.SqlClient.SqlParameter("@dModDate", dModDate), new System.Data.SqlClient.SqlParameter("@btCount", btCount), }; if (!(dbClient.ExecuteProcedure("CreateHumInfo", SqlParams, ref dsCustom) > 0)) { return(false); } if (!(dbClient.ExecuteSql(string.Format("INSERT INTO HumDataInfo(Guid,btSex,btJob,btHair) VALUES('{0}',{1},{2},{3})", sGuid, objHumDataInfo.Data.btSex, objHumDataInfo.Data.btJob, objHumDataInfo.Data.btHair )) > 0)) { return(false); } return(true); }