C # automatically extract the variable name with @ from SQL to obtain the generated sqlparameter array from the simple data object for data insertion (Using Reflection)

Source: Internet
Author: User

C # automatically extract the variable name with @ from SQL to obtain the generated sqlparameter array from the simple data object for data insertion



// Automatically obtain the @ variable in SQL, generate the sqlparameter array, and obtain the required variable value in SQL from a simple data object.

Public class zidonggetsqlpara
{
# Region Public static object [] getpararr (string strsql, object dataobj)
/// <Summary>
/// Use the sqlparameter array for database operation SQL
/// </Summary>
/// <Param name = "strsql"> SQL statement </param>
/// <Param name = "dataobj"> objects stored in variable data for SQL query </param>
/// <Returns> sqlparameter array </returns>
Public static object [] getpararr (string strsql, object dataobj)
{

Object [] retobj = new object [1];
// String strsql = "Update tablname set tb_password = @ tb_password where tb_password = @ oldtb_password and tb_username = @ tb_username where dd = @ DD and @ f_ff = dfffddd and @ Chinese field name = T chinese field name f and @ resr = @ etet222 ";
RegEx Rg = new RegEx ("@ [^, \ t/=) (;-] *", regexoptions. ignorecase );
Matchcollection matcol = RG. Matches (strsql );
Sqlparameter [] sqlpararr = new sqlparameter [matcol. Count];
Int I = 0;
Foreach (match MT in matcol)
{
Sqlpararr [I ++] = new sqlparameter (mt. Value, getfieldvalue (mt. value. tostring (). trimstart ('@'), dataobj ));
}
Retobj [0] = sqlpararr;
Return retobj;
}
# Endregion

# Region Public static string getfieldvalue (string strobjname, object dataobj) Get the variable or attribute name specified in the specified object
/// <Summary>
/// Get the variable or attribute name specified in the specified object
/// </Summary>
/// <Param name = "strobjname"> variable or attribute name </param>
/// <Param name = "dataobj"> Object </param>
/// <Returns> </returns>
Public static string getfieldvalue (string strobjname, object dataobj)
{
String strret = "";
Type T = dataobj. GetType ();
If (T. fullname. tostring (). Equals ("system. Collections. hashtable "))
{
Strret = convert. tostring (hashtable) dataobj) [strobjname]);
}
Else
{
Propertyinfo method_1 = T. getproperty (strobjname); // method name
If (method_1! = NULL)
{
Strret = convert. tostring (method_1.getgetmethod (). Invoke (dataobj, null); // obtain the attribute value
}
Else
{
Fieldinfo Fi = T. getfield (strobjname); // get the variable Field object
If (Fi! = NULL)
{
Strret = convert. tostring (Fi. getvalue (dataobj); // obtain the variable value
}
}
}
Return strret;
}
# Endregion

# Region Public static int datainsert (string strsql, string databeanobj) data insertion
///


// data insertion
///
/// insert SQL
// insert SQL to store objects with variables
//
Public static int datainsert (string strsql, object databeanobj)
{< br> int iret = 0;
sqlparameter [] sqlpararr = getpararr (strsql, databeanobj) [0] As sqlparameter [];
sqlhelper. executenonquery (sqlhelper. connectionstring, commandtype. text, strsql, sqlpararr);
return iret;
}< BR ># endregion

}

// Simple data object class

Public class logshow
{
// Pkid, Pcontent, createdate, errmesssge
Private string _ Pcontent;

Public String Pcontent
{
Get {return _ Pcontent ;}
Set {_ Pcontent = value ;}
}
Private string _ errmesssge;

Public String errmesssge
{
Get {return _ errmesssge ;}
Set {_ errmesssge = value ;}
}

}

// TestCode

Logshow logshowdatabean = new logshow ();
Logshowdatabean. errmesssge = "http://www.my400800.cn ";
Logshowdatabean. Pcontent = "http://www.my400800.cn is a good site. ";
Zidonggetsqlpara. datainsert ("insert into tb_log (Pcontent, errmesssge) values (@ Pcontent, @ errmesssge)", logshowdatabean );

// Reference to be added

Using system;
Using system. Data;
Using system. configuration;
Using system. collections;
Using system. Web;
Using system. Web. Security;
Using system. Web. UI;
Using system. Web. UI. webcontrols;
Using system. Web. UI. webcontrols. webparts;
Using system. Web. UI. htmlcontrols;
Using system. reflection;
Using system. Data. sqlclient;
Using system. text;
Using system. Text. regularexpressions;
Using fjt. dbutility;

// Obtain the value of the SQL variable based on the simple data object

Zidonggetsqlpara. getfieldvalue ("strpri1", T1 );
Zidonggetsqlpara. getfieldvalue ("strpri2", T1 );
Zidonggetsqlpara. getfieldvalue ("strgetsettest", T1 );

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.