C#-.Net前端

C#

Grid

string columns = "列1,列2,列3,列4,列5,列6，列7";
mainGrid.Column(1).CellType = FlexCell.CellTypeEnum.CheckBox;//列1：选择 （1选中，0不选）
GridHelper.loadGrid<Entity>(columns, new int[] { 7 }, mainListRight, false, mainGrid);//加载list，隐藏列7

mainGrid.Selection.FirstRow //mainGrid选中的第一行
mainGrid.Selection.LastRow;//mainGrid选中的最后一行

mainGrid.AutoRedraw = false;//重画，可在加载数据前关闭，加载完后打开
mainGrid.AutoRedraw = true;

mainGrid.Refresh();//刷新
mainGrid.Rows = 1;//清空内容  行0为标题，数据行从1开始，Rows数包含标题

mainGrid.AllowUserResizing = FlexCell.ResizeEnum.Both;//允许用户调整行高和列宽
mainGrid.Column(i).AutoFit();//自适应列宽
mainGrid.Row(i).AutoFit();//自适应行高

mainGrid.Cell(row,colum).Text;//单元格内容，string类型
//属性：SelectionMode ByRow

杂项

string createuser = Statics.serviceinfo.username;//获取当前登录用户名

string.IsNullOrEmpty(item);//判断item是否为空
list.Contains(check);      //判断list是否包含check

Decimal.Parse(vsNum.ToString()) //string 转 decimal

请求参数与返回值

/**传入值**/
string param = ConvertBaseTools.FromEntityToJson<Entity>(entity);  			//传入：entity
string param = ConvertBaseTools.FromEntitylistToJson<Entity>(entityList);   //传入：list
/**返回值**/
RespReturnData<Entity> result = service.CallRestfulGETData<Entity>(url);//返回：entity
RespReturnOptFlag result = service.CallRestfulPost(url, param, "POST");//无返回值
RespReturnDataList<Entity> resultList = service.CallRestfulPostData<Entity>(url, param, "POST");//返回：list

文件下载与导入导出

/**文件下载***/
private void tsb_download_Click(object sender, EventArgs e)
{
    SaveFileDialog saveFileDialog = new SaveFileDialog();    				
    saveFileDialog.Filter = " xml files(*.xml)|*.xml|All files(*.*)|*.*";   //设置文件类型  
    saveFileDialog.FilterIndex = 1; 										//设置默认文件类型显示顺序  
    saveFileDialog.RestoreDirectory = true;									//保存对话框是否记忆上次打开的目录  
    saveFileDialog.FileName = "导入模板.xml";					//文件名称
    string str = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\ExportModel\\模板.xml";
    //点了保存按钮进入 
    if (!File.Exists(str))
    {
        MessageBox.Show("导入模板不存在！", "标题", MessageBoxButtons.OK, MessageBoxIcon.Warning);
        return;
    }
    if (saveFileDialog.ShowDialog() == DialogResult.OK)
    {
        File.Copy(str, saveFileDialog.FileName, true);//保存 
        MessageBox.Show("下载成功！");
    }
}
/**导入**/
List<Entity> list = XMLExcelService.XMLBaseDataTableImport<Entity>();//自动匹配xml文件列与Entity实体属性
if (list.Count > 0)
{
    MessageBox.Show("导入成功");
}
else
{
    MessageBox.Show("导入数据为空");
}
/**导出-利用Grid的导出函数导出**/
#region 按钮-导出
private void tab_export_Click(object sender, EventArgs e)
{
	try
	{
		if(MainGrid.Rows<=1)
		{
			throw new Exception("没有可导出的数据");
		}
		SaveFileDialog fileDialog = new SaveFileDialog();
		fileDialog.Title = "导出Excel";
		fileDialog.Filter = "Excel文件(*.xls)|*.xls";
		DialogResult dialogResult = fileDialog.ShowDialog(this);
		if (dialogResult == DialogResult.OK)
        {
			MainGrid.ExportToExcel(fileDialog.FileName, true, false);  //名称，是否包含表头，是否包含序号
			MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
    }
	catch (Exception ex)
	{
		MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
	}
}
#endregion

list

void gather()
        {
            mainListLeft.Clear();
            var query = from item in mainList
                        group item by new { item.productCode, item.productName, item.number, } into g
                        select new Entity
                        {
                            productCode = g.Key.productCode,
                            productName = g.Key.productName,
                            number = g.Sum(p => p.number),    //number 为 decimal 类型
                        };
            mainListLeft = query.ToList();
        }

分页

/**分页查询  分页控件：pageControls1**/
int nMax = 0; 
int pagesize = pageControls1.PageSize;
int current = pageControls1.PageIndex - 1;
int nextpage = current + 1;
pageControls1.URL = XMLOperatorClass.GetUrl("SpMatExtendManage_selectByPage");
InitData((pagesize * current).ToString(), pagesize.ToString());
this.mainGrid.AllowUserResizing = FlexCell.ResizeEnum.Both;
/**请求后台**/
private void InitData(string start, string pagesize)
{
    ServiceClass service = new ServiceClass();
    string url = pageControls1.URL + "/" + start + "/" + pagesize;
    url = SetUrlClass.addurl(url);
    SpMatExtendEntity entity = new SpMatExtendEntity();//查询条件
    string param = ConvertBaseTools.FromEntityToJson<SpMatExtendEntity>(entity);//查询条件转换格式
    RespReturnDataList<SpMatExtendEntity> result = service.CallRestfulPostData<SpMatExtendEntity>(url, param, "POST");//访问后台
    List<SpMatExtendEntity> conlist = result.dataList;//结果
    if (result.flag == BaseEntity.success)
    {
        //查询成功
    }
    else
    {
        MessageBox.Show(result.errorMessage, "查询出现错误:");
    }
    autoFit();
    mainGrid.Refresh();
    nMax = int.Parse(result.scount);
    pageControls1.DrawControl(nMax);
}
private void autoFit()
{
    for (int i = 1; i < mainGrid.Cols; i++)
    {
        mainGrid.Column(i).AutoFit();
    }
}
/**控件**/
private void pageControls1_OnPageChanged(object sender, EventArgs e)
{
    int pagesize = pageControls1.PageSize;
    int current = pageControls1.PageIndex - 1;
    int nextpage = current + 1;
    InitData((pagesize * current).ToString(), pagesize.ToString());

}

弹窗

/**弹窗提示：表格**/
string[] sCap = { "列1", "列2", "列3", "列4", "列5", "列6", "错误描述" };
string[] sFlds = { "item1", "item2", "item3", "item4", "item5", "item6", "errMsg" };
string[] sVisible = { "1", "1", "1", "1", "1", "1", "1" };
DataTable dterror = new DataTable("xwlerror");
DataColumn dc;
dc = new DataColumn("item1");                       //
dc.DataType = System.Type.GetType("System.String"); //重复7次
dterror.Columns.Add(dc);							//
StringBuilder errorMsg = new StringBuilder();//错误信息
errorMsg.Append("错误!");                     //Append可以在字符串后添加字符串
string[] row = { item1, item2, item3, item4, item5, item6, errorMsg.ToString() };//赋值（一般用循环）
dterror.Rows.Add(row);//dterror为弹窗中显示的表格
BaseFunction.ShowLngConfirmMsg("导入失败，请修改以下错误后重新导入", sCap, sFlds, sVisible, dterror, "导入错误");

MessageBox.Show("内容", "标题", MessageBoxButtons.OK, MessageBoxIcon.Error);//错误提示
MessageBox.Show("下载成功！");