public unsafe bool Add(THumInfo HumRecord) { try { HumInfo objHumInfo = new HumInfo(); objHumInfo.boDeleted = HumRecord.Header.boDeleted; objHumInfo.boIsHero = HumRecord.Header.boIsHero; objHumInfo.bt2 = HumRecord.Header.bt2; objHumInfo.dCreateDate = HumRecord.Header.dCreateDate; objHumInfo.sName = HumRecord.Header.sName; //objHumInfo.sName = HUtil32.SBytePtrToString(HumRecord.Header.sName, 15); objHumInfo.boDeleted1 = HumRecord.boDeleted; objHumInfo.boIsHero1 = HumRecord.boIsHero; objHumInfo.boSelected = HumRecord.boSelected; objHumInfo.btCount = HumRecord.btCount; objHumInfo.dModDate = HumRecord.dModDate.ToOADate(); objHumInfo.n6 = HUtil32.BytePtrToByteArray(HumRecord.n6, 6); objHumInfo.sAccount = HumRecord.sAccount; //objHumInfo.sAccount = HUtil32.SBytePtrToString(HumRecord.sAccount, 30); objHumInfo.sChrName = HumRecord.sChrName; //objHumInfo.sChrName = HUtil32.SBytePtrToString(HumRecord.sChrName, 14); objHumInfo.nSelectID = HumRecord.Header.nSelectID; HumInfoSet.AddObject(objHumInfo); objMir2Entities.SaveChanges(); } catch (Exception ex) { DBShare.MainOutMessage(ex.Message); return(false); } return(true); }
public unsafe bool Update(string sName, THumInfo HumDBRecord) { HumInfo objHumInfo = FindObjectByChrName(sName); objHumInfo.boDeleted = HumDBRecord.Header.boDeleted; objHumInfo.boIsHero = HumDBRecord.Header.boIsHero; objHumInfo.bt2 = HumDBRecord.Header.bt2; objHumInfo.dCreateDate = HumDBRecord.Header.dCreateDate; objHumInfo.sName = HumDBRecord.Header.sName; //objHumInfo.sName = HUtil32.SBytePtrToString(HumDBRecord.Header.sName, 15); objHumInfo.boDeleted1 = HumDBRecord.boDeleted; objHumInfo.boIsHero1 = HumDBRecord.boIsHero; objHumInfo.boSelected = HumDBRecord.boSelected; objHumInfo.btCount = HumDBRecord.btCount; objHumInfo.dModDate = HumDBRecord.dModDate.ToOADate(); objHumInfo.n6 = HUtil32.BytePtrToByteArray(HumDBRecord.n6, 6); objHumInfo.sAccount = HumDBRecord.sAccount; //objHumInfo.sAccount = HUtil32.SBytePtrToString(HumDBRecord.sAccount, 30); objHumInfo.sChrName = HumDBRecord.sChrName; //objHumInfo.sChrName = HUtil32.SBytePtrToString(HumDBRecord.sChrName, 14); return(true); }
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); }
public unsafe int FindByAccount(string sAccount, ref ArrayList ChrNameList) { var FindHumList = from Hum in HumInfoSet where Hum.sAccount == sAccount select Hum; if (FindHumList.Count <HumInfo>() > 0) { foreach (HumInfo item in FindHumList) { THumInfo HumRecord = default(THumInfo); HumRecord.Header.boDeleted = item.boDeleted.Value; HumRecord.Header.boIsHero = item.boIsHero.Value; HumRecord.Header.bt2 = item.bt2.Value; HumRecord.Header.dCreateDate = item.dCreateDate.Value; HumRecord.Header.nSelectID = item.nSelectID.Value; HumRecord.Header.sName = item.sName; //HUtil32.StringToSBytePtr(item.sName, HumRecord.Header.sName, 0); HumRecord.Header.NameLen = 15; HumRecord.boDeleted = item.boDeleted1.Value; HumRecord.boIsHero = item.boIsHero1.Value; HumRecord.boSelected = item.boSelected.Value; HumRecord.btCount = item.btCount.Value; HumRecord.dModDate = DateTime.FromOADate(item.dModDate.Value); HUtil32.ByteArrayToBytePtr(HumRecord.n6, 6, item.n6); HumRecord.sAccount = item.sAccount; //HUtil32.StringToSBytePtr(item.sAccount, HumRecord.sAccount, 0); HumRecord.AccountLen = 30; HumRecord.sChrName = item.sChrName; //HUtil32.StringToSBytePtr(item.sChrName, HumRecord.sChrName, 0); HumRecord.ChrNameLen = 14; ChrNameList.Add(HumRecord); } return(FindHumList.Count <HumInfo>()); } ChrNameList = null; return(-1); }