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