/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelAgency.Model.VisaInfo_Tmp GetModel(Guid VisaInfo_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 VisaInfo_id,Visa_id,GroupNo,Name,EnglishName,Sex,Birthday,PassportNo,LicenceTime,ExpiryDate,Birthplace,IssuePlace,Post,Phone,GuideNo,Client,Salesperson,Types,Sale_id,DepartmentId,Tips,EntryTime,EmbassyTime,InTime,OutTime,RealOut,RealOutTime,Country,Call,outState,Residence,Occupation,DepartureRecord,Marriaged,Identification,FinancialCapacity,AgencyOpinion,HasTypeIn,AbnormalOutTime,HasChecked,CheckPerson,ReturnTime from VisaInfo_Tmp ");
strSql.Append(" where VisaInfo_id=@VisaInfo_id ");
SqlParameter[] parameters =
{
new SqlParameter("@VisaInfo_id", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = VisaInfo_id;
TravelAgency.Model.VisaInfo_Tmp model = new TravelAgency.Model.VisaInfo_Tmp();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public TravelAgency.Model.VisaInfo_Tmp GetModelByPassportNo(string passportNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from VisaInfo_Tmp ");
strSql.Append(" where PassportNo=@PassportNo ");
SqlParameter[] parameters =
{
new SqlParameter("@PassportNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = passportNo;
TravelAgency.Model.VisaInfo_Tmp model = new TravelAgency.Model.VisaInfo_Tmp();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TravelAgency.Model.VisaInfo_Tmp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into VisaInfo_Tmp(");
strSql.Append("VisaInfo_id,Visa_id,GroupNo,Name,EnglishName,Sex,Birthday,PassportNo,LicenceTime,ExpiryDate,Birthplace,IssuePlace,Post,Phone,GuideNo,Client,Salesperson,Types,Sale_id,DepartmentId,Tips,EntryTime,EmbassyTime,InTime,OutTime,RealOut,RealOutTime,Country,Call,outState,Residence,Occupation,DepartureRecord,Marriaged,Identification,FinancialCapacity,AgencyOpinion,HasTypeIn,AbnormalOutTime,HasChecked,CheckPerson,ReturnTime)");
strSql.Append(" values (");
strSql.Append("@VisaInfo_id,@Visa_id,@GroupNo,@Name,@EnglishName,@Sex,@Birthday,@PassportNo,@LicenceTime,@ExpiryDate,@Birthplace,@IssuePlace,@Post,@Phone,@GuideNo,@Client,@Salesperson,@Types,@Sale_id,@DepartmentId,@Tips,@EntryTime,@EmbassyTime,@InTime,@OutTime,@RealOut,@RealOutTime,@Country,@Call,@outState,@Residence,@Occupation,@DepartureRecord,@Marriaged,@Identification,@FinancialCapacity,@AgencyOpinion,@HasTypeIn,@AbnormalOutTime,@HasChecked,@CheckPerson,@ReturnTime)");
SqlParameter[] parameters =
{
new SqlParameter("@VisaInfo_id", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Visa_id", SqlDbType.VarChar, 50),
new SqlParameter("@GroupNo", SqlDbType.VarChar, 500),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@EnglishName", SqlDbType.VarChar, 50),
new SqlParameter("@Sex", SqlDbType.VarChar, 50),
new SqlParameter("@Birthday", SqlDbType.DateTime, 3),
new SqlParameter("@PassportNo", SqlDbType.VarChar, 50),
new SqlParameter("@LicenceTime", SqlDbType.DateTime, 3),
new SqlParameter("@ExpiryDate", SqlDbType.DateTime, 3),
new SqlParameter("@Birthplace", SqlDbType.VarChar, 50),
new SqlParameter("@IssuePlace", SqlDbType.VarChar, 50),
new SqlParameter("@Post", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@GuideNo", SqlDbType.VarChar, 50),
new SqlParameter("@Client", SqlDbType.VarChar, 50),
new SqlParameter("@Salesperson", SqlDbType.VarChar, 50),
new SqlParameter("@Types", SqlDbType.VarChar, 50),
new SqlParameter("@Sale_id", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@DepartmentId", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Tips", SqlDbType.VarChar, -1),
new SqlParameter("@EntryTime", SqlDbType.DateTime),
new SqlParameter("@EmbassyTime", SqlDbType.DateTime),
new SqlParameter("@InTime", SqlDbType.DateTime),
new SqlParameter("@OutTime", SqlDbType.DateTime),
new SqlParameter("@RealOut", SqlDbType.VarChar, 50),
new SqlParameter("@RealOutTime", SqlDbType.DateTime),
new SqlParameter("@Country", SqlDbType.VarChar, 50),
new SqlParameter("@Call", SqlDbType.VarChar, 50),
new SqlParameter("@outState", SqlDbType.VarChar, 12),
new SqlParameter("@Residence", SqlDbType.VarChar, 100),
new SqlParameter("@Occupation", SqlDbType.VarChar, 50),
new SqlParameter("@DepartureRecord", SqlDbType.VarChar, 10),
new SqlParameter("@Marriaged", SqlDbType.VarChar, 10),
new SqlParameter("@Identification", SqlDbType.VarChar, 100),
new SqlParameter("@FinancialCapacity", SqlDbType.VarChar, 100),
new SqlParameter("@AgencyOpinion", SqlDbType.VarChar, 20),
new SqlParameter("@HasTypeIn", SqlDbType.VarChar, 2),
new SqlParameter("@AbnormalOutTime", SqlDbType.DateTime),
new SqlParameter("@HasChecked", SqlDbType.VarChar, 2),
new SqlParameter("@CheckPerson", SqlDbType.VarChar, 50),
new SqlParameter("@ReturnTime", SqlDbType.DateTime)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.Visa_id;
parameters[2].Value = model.GroupNo;
parameters[3].Value = model.Name;
parameters[4].Value = model.EnglishName;
parameters[5].Value = model.Sex;
parameters[6].Value = model.Birthday;
parameters[7].Value = model.PassportNo;
parameters[8].Value = model.LicenceTime;
parameters[9].Value = model.ExpiryDate;
parameters[10].Value = model.Birthplace;
parameters[11].Value = model.IssuePlace;
parameters[12].Value = model.Post;
parameters[13].Value = model.Phone;
parameters[14].Value = model.GuideNo;
parameters[15].Value = model.Client;
parameters[16].Value = model.Salesperson;
parameters[17].Value = model.Types;
parameters[18].Value = Guid.NewGuid();
parameters[19].Value = Guid.NewGuid();
parameters[20].Value = model.Tips;
parameters[21].Value = model.EntryTime;
parameters[22].Value = model.EmbassyTime;
parameters[23].Value = model.InTime;
parameters[24].Value = model.OutTime;
parameters[25].Value = model.RealOut;
parameters[26].Value = model.RealOutTime;
parameters[27].Value = model.Country;
parameters[28].Value = model.Call;
parameters[29].Value = model.outState;
parameters[30].Value = model.Residence;
parameters[31].Value = model.Occupation;
parameters[32].Value = model.DepartureRecord;
parameters[33].Value = model.Marriaged;
parameters[34].Value = model.Identification;
parameters[35].Value = model.FinancialCapacity;
parameters[36].Value = model.AgencyOpinion;
parameters[37].Value = model.HasTypeIn;
parameters[38].Value = model.AbnormalOutTime;
parameters[39].Value = model.HasChecked;
parameters[40].Value = model.CheckPerson;
parameters[41].Value = model.ReturnTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelAgency.Model.VisaInfo_Tmp DataRowToModel(DataRow row)
{
TravelAgency.Model.VisaInfo_Tmp model = new TravelAgency.Model.VisaInfo_Tmp();
if (row != null)
{
if (row["VisaInfo_id"] != null && row["VisaInfo_id"].ToString() != "")
{
model.VisaInfo_id = new Guid(row["VisaInfo_id"].ToString());
}
if (row["Visa_id"] != null)
{
model.Visa_id = row["Visa_id"].ToString();
}
if (row["GroupNo"] != null)
{
model.GroupNo = row["GroupNo"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["EnglishName"] != null)
{
model.EnglishName = row["EnglishName"].ToString();
}
if (row["Sex"] != null)
{
model.Sex = row["Sex"].ToString();
}
if (row["Birthday"] != null && row["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(row["Birthday"].ToString());
}
if (row["PassportNo"] != null)
{
model.PassportNo = row["PassportNo"].ToString();
}
if (row["LicenceTime"] != null && row["LicenceTime"].ToString() != "")
{
model.LicenceTime = DateTime.Parse(row["LicenceTime"].ToString());
}
if (row["ExpiryDate"] != null && row["ExpiryDate"].ToString() != "")
{
model.ExpiryDate = DateTime.Parse(row["ExpiryDate"].ToString());
}
if (row["Birthplace"] != null)
{
model.Birthplace = row["Birthplace"].ToString();
}
if (row["IssuePlace"] != null)
{
model.IssuePlace = row["IssuePlace"].ToString();
}
if (row["Post"] != null)
{
model.Post = row["Post"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["GuideNo"] != null)
{
model.GuideNo = row["GuideNo"].ToString();
}
if (row["Client"] != null)
{
model.Client = row["Client"].ToString();
}
if (row["Salesperson"] != null)
{
model.Salesperson = row["Salesperson"].ToString();
}
if (row["Types"] != null)
{
model.Types = row["Types"].ToString();
}
if (row["Sale_id"] != null && row["Sale_id"].ToString() != "")
{
model.Sale_id = new Guid(row["Sale_id"].ToString());
}
if (row["DepartmentId"] != null && row["DepartmentId"].ToString() != "")
{
model.DepartmentId = new Guid(row["DepartmentId"].ToString());
}
if (row["Tips"] != null)
{
model.Tips = row["Tips"].ToString();
}
if (row["EntryTime"] != null && row["EntryTime"].ToString() != "")
{
model.EntryTime = DateTime.Parse(row["EntryTime"].ToString());
}
if (row["EmbassyTime"] != null && row["EmbassyTime"].ToString() != "")
{
model.EmbassyTime = DateTime.Parse(row["EmbassyTime"].ToString());
}
if (row["InTime"] != null && row["InTime"].ToString() != "")
{
model.InTime = DateTime.Parse(row["InTime"].ToString());
}
if (row["OutTime"] != null && row["OutTime"].ToString() != "")
{
model.OutTime = DateTime.Parse(row["OutTime"].ToString());
}
if (row["RealOut"] != null)
{
model.RealOut = row["RealOut"].ToString();
}
if (row["RealOutTime"] != null && row["RealOutTime"].ToString() != "")
{
model.RealOutTime = DateTime.Parse(row["RealOutTime"].ToString());
}
if (row["Country"] != null)
{
model.Country = row["Country"].ToString();
}
if (row["Call"] != null)
{
model.Call = row["Call"].ToString();
}
if (row["outState"] != null)
{
model.outState = row["outState"].ToString();
}
if (row["Residence"] != null)
{
model.Residence = row["Residence"].ToString();
}
if (row["Occupation"] != null)
{
model.Occupation = row["Occupation"].ToString();
}
if (row["DepartureRecord"] != null)
{
model.DepartureRecord = row["DepartureRecord"].ToString();
}
if (row["Marriaged"] != null)
{
model.Marriaged = row["Marriaged"].ToString();
}
if (row["Identification"] != null)
{
model.Identification = row["Identification"].ToString();
}
if (row["FinancialCapacity"] != null)
{
model.FinancialCapacity = row["FinancialCapacity"].ToString();
}
if (row["AgencyOpinion"] != null)
{
model.AgencyOpinion = row["AgencyOpinion"].ToString();
}
if (row["HasTypeIn"] != null)
{
model.HasTypeIn = row["HasTypeIn"].ToString();
}
if (row["AbnormalOutTime"] != null && row["AbnormalOutTime"].ToString() != "")
{
model.AbnormalOutTime = DateTime.Parse(row["AbnormalOutTime"].ToString());
}
if (row["HasChecked"] != null)
{
model.HasChecked = row["HasChecked"].ToString();
}
if (row["CheckPerson"] != null)
{
model.CheckPerson = row["CheckPerson"].ToString();
}
if (row["ReturnTime"] != null && row["ReturnTime"].ToString() != "")
{
model.ReturnTime = DateTime.Parse(row["ReturnTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TravelAgency.Model.VisaInfo_Tmp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update VisaInfo_Tmp set ");
strSql.Append("Visa_id=@Visa_id,");
strSql.Append("GroupNo=@GroupNo,");
strSql.Append("Name=@Name,");
strSql.Append("EnglishName=@EnglishName,");
strSql.Append("Sex=@Sex,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("PassportNo=@PassportNo,");
strSql.Append("LicenceTime=@LicenceTime,");
strSql.Append("ExpiryDate=@ExpiryDate,");
strSql.Append("Birthplace=@Birthplace,");
strSql.Append("IssuePlace=@IssuePlace,");
strSql.Append("Post=@Post,");
strSql.Append("Phone=@Phone,");
strSql.Append("GuideNo=@GuideNo,");
strSql.Append("Client=@Client,");
strSql.Append("Salesperson=@Salesperson,");
strSql.Append("Types=@Types,");
strSql.Append("Sale_id=@Sale_id,");
strSql.Append("DepartmentId=@DepartmentId,");
strSql.Append("Tips=@Tips,");
strSql.Append("EntryTime=@EntryTime,");
strSql.Append("EmbassyTime=@EmbassyTime,");
strSql.Append("InTime=@InTime,");
strSql.Append("OutTime=@OutTime,");
strSql.Append("RealOut=@RealOut,");
strSql.Append("RealOutTime=@RealOutTime,");
strSql.Append("Country=@Country,");
strSql.Append("Call=@Call,");
strSql.Append("outState=@outState,");
strSql.Append("Residence=@Residence,");
strSql.Append("Occupation=@Occupation,");
strSql.Append("DepartureRecord=@DepartureRecord,");
strSql.Append("Marriaged=@Marriaged,");
strSql.Append("Identification=@Identification,");
strSql.Append("FinancialCapacity=@FinancialCapacity,");
strSql.Append("AgencyOpinion=@AgencyOpinion,");
strSql.Append("HasTypeIn=@HasTypeIn,");
strSql.Append("AbnormalOutTime=@AbnormalOutTime,");
strSql.Append("HasChecked=@HasChecked,");
strSql.Append("CheckPerson=@CheckPerson,");
strSql.Append("ReturnTime=@ReturnTime");
strSql.Append(" where VisaInfo_id=@VisaInfo_id ");
SqlParameter[] parameters =
{
new SqlParameter("@Visa_id", SqlDbType.VarChar, 50),
new SqlParameter("@GroupNo", SqlDbType.VarChar, 500),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@EnglishName", SqlDbType.VarChar, 50),
new SqlParameter("@Sex", SqlDbType.VarChar, 50),
new SqlParameter("@Birthday", SqlDbType.DateTime, 3),
new SqlParameter("@PassportNo", SqlDbType.VarChar, 50),
new SqlParameter("@LicenceTime", SqlDbType.DateTime, 3),
new SqlParameter("@ExpiryDate", SqlDbType.DateTime, 3),
new SqlParameter("@Birthplace", SqlDbType.VarChar, 50),
new SqlParameter("@IssuePlace", SqlDbType.VarChar, 50),
new SqlParameter("@Post", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@GuideNo", SqlDbType.VarChar, 50),
new SqlParameter("@Client", SqlDbType.VarChar, 50),
new SqlParameter("@Salesperson", SqlDbType.VarChar, 50),
new SqlParameter("@Types", SqlDbType.VarChar, 50),
new SqlParameter("@Sale_id", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@DepartmentId", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Tips", SqlDbType.VarChar, -1),
new SqlParameter("@EntryTime", SqlDbType.DateTime),
new SqlParameter("@EmbassyTime", SqlDbType.DateTime),
new SqlParameter("@InTime", SqlDbType.DateTime),
new SqlParameter("@OutTime", SqlDbType.DateTime),
new SqlParameter("@RealOut", SqlDbType.VarChar, 50),
new SqlParameter("@RealOutTime", SqlDbType.DateTime),
new SqlParameter("@Country", SqlDbType.VarChar, 50),
new SqlParameter("@Call", SqlDbType.VarChar, 50),
new SqlParameter("@outState", SqlDbType.VarChar, 12),
new SqlParameter("@Residence", SqlDbType.VarChar, 100),
new SqlParameter("@Occupation", SqlDbType.VarChar, 50),
new SqlParameter("@DepartureRecord", SqlDbType.VarChar, 10),
new SqlParameter("@Marriaged", SqlDbType.VarChar, 10),
new SqlParameter("@Identification", SqlDbType.VarChar, 100),
new SqlParameter("@FinancialCapacity", SqlDbType.VarChar, 100),
new SqlParameter("@AgencyOpinion", SqlDbType.VarChar, 20),
new SqlParameter("@HasTypeIn", SqlDbType.VarChar, 2),
new SqlParameter("@AbnormalOutTime", SqlDbType.DateTime),
new SqlParameter("@HasChecked", SqlDbType.VarChar, 2),
new SqlParameter("@CheckPerson", SqlDbType.VarChar, 50),
new SqlParameter("@ReturnTime", SqlDbType.DateTime),
new SqlParameter("@VisaInfo_id", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = model.Visa_id;
parameters[1].Value = model.GroupNo;
parameters[2].Value = model.Name;
parameters[3].Value = model.EnglishName;
parameters[4].Value = model.Sex;
parameters[5].Value = model.Birthday;
parameters[6].Value = model.PassportNo;
parameters[7].Value = model.LicenceTime;
parameters[8].Value = model.ExpiryDate;
parameters[9].Value = model.Birthplace;
parameters[10].Value = model.IssuePlace;
parameters[11].Value = model.Post;
parameters[12].Value = model.Phone;
parameters[13].Value = model.GuideNo;
parameters[14].Value = model.Client;
parameters[15].Value = model.Salesperson;
parameters[16].Value = model.Types;
parameters[17].Value = model.Sale_id;
parameters[18].Value = model.DepartmentId;
parameters[19].Value = model.Tips;
parameters[20].Value = model.EntryTime;
parameters[21].Value = model.EmbassyTime;
parameters[22].Value = model.InTime;
parameters[23].Value = model.OutTime;
parameters[24].Value = model.RealOut;
parameters[25].Value = model.RealOutTime;
parameters[26].Value = model.Country;
parameters[27].Value = model.Call;
parameters[28].Value = model.outState;
parameters[29].Value = model.Residence;
parameters[30].Value = model.Occupation;
parameters[31].Value = model.DepartureRecord;
parameters[32].Value = model.Marriaged;
parameters[33].Value = model.Identification;
parameters[34].Value = model.FinancialCapacity;
parameters[35].Value = model.AgencyOpinion;
parameters[36].Value = model.HasTypeIn;
parameters[37].Value = model.AbnormalOutTime;
parameters[38].Value = model.HasChecked;
parameters[39].Value = model.CheckPerson;
parameters[40].Value = model.ReturnTime;
parameters[41].Value = model.VisaInfo_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
