如何在DAL中编写For循环以及如何在三层架构中的演示中调用它

问题描述

如何在DAL中编写For循环以及如何在三层体系结构中的演示文稿中调用它

How to write For loop in DAL and how to call it in presentation in three tier architecture

推荐答案

public class TestDAL
{
 public int YourFunction(int YourInput)
{
//Your For loop as you want

for (int i = 10 - 1; i >= 0; i--)
	{
	    // What you want to do within the for loop
	}
}
}

然后您需要将具有DAL类的项目引用到您的表示层。您可以右键单击参考文件夹并添加参考>>从解决方案中选择DAL项目



然后您完全将您的DAL项目推荐给UI。

在UI项目中转到您的班级。导入您已经提到的程序集。 （包括DAL类）

例如：

Then you need to refer the project having DAL Class to your Presentation Layer. You can right click the reference folder and add reference >> select the DAL project from solution

Then you have complete refer your DAL project to the UI.
Go to your class in UI project. import the assembly you referred already. (Included the DAL Class)
Eg:

using YourSolutionName.YourProjectName

然后你可以调用你的DAL类函数包含你的for循环。为此你需要首先创建DAL类的对象



例如：

Then You can call your DAL class function included your for loop.For that you need to create object of the DAL Class first

eg:

DALClass ObjDAL = new DALClass ();

然后你可以调用DAL的功能

Then You can call function of DAL

objDAL.YourFunction(int YourInput)

认为你可以理解这个过程。

Think you could understood the process.

for (int i = 0; i < Prodcode.Length; i++)
                    {
                        if (cn.State != ConnectionState.Open)
                            cn.Open();
                        cmd.Connection = cn;
                        string value = "";

                        cmd.CommandText = " select  A.[prod_code] [Code],A.[prod_desc] [Desc],invd_uom [UOM],A.invd_qty-A.invd_qty_sent-(select isnull(sum(invd_qty_sent),0) from invoice_details where prod_code='" + Prodcode[i] + "' and comp_id='" + cpnyid + "' and Link_inv_no=B.inv_no) as reserve,B.inv_no as Invoice  from invoice_details AS A" +
                                          " INNER JOIN invoice_master AS B ON A.inv_no=B.inv_no " +
                                          "  WHERE (A.invd_qty-A.invd_qty_sent)>0 AND a.invd_qty_reservePros='false' and A.comp_id='" + cpnyid + "'and B.cust_code= '" + cfs.singlequotconver(txt_Custcode.Text)
                                          + "' and prod_code ='" + Prodcode[i] + "' and b.inv_no='" + Trnno[i] + "'and invd_qty_reserveDone<>'true' and invd_id='" + IdS[i] + "'  union ";
                        cmd.CommandText += "select prod_code [Code],prod_desc [Desc],popr_uom [UOM],convert(decimal(18,0),popr_bqty)-(select isnull(sum(invd_qty_sent),0) from invoice_details where prod_code='" + Prodcode[i] + "' and comp_id='" + cpnyid + "' and Link_inv_no=product_open_balance_reserve.inv_no) as  [reserve],inv_no as Invoice " +
                            " from product_open_balance_reserve where comp_id='" + cpnyid + "' and cust_code='" + cfs.singlequotconver(txt_Custcode.Text) +
                            "' and prod_code ='" + Prodcode[i] + "' and inv_no='" + Trnno[i] + "' and popr_deleted=0 and popr_id='" + IdS[i] + "' ";
                        dr = cmd.ExecuteReader();
                        object[] obj1 = { "", "", "", Properties.Settings.Default.SendBalance.ToString() };
                        if (i == 0)
                        {
                            dataGridViewEx1.Rows.Add(obj1);
                        }
                        while (dr.Read())
                        {
                            object[] obj = { "", dr["Code"].ToString(), "", dr["Desc"].ToString(), "", "", dr["reserve"].ToString(), dr["UOM"].ToString(), "", "", dr["reserve"].ToString(), "", "", "", "", "", "", "", "", "", "", dr["Invoice"].ToString() };
                            dataGridViewEx1.Rows.Add(obj);
                        } dr.Close();

                    }

这篇关于如何在DAL中编写For循环以及如何在三层架构中的演示中调用它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！