第C#實現(xiàn)表格數(shù)據(jù)轉(zhuǎn)實體的示例代碼get{return"\t\t"+string.Join("",Modifier,Type+(IsNull"":""),FieldName,Property);}

}

publicpartialclassForm_ToEntity:Form

BindingListEntitybindData=newBindingListEntity

publicForm_ToEntity()

InitializeComponent();

privatevoidForm_ToEntity_Load(objectsender,EventArgse)

string[]types=newstring[]{

"string",

"decimal",

"double",

"int",

"bool",

"long"

DataGridViewComboBoxColumndgvComboBox=Column2asDataGridViewComboBoxColumn;

dgvComboBox.Items.AddRange(types);

dataGridView1.DataSource=bindData;

#region處理點擊選中著色

privatevoiddataGridView1_ColumnHeaderMouseClick(objectsender,DataGridViewCellMouseEventArgse)

DataGridViewColumnselectColumn=dataGridView1.Columns[e.ColumnIndex];

Colorcolor=selectColumn.DefaultCellStyle.BackColor==Color.LightGrayColor.White:Color.LightGray;

selectColumn.DefaultCellStyle.BackColor=color;

selectColumn.HeaderCell.Style.BackColor=color;

selectColumn.Tag=color;

privatevoiddataGridView1_CellPainting(objectsender,DataGridViewCellPaintingEventArgse)

if(e.RowIndex==-1e.ColumnIndex-1)

DataGridViewColumnselectColumn=dataGridView1.Columns[e.ColumnIndex];

Colorcolor=selectColumn.Tag==nullColor.White:(Color)selectColumn.Tag;

e.CellStyle.BackColor=color;

#endregion

///summary

///獲取剪切板數(shù)據(jù)

////summary

///paramname="sender"/param

///paramname="e"/param

privatevoiddataGridView1_KeyDown(objectsender,KeyEventArgse)

if(e.Controle.KeyCode==Keys.V)

stringtext=Clipboard.GetText();

if(string.IsNullOrWhiteSpace(text))

return;

string[]clipData=text.Split(newstring[]{"\r\n"},StringSplitOptions.RemoveEmptyEntries);

bindData=Clip2Entity(clipData);

dataGridView1.DataSource=newBindingListEntity(bindData);

catch(Exceptionex)

MessageBox.Show(ex.Message);

///summary

///將剪切板數(shù)據(jù)轉(zhuǎn)換為表格數(shù)據(jù)

////summary

///paramname="data"/param

///returns/returns

privateBindingListEntityClip2Entity(string[]data)

BindingListEntitylist=newBindingListEntity

foreach(stringsindata)

Entityentity=newEntity();

string[]arr=s.Split('\t');

if(arr.Length==2)

//選中名稱和類型

if(isCheck(dataGridView1.Columns[0])isCheck(dataGridView1.Columns[1]))

=arr[0];

entity.type=arr[1].ToLower();

entity.remark="";

//選中名稱和備注

if(isCheck(dataGridView1.Columns[0])isCheck(dataGridView1.Columns[2]))

=arr[0];

entity.type="string";

entity.remark=arr[1];

//選中類型和備注

if(isCheck(dataGridView1.Columns[1])isCheck(dataGridView1.Columns[2]))

="";

entity.type=arr[0].ToLower();

entity.remark=arr[1];

elseif(arr.Length==3)

=arr[0];

entity.type=arr[1].ToLower();

entity.remark=arr[2];

else

if(isCheck(dataGridView1.Columns[0]))

=s;

entity.type="string";

entity.remark="";

elseif(isCheck(dataGridView1.Columns[1]))

="";

entity.type=s.ToLower();

entity.remark="";

elseif(isCheck(dataGridView1.Columns[2]))

="";

entity.type="string";

entity.remark=s;

list.Add(entity);

returnlist;

///summary

///判斷列是否被選中

////summary

///paramname="column"/param

///returns/returns

privateboolisCheck(DataGridViewColumncolumn)

if(column.DefaultCellStyle.BackColor==Color.LightGray)

returntrue;

else

returnfalse;

privateclassEntity

publicstringname{get;set;}

publicstringtype{get;set;}

publicstringremark{get;set;}

privatevoidbtn_add_Click(objectsender,EventArgse)

bindData.Add(newEntity

type="string"

privatevoidbtn_delete_Click(objectsender,EventArgse)

foreach(DataGridViewRowrowindataGridView1.SelectedRows)

dataGridView1.Rows.Remove(row);

privatevoidbtn_generate_Click(objectsender,EventArgse)

StringBuilderstringBuilder=newStringBuilder();

foreach(EntityentityinbindData)

GeneratorFieldModelfield=newGeneratorFieldModel

FieldName=,

FieldDesc=entity.remark,

Type=entity.type

stringBuilder.AppendLine(field.FieldDescText);

stringBuilder.AppendLine(field.PropertyText);

stringpath=Application.StartupPath+"\\entity.txt";

File.WriteAllText(path,stringBuilder.ToString());

Proces