/// <summary>
/// 把datatable某行的值，生成insert的SQL语句
/// </summary>
/// <param name="dt"></param>
/// <param name="as_tablename"></param>
/// <param name="ai_row"></param>
/// <returns></returns>
public static string of_InsertToTable(DataTable dt, string as_tablename, DataRow dr,out GysoftParameter[] ap_value)
{
ErrStr = "";
if (dt == null)
{
ap_value = new GysoftParameter[1];
return "";
}
ap_value = new GysoftParameter[dt.Columns.Count];
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable(as_tablename);
string ls_step = "1";
string ls_rc="";
try
{
ls_step = "2";
for (int li_col = 0; li_col < dt.Columns.Count; li_col++)
{
string ls_colName;
ls_colName = dt.Columns[li_col].ColumnName.ToString();
lnv_sql.of_AddCol(ls_colName, "@" + ls_colName);
ap_value[li_col] = new GysoftParameter();
ap_value[li_col].PaName = ls_colName;
ap_value[li_col].Value = dr[li_col].ToString();
}
ls_step = "3";
ls_rc = lnv_sql.of_GetInsertSQL();
ls_step = "4";
}
catch (Exception ex)
{
ErrStr =ls_step+" "+ ex.ToString();
}
return ls_rc;
}
public static string of_InsertToTable(DataTable dt, string as_tablename, DataRow dr)
{
ErrStr = "";
if (dt == null)
{
return "";
}
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable(as_tablename);
string ls_step = "1";
string ls_rc = "";
try
{
ls_step = "2";
for (int li_col = 0; li_col < dt.Columns.Count; li_col++)
{
string ls_colName;
ls_colName = dt.Columns[li_col].ColumnName.ToString();
string ls_value;
ls_value = dr[li_col].ToString();
ls_value = ls_value.Replace("'", "''");
lnv_sql.of_AddCol(ls_colName, ls_value);
}
ls_step = "3";
ls_rc = lnv_sql.of_GetInsertSQL();
ls_step = "4";
}
catch (Exception ex)
{
ErrStr = ls_step + " " + ex.ToString();
}
return ls_rc;
}
/// <summary>
/// 把datatable某行的值，生成insert的SQL语句
/// </summary>
/// <param name="dt"></param>
/// <param name="as_tablename"></param>
/// <param name="ai_row"></param>
/// <returns></returns>
public static string of_InsertToTable(DataTable dt, string as_tablename, int ai_row, out GysoftParameter[] ap_value)
{
ErrStr = "";
if (dt == null)
{
ap_value = new GysoftParameter[1];
return "";
}
if (ai_row>=dt.Rows.Count)
{
ap_value = new GysoftParameter[1];
return "";
}
ap_value = new GysoftParameter[dt.Columns.Count];
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable(as_tablename);
for (int li_col = 0; li_col < dt.Columns.Count; li_col++)
{
string ls_colName;
ls_colName = dt.Columns[li_col].ColumnName.ToString();
lnv_sql.of_AddCol(ls_colName, "@" + ls_colName);
ap_value[li_col].PaName = ls_colName;
ap_value[li_col].Value = dt.Rows[ai_row][li_col].ToString();
}
string ls_rc;
ls_rc = lnv_sql.of_GetInsertSQL();
return ls_rc;
}