//往择偶表插入数据
public int InsertIntoChoose(choose mychoose)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, mychoose.username),
data.MakeInParam("@Csex", SqlDbType.VarChar, 50, mychoose.csex),
data.MakeInParam("@Option1", SqlDbType.VarChar, 50, mychoose.option1),
data.MakeInParam("@Option2", SqlDbType.VarChar, 50, mychoose.option2),
data.MakeInParam("@Option3", SqlDbType.VarChar, 50, mychoose.option3),
data.MakeInParam("@Option4", SqlDbType.VarChar, 50, mychoose.option4),
data.MakeInParam("@Option5", SqlDbType.VarChar, 50, mychoose.option5),
data.MakeInParam("@Option6", SqlDbType.VarChar, 50, mychoose.option6),
data.MakeInParam("@Option7", SqlDbType.VarChar, 50, mychoose.option7),
data.MakeInParam("@Option8", SqlDbType.VarChar, 50, mychoose.option8),
data.MakeInParam("@Option9", SqlDbType.VarChar, 50, mychoose.option9),
data.MakeInParam("@Option10", SqlDbType.VarChar, 50, mychoose.option10),
data.MakeInParam("@Option11", SqlDbType.VarChar, 50, mychoose.option11),
data.MakeInParam("@Option12", SqlDbType.VarChar, 50, mychoose.option12),
data.MakeInParam("@Age", SqlDbType.Int, 32, mychoose.age),
data.MakeInParam("@Marriagestatus", SqlDbType.VarChar, 50, mychoose.marriagestatus),
data.MakeInParam("@Height", SqlDbType.Int, 32, mychoose.height),
data.MakeInParam("@Locationarea", SqlDbType.VarChar, 50, mychoose.locationarea),
data.MakeInParam("@Ishasimage", SqlDbType.VarChar, 50, mychoose.ishasimage),
data.MakeInParam("@Salary", SqlDbType.VarChar, 50, mychoose.salary),
data.MakeInParam("@Degree", SqlDbType.VarChar, 50, mychoose.degree)
};
return(data.RunProc("insert into choose(username,csex,option1,option2,option3,option4,option5,option6,option7,option8,option9,option10,option11,option12,age,height,degree,marriagestatus,locationarea,ishasimage,salary) values(@UserName,@Csex,@Optioin1,@Optioin2,@Optioin3,@Optioin4,@Optioin5,@Optioin6,@Optioin7,@Optioin8,@Optioin9,@Optioin10,@Optioin11,@Optioin12,@Age,@Height,@Degree,@Marriagestatus,@Locationarea,@Ishasimage,@Salary)", parms));
}
//编辑择偶表数据
public int UpdateChoose(choose mychoose)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, mychoose.username),
data.MakeInParam("@Csex", SqlDbType.VarChar, 50, mychoose.csex),
data.MakeInParam("@Option1", SqlDbType.VarChar, 50, mychoose.option1),
data.MakeInParam("@Option2", SqlDbType.VarChar, 50, mychoose.option2),
data.MakeInParam("@Option3", SqlDbType.VarChar, 50, mychoose.option3),
data.MakeInParam("@Option4", SqlDbType.VarChar, 50, mychoose.option4),
data.MakeInParam("@Option5", SqlDbType.VarChar, 50, mychoose.option5),
data.MakeInParam("@Option6", SqlDbType.VarChar, 50, mychoose.option6),
data.MakeInParam("@Option7", SqlDbType.VarChar, 50, mychoose.option7),
data.MakeInParam("@Option8", SqlDbType.VarChar, 50, mychoose.option8),
data.MakeInParam("@Option9", SqlDbType.VarChar, 50, mychoose.option9),
data.MakeInParam("@Option10", SqlDbType.VarChar, 50, mychoose.option10),
data.MakeInParam("@Option11", SqlDbType.VarChar, 50, mychoose.option11),
data.MakeInParam("@Option12", SqlDbType.VarChar, 50, mychoose.option12),
data.MakeInParam("@Age", SqlDbType.Int, 32, mychoose.age),
data.MakeInParam("@Marriagestatus", SqlDbType.VarChar, 50, mychoose.marriagestatus),
data.MakeInParam("@Height", SqlDbType.Int, 32, mychoose.height),
data.MakeInParam("@Locationarea", SqlDbType.VarChar, 50, mychoose.locationarea),
data.MakeInParam("@Ishasimage", SqlDbType.VarChar, 50, mychoose.ishasimage),
data.MakeInParam("@Salary", SqlDbType.VarChar, 50, mychoose.salary),
data.MakeInParam("@Degree", SqlDbType.VarChar, 50, mychoose.degree)
};
return(data.RunProc("update choose set username=@UserName,csex=@Csex,option1=@Option1,option2=@Option2,option3=@Option3,option4=@Option4,option5=@Option5,option6=@Option6,option7=@Option7,option8=@Option8,option9=@Option9,option10=@Option10,option11=@Option11,option12=@Option12,age=@Age,height=@Height,degree=@Degree,marriagestatus=@Marriagestatus,locationarea=@Locationarea,ishasimage=@Ishasimage,salary=@Salary where username=@UserName", parms));
}
//查看择偶表数据
public DataSet SelectChoose(choose mychoose)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, mychoose.username)
};
return(data.RunProcReturn("select * from choose where username=@UserName", parms, "choose"));
}
public void SetMatchOption(choose mychoose)
{
csex = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["csex"].ToString();
option1 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option1"].ToString();
option2 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option2"].ToString();
option3 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option3"].ToString();
option4 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option4"].ToString();
option5 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option5"].ToString();
option6 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option6"].ToString();
option7 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option7"].ToString();
option8 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option8"].ToString();
option9 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option9"].ToString();
option10 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option10"].ToString();
option11 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option11"].ToString();
option12 = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["option12"].ToString();
age = Convert.ToInt32(mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["age"]);
marriagestatus = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["marriagestatus"].ToString();
degree = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["degree"].ToString();
height = Convert.ToInt32(mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["height"]);
locationarea = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["locationarea"].ToString();
ishaiimage = mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["ishasimage"].ToString();
salary = Convert.ToInt32(mychoose.SelectChoose(mychoose).Tables[0].Rows[0]["salary"]);
}
void Start()
{
bg = GetComponent <Image>();
bg.color = Color.white;
cm = GetComponentInParent <choose>();
}
