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