WPF之新增
新增数据:要获取下拉框、文本框、日期。这三种的值:
下拉框获取方式:下拉框的Name值.SelectedValue
文本框获取方式: 文本框的Name值.Text
日期框获取方式:密码框的Name值.Text.ToString
然后去看数据库SQL的新增语句
数据库新增字段要和客户端的字段保持一致。
然后去服务层是固定写法,都是有SQL多少参数,你就要写多少参数。
//OperationContract(操作契约)是WCF契约的类型
[OperationContract]
#region 新增旅客资料
public int btn_Affirm_Click_InsertTraveller(int intas_certificate_type_id, int intuser_id, int intas_passenger_type_id,string struser_name, int intas_gender_id, DateTime date_of_birth, string strage, string strcountry_or_region,string strcertificate_number, string strphone_number, string stremergency_phone, string straddress, string stremergency_address,string strzip_code, DateTime register_date)
{
SqlParameter[] SQLCMDpas ={
new SqlParameter ("@Type",SqlDbType.Char),
new SqlParameter ("@as_certificate_type_id",SqlDbType.Int),
new SqlParameter ("@user_id",SqlDbType.Int),
new SqlParameter ("@as_passenger_type_id",SqlDbType.Int),
new SqlParameter ("@user_name",SqlDbType.Char),
new SqlParameter ("@as_gender_id",SqlDbType.Int),
new SqlParameter ("@date_of_birth",SqlDbType.DateTime),
new SqlParameter ("@age",SqlDbType.Char),
new SqlParameter ("@country_or_region",SqlDbType.Char),
new SqlParameter ("@certificate_number",SqlDbType.Char),
new SqlParameter ("@phone_number",SqlDbType.Char),
new SqlParameter ("@emergency_phone",SqlDbType.Char),
new SqlParameter ("@address",SqlDbType.Char),
new SqlParameter ("@emergency_address",SqlDbType.Char),
new SqlParameter ("@zip_code",SqlDbType.Char),
new SqlParameter ("@register_date",SqlDbType.DateTime),
};
SQLCMDpas[0].Value = "btn_Affirm_Click_InsertTraveller";
SQLCMDpas[1].Value = intas_certificate_type_id;
SQLCMDpas[2].Value = intuser_id;
SQLCMDpas[3].Value = intas_passenger_type_id;
SQLCMDpas[4].Value = struser_name;
SQLCMDpas[5].Value = intas_gender_id;
SQLCMDpas[6].Value = date_of_birth;
SQLCMDpas[7].Value = strage;
SQLCMDpas[8].Value = strcountry_or_region;
SQLCMDpas[9].Value = strcertificate_number;
SQLCMDpas[10].Value = strphone_number;
SQLCMDpas[11].Value = stremergency_phone;
SQLCMDpas[12].Value = straddress;
SQLCMDpas[13].Value = stremergency_address;
SQLCMDpas[14].Value = strzip_code;
SQLCMDpas[15].Value = register_date;
int count = myDALMethod.UpdateData("FRM_TravellerInformation", SQLCMDpas);
return count;
}
#endregion
然后要更新客户端的对应服务:实例化服务之后,调用服务:
int count = myClient.btn_Affirm_Click_InsertTraveller(intas_certificate_type_id,intuser_id, intas_passenger_type_id, struser_name, intas_gender_id, date_of_birth, strage,strcountry_or_region, strcertificate_number, strphone_number, stremergency_phone, straddress,stremergency_address, strzip_code, register_date);
参数要一模一样。