Codebuider使用方法2
看代码:
生成的存储过程
sp_Flow_GetDocumentStatusByStaff
这个生成有很多的问题,一看代码就知道是错误的,但是它可以把存储过程里的参数取出来,大家写的时候可以做必要的修改;DataBase是我封装的类,在我下载的里面。
下面是一些赋值操作:
//*************************************赋值1**************************************
employee1.Staff_Name = this.txt_Staff_Name.Text.Trim();
employee1.Password = this.txt_Password.Text.Trim();
employee1.RealName = this.txt_RealName.Text.Trim();
employee1.Sex = this.txt_Sex.Text.Trim();
employee1.Email = this.txt_Email.Text.Trim();
employee1.Status = this.txt_Status.Text.Trim();
employee1.RegistedDate = this.txt_RegistedDate.Text.Trim();
employee1.Dimission = this.txt_Dimission.Text.Trim();
employee1.Phone = this.txt_Phone.Text.Trim();
employee1.Mobile = this.txt_Mobile.Text.Trim();
employee1.Birthday = this.txt_Birthday.Text.Trim();
employee1.Style = this.txt_Style.Text.Trim();
employee1.IsNeedKey = this.txt_IsNeedKey.Text.Trim();
employee1.Caste = this.txt_Caste.Text.Trim();
employee1.PostionID = this.txt_PostionID.Text.Trim();
//*************************************赋值1************************************
//*************************************赋值2************************************
this.txt_Staff_Name.Text = employee1.Staff_Name;
this.txt_Password.Text = employee1.Password;
this.txt_RealName.Text = employee1.RealName;
this.txt_Sex.Text = employee1.Sex;
this.txt_Email.Text = employee1.Email;
this.txt_Status.Text = employee1.Status;
this.txt_RegistedDate.Text = employee1.RegistedDate;
this.txt_Dimission.Text = employee1.Dimission;
this.txt_Phone.Text = employee1.Phone;
this.txt_Mobile.Text = employee1.Mobile;
this.txt_Birthday.Text = employee1.Birthday;
this.txt_Style.Text = employee1.Style;
this.txt_IsNeedKey.Text = employee1.IsNeedKey;
this.txt_Caste.Text = employee1.Caste;
this.txt_PostionID.Text = employee1.PostionID;
//*************************************赋值2**************************************
employee1.Staff_Name = this.txt_Staff_Name.Text.Trim();
employee1.Password = this.txt_Password.Text.Trim();
employee1.RealName = this.txt_RealName.Text.Trim();
employee1.Sex = this.txt_Sex.Text.Trim();
employee1.Email = this.txt_Email.Text.Trim();
employee1.Status = this.txt_Status.Text.Trim();
employee1.RegistedDate = this.txt_RegistedDate.Text.Trim();
employee1.Dimission = this.txt_Dimission.Text.Trim();
employee1.Phone = this.txt_Phone.Text.Trim();
employee1.Mobile = this.txt_Mobile.Text.Trim();
employee1.Birthday = this.txt_Birthday.Text.Trim();
employee1.Style = this.txt_Style.Text.Trim();
employee1.IsNeedKey = this.txt_IsNeedKey.Text.Trim();
employee1.Caste = this.txt_Caste.Text.Trim();
employee1.PostionID = this.txt_PostionID.Text.Trim();
//*************************************赋值1************************************
//*************************************赋值2************************************
this.txt_Staff_Name.Text = employee1.Staff_Name;
this.txt_Password.Text = employee1.Password;
this.txt_RealName.Text = employee1.RealName;
this.txt_Sex.Text = employee1.Sex;
this.txt_Email.Text = employee1.Email;
this.txt_Status.Text = employee1.Status;
this.txt_RegistedDate.Text = employee1.RegistedDate;
this.txt_Dimission.Text = employee1.Dimission;
this.txt_Phone.Text = employee1.Phone;
this.txt_Mobile.Text = employee1.Mobile;
this.txt_Birthday.Text = employee1.Birthday;
this.txt_Style.Text = employee1.Style;
this.txt_IsNeedKey.Text = employee1.IsNeedKey;
this.txt_Caste.Text = employee1.Caste;
this.txt_PostionID.Text = employee1.PostionID;
//*************************************赋值2**************************************
这段代码是用来偷懒的,呵呵