public PersonEntity GetPersonInfo(string userName, string passWord)
{
PersonEntity pe = new PersonEntity();
string strSql = @" SELECT *
FROM TBLPERSON where personaccount=@UserName and personpassword=@PassWord";
string[] paramName=new string[2];
object[] paramValue = new object[2];
paramName[0]="UserName";
paramName[1] = "PassWord";
paramValue[0] = userName;
paramValue[1] = passWord;
SqlDBBroker broker = new SqlDBBroker();
broker.Open();
DataSet dst = broker.ExecuteDataset(strSql,CommandType.Text,paramName,paramValue);
broker.Close();
if (dst != null && dst.Tables[0] != null && dst.Tables[0].Rows.Count > 0)
{
return this.DataRow2Person(dst.Tables[0].Rows[0]);
}
else
{
return null;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (CheckSave())
{
PersonEntity per = new PersonEntity();
per.OID = hdfPersonID.Value;
per.CUSER = AppCenter.CurrentPersonAccount;
per.MUSER = AppCenter.CurrentPersonAccount;
per.PERSONACCOUNT = txtPersonAccount.Text.Trim();
per.PERSONCODE = txtPersonAccount.Text.Trim();
per.PERSONDESC = txtPersonMemo.Text.Trim();
per.PERSONEMAIL = txtEmail.Text.Trim();
per.PERSONMEMO = txtPersonMemo.Text.Trim();
per.PERSONMOBILEPHONE = txtMobilPhone.Text.Trim();
per.PERSONNAME = txtPersonName.Text.Trim();
per.PERSONOFFICEPHONE = txtOfficePhone.Text.Trim();
per.PERSONSEX = Convert.ToInt32(drpPersonSex.SelectedValue);
per.PERSONSTATUS = Convert.ToInt32(drpPersonStatus.SelectedValue);
per.PERSONTYPE = Convert.ToInt32(drpPersonType.SelectedValue);
bool retValue = true;
if (string.IsNullOrEmpty(per.OID))
{
per.OID = Guid.NewGuid().ToString();
retValue = new PersonController().InsertPerson(per);
}
else
{
retValue = new PersonController().UpdatePersonAdmin(per);
}
if (retValue)
{
hdfFlag.Value = "1";
base.ShowMessage(CommonMessage.SaveSuccess);
}
else
{
base.ShowMessage(CommonMessage.SaveFailed);
}
}
}
public PersonEntity GetPersonInfo(string personID)
{
PersonEntity pe = new PersonEntity();
string strSql = @" SELECT *
FROM TBLPERSON where oid=@OID ";
string[] paramName = new string[1];
object[] paramValue = new object[1];
paramName[0] = "OID";
paramValue[0] = personID;
SqlDBBroker broker = new SqlDBBroker();
broker.Open();
DataSet dst = broker.ExecuteDataset(strSql, CommandType.Text, paramName, paramValue);
broker.Close();
if (dst != null && dst.Tables[0] != null && dst.Tables[0].Rows.Count > 0)
{
return this.DataRow2Person(dst.Tables[0].Rows[0]);
}
else
{
return null;
}
}
private PersonEntity DataRow2Person(DataRow dr)
{
PersonEntity pe = new PersonEntity();
if (dr != null)
{
pe.OID = Convert.ToString(dr["oid"]);
pe.PERSONACCOUNT = Convert.ToString(dr["personaccount"]);
pe.PERSONNAME = Convert.ToString(dr["personname"]);
pe.PERSONSEX = Convert.ToInt32(dr["personsex"]);
pe.PERSONSTATUS = Convert.ToInt32(dr["personstatus"]);
pe.PERSONTYPE = Convert.ToInt32(dr["persontype"]);
pe.PERSONEMAIL = Convert.ToString(dr["personemail"]);
pe.PERSONMOBILEPHONE = Convert.ToString(dr["personmobilephone"]);
pe.PERSONOFFICEPHONE = Convert.ToString(dr["personofficephone"]);
pe.PERSONMEMO = Convert.ToString(dr["personmemo"]);
}
return pe;
}
public bool InsertPerson(PersonEntity per)
{
if (per != null)
{
string strSQL = @" INSERT INTO TBLPERSON ( oid , personcode , personaccount , personpassword , personname , personsex ,
personstatus , persontype , personofficephone , personmobilephone , personemail ,
personmemo , cuser , cdate , muser , mdate , mpwdtime , personpasswordquestion ,
personpasswordanswer , addition1 , addition2 )
VALUES ( @oid, @personcode,@personaccount,@personpassword,@personname,@personsex,
@personstatus,@persontype,@personofficephone,@personmobilephone,@personemail,
@personmemo,@cuser, GETDATE(),@muser,GETDATE(),GETDATE(),' ' ,' ', NULL,NULL) ";
string[] paramNames = new string[14];
object[] paramValues = new object[14];
paramNames[0] = "OID";
paramNames[1] = "personcode";
paramNames[2] = "personaccount";
paramNames[3] = "personpassword";
paramNames[4] = "personname";
paramNames[5] = "personsex";
paramNames[6] = "personstatus";
paramNames[7] = "persontype";
paramNames[8] = "personofficephone";
paramNames[9] = "personmobilephone";
paramNames[10] = "personemail";
paramNames[11] = "personmemo";
paramNames[12] = "cuser";
paramNames[13] = "muser";
paramValues[0] = per.OID;
paramValues[1] = per.PERSONCODE;
paramValues[2] = per.PERSONACCOUNT;
paramValues[3] = per.PERSONPASSWORD??" ";
paramValues[4] = per.PERSONNAME;
paramValues[5] = per.PERSONSEX;
paramValues[6] = per.PERSONSTATUS;
paramValues[7] = per.PERSONTYPE;
paramValues[8] = per.PERSONOFFICEPHONE;
paramValues[9] = per.PERSONMOBILEPHONE;
paramValues[10] = per.PERSONEMAIL;
paramValues[11] = per.PERSONMEMO;
paramValues[12] = per.CUSER;
paramValues[13] = per.MUSER;
SqlDBBroker broker = new SqlDBBroker();
try
{
broker.Open();
broker.BeginTrans();
broker.ExecuteNonQuery(strSQL, CommandType.Text, paramNames, paramValues);
broker.CommitTrans();
}
catch
{
broker.RollbackTrans();
return false;
}
finally
{
broker.Close();
}
}
return true;
}
public bool UpdatePersonAdmin(PersonEntity per)
{
if (per != null)
{
string strSQL = @" UPDATE TBLPERSON SET personcode=@personcode,personaccount=@personaccount,personname=@personname,personsex=@personsex,
personstatus=@personstatus,persontype=@persontype,personofficephone=@personofficephone,
personmobilephone=@personmobilephone,personemail=@personemail,personmemo=@personmemo,muser=@muser,mdate=GETDATE()
WHERE oid=@oid ";
string[] paramNames = new string[12];
object[] paramValues = new object[12];
paramNames[0] = "OID";
paramNames[1] = "personcode";
paramNames[2] = "personaccount";
paramNames[3] = "personname";
paramNames[4] = "personsex";
paramNames[5] = "personstatus";
paramNames[6] = "persontype";
paramNames[7] = "personofficephone";
paramNames[8] = "personmobilephone";
paramNames[9] = "personemail";
paramNames[10] = "personmemo";
paramNames[11] = "muser";
paramValues[0] = per.OID;
paramValues[1] = per.PERSONCODE;
paramValues[2] = per.PERSONACCOUNT;
paramValues[3] = per.PERSONNAME;
paramValues[4] = per.PERSONSEX;
paramValues[5] = per.PERSONSTATUS;
paramValues[6] = per.PERSONTYPE;
paramValues[7] = per.PERSONOFFICEPHONE;
paramValues[8] = per.PERSONMOBILEPHONE;
paramValues[9] = per.PERSONEMAIL;
paramValues[10] = per.PERSONMEMO;
paramValues[11] = per.MUSER;
SqlDBBroker broker = new SqlDBBroker();
try
{
broker.Open();
broker.BeginTrans();
broker.ExecuteNonQuery(strSQL, CommandType.Text, paramNames, paramValues);
broker.CommitTrans();
}
catch
{
broker.RollbackTrans();
return false;
}
finally
{
broker.Close();
}
}
return true;
}
