How to Use Codebuider 2

Check the Code:
Generated Stored Procedure

Sp_Flow_GetDocumentStatusByStaff # region sp_Flow_GetDocumentStatusByStaff
Pulic void Exec_sp_Flow_GetDocumentStatusByStaff (int staff_id, int docid ,)
{
DataBase db = new DataBase ();
DataTable dt = null;
IDbDataParameter [] para = {
Db. MakeInParam ("@ staff_id", Int32, staff_id ),
Db. MakeInParam ("@ DocID", Int32, DocID ),
}
Try
{
Dt = db. SpExecuteDataTable ("sp_Flow_GetDocumentStatusByStaff", para );
}
Catch (System. Exception ex)
{
Dt = null;
Throw new Exception ("an error occurred! ", Ex );
}
Return dt;
}
# Endregion

There are a lot of problems with this generation, and it will be known to be wrong when you look at the code, but it can take out the parameters in the stored procedure, and you can make necessary modifications when writing; dataBase is my encapsulated class, which is downloaded by me.

Here are some assignment operations: // *********************************** value assignment 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 ();
// *********************************** Value assignment 1 ************************************
// *********************************** Value assignment 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;
// *********************************** Value assignment 2 **************************************

This code is used to be lazy.